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