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

COMPANY..MRP2230 Table Definition

(COMPANY..mrpWeeksEPS)

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
ORDRPNTQTY numeric(19,5)
0.00

IVREPLENISHMENT numeric(19,5)
0.00

MADEBYMOOPEN numeric(19,5)
0.00

MADEBYMORELEASED numeric(19,5)
0.00

ALLCBYMOOPEN numeric(19,5)
0.00

ALLOCBYMORELEASED numeric(19,5)
0.00

REQBYMOOPEN numeric(19,5)
0.00

REQBYMORELEASED numeric(19,5)
0.00

CNSMDBYMOOPEN numeric(19,5)
0.00

CNSMDBYMORELEASED numeric(19,5)
0.00

QUOTESALESORDERS numeric(19,5)
0.00

ORDERSALESORDERS numeric(19,5)
0.00

BOSALESORDERS numeric(19,5)
0.00

UNMTSALESFRCST numeric(19,5)
0.00

PLNNDPRCHSORDERS numeric(19,5)
0.00

FIRMPRCHSORDERS numeric(19,5)
0.00

REQPLANNED numeric(19,5)
0.00

REQFIRM numeric(19,5)
0.00

ACQUIREDPLANNED numeric(19,5)
0.00

AQUIREDFIRM numeric(19,5)
0.00

ONHANDFIRM numeric(19,5)
0.00

ONHANDTOTAL numeric(19,5)
0.00

ATPFIRM numeric(19,5)
0.00

ATPTOTAL numeric(19,5)
0.00

GROSSREQUIREMENT numeric(19,5)
0.00

NETREQUIREMENT numeric(19,5)
0.00

MRPSUGGESTIONS numeric(19,5)
0.00

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