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

COMPANY..CT00200 Table Definition

(COMPANY..IC_COST_Tracked_Changes)

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
STRNG132 char(133)
''

ITEMDESC char(101)
''
Item Descr...(more) Join Now POP10110.ITEMDESC
ITEM_COSTS_ARRAY_I_1 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_2 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_3 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_4 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_5 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_6 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_7 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_8 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_9 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_10 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_1 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_2 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_3 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_4 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_5 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_6 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_7 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_8 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_9 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_OLD_I_10 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_1 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_2 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_3 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_4 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_5 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_6 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_7 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_8 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_9 numeric(19,5)
0.00

ITEM_COSTS_CHANGEARRAY_I_10 numeric(19,5)
0.00

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
CHANGETIME_I datetime
'1/1/1900'

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