AR_InvoiceHeader AR Invoice Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_Invoice_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHeader.M4T"
KPRIMARY: InvoiceNo+InvoiceType
KBATCH: BatchNo+InvoiceNo+InvoiceType
KCUSTOMER: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUMC Next:Invoi
ceNo$ Notes: {AR7$(1,7)}
2 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . .
DfltVal:IN Valid:CM,DM,IN,FC,
CA,XD Notes: CM=Credit Memo,
DM=Debit Memo, IN=INvoice,
FC=Finance Charge, CA=CAsh,
XD=Deleted {AR7$(8,2)}
3 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:ARDivisionRequired
Notes: {AR7$(10,2)}
4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{AR7$(12,7)}
5 SoldTo. . . . . . . . . . . . 30 SNN Sold To . . . . . . . . . . . .NAME
Notes: {AR7$(19,30)}
6 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
DepVal:REQUIRED Notes:
{AR7$(49,6)}
7 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS
Mask:00 FmtType:ZEROFILL
DepVal:REQUIRED Notes:
{AR7$(55,2)}
8 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:ARSalesTax
Notes: {AR7$(57,9)}
9 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:ARDivisionRequired,
SalespersonReporting,
CustomerRequired
10 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:SalespersonReport
ing,CustomerRequired Notes:
{AR7$(66,4)}
11 PrintInvoice. . . . . . . . . 1 SYN Print Invoice . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AR7$(70,1)}
12 ShipMethod. . . . . . . . . . 15 SYN Ship Method . . . . . . . . . .SHIPCODE
Notes: {AR7$(71,15)}
13 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
Notes: {AR7$(86,15)}
14 ApplyToInvoiceNo. . . . . . . 7 SYN Apply To Invoice Number . . . .
FmtType:CHARNUM Notes:
{AR7$(101,7)}
15 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {AR7$(108,30)}
16 Adjustment. . . . . . . . . . 1 SYN Adjustment. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AR7$(138,1)}
17 RepetitiveInvoiceRefNo. . . . 4 SYN Repetitive Invoice Reference Nu
FmtType:CHARNUM Notes:
{AR7$(139,4)}
18 ActuallyPrinted . . . . . . . 1 SYN Actually Printed. . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AR7$(143,1)}
19 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:JCIntegrated
Notes: {AR7$(144,7)}
20 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE
Notes: {AR7$(151,6)}
21 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE
Notes: {AR7$(157,6)}
22 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM Notes:
{AR7$(163,5)}
23 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:ARSalesTax Notes:
{AR7$(168,1)}
24 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{AR7$(169,1)}
25 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
Notes: {AR7$(170,17)}
26 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
27 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:Salesp
ersonReporting Notes:
{AR7[0]}
28 TaxableSalesAmt . . . . . . . 14.2 NNN Taxable Sales Amount. . . . . .SALESAMOUNT
Read Only:Y Mask:#,###,###,
###.00- ValGroup:ARSalesTax
Notes: {AR7[1]}
29 NonTaxableSalesAmt. . . . . . 14.2 NNN Non Taxable Sales Amount. . . .SALESAMOUNT
Read Only:Y Mask:#,###,###,
###.00- Notes: {AR7[2]}
30 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValSeqNo:9999 Notes: {AR7[3]}
31 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT
Read Only:Y Mask:##,###,
###.00- ValGroup:ARSalesTax
Notes: {AR7[4]}
32 CostOfSalesAmt. . . . . . . . 14.2 NNN Cost of Sales Amount. . . . . .SALESAMOUNT
Read Only:Y Mask:#,###,###,
###.00- Notes: {AR7[5]}
33 SalesSubjectToComm. . . . . . 14.2 NNN Sales Subject to Commission . .SALESAMOUNT
Read Only:Y Mask:#,###,###,
###.00- ValGroup:SalespersonR
eporting Notes: {AR7[6]}
34 CostSubjectToComm . . . . . . 14.2 NNN Cost Subject To Commission. . .SALESAMOUNT
Read Only:Y Mask:#,###,###,
###.00- ValGroup:SalespersonR
eporting Notes: {AR7[7]}
35 CommissionAmt . . . . . . . . 14.2 NNN Commission Amount . . . . . . .SALESAMOUNT
Mask:#,###,###,###.00-
ValGroup:SalespersonReporting
Notes: {AR7[8]}
36 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . .SALESAMOUNT
Mask:#,###,###,###.00-
ValGroup:JCIntegrated,
JCRetention Notes: {AR7[10]}
37 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y
38 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
39 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
40 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y
41 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
42 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL