BM_OptionInteractionDetail BM Option Interaction Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: BM_OptionInteractionDetail_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_OptionInteractionDetail.M4T"
KPRIMARY: BillNo+Revision+BillOption1+BillOption2+BillOption3+BillOption4+BillOption5+BillOption6+BillO ption7+BillOption8+BillOption9+LineKey KDISPLAY: BillNo+Revision+BillOption1+BillOption2+BillOption3+BillOption4+BillOption5+BillOption6+BillO ption7+BillOption8+BillOption9+LineSeqNo+LineKey KWHEREUSED: ComponentItemCode+BillNo+Revision+BillOption1+BillOption2+BillOption3+BillOption4+BillOptio n5+BillOption6+BillOption7+BillOption8+BillOption9+ComponentRevision+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 BillNo. . . . . . . . . . . . 30 SYY Bill Number . . . . . . . . . .BILLNO Read Only:Y Notes: {BM4$(1, 15)} 2 Revision. . . . . . . . . . . 3 SYY Bill Revision Code. . . . . . .REVISION Read Only:Y FmtType:CHARNUM Notes: {BM4$(21,3)} 3 BillOption1 . . . . . . . . . 2 SYN Bill Option Code 1. . . . . . .BILLOPTION Read Only:Y Notes: {BM4$(24, 2)} 4 BillOption2 . . . . . . . . . 2 SYN Bill Option Code 2. . . . . . .BILLOPTION Read Only:Y Notes: {BM4$(26, 2)} 5 BillOption3 . . . . . . . . . 2 SYN Bill Option Code 3. . . . . . .BILLOPTION Read Only:Y Notes: {BM4$(28, 2)} 6 BillOption4 . . . . . . . . . 2 SYN Bill Option Code 4. . . . . . .BILLOPTION Read Only:Y Notes: {BM4$(30, 2)} 7 BillOption5 . . . . . . . . . 2 SYN Bill Option Code 5. . . . . . .BILLOPTION Read Only:Y Notes: {BM4$(32, 2)} 8 BillOption6 . . . . . . . . . 2 SYN Bill Option Code 6. . . . . . .BILLOPTION Read Only:Y Notes: {BM4$(34, 2)} 9 BillOption7 . . . . . . . . . 2 SYN Bill Option Code 7. . . . . . .BILLOPTION Read Only:Y Notes: {BM4$(36, 2)} 10 BillOption8 . . . . . . . . . 2 SYN Bill Option Code 8. . . . . . .BILLOPTION Read Only:Y Notes: {BM3$(38, 2)} 11 BillOption9 . . . . . . . . . 2 SYN Bill Option Code 9. . . . . . .BILLOPTION Read Only:Y Notes: {BM4$(40, 2)} 12 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 13 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Mask:00000000000000 FmtType:ZEROFILL 14 ComponentItemCode . . . . . . 30 SYY Component Item Code . . . . . .ITEM Notes: {BM4$(1,15)} 15 ComponentRevision . . . . . . 3 SYN Component Revision. . . . . . .REVISION FmtType:CHARNUM DepVal:REQUIR ED ValGroup:NotComment, NotCharge,ItemRequired, BillRevisions Notes: * = Use Current Revision {BM4$(22,3)} 16 ItemType. . . . . . . . . . . 1 SYY Item Type . . . . . . . . . . . Read Only:Y DfltVal:1 Valid:1,3,4 Notes: 1=Componen t, 3=Misc Charge, 4=Comment {BM4$(21,1)} 17 ComponentDesc . . . . . . . . 30 SNN Component Description . . . . .DESCRIPTION ValGroup:NotComment, ItemRequired 18 EngineeringChangeAddNo. . . . 7 SYN Engineering Change/Add Number . FmtType:ALPHANUM ValGroup:Eng ineeringChangeControl Notes: {BM4$(30,6)} LineType=1 19 EngineeringChangeAddDate. . . 8 SNN Engineering Change/Add Date . .DATE ValGroup:EngineeringChangeCon trol Notes: {BM4$(36,6)} LineType=1 20 EngineeringChangeDelNo. . . . 7 SNN Engineering Change/Delete Numbe FmtType:ALPHANUM ValGroup:Eng ineeringChangeControl Notes: {BM4$(42,6)} LineType=1 21 EngineeringChangeDelDate. . . 8 SNN Engineering Change/Delete Date.DATE ValGroup:EngineeringChangeCon trol Notes: {BM4$(48,6)} LineType=1 22 BillType. . . . . . . . . . . 1 SYN Bill Type . . . . . . . . . . . 23 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .COMMENT Notes: {BM4$(22,50)} LineType=2 24 MiscChargeGLAcctKey . . . . . 9 SYN Miscellaneous Charge G/L AccounACCOUNT DepVal:REQUIRED ValGroup:NotC omment,NotItem Notes: {BM4$(52,9)} LineType=3 25 SetupCharge . . . . . . . . . 1 SYN Setup Charge. . . . . . . . . .YESNO Read Only:Y DfltVal:N Valid:Y,N ValGroup:NotComment ,NotItem Notes: {BM4$(62,1)} LineType=3 26 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE ValGroup:NotComment,NotItem, ItemRequired Notes: {BM4$(63, 4)} LineType=3 27 QuantityPerBill . . . . . . . 16.6 NNN Quantity Per Bill . . . . . . .QUANTITY Mask:##,###,###.000000- ValGroup:NotComment Notes: {BM4[0]} LineType=1,3 28 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost Per Bill . .COST Mask:##,###,###.000000- ValGroup:NotComment,NotItem Notes: {BM4[1]} LineType=3 29 ScrapPercent. . . . . . . . . 9.3 NNN Scrap Percent . . . . . . . . .BMPERCENTAGE DfltVal:0 Mask:#0.000% ValGroup:ScrapYield Notes: {BM4[1]}