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

COMPANY..WO010515Rebuild Table Definition

(COMPANY..Manufacture Order Serial Issue)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ITEMNMBR char
''
Item Numbe...(more) Join Now
join ... more text available
MANUFACTUREORDER_I char
''

SERLNMBR 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
LNSEQNBR numeric
0
Line SEQ N...(more) Join Now
RETURNTOSTOCKCB_I tinyint
0

SLTSQNUM int
0

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

POSTED tinyint
0

SERLTQTY numeric
0.00
Serial/Lot...(more) Join Now QA010332.SERLTQTY
IVDOCNBR char
''

IVDOCTYP smallint
0

OSRC_Shipped tinyint
0

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
ROWID int
0

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