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

COMPANY..WO010116 Table Definition

(COMPANY..MOP Historical Variance)

4Penny.net

Field Definitions:

What is the 'source' column?

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

DSCRIPTN char(31)
''

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
BOMCAT_I smallint
0

BOMNAME_I char(15)
''
Bill of Ma...(more) Join Now
ITEMDESC char(101)
''
Item Descr...(more) Join Now
ROUTINGNAME_I char(31)
''

REVISIONLEVEL_I char(51)
''

STARTQTY_I numeric(19,5)
0.00

ENDQTY_I numeric(19,5)
0.00

PROJEMPLOYEEHRSSUM_I numeric(19,5)
0.00

PROJMACHINEHRSSUM_I numeric(19,5)
0.00

ACTUALEMPHOURSSUM_I numeric(19,5)
0.00

ACTUALMACHRSSUM_I numeric(19,5)
0.00

MATCOSTI_1 numeric(19,5)
0.00

MATCOSTI_2 numeric(19,5)
0.00

MATCOSTI_3 numeric(19,5)
0.00

MATCOSTI_4 numeric(19,5)
0.00

MATCOSTI_5 numeric(19,5)
0.00

MATCOSTI_6 numeric(19,5)
0.00

MATCOSTI_7 numeric(19,5)
0.00

MATCOSTI_8 numeric(19,5)
0.00

MATFIXOHDCOSTI_1 numeric(19,5)
0.00

MATFIXOHDCOSTI_2 numeric(19,5)
0.00

MATFIXOHDCOSTI_3 numeric(19,5)
0.00

MATFIXOHDCOSTI_4 numeric(19,5)
0.00

MATFIXOHDCOSTI_5 numeric(19,5)
0.00

MATFIXOHDCOSTI_6 numeric(19,5)
0.00

MATFIXOHDCOSTI_7 numeric(19,5)
0.00

MATFIXOHDCOSTI_8 numeric(19,5)
0.00

MATVAROHDCOSTI_1 numeric(19,5)
0.00

MATVAROHDCOSTI_2 numeric(19,5)
0.00

MATVAROHDCOSTI_3 numeric(19,5)
0.00

MATVAROHDCOSTI_4 numeric(19,5)
0.00

MATVAROHDCOSTI_5 numeric(19,5)
0.00

MATVAROHDCOSTI_6 numeric(19,5)
0.00

MATVAROHDCOSTI_7 numeric(19,5)
0.00

MATVAROHDCOSTI_8 numeric(19,5)
0.00

LABCOSTI_1 numeric(19,5)
0.00

LABCOSTI_2 numeric(19,5)
0.00

LABCOSTI_3 numeric(19,5)
0.00

LABCOSTI_4 numeric(19,5)
0.00

LABCOSTI_5 numeric(19,5)
0.00

LABCOSTI_6 numeric(19,5)
0.00

LABCOSTI_7 numeric(19,5)
0.00

LABCOSTI_8 numeric(19,5)
0.00

LABFIXOHDCOSTI_1 numeric(19,5)
0.00

LABFIXOHDCOSTI_2 numeric(19,5)
0.00

LABFIXOHDCOSTI_3 numeric(19,5)
0.00

LABFIXOHDCOSTI_4 numeric(19,5)
0.00

LABFIXOHDCOSTI_5 numeric(19,5)
0.00

LABFIXOHDCOSTI_6 numeric(19,5)
0.00

LABFIXOHDCOSTI_7 numeric(19,5)
0.00

LABFIXOHDCOSTI_8 numeric(19,5)
0.00

LABVAROHDCOSTI_1 numeric(19,5)
0.00

LABVAROHDCOSTI_2 numeric(19,5)
0.00

LABVAROHDCOSTI_3 numeric(19,5)
0.00

LABVAROHDCOSTI_4 numeric(19,5)
0.00

LABVAROHDCOSTI_5 numeric(19,5)
0.00

LABVAROHDCOSTI_6 numeric(19,5)
0.00

LABVAROHDCOSTI_7 numeric(19,5)
0.00

LABVAROHDCOSTI_8 numeric(19,5)
0.00

MACHCOSTI_1 numeric(19,5)
0.00

MACHCOSTI_2 numeric(19,5)
0.00

MACHCOSTI_3 numeric(19,5)
0.00

MACHCOSTI_4 numeric(19,5)
0.00

MACHCOSTI_5 numeric(19,5)
0.00

MACHCOSTI_6 numeric(19,5)
0.00

MACHCOSTI_7 numeric(19,5)
0.00

MACHCOSTI_8 numeric(19,5)
0.00

MACHFIXOHDCOSTI_1 numeric(19,5)
0.00

MACHFIXOHDCOSTI_2 numeric(19,5)
0.00

MACHFIXOHDCOSTI_3 numeric(19,5)
0.00

MACHFIXOHDCOSTI_4 numeric(19,5)
0.00

MACHFIXOHDCOSTI_5 numeric(19,5)
0.00

MACHFIXOHDCOSTI_6 numeric(19,5)
0.00

MACHFIXOHDCOSTI_7 numeric(19,5)
0.00

MACHFIXOHDCOSTI_8 numeric(19,5)
0.00

MACHVAROHDCOSTI_1 numeric(19,5)
0.00

MACHVAROHDCOSTI_2 numeric(19,5)
0.00

MACHVAROHDCOSTI_3 numeric(19,5)
0.00

MACHVAROHDCOSTI_4 numeric(19,5)
0.00

MACHVAROHDCOSTI_5 numeric(19,5)
0.00

MACHVAROHDCOSTI_6 numeric(19,5)
0.00

MACHVAROHDCOSTI_7 numeric(19,5)
0.00

MACHVAROHDCOSTI_8 numeric(19,5)
0.00

QAQCNEEDEDSTR3_I char(3)
''

QTYTOPOST_I numeric(19,5)
0.00

LOTNUMBR char(21)
''

PLANNAME_I char(15)
''

ACTUALDEMAND_I numeric(19,5)
0.00

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
MRPAMOUNT_I numeric(19,5)
0.00

DATE1 datetime
'1/1/1900'

TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now
BASEUOFM char(9)
''

See I... more text available
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
DECPLCUR smallint
0
Number of ...(more) Join Now
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