AP_CheckDetailPosting AP Check Detail Posting Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_CheckRegister_upd,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,PO_ReceiptRegister_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_CheckDetailPosting.M4T"
KPRIMARY: BankCode+CheckNo+InvoiceNo
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 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE
4 CheckType . . . . . . . . . . 1 SNN Check Type. . . . . . . . . . .
5 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE
Notes: {AP_16$(9,10)}
6 InvoiceType . . . . . . . . . 1 SNN Invoice Type. . . . . . . . . .
7 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
Notes: {AP_16$(22,6)}
8 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AP_16$(28,2)}
9 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
Notes: {AP_16$(30,7)}
10 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . .NAME
Notes: {AP_16$(37,30)}
11 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . .
12 Vendor1099CalendarYr. . . . . 4 SNN Vendor 1099 Calendar Year . . .YEAR
Mask:0000
13 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . .
Notes: D=Dividend,I=Interest,
M=Miscellaneous, {AP_16$(67,
1)}
14 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . .BOX1099
Mask:###,###,###.00 Notes:
{AP_16$(68,2)}
15 AmountPaid. . . . . . . . . . 13.2 NNN Amount Paid . . . . . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{AP_16[0]}
16 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{AP_16[1]}
17 UnappliedDiscountAmt. . . . . 13.2 NNN Unapplied Discount Amount . . .AMOUNT
Mask:###,###,###.00
18 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT
Mask:###,###,###.00 Notes:
{AP_16[2]}