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