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 CT00002
You are currently viewing the COMPANY database.
Change

COMPANY..CT00002 Table Definition

(COMPANY..IC COST Standard Item Class Defaults)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
CMPANYID smallint
0
Company ID...(more) Join Now POP10100.CMPANYID
join ... more text available
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
ITEMDESC char(101)
''
Item Descr...(more) Join Now POP10110.ITEMDESC
ITMCLSCD char(11)
''
Item Class...(more) Join Now IV00101.ITMCLSCD
ITMCLSDC char(31)
''

DEFLTCLS tinyint
0

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

LOTTYPE char(11)
''

KPERHIST tinyint
0

KPTRXHST tinyint
0

KPCALHST tinyint
0

KPDSTHST tinyint
0

ALWBKORD tinyint
0

ITMGEDSC char(11)
''

TAXOPTNS smallint
0

ITMTSHID char(15)
''
Item Tax S...(more) Join Now PA11801.ITMTSHID
COMMCODE char(15)
''

UOMSCHDL char(11)
''
p>U of M S...(more) Join Now SVC8005.UOMSCHDL
join ... more text available
VCTNMTHD smallint
0
Valuation ...(more) Join Now POP10110.VCTNMTHD
USCATVLS_1 char(11)
''

USCATVLS_2 char(11)
''

USCATVLS_3 char(11)
''

USCATVLS_4 char(11)
''

USCATVLS_5 char(11)
''

USCATVLS_6 char(11)
''

DECPLQTY smallint
0
 Decimal Pl...(more) Join Now
DECPLCUR smallint
0
 Number of ...(more) Join Now
ICIVICOFDI numeric(19,5)
0.00

ICIVICOFPI int
0

ICIVICOVDI numeric(19,5)
0.00

ICIVICOVPI int
0

ICIVICOFDOPI smallint
0

ICIVICVDOPI smallint
0

ICIVOUSEI_1 tinyint
0

ICIVOUSEI_2 tinyint
0

ICIVOUSEI_3 tinyint
0

ICIVOUSEI_4 tinyint
0

ICIVOUSEI_5 tinyint
0

ICIVOUSEI_6 tinyint
0

ICIVOUSEI_7 tinyint
0

ICIVOUSEI_8 tinyint
0

ICIVOUSEI_9 tinyint
0

ICIVOUSEI_10 tinyint
0

ICIVOUSEI_11 tinyint
0

ICIVOUSEI_12 tinyint
0

ICIVOUSEI_13 tinyint
0

ICIVOUSEI_14 tinyint
0

ICIVOUSEI_15 tinyint
0

ICIVOUSEI_16 tinyint
0

ICIVOUSEI_17 tinyint
0

ICIVOUSEI_18 tinyint
0

ICIVOUSEI_19 tinyint
0

ICIVOUSEI_20 tinyint
0

ICIVOUSEI_21 tinyint
0

ICIVOUSEI_22 tinyint
0

ICIVOUSEI_23 tinyint
0

ICIVOUSEI_24 tinyint
0

ICIVOUSEI_25 tinyint
0

ICIVOUSEI_26 tinyint
0

ICIVOUSEI_27 tinyint
0

ICIVOUSEI_28 tinyint
0

ICIVOUSEI_29 tinyint
0

ICIVOUSEI_30 tinyint
0

ICIVOUSEI_31 tinyint
0

ICIVOUSEI_32 tinyint
0

ICIVOUSEI_33 tinyint
0

ICIVOUSEI_34 tinyint
0

ICIVOUSEI_35 tinyint
0

ICIVOGRPI_1 smallint
0

ICIVOGRPI_2 smallint
0

ICIVOGRPI_3 smallint
0

ICIVOGRPI_4 smallint
0

ICIVOGRPI_5 smallint
0

PRCLEVEL char(11)
''

MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
MDFUSRID char(15)
''
User that ...(more) Join Now
join ... more text available
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