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

COMPANY..BM010300 Table Definition

(COMPANY..Bill Of Materials Log 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
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
CHANGENUMBER_I smallint
0

DESCRIPTIN50 char(51)
''

UNIT_I char(11)
''

ADDCHG_I char(15)
''

DATE1 datetime
'1/1/1900'

TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now POP10100.TIME1
QUANTITY_I numeric(19,5)
0.00
Quantity...(more) Join Now
OPTPERCENT_I int
0

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

ALTERNATEPARTFOR_I char(31)
''

LEADTIMEOFFSET_I numeric(19,5)
0.00

BOMUSERDEF1_I char(31)
''

BOMUSERDEF2_I char(31)
''

BOMSINGLELOT_I tinyint
0

BOMENGAPPROVAL_I tinyint
0

WCID_I char(11)
''

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