     JC_H3  J/C Job History Transaction Detail File (JC_H3_TransactionDetailHistory) Level: 4.40
            Record Type: 1    J/C Cost Trans File (Contract Chnge/Ord)               08/28/2009

     File Type: Direct   Key Size: 40   Rec Len: 200     Min Len: 144    Define: Y

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

     Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(1,7)
     Rec Type (0=Contract Change Orders) . . RecordType. . . . . . . . . . Zero-Filled *(8,1)
     Cost Code (Not Used). . . . . . . . . . CostCode. . . . . . . . . . . Account     *(9,9)
     Cost Type (Not Used). . . . . . . . . . CostType. . . . . . . . . . . String      *(18,1)
     Division Number (Not Used). . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(19,2)
     Vendor Number (Not Used). . . . . . . . VendorNumber. . . . . . . . . String      *(21,7)
     Cost Detail Type (Not Used) . . . . . . CostDetailType. . . . . . . . Zero-Filled *(28,1)
     Transaction Date. . . . . . . . . . . . TransactionDate . . . . . . . Date        *(29,6)
     Source Code ("CO"=Change Order) . . . . SourceCode. . . . . . . . . . String      *(35,2)
     Sequence Counter. . . . . . . . . . . . SeqNo . . . . . . . . . . . . Zero-Filled *(37,4)
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (41,1)
     Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String      (42,53)
     Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (95,50)
     Trans Units . . . . . . . . . . . . . . TransactionUnits. . . . . . . Number      [0]       7.2
     Transaction Unit Cost . . . . . . . . . TransactionUnitCost . . . . . Number      [1]       7.2
     Transaction Amount. . . . . . . . . . . TransactionAmount . . . . . . Number      [2]       8.2
     Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3]       0.
                                                                                       ________
                                                                          Total Bytes  184

     JC_H3  J/C Job History Transaction Detail File (JC_H3_TransactionDetailHistory) Level: 4.40
            Record Type: 2    J/C Cost Transaction File  (Bill Detail)               08/28/2009

     File Type: Direct   Key Size: 40   Rec Len: 200     Min Len: 144    Define: Y

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

     Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(1,7)
     Rec Type (1=Bill Detail). . . . . . . . RecordType. . . . . . . . . . Zero-Filled *(8,1)
     Cost Code (Not Used). . . . . . . . . . CostCode. . . . . . . . . . . Account     *(9,9)
     Cost Type (Not Used). . . . . . . . . . CostType. . . . . . . . . . . String      *(18,1)
     Division Number (Not Used). . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(19,2)
     Vendor Number (Not Used). . . . . . . . VendorNumber. . . . . . . . . String      *(21,7)
     Cost Detail Type (Not Used) . . . . . . CostDetailType. . . . . . . . Zero-Filled *(28,1)
     Transaction Date. . . . . . . . . . . . TransactionDate . . . . . . . Date        *(29,6)
     Type Code ("I"=Invoice, "P"=Payment). . TypeCode. . . . . . . . . . . String      *(35,1)
     Source Code ("A"=A/R, "J"=J/C). . . . . SourceCodeBillDetl. . . . . . String      *(36,1)
     Sequence Counter. . . . . . . . . . . . SeqNo . . . . . . . . . . . . Zero-Filled *(37,4)
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (41,1)
     Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String      (42,53)
     Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (95,50)
     Retention Amount. . . . . . . . . . . . BillRetentionAmount . . . . . Number      [0]       8.2
     Sales Tax Amount. . . . . . . . . . . . BillSalesTaxAmount. . . . . . Number      [1]       7.2
     Billed/Payment Amount . . . . . . . . . BilledOrPaymentAmount . . . . Number      [2]       8.2
     Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3]       0.
                                                                                       ________
                                                                          Total Bytes  185

     JC_H3  J/C Job History Transaction Detail File (JC_H3_TransactionDetailHistory) Level: 4.40
            Record Type: 3    J/C Cost Transaction File (Cost Detail)                08/28/2009

     File Type: Direct   Key Size: 40   Rec Len: 200     Min Len: 144    Define: Y

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

     Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(1,7)
     Rec Type (2=Cost Detail). . . . . . . . RecordType. . . . . . . . . . Zero-Filled *(8,1)
     Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account     *(9,9)
     Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . String      *(18,1)
     Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(19,2)
       Only with Cost Type = S . . . . . . . . . . . . . . . . . . . . . . Memo
     Vendor Number (If Cost Type "S"). . . . VendorNumber. . . . . . . . . String      *(21,7)
       Only with Cost Type = S . . . . . . . . . . . . . . . . . . . . . . Memo
     Cost Detail Type. . . . . . . . . . . . CostDetailType. . . . . . . . Zero-Filled *(28,1)
       0 = Subcontract C/O, 1 = Costs. . . . . . . . . . . . . . . . . . . Memo
     Transaction Date. . . . . . . . . . . . TransactionDate . . . . . . . Date        *(29,6)
     Source Code ("CO"=Change Order) . . . . SourceCode. . . . . . . . . . String      *(35,2)
     Sequence Counter. . . . . . . . . . . . SeqNo . . . . . . . . . . . . Zero-Filled *(37,4)
     Billed. . . . . . . . . . . . . . . . . Billed. . . . . . . . . . . . Yes/No      (41,1)
     Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String      (42,53)
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (95,50)
     Trans Units . . . . . . . . . . . . . . TransactionUnits. . . . . . . Number      [0]       7.2
     Transaction Unit Cost . . . . . . . . . TransactionUnitCost . . . . . Number      [1]       7.2
     Transaction Amount. . . . . . . . . . . TransactionAmount . . . . . . Number      [2]       8.2
     Retention Amount (If Cost Type = "S") . CostRetentionAmount . . . . . Number      [3]       8.2
                                                                                       ________
                                                                          Total Bytes  196