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

COMPANY..MOP1100 Table Definition

(COMPANY..MOP_Receipt_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
MOPRCTNM char(21)
''

REVERSED_RECEIPT_I tinyint
0

REVERSIBLE_RECEIPT_I tinyint
0

MANUFACTUREORDER_I char(31)
''

DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now
QTYRECVD numeric(19,5)
0.00
Qty Receiv...(more) Join Now
TO_SITE_I char(11)
''
LOCNCODE f...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
POSTDATE datetime
'1/1/1900'
Post Dateb...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
RECEIPTCOSTSARRAY_1 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_2 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_3 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_4 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_5 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_6 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_7 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_8 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_9 numeric(19,5)
0.00

RECEIPTCOSTSARRAY_10 numeric(19,5)
0.00

LABCOSTSINDCTR smallint
0

MACHCOSTSINDCTR smallint
0

LABORCOSTSPCT smallint
0

MACHINECOSTSPCT smallint
0

SETUP_COSTS_TO_USE_I_1 numeric(19,5)
0.00

SETUP_COSTS_TO_USE_I_2 numeric(19,5)
0.00

SETUP_COSTS_TO_USE_I_3 numeric(19,5)
0.00

COSTS_TO_USE_I_1 numeric(19,5)
0.00

COSTS_TO_USE_I_2 numeric(19,5)
0.00

COSTS_TO_USE_I_3 numeric(19,5)
0.00

COSTS_TO_USE_I_4 numeric(19,5)
0.00

COSTS_TO_USE_I_5 numeric(19,5)
0.00

COSTS_TO_USE_I_6 numeric(19,5)
0.00

SETUP_COSTS_TO_BACKFLUSH_1 numeric(19,5)
0.00

SETUP_COSTS_TO_BACKFLUSH_2 numeric(19,5)
0.00

SETUP_COSTS_TO_BACKFLUSH_3 numeric(19,5)
0.00

COSTS_TO_BACKFLUSH_I_1 numeric(19,5)
0.00

COSTS_TO_BACKFLUSH_I_2 numeric(19,5)
0.00

COSTS_TO_BACKFLUSH_I_3 numeric(19,5)
0.00

COSTS_TO_BACKFLUSH_I_4 numeric(19,5)
0.00

COSTS_TO_BACKFLUSH_I_5 numeric(19,5)
0.00

COSTS_TO_BACKFLUSH_I_6 numeric(19,5)
0.00

POSTED tinyint
0

COMPLETEMOATCOMPCLOSE tinyint
0

CLOSEMOATCOMPCLOSE tinyint
0

JOBLINKSTATE smallint
0

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