JCI J/C Job Estimate Line Detail File (JCI_EstimateDetailLine) Level: 4.40 Record Type: 1 J/C Estimate Line Detail (Item) 08/28/2009 File Type: Indexed Key Size: Rec Len: 256 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Estimate Number . . . . . . . . . . . . EstimateNumber. . . . . . . . Account (1,7) Link To Previous Line (0=First) . . . . PreviousIndexNumber . . . . . Number [0] 6.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0 Line Type (1=Inventory Item). . . . . . LineType. . . . . . . . . . . String (1,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (2,15) Description . . . . . . . . . . . . . . Description . . . . . . . . . String (17,30) U/M . . . . . . . . . . . . . . . . . . ItemUnitOfMeasure . . . . . . Uppercase (47,4) Cost Code . . . . . . . . . . . . . . . ItemCostCode. . . . . . . . . Uppercase (51,9) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (60,7) Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (67,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (97,50) Quantity. . . . . . . . . . . . . . . . Qty . . . . . . . . . . . . . Number [0] 6.4 Unit Cost . . . . . . . . . . . . . . . UnitCost. . . . . . . . . . . Number [1] 6.4 Unit Price. . . . . . . . . . . . . . . UnitPrice . . . . . . . . . . Number [2] 6.4 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0. Extended Cost . . . . . . . . . . . . . ExtdCost. . . . . . . . . . . Number [4] 6.4 Extended Price. . . . . . . . . . . . . ExtdPrice . . . . . . . . . . Number [5] 6.4 ________ Total Bytes 240
JCI J/C Job Estimate Line Detail File (JCI_EstimateDetailLine) Level: 4.40 Record Type: 2 J/C Estimate Line Detail (Misc) 08/28/2009 File Type: Indexed Key Size: Rec Len: 256 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Estimate Number . . . . . . . . . . . . EstimateNumber. . . . . . . . Account (1,7) Link To Previous Line (0=First) . . . . PreviousIndexNumber . . . . . Number [0] 6.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0 Line Type (2=Misc. Charge). . . . . . . LineType. . . . . . . . . . . String (1,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (2,15) Description . . . . . . . . . . . . . . Description . . . . . . . . . String (17,30) Type. . . . . . . . . . . . . . . . . . TypeForRecord2. . . . . . . . String (47,1) Method. . . . . . . . . . . . . . . . . Method. . . . . . . . . . . . String (48,1) Cost Code . . . . . . . . . . . . . . . MiscCostCode. . . . . . . . . Uppercase (49,9) U/M . . . . . . . . . . . . . . . . . . MiscUnitOfMeasure . . . . . . String (58,4) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (62,5) "/M " (For Direct Cost Code Entry) . MiscOrCommentCode . . . . . . String (67,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (97,50) Quantity. . . . . . . . . . . . . . . . Qty . . . . . . . . . . . . . Number [0] 6.4 Unit Cost . . . . . . . . . . . . . . . UnitCost. . . . . . . . . . . Number [1] 6.4 Unit Price. . . . . . . . . . . . . . . UnitPrice . . . . . . . . . . Number [2] 6.4 Rate. . . . . . . . . . . . . . . . . . MiscRate. . . . . . . . . . . Number [3] 6.4 Extended Cost . . . . . . . . . . . . . ExtdCost. . . . . . . . . . . Number [4] 6.4 Extended Price. . . . . . . . . . . . . ExtdPrice . . . . . . . . . . Number [5] 6.4 ________ Total Bytes 252
JCI J/C Job Estimate Line Detail File (JCI_EstimateDetailLine) Level: 4.40 Record Type: 3 J/C Estimate Line Detail (Comment) 08/28/2009 File Type: Indexed Key Size: Rec Len: 256 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Estimate Number . . . . . . . . . . . . EstimateNumber. . . . . . . . Account (1,7) Link To Previous Line (0=First) . . . . PreviousIndexNumber . . . . . Number [0] 6.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0 Line Type (3=Comment) . . . . . . . . . LineType. . . . . . . . . . . String (1,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (2,15) Description Line 1. . . . . . . . . . . DescriptionLine1. . . . . . . String (17,50) Comment Code ("/C "). . . . . . . . . MiscOrCommentCode . . . . . . String (67,30) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (97,50) 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. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5] 0. ________ Total Bytes 180
JCI J/C Job Estimate Line Detail File (JCI_EstimateDetailLine) Level: 4.40 Record Type: 4 J/C Estimate Line Detail (SUB) 08/28/2009 File Type: Indexed Key Size: Rec Len: 256 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Estimate Number . . . . . . . . . . . . EstimateNumber. . . . . . . . Account (1,7) Link To Previous Line (0=First) . . . . PreviousIndexNumber . . . . . Number [0] 6.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0 Line Type (4=Subtotal). . . . . . . . . LineType. . . . . . . . . . . String (1,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (2,15) Description Line 1. . . . . . . . . . . Description . . . . . . . . . String (17,30) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (47,20) "*SUB". . . . . . . . . . . . . . . . . TotOrSubType4_5 . . . . . . . String (67,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (97,50) 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. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5] 0. ________ Total Bytes 180
JCI J/C Job Estimate Line Detail File (JCI_EstimateDetailLine) Level: 4.40 Record Type: 5 J/C Estimate Line Detail (TOT) 08/28/2009 File Type: Indexed Key Size: Rec Len: 256 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Estimate Number . . . . . . . . . . . . EstimateNumber. . . . . . . . Account (1,7) Link To Previous Line (0=First) . . . . PreviousIndexNumber . . . . . Number [0] 6.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 6.0 Line Type (5=Total) . . . . . . . . . . LineType. . . . . . . . . . . String (1,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (2,15) Description Line 1. . . . . . . . . . . Description . . . . . . . . . String (17,30) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (47,20) "*TOT". . . . . . . . . . . . . . . . . TotOrSubType4_5 . . . . . . . String (67,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (97,50) 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. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5] 0. ________ Total Bytes 180