DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module Manufacturing tables BMMU0005
You are currently viewing the COMPANY database.
Change

COMPANY..BMMU0005 Table Definition

(COMPANY..BOM_Mass_Changes_Reporting_WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
PPN_I char(31)
''
Parent Par...(more) Join Now
CPN_I char(31)
''
Component ...(more) Join Now
BOMCAT_I smallint
0

BOMNAME_I char(15)
''
Bill of Ma...(more) Join Now
BOMSEQ_I int
0
Bill of Ma...(more) Join Now
POSITION_NUMBER smallint
0
Position N...(more) Join Now
REVISIONLEVEL_I char(51)
''

CB_I tinyint
0

BOMTYPE_I smallint
0

SUBCAT_I smallint
0
Sub Catego...(more) Join Now
SUBNAME_I char(15)
''
Sub Catego...(more) Join Now
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
CHANGEBY_I char(15)
''
*Change By...(more) Join Now TATX1030.CHANGEBY_I
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

ACTION1 smallint
0

ROUTINGLINK_I tinyint
0

ROUTING_LINK_DISSOLVED_I tinyint
0

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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3