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$