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