AP_CheckHistoryDetail AP Check History Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_PaymentHistoryDetail_bus,AP_CheckRegister_upd,AP_ManualCheckRegister_upd,PO_ReceiptRegister
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_CheckHistoryDetail.M4T"
KPRIMARY: BankCode+CheckNo+CheckSeqNo+InvoiceNo+InvoiceSeqNo
KINVOICE: InvoiceNo+InvoiceSeqNo+BankCode+CheckNo+CheckSeqNo
KVENDOR: APDivisionNo+VendorNo+BankCode+CheckNo+CheckSeqNo+InvoiceNo+InvoiceSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 BankCode. . . . . . . . . . . 1 SYY Bank Code . . . . . . . . . . .BANKCODE
Notes: {AP_16$(1,1)}
2 CheckNo . . . . . . . . . . . 10 SNY AP Check Number . . . . . . . .APCHECKNO
Notes: {AP_16$(2,6)}
3 CheckSeqNo. . . . . . . . . . 6 SNY Check Sequence Number . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {AP_16$(8,1)}
4 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE
Notes: {AP_16$(9,10)}
5 InvoiceSeqNo. . . . . . . . . 6 SNY Invoice Sequence Number . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {AP_16$(19,3)}
6 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
Notes: {AP_16$(22,6)}
7 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AP_16$(28,2)}
8 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{AP_16$(30,7)}
9 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . .NAME
Notes: {AP_16$(37,30)}
10 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . .
11 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . .
Notes: {AP_16$(67,1)}D=Divid
endI=InterestM=Miscellaneou
s
12 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . .
Notes: {AP_16$(68,2)}
13 AmountPaid. . . . . . . . . . 13.2 NNN Amount Paid . . . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_16[0]}
14 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_16[1]}
15 UnappliedDiscountAmt. . . . . 13.2 NNN Unapplied Discount Amount . . .AMOUNT
Mask:###,###,###.00
16 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_16[2]}