Module List > Module Manufacturing tables WO010302Rebuild
You are currently viewing the COMPANY database.
Change

COMPANY..WO010302Rebuild Table Definition

(COMPANY..Manufacture Order Lot Issue)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
MANUFACTUREORDER_I char
''

ITEMNMBR char
''
Item Numbe...(more) Join Now
join ... more text available
LOTNUMBR char
''

SERLTQTY numeric
0.00
Serial/Lot...(more) Join Now QA010332.SERLTQTY
LNSEQNBR numeric
0
Line SEQ N...(more) Join Now
SLTSQNUM int
0

LOCNCODE char
''
Location C...(more) Join Now
join ... more text available
WCID_I char
''

DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now MOP1027.DATERECD
DTSEQNUM numeric
0.00
Date SEQ N...(more) Join Now MOP1020.DTSEQNUM
POSTED tinyint
0

LineNumber smallint
0

IVDOCNBR char
''

IVDOCTYP smallint
0

OSRC_Lot_Qty numeric
0.00

WIPSEQNMBR numeric
0.00

QTYCONSUMED numeric
0.00

QTYPENDING numeric
0.00

NUMBERSCRAPPED_I numeric
0.00

ATYALLOC numeric
0.00
QTY Alloca...(more) Join Now
PICKNUMBER char
''

PICKLISTSEQ int
0

QTY_BACKFLUSHED_I numeric
0.00

SCRAPBACKFLUSHED numeric
0.00

SCRAPCONSUMED numeric
0.00

BIN char
''
Bin The de...(more) Join Now
PENDING_SCRAP_QTY_I numeric
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
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