| 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
|
|
|
|