DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module Manufacturing tables MRP6060
You are currently viewing the COMPANY database.
Change

COMPANY..MRP6060 Table Definition

(COMPANY..mrpQuantitiesQuery)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
QUERYNAME char(51)
''

MRPQTYNUM_I smallint
0

STTITNUM char(31)
''

ENITMNBR char(31)
''

ITEMDESC char(101)
''
Item Descr...(more) Join Now POP10110.ITEMDESC
STTITCLS char(11)
''

ENITMCLS char(11)
''

STTLOCCD char(11)
''

ENLOCNCD char(11)
''

STARTORDERNMBR char(31)
''

ENDORDERNMBR char(31)
''

STARTBUYERID char(15)
''

ENDBUYERID char(15)
''

STARTPLANNERID char(15)
''

ENDPLANNERID char(15)
''

STARTRELEASEDATE datetime
'1/1/1900'

ENDRELEASEDATE datetime
'1/1/1900'

STTDUEDT datetime
'1/1/1900'

ENDDUEDT datetime
'1/1/1900'

MRPQUERYIV_1 tinyint
0

MRPQUERYIV_2 tinyint
0

MRPQUERYIV_3 tinyint
0

MRPQUERYIV_4 tinyint
0

MRPQUERYPO_1 tinyint
0

MRPQUERYPO_2 tinyint
0

MRPQUERYPO_3 tinyint
0

MRPQUERYPO_4 tinyint
0

MRPQUERYSO_1 tinyint
0

MRPQUERYSO_2 tinyint
0

MRPQUERYSO_3 tinyint
0

MRPQUERYSO_4 tinyint
0

MRPQUERYSO_5 tinyint
0

MRPQUERYSO_6 tinyint
0

MRPQUERYSO_7 tinyint
0

MRPQUERYMO_1 tinyint
0

MRPQUERYMO_2 tinyint
0

MRPQUERYMO_3 tinyint
0

MRPQUERYMO_4 tinyint
0

MRPQUERYMO_5 tinyint
0

MRPQUERYMO_6 tinyint
0

MRPQUERYPK_1 tinyint
0

MRPQUERYPK_2 tinyint
0

MRPQUERYPK_3 tinyint
0

MRPQUERYPK_4 tinyint
0

MRPQUERYPK_5 tinyint
0

MRPQUERYPK_6 tinyint
0

MRPQUERYSUGGESTIONS_1 tinyint
0

MRPQUERYSUGGESTIONS_2 tinyint
0

MRPQUERYSUGGESTIONS_3 tinyint
0

MRPQUERYSUGGESTIONS_4 tinyint
0

MRPQUERYEXCEPTIONS_1 tinyint
0

MRPQUERYEXCEPTIONS_2 tinyint
0

MRPQUERYEXCEPTIONS_3 tinyint
0

MRPQUERYEXCEPTIONS_4 tinyint
0

MRPQUERYEXCEPTIONS_5 tinyint
0

MRPQUERYEXCEPTIONS_6 tinyint
0

MRPQUERYEXCEPTIONS_7 tinyint
0

MRPQUERYEXCEPTIONS_8 tinyint
0

MRPQUERYEXCEPTIONS_9 tinyint
0

MRPQUERYDUEDATE smallint
0

MRPQUERYRLSDATE smallint
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3