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

COMPANY..CT00001 Table Definition

(COMPANY..IC COST Standard Company 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
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

Mach_Fixed_Amt_or_Pct smallint
0

Mach_Fixed_Ohd_Acct int
0

Mach_Fixed_Ohd_Amt numeric(19,5)
0.00

Mach_Fixed_Ohd_AmtUnit smallint
0

Mach_Fixed_Ohd_Pct int
0

Mach_Fixed_Ohd_PctUnit smallint
0

Mach_Mach_Applied_Acct int
0

Mach_Variable_Amt_or_Pct smallint
0

Mach_Variable_Ohd_Acct int
0

Mach_Variable_Ohd_Amt numeric(19,5)
0.00

Mach_Variable_Ohd_AmtUnt smallint
0

Mach_Variable_Ohd_Pct int
0

Mach_Variable_Ohd_PctUni smallint
0

LC_Fixed_Overhead_Amount numeric(19,5)
0.00

LC_Fixed_Amount_or_Perce smallint
0

LC_Fixed_Overhead_AmtUni smallint
0

LC_Fixed_Overhead_PerUni smallint
0

LC_Fixed_Overhead_Percen int
0

LC_Variable_Overhead_Amo numeric(19,5)
0.00

LC_Variable_Amount_or_Pe smallint
0

LC_Variable_OverheadAmtU smallint
0

LC_Variable_Overhead_Per int
0

LC_Variable_OverheadPerU smallint
0

LC_Fixed_Overhead int
0

LC_Labor_Applied int
0

LC_Variable_Overhead int
0

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