DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module Manufacturing tables ICIV0323
You are currently viewing the COMPANY database.
Change

COMPANY..ICIV0323 Table Definition

(COMPANY..IC_IV_STANDARD)

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
ITMCLSCD char(11)
''
Item Class...(more) Join Now IV00101.ITMCLSCD
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

MATCOSTEFFDATEI_1 datetime
'1/1/1900'

MATCOSTEFFDATEI_2 datetime
'1/1/1900'

MATCOSTEFFDATEI_3 datetime
'1/1/1900'

MATCOSTEFFDATEI_4 datetime
'1/1/1900'

MATCOSTEFFDATEI_5 datetime
'1/1/1900'

MATCOSTEFFDATEI_6 datetime
'1/1/1900'

MATCOSTEFFDATEI_7 datetime
'1/1/1900'

MATCOSTEFFDATEI_8 datetime
'1/1/1900'

NO_CALC_MAT tinyint
0

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

MATFIXOHDCOSTEFFDTI_1 datetime
'1/1/1900'

MATFIXOHDCOSTEFFDTI_2 datetime
'1/1/1900'

MATFIXOHDCOSTEFFDTI_3 datetime
'1/1/1900'

MATFIXOHDCOSTEFFDTI_4 datetime
'1/1/1900'

MATFIXOHDCOSTEFFDTI_5 datetime
'1/1/1900'

MATFIXOHDCOSTEFFDTI_6 datetime
'1/1/1900'

MATFIXOHDCOSTEFFDTI_7 datetime
'1/1/1900'

MATFIXOHDCOSTEFFDTI_8 datetime
'1/1/1900'

NO_CALC_MAT_FIX_OHD tinyint
0

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

MATVAROHDCOSTEFFDTI_1 datetime
'1/1/1900'

MATVAROHDCOSTEFFDTI_2 datetime
'1/1/1900'

MATVAROHDCOSTEFFDTI_3 datetime
'1/1/1900'

MATVAROHDCOSTEFFDTI_4 datetime
'1/1/1900'

MATVAROHDCOSTEFFDTI_5 datetime
'1/1/1900'

MATVAROHDCOSTEFFDTI_6 datetime
'1/1/1900'

MATVAROHDCOSTEFFDTI_7 datetime
'1/1/1900'

MATVAROHDCOSTEFFDTI_8 datetime
'1/1/1900'

NO_CALC_MAT_VAR_OHD tinyint
0

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

LABCOSTEFFDTI_1 datetime
'1/1/1900'

LABCOSTEFFDTI_2 datetime
'1/1/1900'

LABCOSTEFFDTI_3 datetime
'1/1/1900'

LABCOSTEFFDTI_4 datetime
'1/1/1900'

LABCOSTEFFDTI_5 datetime
'1/1/1900'

LABCOSTEFFDTI_6 datetime
'1/1/1900'

NO_CALC_LAB tinyint
0

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

LABFIXOHDCOSTEFFDTI_1 datetime
'1/1/1900'

LABFIXOHDCOSTEFFDTI_2 datetime
'1/1/1900'

LABFIXOHDCOSTEFFDTI_3 datetime
'1/1/1900'

LABFIXOHDCOSTEFFDTI_4 datetime
'1/1/1900'

LABFIXOHDCOSTEFFDTI_5 datetime
'1/1/1900'

LABFIXOHDCOSTEFFDTI_6 datetime
'1/1/1900'

NO_CALC_LAB_FIX_OHD tinyint
0

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

LABVAROHDCOSTEFFDTI_1 datetime
'1/1/1900'

LABVAROHDCOSTEFFDTI_2 datetime
'1/1/1900'

LABVAROHDCOSTEFFDTI_3 datetime
'1/1/1900'

LABVAROHDCOSTEFFDTI_4 datetime
'1/1/1900'

LABVAROHDCOSTEFFDTI_5 datetime
'1/1/1900'

LABVAROHDCOSTEFFDTI_6 datetime
'1/1/1900'

NO_CALC_LAB_VAR_OHD tinyint
0

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

MACHCOSTEFFDTI_1 datetime
'1/1/1900'

MACHCOSTEFFDTI_2 datetime
'1/1/1900'

MACHCOSTEFFDTI_3 datetime
'1/1/1900'

MACHCOSTEFFDTI_4 datetime
'1/1/1900'

MACHCOSTEFFDTI_5 datetime
'1/1/1900'

MACHCOSTEFFDTI_6 datetime
'1/1/1900'

NO_CALC_MACH tinyint
0

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

MACHFIXOHDCOSTEFFDTI_1 datetime
'1/1/1900'

MACHFIXOHDCOSTEFFDTI_2 datetime
'1/1/1900'

MACHFIXOHDCOSTEFFDTI_3 datetime
'1/1/1900'

MACHFIXOHDCOSTEFFDTI_4 datetime
'1/1/1900'

MACHFIXOHDCOSTEFFDTI_5 datetime
'1/1/1900'

MACHFIXOHDCOSTEFFDTI_6 datetime
'1/1/1900'

NO_CALC_MACH_FIX_OHD tinyint
0

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

MACHVAROHDCOSTEFFDTI_1 datetime
'1/1/1900'

MACHVAROHDCOSTEFFDTI_2 datetime
'1/1/1900'

MACHVAROHDCOSTEFFDTI_3 datetime
'1/1/1900'

MACHVAROHDCOSTEFFDTI_4 datetime
'1/1/1900'

MACHVAROHDCOSTEFFDTI_5 datetime
'1/1/1900'

MACHVAROHDCOSTEFFDTI_6 datetime
'1/1/1900'

NO_CALC_MACH_VAR_OHD tinyint
0

TOTALCOSTI_1 numeric(19,5)
0.00

TOTALCOSTI_2 numeric(19,5)
0.00

TOTALCOSTI_3 numeric(19,5)
0.00

TOTALCOSTI_4 numeric(19,5)
0.00

TOTALCOSTI_5 numeric(19,5)
0.00

TOTALCOSTI_6 numeric(19,5)
0.00

TOTALCOSTI_7 numeric(19,5)
0.00

TOTALCOSTI_8 numeric(19,5)
0.00

BTDT_I tinyint
0

DONT_ROLLUP_WU tinyint
0

MAT_SET_TO_ZERO tinyint
0

MAT_FIXED_SET_TO_ZERO tinyint
0

MAT_VAR_SET_TO_ZERO tinyint
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3