JC_21 Crystal Job Billing Data Entry Detail (JC_21CrystalJobBillingLine) Level: 4.40 Record Type: 1 Cost Code Detail Line 08/28/2009 File Type: Direct Key Size: 18 Rec Len: 225 Min Len: 165 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(7,7) Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5) Line Type (1=Cost Code, 2=/M, 3=/C) . . LineType. . . . . . . . . . . Zero-Filled (19,1) Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account (20,9) Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . String (29,1) Cost Code Description . . . . . . . . . CostCodeDescription . . . . . String (30,30) Cost Type Description . . . . . . . . . CostTypeDescription . . . . . String (60,15) Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled (75,2) Vendor Number . . . . . . . . . . . . . VendorNumber. . . . . . . . . Account (77,7) Description Only? (Y/N) . . . . . . . . DescriptionOnly . . . . . . . String (84,1) Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . String (85,4) Bill Method (% Markup, Unit Price). . . BillMethod. . . . . . . . . . Uppercase (89,1) Description . . . . . . . . . . . . . . Description . . . . . . . . . String (90,40) Cost Detail Trans Date. . . . . . . . . CostDetailTransdate . . . . . Date (130,6) Cost Detail Source. . . . . . . . . . . CostDetailSource. . . . . . . Uppercase (136,2) Cost Detail Sequence. . . . . . . . . . CostDetailSequence. . . . . . Zero-Filled (138,4) Commissionable? (Y/N) . . . . . . . . . Commissionable. . . . . . . . Yes/No (142,1) Subject To Exemption? . . . . . . . . . SubjectToExemption. . . . . . Yes/No (143,1) Billed? . . . . . . . . . . . . . . . . Billed. . . . . . . . . . . . Yes/No (144,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (145,9) Tax Class . . . . . . . . . . . . . . . TaxClass. . . . . . . . . . . Uppercase (154,2) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (156,10) Unbilled Units (Wip). . . . . . . . . . UnbilledUnitsWIP. . . . . . . Number [0] 9.2 Unbilled Cost (Wip) . . . . . . . . . . UnbilledCostWIP . . . . . . . Number [1] 9.2 Bill Rate . . . . . . . . . . . . . . . BillRate. . . . . . . . . . . Number [2] 9.2 Bill Amount . . . . . . . . . . . . . . BillAmount. . . . . . . . . . Number [3] 9.2 ________ Total Bytes 223
JC_21 Crystal Job Billing Data Entry Detail (JC_21CrystalJobBillingLine) Level: 4.40 Record Type: 2 Misc Charge Line 08/28/2009 File Type: Direct Key Size: 18 Rec Len: 225 Min Len: 165 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(7,7) Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5) Line Type (1=Cost Code, 2=/M, 3=/C)Ne). LineType. . . . . . . . . . . String (19,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,10) Misc Charge Code ("/M ") . . . . MiscAndCommentCodes . . . . . String (30,9) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (39,51) Description . . . . . . . . . . . . . . Description . . . . . . . . . String (90,40) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (130,12) Commissionable? . . . . . . . . . . . . Commissionable. . . . . . . . Yes/No (142,1) Subject To Exemption? . . . . . . . . . SubjectToExemption. . . . . . Yes/No (143,1) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (144,1) G/L Expense Account . . . . . . . . . . GLExpenseAccount. . . . . . . G/L Account (145,9) Tax Class . . . . . . . . . . . . . . . TaxClass. . . . . . . . . . . Uppercase (154,2) Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (156,10) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0. Bill Amount for Misc Type . . . . . . . BillAmount. . . . . . . . . . Number [3] 9.2 ________ Total Bytes 184
JC_21 Crystal Job Billing Data Entry Detail (JC_21CrystalJobBillingLine) Level: 4.40 Record Type: 3 Comment Detail Line 08/28/2009 File Type: Direct Key Size: 18 Rec Len: 225 Min Len: 165 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(7,7) Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5) Line Type (1=Cost Code, 2=/M, 3=/C) . . LineType. . . . . . . . . . . Zero-Filled (19,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,10) Comment Code ("/C ") . . . . . . MiscAndCommentCodes . . . . . String (30,9) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (39,1) Comment . . . . . . . . . . . . . . . . Comment . . . . . . . . . . . String (40,55) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (95,71) 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. ________ Total Bytes 171
JC_21 Crystal Job Billing Data Entry Detail (JC_21CrystalJobBillingLine) Level: 4.40 Record Type: X Header Only Place Holder for Crystal 08/28/2009 File Type: Direct Key Size: 18 Rec Len: 225 Min Len: 165 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Workstation Fid + Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(7,7) Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5) Line Type (0=Header Only Placeholder) . LineType. . . . . . . . . . . Zero-Filled (19,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,146) Unbilled Units (WIP). . . . . . . . . . UnbilledUnitsWIP. . . . . . . Number [0] 9.2 Unbilled Cost (WIP) . . . . . . . . . . UnbilledCostWIP . . . . . . . Number [1] 9.2 Bill Rate . . . . . . . . . . . . . . . BillRate. . . . . . . . . . . Number [2] 9.2 Bill Amount . . . . . . . . . . . . . . BillAmount. . . . . . . . . . Number [3] 9.2 ________ Total Bytes 223