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

COMPANY..MRP1010 Table Definition

(COMPANY..PR_Short_Items_Work)

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
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
MRPISSUEDATE_I datetime
'1/1/1900'

SHORTAMOUNT_I_1 numeric(19,5)
0.00

SHORTAMOUNT_I_2 numeric(19,5)
0.00

VENDORID char(15)
''
Vendor ID ...(more) Join Now POP10100.VENDORID
join ... more text available
ORD int
0
Ord Sequen...(more) Join Now POP10110.ORD
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
STR30 char(31)
''

Buy_Total numeric(19,5)
0.00

UOFM char(9)
''
U of M The...(more) Join Now POP10110.UOFM
See I... more text available
RELEASEDATE_I datetime
'1/1/1900'

RNNMBR int
0

ITEMDESC char
''
Item Descr...(more) Join Now WO010116.ITEMDESC
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