Module List >
Module Manufacturing tables
MOPW500
You are currently viewing the COMPANY
database.
Change
|
COMPANY..MOPW500 Table Definition
(COMPANY..MOP Receipt TEMP WORK)
Field Definitions:
What is the 'source' column?
| MOPRCTNM |
char(21)
''
|
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
IV10201.ITEMNMBR
|
|
join ... more text available
|
| PICKLISTSEQ |
int
0
|
|
|
|
|
| POSITION_NUMBER |
smallint
0
|
Position N...(more) Join Now
|
|
|
|
| POSITION_NUMBER2 |
smallint
0
|
|
|
|
|
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| ITEMDESC |
char(101)
''
|
Item Descr...(more) Join Now
|
POP10110.ITEMDESC
|
|
|
| ITMTRKOP |
smallint
0
|
Item Track...(more) Join Now
|
POP10110.ITMTRKOP
|
|
|
| QTYPLANNEDTOCONSUME |
numeric(19,5)
0.00
|
|
|
|
|
| QTYPLANNEDTOBACKFLUSH |
numeric(19,5)
0.00
|
|
|
|
|
| QTYTOCONSUME |
numeric(19,5)
0.00
|
|
|
|
|
| QTYTOBACKFLUSH |
numeric(19,5)
0.00
|
|
|
|
|
| BACKFLUSHSITEID |
char(11)
''
|
|
|
|
|
| BYPRODUCTSITEID |
char(11)
''
|
|
|
|
|
| QTYTOUSE |
numeric(19,5)
0.00
|
|
|
|
|
| UOFM |
char(9)
''
|
U of M The...(more) Join Now
|
POP10110.UOFM
|
|
See I... more text available
|
| MOP_REQUIRED_QUANTITY_I |
numeric(19,5)
0.00
|
|
|
|
|
| WIPQUANTITY |
numeric(19,5)
0.00
|
|
|
|
|
| QTYAVAIL |
numeric(19,5)
0.00
|
|
|
|
|
| QTYCONSUMEDTODATE |
numeric(19,5)
0.00
|
|
|
|
|
| QTYBACKFLUSHEDTODATE |
numeric(19,5)
0.00
|
|
|
|
|
| QTYSLCTD |
numeric(19,5)
0.00
|
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| NUMBERSCRAPPED_I |
numeric(19,5)
0.00
|
|
|
|
|
| BOMSINGLELOT_I |
tinyint
0
|
|
|
|
|
| BACKFLUSHCB |
tinyint
0
|
|
|
|
|
| ATYALLOC |
numeric(19,5)
0.00
|
QTY Alloca...(more) Join Now
|
|
|
|
| PLNDFIXDQTYTOCONS |
numeric(19,5)
0.00
|
|
|
|
|
| PLNDFIXDQTYTOBF |
numeric(19,5)
0.00
|
|
|
|
|
| FIXDQTYTOCONS |
numeric(19,5)
0.00
|
|
|
|
|
| FIXDQTYTOBF |
numeric(19,5)
0.00
|
|
|
|
|
| QTYSELCTDBF |
numeric(19,5)
0.00
|
|
|
|
|
| FLOORSTOCK_I |
tinyint
0
|
|
|
|
|
| NONINVENTORY |
tinyint
0
|
|
|
|
|
| STR20DUMMY_I |
char(21)
''
|
|
|
|
|
| ITEMTYPE |
smallint
0
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| SUBASSEMBLYOF_I |
char(31)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|