JC7 J/C Job Posting Entry Detail (JC7_TransactionDataEntry) Level: 4.40
Record Type: 1 J/C Job Trans Data Entry Detail (Costs) 08/28/2009
File Type: Indexed Key Size: Rec Len: 152 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Trans Type ("1"=Direct Cost Postings) . TransactionType . . . . . . . Zero-Filled (1,1)
Cost Posting Batch Number . . . . . . . BatchNumber . . . . . . . . . Zero-Filled (2,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 6.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase (1,7)
Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account (8,9)
Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . String (17,1)
Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled (18,2)
Vendor Number . . . . . . . . . . . . . VendorNumber. . . . . . . . . Account (20,7)
Reference . . . . . . . . . . . . . . . RefNumber . . . . . . . . . . String (27,10)
Detail Transaction Date . . . . . . . . DetailTransactionDate . . . . Date (37,6)
Debit G/L Account . . . . . . . . . . . DebitGlAcct . . . . . . . . . G/L Account (43,9)
Comment . . . . . . . . . . . . . . . . Comment . . . . . . . . . . . String (52,20)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (72,9)
Unit Cost . . . . . . . . . . . . . . . UnitCost. . . . . . . . . . . Number [0] 7.2
Units . . . . . . . . . . . . . . . . . Units . . . . . . . . . . . . Number [1] 7.2
Extension . . . . . . . . . . . . . . . Extension . . . . . . . . . . Number [2] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
________
Total Bytes 146
JC7 J/C Job Posting Entry Detail (JC7_TransactionDataEntry) Level: 4.40
Record Type: 2 J/C Job Trans Data Entry Detail (Bills) 08/28/2009
File Type: Indexed Key Size: Rec Len: 152 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Trans Type ("2"=Billing Postings) . . . TransactionType . . . . . . . Zero-Filled (1,1)
Billing Batch Number. . . . . . . . . . BatchNumber . . . . . . . . . Zero-Filled (2,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 6.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase (1,7)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (8,19)
Reference . . . . . . . . . . . . . . . RefNumber . . . . . . . . . . String (27,10)
Detail Transaction Date . . . . . . . . DetailTransactionDate . . . . Date (37,6)
Credit G/L Account. . . . . . . . . . . CreditGlAcct. . . . . . . . . G/L Account (43,9)
Comment . . . . . . . . . . . . . . . . Comment . . . . . . . . . . . String (52,20)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (72,9)
Retention % . . . . . . . . . . . . . . RetentionPercent. . . . . . . Number [0] 3.2
Bill Amount . . . . . . . . . . . . . . BillAmount. . . . . . . . . . Number [1] 7.2
Retention Amount. . . . . . . . . . . . RetentionAmount . . . . . . . Number [2] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
________
Total Bytes 142
JC7 J/C Job Posting Entry Detail (JC7_TransactionDataEntry) Level: 4.40
Record Type: 3 J/C Job Trans Data Entry Dtl (Csh Rcpt) 08/28/2009
File Type: Indexed Key Size: Rec Len: 152 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Trans Type ("3"=Cash Receipt Postings). TransactionType . . . . . . . Zero-Filled (1,1)
Cash Receipt Batch Number . . . . . . . BatchNumber . . . . . . . . . Zero-Filled (2,7)
Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 6.0
Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase (1,7)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (8,19)
Reference . . . . . . . . . . . . . . . RefNumber . . . . . . . . . . String (27,10)
Detail Transaction Date . . . . . . . . DetailTransactionDate . . . . Date (37,6)
Credit G/L Account. . . . . . . . . . . CreditGlAcct. . . . . . . . . G/L Account (43,9)
Comment . . . . . . . . . . . . . . . . Comment . . . . . . . . . . . String (52,20)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (72,9)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Receipt Amount. . . . . . . . . . . . . RecptAmount . . . . . . . . . Number [1] 7.2
Retention Amount. . . . . . . . . . . . RetentionAmount . . . . . . . Number [2] 7.2
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [3] 0.
________
Total Bytes 135