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

COMPANY..MPUF0130 Table Definition

(COMPANY..MFG_Module_Options_MRP)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
REPORTOPTION_I char(21)
''

REPORTINDEX_I numeric(19,5)
0.00

ASKECHTM tinyint
0

INCLGNDS tinyint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

IFFILXST smallint
0

FILEXPNM char(255)
''

EXPTTYPE smallint
0

STARTMCDESC_I char(31)
''

STARTINSTDATE_I datetime
'1/1/1900'

ENDMCDESC_I char(31)
''

ENDINSTDATE_I datetime
'1/1/1900'

SORTBY_I char(31)
''

STTLOCCD char(11)
''

ENLOCNCD char(11)
''

STTITNUM char(31)
''

ENITMNBR char(31)
''

STARTBUYERID char(15)
''

STARTPLANNERCODE_I char(3)
''

ENDBUYERID char(15)
''

ENDPLANNERCODE_I char(3)
''

NETACROSSSITES_I tinyint
0

CBXUSETEXTBUTTONS_I tinyint
0

STVNDRID char(15)
''

ENDVNDID char(15)
''

STTUSRID char(15)
''

ENDUSRID char(15)
''

Start_Regen_Type smallint
0

End_Regen_Type smallint
0

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now PA02101.STRTDATE
ENDDATE datetime
'1/1/1900'
End Date ...(more) Join Now PA02101.ENDDATE
DueDateFrom datetime
'1/1/1900'

DueDateTo datetime
'1/1/1900'

ReleaseFrom datetime
'1/1/1900'

ReleaseTo datetime
'1/1/1900'

Start_Counter int
0

End_Counter int
0

MRPQTYNUM_I smallint
0

MRPUSERNAME_I char(21)
''

RSRCID char(31)
''

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