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

COMPANY..BM010415 Table Definition

(COMPANY..BOM Revision)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
BOMCAT_I smallint
0
p>Actually...(more) Join Now
BOMNAME_I char(15)
''
Bill of Ma...(more) Join Now
REVISIONLEVEL_I char(51)
''

EFFECTIVEDATE_I datetime
'1/1/1900'

BACKFLUSHITEM_I tinyint
0

BOMTYPE_I smallint
0
p>Actually...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now POP10110.LOCNCODE
join ... more text available
WCID_I char(11)
''

Net_Phantom_Inventory tinyint
0

CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
CHANGEBY_I char(15)
''
*Change By...(more) Join Now TATX1030.CHANGEBY_I
MFGNOTEINDEX3_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