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]}