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

COMPANY..MRP4020 Table Definition

(COMPANY..mrpPicklistLinesEPS)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
LOCNCODE char(11)
''
Location C...(more) Join Now POP10110.LOCNCODE
join ... more text available
DUEDATE datetime
'1/1/1900'
Due Date T...(more) Join Now POP10100.DUEDATE
ORDERNUMBER char(31)
''

MRPTYPE smallint
0

MRPPARENTTYPE smallint
0

SEQ_I int
0

PHNTMPRNT char(31)
''

Status smallint
0
p>Field Ty...(more) Join Now SVC00700.STATUS
STSDESCR char(31)
''
 ...(more) Join Now MP040000.STSDESCR
ALLCBYMOOPEN numeric(19,5)
0.00

ALLOCBYMORELEASED numeric(19,5)
0.00

CNSMDBYMOOPEN numeric(19,5)
0.00

CNSMDBYMORELEASED numeric(19,5)
0.00

REQBYMOOPEN numeric(19,5)
0.00

REQBYMORELEASED numeric(19,5)
0.00

MOVEIN tinyint
0

MOVEOUT tinyint
0

ORGNLDUEDT datetime
'1/1/1900'

CANCELED tinyint
0

HASMRPEXCEPTION_1 tinyint
0

HASMRPEXCEPTION_2 tinyint
0

HASMRPEXCEPTION_3 tinyint
0

HASMRPEXCEPTION_4 tinyint
0

HASMRPEXCEPTION_5 tinyint
0

HASMRPEXCEPTION_6 tinyint
0

HASMRPEXCEPTION_7 tinyint
0

HASMRPEXCEPTION_8 tinyint
0

HASMRPEXCEPTION_9 tinyint
0

HASMRPEXCEPTION_10 tinyint
0

HASMRPEXCEPTION_11 tinyint
0

HASMRPEXCEPTION_12 tinyint
0

HASMRPEXCEPTION_13 tinyint
0

HASMRPEXCEPTION_14 tinyint
0

HASMRPEXCEPTION_15 tinyint
0

HASMRPEXCEPTION_16 tinyint
0

HASMRPEXCEPTION_17 tinyint
0

HASMRPEXCEPTION_18 tinyint
0

HASMRPEXCEPTION_19 tinyint
0

HASMRPEXCEPTION_20 tinyint
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