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

COMPANY..MOP1012 Table Definition

(COMPANY..MOP_MO_Variance_Material_Hist_STD)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
MANUFACTUREORDER_I char(31)
''

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now POP10110.ITEMDESC
MRPAMOUNT_I numeric(19,5)
0.00

DECPLCUR smallint
0
Number of ...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
MRPAMOUNT2_I numeric(19,5)
0.00

VARSTDCOSTS1_1 numeric(19,5)
0.00

VARSTDCOSTS1_2 numeric(19,5)
0.00

VARSTDCOSTS1_3 numeric(19,5)
0.00

VARSTDCOSTS1_4 numeric(19,5)
0.00

VARSTDCOSTS1_5 numeric(19,5)
0.00

VARSTDCOSTS1_6 numeric(19,5)
0.00

VARSTDCOSTS1_7 numeric(19,5)
0.00

VARSTDCOSTS1_8 numeric(19,5)
0.00

VARSTDCOSTS1_9 numeric(19,5)
0.00

VARSTDCOSTS1_10 numeric(19,5)
0.00

VARSTDCOSTS1_11 numeric(19,5)
0.00

VARSTDCOSTS1_12 numeric(19,5)
0.00

VARSTDCOSTS1_13 numeric(19,5)
0.00

VARSTDCOSTS2_1 numeric(19,5)
0.00

VARSTDCOSTS2_2 numeric(19,5)
0.00

VARSTDCOSTS2_3 numeric(19,5)
0.00

VARSTDCOSTS2_4 numeric(19,5)
0.00

VARSTDCOSTS2_5 numeric(19,5)
0.00

VARSTDCOSTS2_6 numeric(19,5)
0.00

VARSTDCOSTS2_7 numeric(19,5)
0.00

VARSTDCOSTS2_8 numeric(19,5)
0.00

VARSTDCOSTS2_9 numeric(19,5)
0.00

VARSTDCOSTS2_10 numeric(19,5)
0.00

VARSTDCOSTS2_11 numeric(19,5)
0.00

VARSTDCOSTS2_12 numeric(19,5)
0.00

VARSTDCOSTS2_13 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