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