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