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$