AP_InvoiceHeader AP Invoice Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_Invoice_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHeader.M4T"
KPRIMARY: APDivisionNo+VendorNo+InvoiceNo KBATCH: BatchNo+APDivisionNo+VendorNo+InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL ValGroup:APDivisionRequired Notes: {AP5$(1,2)} 2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM Notes: {AP5$(3,7)} 3 InvoiceNo . . . . . . . . . . 10 SYY Invoice Number. . . . . . . . .APINVOICE Notes: {AP5$(10,10)} 4 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE DepVal:REQUIRED Notes: {AP5$(20,6)} 5 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE Notes: {AP5$(26,6)} 6 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE Notes: {AP5$(32,6)} 7 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .APTERMS Mask:00 FmtType:ZEROFILL DepVal:REQUIRED Notes: {AP5$(38,2)} 8 HoldPayment . . . . . . . . . 1 SYN Hold Payment. . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP5$(40,1)} 9 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . . Notes: {AP5$(41,30)} 10 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:JCIntegrated Notes: {AP5$(71,7)} 11 Adjustment. . . . . . . . . . 1 SYN Adjustment. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP5$(78,1)} 12 RecurringInvoice. . . . . . . 1 SYN Recurring Invoice . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP5$(79,1)} 13 PrepaidApplyToInvoiceNo . . . 10 SYN Prepaid Apply To AP Invoice NumAPINVOICE DepVal:REQUIRED Notes: {AP5$(80,10)} 14 PrepaidPaymentDate. . . . . . 8 SNN Prepaid Payment Invoice Date. .DATE Notes: {AP5$(90,6)} 15 PrepaidCheckNo. . . . . . . . 10 SYN Prepaid Check Number. . . . . .APCHECKNO Notes: {AP5$(96,6)} 16 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . .FORM1099 ValGroup:TEN99 Notes: {AP5$(102,1)} 17 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . .BOX1099 ValGroup:TEN99 Notes: {AP5$(103,2)} 18 SeparateCheck . . . . . . . . 1 SYN Separate Check. . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP5$(105,1)} 19 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO FmtType:ALPHANUM Notes: {AP5$(106,5)} 20 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:APSalesTax Notes: {AP5$(111,9)} 21 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS DepVal:REQUIRED ValGroup:APSa lesTax Notes: {AP5$(120,2)} 22 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO DfltVal:N Valid:Y,N ValGroup:APSalesTax Notes: {AP5$(122,1)} 23 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N ValGroup:APSalesTax Notes: {AP5$(123,1)} 24 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP5[0]} 25 NetInvoiceAmt . . . . . . . . 13.2 NNN Net Invoice Amount. . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP5[1]} 26 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT Mask:###,###,###.00- ValSeqNo:9999 Notes: {AP5[2]} 27 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- ValGroup:JCIntegrated ,JCRetention Notes: {AP5[3]} 28 PrepaymentAmt . . . . . . . . 13.2 NNN Prepayment Amount . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP5[4]} 29 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- ValGroup:APSalesTax Notes: {AP5[6]} 30 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- Notes: {AP5[7]} 31 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP5[8]} 32 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- ValGroup:APSalesTax ValSeqNo:9999 Notes: {AP5[9]} 33 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- ValGroup:APSalesTax Notes: {AP5[10]} 34 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 35 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 36 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 37 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 38 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 39 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000