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$