AR_RepetitiveInvoiceHeader AR Repetitive Invoice Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_RepetitiveInvoice_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_RepetitiveInvoiceHeader.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+ReferenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:ARDivisionRequired
2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$
3 ReferenceNo . . . . . . . . . 4 SYY Reference Number. . . . . . . .
FmtType:CHARNUM
4 SoldTo. . . . . . . . . . . . 30 SNN Sold To . . . . . . . . . . . .NAME
5 SelectCycleCode . . . . . . . 2 SYN Select Cycle Code . . . . . . .
6 StartBillingDate. . . . . . . 8 SNN Start Billing Date. . . . . . .DATE
DfltVal:
7 StopBillingDate . . . . . . . 8 SNN Stop Billing Date . . . . . . .DATE
8 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS
Mask:00 FmtType:ZEROFILL
DepVal:REQUIRED
9 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:ARSalesTax
10 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:ARDivisionRequired,
SalespersonReporting,
CustomerRequired
11 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:SalespersonReport
ing,CustomerRequired
12 PrintInvoice. . . . . . . . . 1 SYN Print Invoice . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
13 ShipMethod. . . . . . . . . . 15 SYN ShipMethod. . . . . . . . . . .SHIPCODE
14 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
15 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
16 LastBilledDate. . . . . . . . 8 SNN Last Billed Date. . . . . . . .DATE
17 SelectThisProcess . . . . . . 1 SYN Select This Process . . . . . .YESNO
DfltVal:N Valid:Y,N
18 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM ValGroup:JCIn
tegrated
19 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:Salesp
ersonReporting
20 TaxableSalesAmt . . . . . . . 14.2 NNN Taxable Sales Amount. . . . . .AMOUNT
Read Only:Y Mask:#,###,###,
###.00- ValGroup:ARSalesTax,
LinesCalc ChngTag:Sum
21 NonTaxableSalesAmt. . . . . . 14.2 NNN Non-Taxable Sales Amount. . . .AMOUNT
Read Only:Y Mask:#,###,###,
###.00- ValGroup:LinesCalc
ChngTag:Sum
22 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValSeqNo:9999 ChngTag:Sum
23 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT
Read Only:Y Mask:##,###,
###.00- ValGroup:ARSalesTax,
LinesCalc ValSeqNo:9999
ChngTag:Sum
24 CostOfSalesAmt. . . . . . . . 14.2 NNN Cost Of Sales Amount. . . . . .AMOUNT
Mask:#,###,###,###.00-
ValGroup:LinesCalc ChngTag:Su
m
25 SalesSubjectToComm. . . . . . 14.2 NNN Sales Subject To Commission . .AMOUNT
Mask:#,###,###,###.00-
ValGroup:SalespersonReporting
,LinesCalc ChngTag:Sum
26 CostSubjectToComm . . . . . . 14.2 NNN Cost Subject To Commission. . .AMOUNT
Mask:#,###,###,###.00-
ValGroup:SalespersonReporting
,LinesCalc ChngTag:Sum
27 CommissionAmt . . . . . . . . 14.2 NNN Commission Amount . . . . . . .AMOUNT
Mask:#,###,###,###.00-
ValGroup:SalespersonReporting
ChngTag:Sum
28 NumberOfTimesBilled . . . . . 7.0 NNN Number Of Times Billed. . . . .
Mask:#####0 ChngTag:Sum
29 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y ChngTag:Min
Notes: YYYYMMDD
30 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y ChngTag:CopyMin/D
ateCreated$
31 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL ChngTag:Copy
Min/DateCreated$
32 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y ChngTag:Max
Notes: YYYYMMDD
33 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y ChngTag:CopyMax/D
ateUpdated$
34 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL ChngTag:Copy
Max/DateUpdated$