     BM_CostOfMaterialsSelection           BM Cost Of Materials Selection  Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: Y  SysDB: N                           "MAS_"+%C$+"/BM"+%C$+"/BM_CostOfMaterialsSelection.M4T"

     KPRIMARY: BillNo+Revision+BillOption1+BillOption2+BillOption3+BillOption4+BillOption5+BillOption6+BillO
               ption7+BillOption8+BillOption9

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  BillNo. . . . . . . . . . . .    30 SYY  Bill Number . . . . . . . . . .BILLNO
       2  Revision. . . . . . . . . . .     3 SYY  Bill Revision Code. . . . . . .REVISION
                                                    DfltVal:000 FmtType:CHARNUM
                                                    DepVal:REQUIRED
       3  BillOption1 . . . . . . . . .     2 SYN  Bill Option Code 1. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
       4  BillOption2 . . . . . . . . .     2 SYN  Bill Option Code 2. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
       5  BillOption3 . . . . . . . . .     2 SYN  Bill Option Code 3. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
       6  BillOption4 . . . . . . . . .     2 SYN  Bill Option Code 4. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
       7  BillOption5 . . . . . . . . .     2 SYN  Bill Option Code 5. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
       8  BillOption6 . . . . . . . . .     2 SYN  Bill Option Code 6. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
       9  BillOption7 . . . . . . . . .     2 SYN  Bill Option Code 7. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      10  BillOption8 . . . . . . . . .     2 SYN  Bill Option Code 8. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      11  BillOption9 . . . . . . . . .     2 SYN  Bill Option Code 9. . . . . . .BILLOPTION
                                                    FmtType:CHARNUM
      12  BillFormat. . . . . . . . . .     1 SYY  Bill Format . . . . . . . . . .
                                                    DfltVal:1 Valid:1,2,3 Notes:
                                                    1=Single, 2=Indented,
                                                    3=Summarized
      13  EffectiveDate . . . . . . . .     8 SYY  Effective Date. . . . . . . . .DATE
                                                    DfltVal:
                                                    ValGroup:EngineeringChangeCon
                                                    trol
      14  ComponentWarehouseCode. . . .     3 SYY  Component Warehouse Code. . . .WAREHOUSE
                                                    FmtType:CHARNUM ValGroup:Mult
                                                    iWarehouse
      15  QuantityRequired. . . . . . . 16.6  NNN  Quantity Required . . . . . . .QUANTITY
                                                    DfltVal:1 Mask:##,###,
                                                    ###.000000-
      16  DateCreated . . . . . . . . .     8 SNY  Date Created. . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      17  TimeCreated . . . . . . . . .     8 SNY  Time Created. . . . . . . . . .
                                                    Read Only:Y
      18  UserCreatedKey. . . . . . . .    10 SYY  User Created Key. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
      19  DateUpdated . . . . . . . . .     8 SNN  Last Date Updated . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      20  TimeUpdated . . . . . . . . .     8 SNN  Last Time Updated . . . . . . .
                                                    Read Only:Y
      21  UserUpdatedKey. . . . . . . .    10 SNN  Last User Updated . . . . . . .USER
                                                    Read Only:Y Mask:0000000000