JC_21  Crystal Job Billing Data Entry Detail (JC_21CrystalJobBillingLine)       Level: 4.40
        Record Type: 1    Cost Code Detail Line                                  08/28/2009
 
 File Type: Direct   Key Size: 18   Rec Len: 225     Min Len: 165    Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
 Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(7,7)
 Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5)
 Line Type (1=Cost Code, 2=/M, 3=/C) . . LineType. . . . . . . . . . . Zero-Filled (19,1)
 Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account     (20,9)
 Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . String      (29,1)
 Cost Code Description . . . . . . . . . CostCodeDescription . . . . . String      (30,30)
 Cost Type Description . . . . . . . . . CostTypeDescription . . . . . String      (60,15)
 Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled (75,2)
 Vendor Number . . . . . . . . . . . . . VendorNumber. . . . . . . . . Account     (77,7)
 Description Only? (Y/N) . . . . . . . . DescriptionOnly . . . . . . . String      (84,1)
 Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . String      (85,4)
 Bill Method (% Markup, Unit Price). . . BillMethod. . . . . . . . . . Uppercase   (89,1)
 Description . . . . . . . . . . . . . . Description . . . . . . . . . String      (90,40)
 Cost Detail Trans Date. . . . . . . . . CostDetailTransdate . . . . . Date        (130,6)
 Cost Detail Source. . . . . . . . . . . CostDetailSource. . . . . . . Uppercase   (136,2)
 Cost Detail Sequence. . . . . . . . . . CostDetailSequence. . . . . . Zero-Filled (138,4)
 Commissionable? (Y/N) . . . . . . . . . Commissionable. . . . . . . . Yes/No      (142,1)
 Subject To Exemption? . . . . . . . . . SubjectToExemption. . . . . . Yes/No      (143,1)
 Billed? . . . . . . . . . . . . . . . . Billed. . . . . . . . . . . . Yes/No      (144,1)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (145,9)
 Tax Class . . . . . . . . . . . . . . . TaxClass. . . . . . . . . . . Uppercase   (154,2)
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (156,10)
 Unbilled Units (Wip). . . . . . . . . . UnbilledUnitsWIP. . . . . . . Number      [0]       9.2
 Unbilled Cost (Wip) . . . . . . . . . . UnbilledCostWIP . . . . . . . Number      [1]       9.2
 Bill Rate . . . . . . . . . . . . . . . BillRate. . . . . . . . . . . Number      [2]       9.2
 Bill Amount . . . . . . . . . . . . . . BillAmount. . . . . . . . . . Number      [3]       9.2
                                                                                   ________
                                                                      Total Bytes  223
 

 JC_21  Crystal Job Billing Data Entry Detail (JC_21CrystalJobBillingLine)       Level: 4.40
        Record Type: 2    Misc Charge Line                                       08/28/2009
 
 File Type: Direct   Key Size: 18   Rec Len: 225     Min Len: 165    Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
 Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(7,7)
 Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5)
 Line Type (1=Cost Code, 2=/M, 3=/C)Ne). LineType. . . . . . . . . . . String      (19,1)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,10)
 Misc Charge Code  ("/M       ") . . . . MiscAndCommentCodes . . . . . String      (30,9)
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (39,51)
 Description . . . . . . . . . . . . . . Description . . . . . . . . . String      (90,40)
 Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (130,12)
 Commissionable? . . . . . . . . . . . . Commissionable. . . . . . . . Yes/No      (142,1)
 Subject To Exemption? . . . . . . . . . SubjectToExemption. . . . . . Yes/No      (143,1)
 Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (144,1)
 G/L Expense Account . . . . . . . . . . GLExpenseAccount. . . . . . . G/L Account (145,9)
 Tax Class . . . . . . . . . . . . . . . TaxClass. . . . . . . . . . . Uppercase   (154,2)
 Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (156,10)
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0]       0.
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1]       0.
 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2]       0.
 Bill Amount for Misc Type . . . . . . . BillAmount. . . . . . . . . . Number      [3]       9.2
                                                                                   ________
                                                                      Total Bytes  184
 

 JC_21  Crystal Job Billing Data Entry Detail (JC_21CrystalJobBillingLine)       Level: 4.40
        Record Type: 3    Comment Detail Line                                    08/28/2009
 
 File Type: Direct   Key Size: 18   Rec Len: 225     Min Len: 165    Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
 Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(7,7)
 Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5)
 Line Type (1=Cost Code, 2=/M, 3=/C) . . LineType. . . . . . . . . . . Zero-Filled (19,1)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,10)
 Comment Code  ("/C       ") . . . . . . MiscAndCommentCodes . . . . . String      (30,9)
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (39,1)
 Comment . . . . . . . . . . . . . . . . Comment . . . . . . . . . . . String      (40,55)
 Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (95,71)
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0]       0.
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1]       0.
 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2]       0.
 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3]       0.
                                                                                   ________
                                                                      Total Bytes  171
 

 JC_21  Crystal Job Billing Data Entry Detail (JC_21CrystalJobBillingLine)       Level: 4.40
        Record Type: X    Header Only Place Holder for Crystal                   08/28/2009
 
 File Type: Direct   Key Size: 18   Rec Len: 225     Min Len: 165    Define: Y

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
 Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(7,7)
 Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5)
 Line Type (0=Header Only Placeholder) . LineType. . . . . . . . . . . Zero-Filled (19,1)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,146)
 Unbilled Units (WIP). . . . . . . . . . UnbilledUnitsWIP. . . . . . . Number      [0]       9.2
 Unbilled Cost (WIP) . . . . . . . . . . UnbilledCostWIP . . . . . . . Number      [1]       9.2
 Bill Rate . . . . . . . . . . . . . . . BillRate. . . . . . . . . . . Number      [2]       9.2
 Bill Amount . . . . . . . . . . . . . . BillAmount. . . . . . . . . . Number      [3]       9.2
                                                                                   ________
                                                                      Total Bytes  223