     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