JC_02 Job Billing Tax Summary File (JC_02JobBillingTaxSummary) Level: 4.40 Record Type: 1 Job Billing Tax Summary Record 08/28/2009 File Type: Mkeyed Key Size: 24 Rec Len: 210 Min Len: 64 Define: Y
Main Key (KNO=0)JobNumber(1,7)+ScheduleSEQNumber(8,2)+TaxCode(10,15) 2nd Key (KNO=1) TaxCode(10,15)+JobNumber(1,7)+ScheduleSEQNumber(8,2)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(1,7) Schedule Seq Number . . . . . . . . . . ScheduleSEQNumber . . . . . . Zero-Filled *(8,2) Tax Code. . . . . . . . . . . . . . . . TaxCode . . . . . . . . . . . Uppercase *(10,15) Exempt Number . . . . . . . . . . . . . ExemptNumber. . . . . . . . . String (25,20) Overridden? . . . . . . . . . . . . . . Overridden. . . . . . . . . . Yes/No (45,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (46,19) Taxable Sales Amount. . . . . . . . . . TaxableSalesAmount. . . . . . Number [0] 8.2 Taxable Freight Amount. . . . . . . . . TaxableFreightAmount. . . . . Number [1] 8.2 Taxable Tax . . . . . . . . . . . . . . TaxableTax. . . . . . . . . . Number [2] 8.2 Non-Taxable Sales Amount. . . . . . . . NonTaxableSalesAmount . . . . Number [3] 8.2 Exempt Sales Amount . . . . . . . . . . ExemptSalesAmount . . . . . . Number [4] 8.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [6] 0. Sales Tax Amount. . . . . . . . . . . . SalesTaxAmount. . . . . . . . Number [7] 8.2 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [8] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [9] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [10] 0. ________ Total Bytes 149