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

COMPANY..MRPW4060 Table Definition

(COMPANY..mrpSopLinesWork)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SOPTYPE smallint
0

SOPNUMBE char(21)
''

LNITMSEQ int
0
Line Item ...(more) Join Now PA11801.LNITMSEQ
CMPNTSEQ int
0

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
REPTING tinyint
0

TRXFREQU smallint
0

TIMETREP smallint
0

DYSTINCR smallint
0

QUANTITY numeric(19,5)
0.00
QTY: The n...(more) Join Now VAT10302.QUANTITY
QTYTBAOR numeric(19,5)
0.00
QTY To Bac...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date T...(more) Join Now POP10100.DUEDATE
STSDESCR char(31)
''
 ...(more) Join Now MP040000.STSDESCR
Status smallint
0
p>Field Ty...(more) Join Now SVC00700.STATUS
CALCMRP_I tinyint
0

MRPEXCEPTIONSARRAY_1 smallint
0

MRPEXCEPTIONSARRAY_2 smallint
0

MRPEXCEPTIONSARRAY_3 smallint
0

MRPEXCEPTIONSARRAY_4 smallint
0

MRPEXCEPTIONSARRAY_5 smallint
0

MRPEXCEPTIONSARRAY_6 smallint
0

MRPEXCEPTIONSARRAY_7 smallint
0

MRPEXCEPTIONSARRAY_8 smallint
0

MRPEXCEPTIONSARRAY_9 smallint
0

MRPEXCEPTIONSARRAY_10 smallint
0

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

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