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

COMPANY..MPPS0130 Table Definition

(COMPANY..MRP Setup File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RUNNUMBER int
0

RUNSTARTDATE_I datetime
'1/1/1900'

RUNENDDATE_I datetime
'1/1/1900'

CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
STTITNUM char(31)
''

ENITMNBR char(31)
''

MRPCBDAYS_I tinyint
0

MRPCBMONTHS_I tinyint
0

MRPCBUSER_I tinyint
0

MRPUSERSIZE_I smallint
0

MRPCBWEEKS_I tinyint
0

MRPRunDateI datetime
'1/1/1900'

MRPRUNLENGTH_I smallint
0

MRPRUNSPAN_I smallint
0

MRPREGENTYPE_I smallint
0

MRP_METHOD smallint
0

PASTDUE smallint
0

MRPEITHER_I smallint
0

MRPCBMOVEIN tinyint
0

MRPCBTIMEFENCE tinyint
0

MOVEOUT tinyint
0

CANCELED tinyint
0

MRPCBCALCINACTIVE_I tinyint
0

CALCPASTDUE tinyint
0

MRP_CB_MO_Quote tinyint
0

MRP_CB_SO_Quote tinyint
0

MRPDDCONSTRAINT_I smallint
0

MRPSOREQFIRM_I tinyint
0

SCHEDULINGPREFEREN_I char(21)
''

STRTTIME datetime
'1/1/1900'

ENDTIME datetime
'1/1/1900'

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now PA02101.STRTDATE
ENDDATE datetime
'1/1/1900'
End Date ...(more) Join Now PA02101.ENDDATE
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