AR_DepositHistory AR Deposit History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CashReceiptsJournal_upd,AR_DepositHistory_bus SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_DepositHistory.M4T"
KPRIMARY: PaymentType+InvoiceNo+SequenceNo KCUSTOMER: ARDivisionNo+CustomerNo KTRANSDATE: TransactionDate(d)+PaymentType+InvoiceNo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 PaymentType . . . . . . . . . 5 SYY Payment Type. . . . . . . . . .PAYMENTTYPE Notes: {AR_14$(1,5)} 2 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {AR_14$(6,7)} 3 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL Notes: {AR_14$(13,3)} 4 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AR_14$(16,2)} 5 CustomerNo. . . . . . . . . . 20 SYN Customer No . . . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {AR_14$(18,7)} 6 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE Notes: {AR_14$(25,6)} 7 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE Notes: {AR_14$(31,6)} 8 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . Valid:DM,IN Notes: DM=Debit Memo, IN=INvoice {AR_14$(87, 2)} 9 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM Notes: {AR_14$(37,7)} 10 ReferenceNo . . . . . . . . . 24 SNN Reference Number. . . . . . . . Notes: {AR_14$(44,24)} 11 CheckNo . . . . . . . . . . . 10 SYN Check Number. . . . . . . . . .CHECKNO FmtType:ALPHANUM Notes: {AR_14$(44,24)} 12 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO Notes: {AR_14$(89,24)} 13 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card Notes: {AR_14$(117,4)} 14 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR2 Notes: {AR_14$(68,2)} 15 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH Mask:00 FmtType:ZEROFILL Notes: {AR_14$(70,2)} 16 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe Notes: {AR_14$(121,16)} 17 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . . Notes: {AR_14$(137,10)} 18 TransactionAmt. . . . . . . . 13.2 NNN Transaction Amount. . . . . . .AMOUNT Mask:###,###,###.00 Notes: {AR_14[0]} 19 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 20 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 21 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL