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$