JCN Temporary Job Billing Work File () Level: 4.40
Record Type: 1 J/C Temporary Job Billing Detail File 08/28/2009
File Type: Direct Key Size: 38 Rec Len: 144 Min Len: 78 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(1,7)
Cost Type Code (1-9,A,B,C For 1-12 Prms)CostType. . . . . . . . . . . String *(8,1)
Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(9,9)
Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(18,2)
Vendor Number (If Cost Type "S"). . . . VendorNumber. . . . . . . . . String *(20,7)
Transaction Date. . . . . . . . . . . . TransactionDate . . . . . . . Date *(27,6)
Source Code ("CO"=Change Order) . . . . SourceCode. . . . . . . . . . String *(33,2)
Sequence Counter. . . . . . . . . . . . SequenceCounter . . . . . . . Zero-Filled *(35,4)
Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String (39,40)
Transaction Units . . . . . . . . . . . TransactionUnits. . . . . . . Number [0] 7.2
Transaction Unit Cost . . . . . . . . . TransactionUnitCost . . . . . Number [1] 7.2
Transaction Amount. . . . . . . . . . . TransactionAmount . . . . . . Number [2] 8.2
Retention (If Type "S") . . . . . . . . Retention . . . . . . . . . . Number [3] 8.2
________
Total Bytes 130