Module List >
Module Manufacturing tables
WO010302
You are currently viewing the COMPANY
database.
Change
|
COMPANY..WO010302 Table Definition
(COMPANY..Manufacture Order Lot Issue)
Field Definitions:
What is the 'source' column?
| MANUFACTUREORDER_I |
char(31)
''
|
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| LOTNUMBR |
char(21)
''
|
|
|
|
|
| SERLTQTY |
numeric(19,5)
0.00
|
Serial/Lot...(more) Join Now
|
QA010332.SERLTQTY
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| SLTSQNUM |
int
0
|
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
join ... more text available
|
| WCID_I |
char(11)
''
|
|
|
|
|
| DATERECD |
datetime
'1/1/1900'
|
Date Recei...(more) Join Now
|
MOP1027.DATERECD
|
|
|
| DTSEQNUM |
numeric(19,5)
0.00
|
Date SEQ N...(more) Join Now
|
MOP1020.DTSEQNUM
|
|
|
| POSTED |
tinyint
0
|
|
|
|
|
| LineNumber |
smallint
0
|
|
|
|
|
| IVDOCNBR |
char(17)
''
|
|
|
|
|
| IVDOCTYP |
smallint
0
|
|
|
|
|
| OSRC_Lot_Qty |
numeric(19,5)
0.00
|
|
|
|
|
| WIPSEQNMBR |
numeric(19,5)
0.00
|
|
|
|
|
| QTYCONSUMED |
numeric(19,5)
0.00
|
|
|
|
|
| QTYPENDING |
numeric(19,5)
0.00
|
|
|
|
|
| NUMBERSCRAPPED_I |
numeric(19,5)
0.00
|
|
|
|
|
| ATYALLOC |
numeric(19,5)
0.00
|
QTY Alloca...(more) Join Now
|
|
|
|
| PICKNUMBER |
char(17)
''
|
|
|
|
|
| PICKLISTSEQ |
int
0
|
|
|
|
|
| QTY_BACKFLUSHED_I |
numeric(19,5)
0.00
|
|
|
|
|
| SCRAPBACKFLUSHED |
numeric(19,5)
0.00
|
|
|
|
|
| SCRAPCONSUMED |
numeric(19,5)
0.00
|
|
|
|
|
| BIN |
char(15)
''
|
Bin The de...(more) Join Now
|
|
|
|
| PENDING_SCRAP_QTY_I |
numeric(19,5)
0.00
|
|
|
|
|
| ROWID |
int
0
|
|
|
|
|
| EXPNDATE |
datetime
'1/1/1900'
|
Expiration...(more) Join Now
|
|
|
|
| MFGDATE |
datetime
'1/1/1900'
|
Manufactur...(more) Join Now
|
MOP1120.MFGDATE
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|