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

COMPANY..MOP1020 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(31)
''

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
SERLTNUM char(21)
''
Serial/Lot...(more) Join Now POP10330.SERLTNUM
DOCNUMBR char(21)
''
Document N...(more) Join Now RM20102.DOCNUMBR
PICKLISTSEQ int
0

CALLEDBY smallint
0

PICKDOCLINENUM int
0

SEQ_I int
0

WIPSEQNMBR numeric(19,5)
0.00

SERLTQTY numeric(19,5)
0.00
Serial/Lot...(more) Join Now POP10330.SERLTQTY
FROM_SITE_I char(11)
''

TO_SITE_I char(11)
''

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

TRX_TYPE smallint
0

ORDOCNUM char(21)
''

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

BIN char(15)
''
Bin If mul...(more) Join Now POP10330.BIN
QTYLNKD 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
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