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