View - dbo.arch_AR_ReceiptMiscAccountGroup

Property	Value
Name	arch_AR_ReceiptMiscAccountGroup
Schema	dbo
Quoted Identifier Status	True
Ansi Nulls Status	True
Returns View Metadata	False
Create Date	10/17/2016 9:34 AM
Description

Column Name	Data Type	Allow Nulls	Fulltext Indexed	Identity	Description / Computed Formula
AccountGroupSeqNbr	int(10, 0)	True	False	False
AccountNumber	varchar(25)	True	False	False
Amount	numeric(17, 2)	False	False	False
Description	varchar(30)	False	False	False
FiscalYear	varchar(4)	True	False	False
Glc	varchar(5)	True	False	False
Location	varchar(2)	True	False	False
PrintedReceiptNumber	int(10, 0)	True	False	False
Qual1	varchar(6)	True	False	False
Qual2	varchar(3)	True	False	False
ReceiptKey	varchar(19)	True	False	False
ReceiptSeqNumber	int(10, 0)	True	False	False
StateOrg	varchar(8)	True	False	False

Name

Insert

Update

Delete

Instead

Name

Clustered

Columns

Name	Type
AR_RECEIPT_A	Table
AR_RECEIPT_A_MISC_ACCOUNT_GROUP	Table

Name	Type
AR_RECEIPT_A	TABLE
AR_RECEIPT_A_MISC_ACCOUNT_GROUP	TABLE

Object

Property

Value

Object

Property

Value

/****** Object: View [dbo].[arch_AR_ReceiptMiscAccountGroup] Script Date: 03/09/2017 16:47:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW [dbo].[arch_AR_ReceiptMiscAccountGroup]
AS
SELECT
       FISCAL_YEAR AS FiscalYear
      ,PRINTED_RECEIPT_NUM AS PrintedReceiptNumber
      ,CASHIER_SESSION_KEY  AS ReceiptKey
      ,RECEIPT_SEQ AS ReceiptSeqNumber
      ,cnxarraycolumn + 1 AS AccountGroupSeqNbr
      ,ACCOUNT_NBR AS AccountNumber
      ,LEFT(ACCOUNT_NBR,8) AS StateOrg
      ,SUBSTRING(ACCOUNT_NBR,9,6) AS Qual1
      ,SUBSTRING(ACCOUNT_NBR,15,2) AS Location
      ,SUBSTRING(ACCOUNT_NBR,17,5) AS Glc
      ,SUBSTRING(ACCOUNT_NBR,22,3) AS Qual2
      ,ISNULL(DESCRIPTION,'N/A') AS Description
      ,ISNULL(AMOUNT,0) AS Amount
  FROM AR_RECEIPT_A_MISC_ACCOUNT_GROUP RcptAcctGrp
  INNER JOIN AR_RECEIPT_A Rcpt
  ON
  (
     Rcpt.ISN_AR_RECEIPT_A = RcptAcctGrp.ISN_AR_RECEIPT_A
  )