JC_01 Job Billing Tax Detail File (JC_01JobBillingTaxDetail) Level: 4.40
Record Type: 1 Job Billing Tax Detail Record 08/28/2009
File Type: Direct Key Size: 26 Rec Len: 196 Min Len: 46 Define: Y
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)
Tax Class . . . . . . . . . . . . . . . TaxClass. . . . . . . . . . . Uppercase *(25,2)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (27,20)
Taxable Sales Amount. . . . . . . . . . TaxableSalesAmount. . . . . . Number [0] 8.2
Non-Taxable Sales Amount. . . . . . . . NonTaxableSalesAmount . . . . Number [1] 8.2
Exempt Sales Amount . . . . . . . . . . ExemptSalesAmount . . . . . . Number [2] 8.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0.
Tax Rate. . . . . . . . . . . . . . . . TaxRate . . . . . . . . . . . Number [5] 3.6
Retention Amount. . . . . . . . . . . . RetentionAmount . . . . . . . Number [6] 8.2
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [7] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [8] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [9] 0.
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [10] 0.
________
Total Bytes 118