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