AP_OpenInvoice AP Open Invoice Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_OpenInvoice_bus,AP_ARClearingRegister_upd,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_OpenInvoice.M4T"
KPRIMARY: APDivisionNo+VendorNo+InvoiceNo KINVOICE: APDivisionNo+VendorNo+InvoiceDate+InvoiceNo KINVOICEDECENDING: APDivisionNo+VendorNo+InvoiceDate(d)+InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {AP4$(1,2)} 2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {AP4$(3,7)} 3 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE Notes: {AP4$(10,10)} 4 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE ChngTag:Min Notes: {AP4$(20, 6)} 5 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE ChngTag:Min Notes: {AP4$(26, 6)} 6 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE ChngTag:Min Notes: {AP4$(32, 6)} 7 InvoiceHistoryHeaderSeqNo . . 6 SNN Invoice History Header Sequence Mask:000000 8 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE 9 TermsCode . . . . . . . . . . 2 SYN Terms Code. . . . . . . . . . .APTERMS Mask:00 Notes: {AP4$(38,2)} 10 HoldPayment . . . . . . . . . 1 SYN Hold Payment. . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP4$(40,1)} 11 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . . Notes: {AP4$(41,30)} 12 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM Notes: {AP4$(71,7)} 13 CheckNo . . . . . . . . . . . 10 SNN AP Check Number . . . . . . . .APCHECKNO Notes: {AP4$(78,6)} 14 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE Notes: {AP4$(84,6)} 15 PaidToday . . . . . . . . . . 1 SYN Paid Today. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP4$(90,1)} 16 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . . Notes: {AP4$(91,1)} 17 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . . Notes: {AP4$(92,2)} 18 SeparateCheck . . . . . . . . 1 SYN Separate Check. . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP4$(94,1)} 19 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE Notes: {AP4$(95,9)} 20 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS Notes: {AP4$(104,2)} 21 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP4$(106,1)} 22 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[0]} 23 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[1]} 24 RetentionCost . . . . . . . . 13.2 NNN Retention Cost. . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[2]} 25 Balance . . . . . . . . . . . 13.2 NNN Balance . . . . . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[3]} 26 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[4]} 27 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[5]} 28 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[6]} 29 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[7]} 30 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP4[8]} 31 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max Notes: YYYYMMDD 32 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 33 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 ChngTag:CopyMax/DateUpdated$