BM_BillDetail BM Bill of Materials Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BM_BillDetail_bus,BM_ChangeControlRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_BillDetail.M4T"
KPRIMARY: BillNo+Revision+LineKey KDISPLAY: BillNo+Revision+LineSeqNo+LineKey KWHEREUSED: ComponentItemCode+BillNo+Revision+ComponentRevision+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 BillNo. . . . . . . . . . . . 30 SYY Bill Number . . . . . . . . . .BILLNO Read Only:Y Notes: {BM2$(1, 15)} 2 Revision. . . . . . . . . . . 3 SYY Bill Revision Code. . . . . . .REVISION Read Only:Y FmtType:CHARNUM Notes: {BM2$(21,3)} 3 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 4 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 FmtType:ZEROFILL 5 ComponentItemCode . . . . . . 30 SYY Component Item Code . . . . . .ITEM Notes: {BM2$(1,15)} 6 ComponentRevision . . . . . . 3 SYN Component Revision. . . . . . .REVISION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:NotComment, NotCharge,ItemRequired, BillRevisions Notes: * = Use Current Revision {BM2$(22,3)} 7 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Read Only:Y DfltVal:1 Valid:1,3,4 Notes: 1=Componen t, 3=Misc Charge, 4=Comment {BM2$(21,1)} 8 ComponentDesc . . . . . . . . 30 SNN Component Description . . . . .DESCRIPTION ValGroup:NotComment, ItemRequired Notes: {BM2$(22, 30)} 9 EngineeringDrawingFindNo. . . 5 SNN Engineering Drawing Find Number FmtType:ALPHANUM Notes: {BM2$(25,5)} 10 EngineeringChangeAddNo. . . . 7 SYN Engineering Change/Add Number . FmtType:ALPHANUM ValGroup:Eng ineeringChangeControl Notes: {BM2$(30,6)} 11 EngineeringChangeAddDate. . . 8 SNN Engineering Change/Add Date . .DATE ValGroup:EngineeringChangeCon trol Notes: {BM2$(36,6)} 12 EngineeringChangeDelNo. . . . 7 SNN Engineering Change/Delete Numbe FmtType:ALPHANUM ValGroup:Eng ineeringChangeControl Notes: {BM2$(42,6)} 13 EngineeringChangeDelDate. . . 8 SNN Engineering Change/Delete Date.DATE ValGroup:EngineeringChangeCon trol Notes: {BM2$(48,6)} 14 WorkOrderStepNo . . . . . . . 4 SNN Work Order Step Number. . . . . FmtType:ZEROFILL Notes: {BM2$(54,4)} 15 BillType. . . . . . . . . . . 1 SYN Bill Type . . . . . . . . . . . Read Only:Y Notes: Bill Type of Component or Blank if Not A Bill {BM2$(58,1)} 16 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT Notes: {BM2$(22.50)} 17 MiscChargeGLAcctKey . . . . . 9 SYN Miscellaneous Charge G/L AccounACCOUNT DepVal:REQUIRED ValGroup:NotC omment,NotItem Notes: {BM2$(52,9)} 18 SetupCharge . . . . . . . . . 1 SYN Setup Charge. . . . . . . . . .YESNO Read Only:Y DfltVal:N Valid:Y,N ValGroup:NotComment ,NotItem Notes: {BM2$(62,1)} 19 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE ValGroup:NotComment,NotItem, ItemRequired Notes: {BM2$(63, 4)} 20 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment Notes: {BM2[0]} 21 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost Per Bill . .COST Mask:##,###,###.000000- ValGroup:NotComment,NotItem Notes: {BM2[1]} LineType=3 22 ScrapPercent. . . . . . . . . 9.3 NNN Scrap Percent . . . . . . . . .BMPERCENTAGE DfltVal:0 Mask:#0.000% ValGroup:ScrapYield Notes: {BM2[1]} LineType=1