AR_TransactionPaymentHistory AR Transaction Payment History Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_SalesJournal_upd,SO_SalesJournal_upd,AR_FinanceChargeJournal_upd,AR_CommissionEditRegister_ SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_TransactionPaymentHistory.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType+TransactionDate+SequenceNo KCREDITCARD: ARDivisionNo+CustomerNo+InvoiceNo+TransactionType+EncryptedCreditCardNo KINVOICE: ARDivisionNo+CustomerNo+TransactionDate+InvoiceNo+InvoiceType+SequenceNo KINVOICEDECENDING: ARDivisionNo+CustomerNo+TransactionDate(d)+InvoiceNo+InvoiceType+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {AR6$(1,2)} 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {AR6$(3,7)} 3 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {AR6$(10,7)} 4 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . . Valid:CM,DM,FC,IN,PP,PY,BC, BF Notes: CM=Credit Memo, DM=Debit Memo, FC=Finance Charge, IN=Invoice, PP=PrePayment, PY=Payment, BC=Balance Forward Other Charges, BF=Balance Forward {AR6$(17,2)} 5 InvoiceHistoryHeaderSeqNo . . 6 SNN Invoice History Header Sequence Mask:000000 6 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE Notes: {AR6$(19,6)} 7 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL ChngTag:KeySeq Notes: {AR6$(25,2)} 8 PaymentReference. . . . . . . 10 SYN Payment Reference . . . . . . . Notes: {AR6$(27,10)} 9 CheckNo . . . . . . . . . . . 10 SYN Check Number. . . . . . . . . .CHECKNO FmtType:ALPHANUM Notes: {AR6$(27,10)} 10 TransactionType . . . . . . . 1 SYN Transaction Type. . . . . . . . Notes: I=Invoice, C=Credit Memo, D=Debit Memo, P=Payment, A=Adjustment, F=Finance Charge, X=PrePaymen t, B=Balance Forward, E=Balance Forward Other Charges {AR6$(37,1)} 11 PaymentDate . . . . . . . . . 8 SNN Payment Date. . . . . . . . . .DATE Notes: {AR6$(38,6)} 12 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . . Notes: {AR6$(44,5)} 13 OtherPaymentTypeRefNo . . . . 24 SYN Other Payment Type Reference Nu FmtType:CHARNUM Notes: {AR6$(49,24)} 14 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .NAME Notes: {AR6$(73,30)} 15 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR2 Notes: {AR6$(103,2)} 16 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH Mask:00 FmtType:ZEROFILL Notes: {AR6$(105,2)} 17 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe Notes: {AR6$(107,16)} 18 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO Notes: {AR6$(123,24)} 19 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card Notes: {AR6$(151,4)} 20 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . . Notes: {AR6$(155,10)} 21 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO FmtType:CHARNUM Notes: {AR6$(165,7)} 22 TransactionAmt. . . . . . . . 13.2 NNN Transaction Amount. . . . . . .AMOUNT Mask:###,###,###.00 ChngTag:Sum Notes: {AR6[0]} 23 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max Notes: YYYYMMDD 24 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 25 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Max/DateUpdated$