AR_CashReceiptsJournalWrk AR Cash Receipts Journal Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CashReceiptsJournal_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CashReceiptsJournalWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 DepositType . . . . . . . . . 1 SNN Deposit Type. . . . . . . . . . 3 BankCode. . . . . . . . . . . 1 SNN Bank Code . . . . . . . . . . . 4 BankDesc. . . . . . . . . . . 30 SNN Bank Description. . . . . . . . 5 DepositDate . . . . . . . . . 8 SNN Deposit Date. . . . . . . . . .DATE 6 BatchNo . . . . . . . . . . . 5 SNN Batch Number. . . . . . . . . . 7 DepositNo . . . . . . . . . . 5 SNN Deposit Number. . . . . . . . . 8 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 9 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 10 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 11 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card 12 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . . 13 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe 14 LineSeqNo . . . . . . . . . . 14 SNN Line Sequence Number. . . . . . 15 LineType. . . . . . . . . . . 1 SNN Line Type . . . . . . . . . . . 16 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 17 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 18 DiscountDate. . . . . . . . . 8 SNN Discount Date . . . . . . . . .DATE 19 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 20 AccountKey. . . . . . . . . . 9 SNN Account Key . . . . . . . . . . 21 Account . . . . . . . . . . . 41 SNN Account . . . . . . . . . . . . 22 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . . 23 FullCreditCardNo. . . . . . . 24 SNN Full Credit Card Number . . . . 24 Comment . . . . . . . . . . . 2048 SNN Comment . . . . . . . . . . . . 25 CashDepositAmt. . . . . . . . 13.2 NNN Cash Deposit Amount . . . . . . 26 CashBalanceAmt. . . . . . . . 13.2 NNN Cash Balance Amount . . . . . . 27 CreditDepositAmt. . . . . . . 13.2 NNN Credit Deposit Amount . . . . . 28 CreditBalanceAmt. . . . . . . 13.2 NNN Credit Balance Amount . . . . . 29 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . . 30 AmountPosted. . . . . . . . . 13.2 NNN Amount Posted . . . . . . . . . 31 InvoiceBalance. . . . . . . . 13.2 NNN Invoice Balance . . . . . . . . 32 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . .