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$