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