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