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