     AP_TransactionPaymentHistory           AP Transaction Payment History Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_ARClearingRegister_upd,AP_ManualCheckRegister_upd,AP_CheckRegister_upd,AP_InvoiceRegister_u
     SQL Def: Y  SysDB: N                          "MAS_"+%C$+"/AP"+%C$+"/AP_TransactionPaymentHistory.M4T"

     KPRIMARY: APDivisionNo+VendorNo+InvoiceNo+TransactionDate+SequenceNo
     KINVOICE: APDivisionNo+VendorNo+TransactionDate+InvoiceNo+SequenceNo
     KINVOICEDECENDING: APDivisionNo+VendorNo+TransactionDate(d)+InvoiceNo+SequenceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  APDivisionNo. . . . . . . . .     2 SNY  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {API$(1,2)}
       2  VendorNo. . . . . . . . . . .     7 SYY  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM ChngTag:Rep
                                                    lace1/APDivisionNo$ Notes:
                                                    {API$(3,7)}
       3  InvoiceNo . . . . . . . . . .    10 SNY  AP Invoice Number . . . . . . .APINVOICE
                                                    Notes: {API$(10,10)}
       4  InvoiceHistoryHeaderSeqNo . .     6 SNY  Invoice History Header Sequence
                                                    Mask:000000 FmtType:ZEROFILL
       5  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
                                                    Notes: {API$(20,6)}
       6  SequenceNo. . . . . . . . . .     6 SNN  Sequence Number . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    ChngTag:Keyseq Notes:
                                                    {API$(26,2)}
       7  TransactionType . . . . . . .     1 SYN  Transaction Type. . . . . . . .
                                                    Valid:A,I,P,X Notes:
                                                    {API$(28,1)}A=Adjustment,
                                                    I=Invoice, P=Payment,
                                                    X=prepayment
       8  CheckNo . . . . . . . . . . .    10 SNN  AP Check Number . . . . . . . .APCHECKNO
                                                    Notes: {API$(29,6)}
       9  CheckHistoryHeaderSeqNo . . .     6 SNN  Check History Header Sequence N
                                                    Mask:000000
      10  CheckDate . . . . . . . . . .     8 SNN  Check Date. . . . . . . . . . .DATE
                                                    Notes: {API$(35,6)}
      11  ApplyToInvoice. . . . . . . .    10 SNN  Apply To AP Invoice Number If XAPINVOICE
                                                    Notes: {API$(41,10)}
      12  ApplyHistoryHeaderSeqNo . . .     6 SNN  Apply History Header Sequence N
                                                    Mask:000000
      13  BankCode. . . . . . . . . . .     1 SYN  Bank Code . . . . . . . . . . .BANKCODE
                                                    Notes: {API$(51,1)}
      14  TransactionAmt. . . . . . . . 13.2  NNN  Transaction Amount. . . . . . .AMOUNT
                                                    Mask:###,###,###.00-
                                                    ChngTag:Sum Notes: {API[0]}
      15  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00-
                                                    ChngTag:Sum Notes: {API[1]}
      16  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00-
                                                    ChngTag:Sum Notes: {API[2]}
      17  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y ChngTag:Max
                                                    Notes: YYYYMMDD
      18  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y ChngTag:CopyMax/D
                                                    ateUpdated$
      19  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    ChngTag:CopyMax/DateUpdated$