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

COMPANY..MOP1090Rebuild Table Definition

(COMPANY..Manufacture Order Lot Issue HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
MANUFACTUREORDER_I char
''

ITEMNMBR char
''
span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
SERLTNUM char
''
Serial/Lot...(more) Join Now RVPS0132.SERLTNUM
DOCNUMBR char
''
Document N...(more) Join Now RM20102.DOCNUMBR
PICKLISTSEQ int
0

CALLEDBY smallint
0

PICKDOCLINENUM int
0

SEQ_I int
0

WIPSEQNMBR numeric
0.00

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

TO_SITE_I char
''

DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now
DTSEQNUM numeric
0.00
Date SEQ N...(more) Join Now
LineNumber smallint
0

NUMBERSCRAPPED_I numeric
0.00

TRX_TYPE smallint
0

ORDOCNUM char
''

ITMTRKOP smallint
0
Item Track...(more) Join Now WO010400.ITMTRKOP
BYPRODUCTITEM tinyint
0

BIN char
''
Bin The de...(more) Join Now IV00112.BIN
EXPNDATE datetime
'1/1/1900'
Expiration...(more) Join Now
MFGDATE datetime
'1/1/1900'
Manufactur...(more) Join Now
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