Module List > Module IV tables BM10300
You are currently viewing the COMPANY database.
Change

COMPANY..BM10300 Table Definition

(COMPANY..Assembly Component)

Contains assembly transaction component information.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TRX_ID char(19)
''
TRX ID The...(more) Join Now
Component_ID int
0
Component ...(more) Join Now
Parent_Component_ID int
0
Parent Com...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now
UOFM char(9)
''
U Of M The...(more) Join Now
See I... more text available
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
Location_Code_Note_Index numeric(19,5)
0.00
Location C...(more) Join Now
Stock_Quantity numeric(19,5)
0.00
Stock Quan...(more) Join Now
Assemble_Quantity numeric(19,5)
0.00
Assemble Q...(more) Join Now
ATYALLOC numeric(19,5)
0.00
QTY Alloca...(more) Join Now
BM_Stock_Method smallint
0
BM Stock M...(more) Join Now
Cost_Type smallint
0
Cost Type ...(more) Join Now
INVINDX int
0
Inventory ...(more) Join Now
Inventory_Account_Reference char(31)
''
Inventory ...(more) Join Now
Inventory_Account_Note_I numeric(19,5)
0.00
Inventory ...(more) Join Now
Variance_Index int
0
Variance I...(more) Join Now
Variance_Account_Reference char(31)
''
Variance A...(more) Join Now
Variance_Account_Note_In numeric(19,5)
0.00
Variance A...(more) Join Now
Design_Quantity numeric(19,5)
0.00
Design Qua...(more) Join Now
Scrap_Percentage smallint
0
Scrap Perc...(more) Join Now
STNDCOST numeric(19,5)
0.00
Standard C...(more) Join Now
Standard_Quantity numeric(19,5)
0.00
Standard Q...(more) Join Now
Extended_Standard_Cost numeric(19,5)
0.00
Extended S...(more) Join Now
Extended_Standard_Quantity numeric(19,5)
0.00
Extended S...(more) Join Now
Ext_Assemble_Qty_Posting_Cost numeric(19,5)
0.00
Ext Assemb...(more) Join Now
Ext_Stock_Receipt_Cost numeric(19,5)
0.00
Ext Stock ...(more) Join Now
Ext_Stock_Qty_Posting_Cost numeric(19,5)
0.00
Ext Stock ...(more) Join Now
Ext_Subasm_Posting_Cost numeric(19,5)
0.00
Ext Subasm...(more) Join Now
Ext_Subasm_Receipt_Cost numeric(19,5)
0.00
Ext Subasm...(more) Join Now
BM_Component_Type smallint
0
BM Compone...(more) Join Now
Lvl smallint
0
Level The ...(more) Join Now
QTYBSUOM numeric(19,5)
0.00
QTY In Bas...(more) Join Now
Assemble_Serial_Lot_Count numeric(19,5)
0.00
Assemble S...(more) Join Now
Stock_Serial_Lot_Count numeric(19,5)
0.00
Stock Seri...(more) Join Now
Temp_Allocated_Quantity numeric(19,5)
0.00
Temp Alloc...(more) Join Now
Temp_Assemble_Quantity numeric(19,5)
0.00
Temp Assem...(more) Join Now
Temp_Extended_Assemble_Q numeric(19,5)
0.00
Temp Exten...(more) Join Now
Temp_Location_Code char(11)
''
Temp Locat...(more) Join Now
Temp_Stock_Quantity numeric(19,5)
0.00
Temp Stock...(more) Join Now
Temp_Extended_Stock_Quan numeric(19,5)
0.00
Temp Exten...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
DECPLCUR smallint
0
Number of ...(more) Join Now
ITMTRKOP smallint
0
Item Track...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
BM_Component_Errors binary(4)
0
BM Compone...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
EXTQTYAL numeric(19,5)
0.00
Existing Q...(more) Join Now
EXTQTYSEL numeric(19,5)
0.00
Existing Q...(more) Join Now
Temp_Extended_Standard_Q numeric(19,5)
0.00
Temp Exten...(more) Join Now
Temp_Existing_Quantity_A numeric(19,5)
0.00
Temp Exist...(more) Join Now
Incl smallint
0
Include De...(more) Join Now
BM_Component_Options binary(4)
0
BM Compone...(more) Join Now
BIN char(15)
''
Bin Do not...(more) Join Now
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