AR_CashReceiptsHistory AR Cash Receipts History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CashReceiptsJournal_upd,AR_CashReceiptsHistory_bus,AP_ARClearingRegister_upd SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CashReceiptsHistory.M4T"
KPRIMARY: BankCode+DepositDate+DepositNo+DepositType+ARDivisionNo+CustomerNo+CheckNo+SequenceNo KCUSTOMER: ARDivisionNo+CustomerNo KDEPOSITDATE: DepositDate(d)+BankCode+DepositNo+DepositType+ARDivisionNo+CustomerNo+CheckNo+SequenceNo KUNENCRYPTED: Last4UnencryptedCreditCardNos+BankCode+DepositDate+DepositNo+DepositType+ARDivisionNo+Cus tomerNo+CheckNo+SequenceNo KDATE: DepositDate+BankCode+DepositNo+DepositType+ARDivisionNo+CustomerNo+CheckNo+SequenceNo KCHECK: CheckNo+DepositDate+BankCode+DepositNo+DepositType+ARDivisionNo+CustomerNo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 BankCode. . . . . . . . . . . 1 SYY Bank Code . . . . . . . . . . .BANKCODE Notes: {AR3$(1,1)} 2 DepositDate . . . . . . . . . 8 SNY Deposit Date. . . . . . . . . .DATE Notes: {AR3$(2,6)} 3 DepositNo . . . . . . . . . . 5 SNY Deposit Number. . . . . . . . .DEPOSITNO FmtType:ZEROFILL Notes: {AR3$(8,5)} 4 DepositType . . . . . . . . . 1 SYY Deposit Type. . . . . . . . . . Valid:C,R Notes: C=Cash, R=cRedit 5 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AR3$(13,2)} 6 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {AR3$(15,7)} 7 CheckNo . . . . . . . . . . . 10 SNY Check Number. . . . . . . . . .CHECKNO Notes: {AR3$(22,10)} 8 CreditCardNo. . . . . . . . . 24 SNN Credit Card Number. . . . . . . 9 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL ChngTag:KeySeq Notes: {AR3$(32,3)} 10 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE 11 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME Notes: {AR3$(35,30)} 12 OpenItemCustomer. . . . . . . 1 SYN Open Item Customer. . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR3$(65,1)} 13 TransactionType . . . . . . . 2 SYN Transaction Type. . . . . . . . Valid:IN,GL Notes: IN=Invoice Type, GL=GL Only {AR3$(66, 2)} 14 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {AR3$(68,7)} 15 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . . Valid:CM,DM,IN,FC,PP Notes: CM=Credit Memo, DM=Debit Memo, IN=Invoice, FC=Finance Charge, PP=PrePayment {AR3$(75,2)} 16 AccountKey. . . . . . . . . . 9 SYN Account Key . . . . . . . . . .ACCOUNT Notes: {AR3_2$(68,9)} 17 DepositDesc . . . . . . . . . 30 SNN Deposit Description . . . . . .DESCRIPTION 18 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO FmtType:ALPHANUM 19 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card 20 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR2 21 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH Mask:00 22 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas 23 CorporateTaxOverrd. . . . . . 1 SYY Corporate Tax Overridden. . . .YESNO DfltVal:N Valid:Y,N 24 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .NAME 25 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . . 26 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe 27 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE 28 AuthorizationTime . . . . . . 8 SNN Authorization Time. . . . . . . 29 AVSAddress. . . . . . . . . . 30 SNN AVS Address . . . . . . . . . .ADDRESSLINE 30 AVSCity . . . . . . . . . . . 20 SNN AVS City. . . . . . . . . . . .CITY 31 AVSState. . . . . . . . . . . 2 SNN AVS State . . . . . . . . . . .STATE 32 AVSZipCode. . . . . . . . . . 10 SNN AVS Zip Code. . . . . . . . . .ZIPCODE 33 CreditCardComment . . . . . . 30 SNN Credit Card Comment . . . . . .COMMENT30 34 Comment . . . . . . . . . . . 2048 SNN Comment . . . . . . . . . . . .COMMENT 35 CashAmountApplied . . . . . . 13.2 NNN Cash Amount Applied . . . . . .AMOUNT Mask:###,###,###.00 Notes: {AR3[0]} 36 DiscountAmountApplied . . . . 13.2 NNN Discount Amount Applied . . . .AMOUNT Mask:###,###,###.00 Notes: {AR3[1]} 37 InvoiceBalance. . . . . . . . 14.2 NNN Invoice Balance . . . . . . . . Mask:#,###,###,###.00- Notes: {AR3[2]} 38 CorporateSalesTax . . . . . . 12.2 NNN Corporate Sales Tax . . . . . .MISCAMOUNT Mask:##,###,###.00- 39 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 40 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 41 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL