Module List > Module Manufacturing tables BM010115
You are currently viewing the COMPANY database.
Change

COMPANY..BM010115 Table Definition

(COMPANY..Bill Of Material Line File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PPN_I char(31)
''
Parent Par...(more) Join Now
CPN_I char(31)
''
Component ...(more) Join Now
BOMCAT_I smallint
0
p>Actually...(more) Join Now
BOMNAME_I char(15)
''
Bill of Ma...(more) Join Now
BOMTYPE_I smallint
0
p>Actually...(more) Join Now
BOMSEQ_I int
0
Bill of Ma...(more) Join Now
POSITION_NUMBER smallint
0
Position N...(more) Join Now
SUBCAT_I smallint
0
Sub Catego...(more) Join Now
SUBNAME_I char(15)
''
Sub Catego...(more) Join Now
SUB_REV_LEVEL_SEQ_I int
0

QUANTITY_I numeric(19,5)
0.00
Quantity...(more) Join Now
OPTPERCENT_I int
0

SCRAPPERCENT_I int
0
Scrap Perc...(more) Join Now
FLOORSTOCK_I tinyint
0

EFFECTIVEINDATE_I datetime
'1/1/1900'

EFFECTIVEOUTDATE_I datetime
'1/1/1900'

ALTERNATE_I tinyint
0

ALTERNATEPARTFOR_I char(31)
''

ALT_FOR_BOM_SEQ_I int
0

LEADTIMEOFFSET_I numeric(19,5)
0.00

LEADTIMEOFFSETINC_I smallint
0

BOMUSERDEF1_I char(31)
''

BOMUSERDEF2_I char(31)
''

BOMSINGLELOT_I tinyint
0

BOMENGAPPROVAL_I tinyint
0

WCID_I char(11)
''

LOCNCODE char(11)
''
Location C...(more) Join Now POP10110.LOCNCODE
join ... more text available
BACKFLUSHITEM_I tinyint
0

CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
OPTIONED_ITEM_I tinyint
0

ACTUAL_CONSUMED_CHECK_I tinyint
0

FIXED_QTY_I numeric(19,5)
0.00

UOFM char(9)
''
U of M The...(more) Join Now POP10110.UOFM
See I... more text available
U_Of_M_2 char(9)
''

QTYBSUOM numeric(19,5)
0.00
QTY In Bas...(more) Join Now SVC30701.QTYBSUOM
OFFSET_FROM_I smallint
0

MFGNOTEINDEX_I numeric(19,5)
0.00

MFGNOTEINDEX2_I numeric(19,5)
0.00

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3