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