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

COMPANY..IC10200 Table Definition

(COMPANY..Manufacturing Series Purchase Receipts)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
TRXLOCTN char(11)
''
p>TRX Loca...(more) Join Now
QTYTYPE smallint
0
QTY Type...(more) Join Now IV10201.QTYTYPE
DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now POP10500.DATERECD
RCTSEQNM int
0
Receipt SE...(more) Join Now POP10500.RCTSEQNM
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

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

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