JC3    J/C Job Cost Transaction Detail File (JC3_TransactionDetail)             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)
 CostCode (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)
 Billed (Not Used) . . . . . . . . . . . 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
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3]       0.
                                                                                   ________
                                                                      Total Bytes  184
 

 JC3    J/C Job Cost Transaction Detail File (JC3_TransactionDetail)             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)
 Billed (Not Used) . . . . . . . . . . . Billed. . . . . . . . . . . . Yes/No      (41,1)
 Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String      (42,53)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . 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
 

 JC3    J/C Job Cost Transaction Detail File (JC3_TransactionDetail)             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 . . . . . . . . . . . . . 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