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