JCE J/C Job Billing Entry Detail File (JCE_JobBillingsDataEntry) Level: 4.40 Record Type: 1 J/C Job Billing Data Entry Detail (C.C.) 08/28/2009 File Type: Indexed Key Size: Rec Len: 168 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Zero-Filled (1,7) Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 6.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0 Line Type (1=Cost Code Line). . . . . . LineType. . . . . . . . . . . Zero-Filled (1,1) Cost Code . . . . . . . . . . . . . . . CostMiscCommentCode . . . . . Account (2,9) Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . Uppercase (11,1) Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled (12,2) Vendor Number (For Cost Type "S")VendorNumber. . . . . . . . . Account (14,7) Description Only? (Y/N) . . . . . . . . DescriptionOnly . . . . . . . String (21,1) Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . String (22,4) Bill Method (% Markup, Unit Price). . . BillMethod. . . . . . . . . . Uppercase (26,1) Description . . . . . . . . . . . . . . Description . . . . . . . . . String (27,40) Cost Detail Trans Date (If Bill Detail)CostDetailTransDate . . . . . Date (67,6) Cost Detail Source (If Bill Detail)CostDetailSource. . . . . . . Uppercase (73,2) Cost Detail Sequence (If Bill Detail)CostSeq . . . . . . . . . . . Zero-Filled (75,4) Commissionable? (Y/N) . . . . . . . . . Commisionable . . . . . . . . Yes/No (79,1) Subject To Exemption. . . . . . . . . . SubjectToExemption. . . . . . Yes/No (80,1) Billed? (Y/N) . . . . . . . . . . . . . Billed. . . . . . . . . . . . Yes/No (81,1) Tax Class . . . . . . . . . . . . . . . TaxClass. . . . . . . . . . . Uppercase (82,2) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (84,2) Unbilled Units (Wip). . . . . . . . . . UnbilledUnits . . . . . . . . Number [0] 7.2 Unbilled Cost (Wip) . . . . . . . . . . UnbilledCost. . . . . . . . . Number [1] 7.2 Bill Rate . . . . . . . . . . . . . . . BillRate. . . . . . . . . . . Number [2] 7.2 Bill Amount . . . . . . . . . . . . . . BillAmountCostCode. . . . . . Number [3] 7.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [4] 0. ________ Total Bytes 162
JCE J/C Job Billing Entry Detail File (JCE_JobBillingsDataEntry) Level: 4.40 Record Type: 2 J/C Job Billing Data Entry Detail (Misc) 08/28/2009 File Type: Indexed Key Size: Rec Len: 168 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Zero-Filled (1,7) Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 6.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0 Line Type (2=Misc Direct Expense Line). LineType. . . . . . . . . . . Zero-Filled (1,1) Misc Direc Expense ("/M "). . . MiscDirectExpense . . . . . . String (2,9) G/L Expense Account . . . . . . . . . . GLExpenseAcctNumber . . . . . G/L Account (11,9) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,7) Description . . . . . . . . . . . . . . Description . . . . . . . . . String (27,40) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (67,12) Commissionable? (Y/N) . . . . . . . . . Commisionable . . . . . . . . Yes/No (79,1) Subject To Exemption (Y/N). . . . . . . SubjectToExemption. . . . . . Yes/No (80,1) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (81,1) Tax Class . . . . . . . . . . . . . . . TaxClass. . . . . . . . . . . Uppercase (82,2) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (84,2) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Bill Amount . . . . . . . . . . . . . . BillAmount. . . . . . . . . . Number [3] 7.2 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [4] 0. ________ Total Bytes 129
JCE J/C Job Billing Entry Detail File (JCE_JobBillingsDataEntry) Level: 4.40 Record Type: 3 J/C Job Billing Data Entry Detail (Cmnt) 08/28/2009 File Type: Indexed Key Size: Rec Len: 168 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Zero-Filled (1,7) Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 6.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0 Line Type (3=Comment Line). . . . . . . LineType. . . . . . . . . . . Zero-Filled (1,1) Comment Code ("/C ") . . . . . . Comment . . . . . . . . . . . String (2,9) Comment . . . . . . . . . . . . . . . . CommentLine . . . . . . . . . String (11,55) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (66,20) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0. ________ Total Bytes 118