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

COMPANY..MRP0300 Table Definition

(COMPANY..mrpExceptionsEPS)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
GUID char(37)
''

RUNNUMBER int
0

ORDERNUMBER char(31)
''

MRPTYPE smallint
0

ORD int
0
Ord Sequen...(more) Join Now POP10110.ORD
SOPTYPE smallint
0

CMPNTSEQ int
0

DUEDATE datetime
'1/1/1900'
Due Date T...(more) Join Now POP10100.DUEDATE
RELEASEDATE_I datetime
'1/1/1900'

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
MRP_EXCEPTION_STATUS char(21)
''

SUPPLYQTY numeric(19,5)
0.00

DEMANDQTY numeric(19,5)
0.00

BUYERID char(15)
''
Buyer ID ...(more) Join Now
PLANNERID char(15)
''

MRPEXCEPTIONS smallint
0

Status smallint
0
p>Field Ty...(more) Join Now SVC00700.STATUS
QUANTITY numeric(19,5)
0.00
QTY: The n...(more) Join Now VAT10302.QUANTITY
REPORTGROUP int
0

LOTNUMBR char(21)
''

DUEDATE2 datetime
'1/1/1900'

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