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]}