     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$