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 Olympic PC tables pc00205
You are currently viewing the COMPANY database.
Change

COMPANY..pc00205 Table Definition

(COMPANY..pcProjectUserDefined )
The pc00205 is the Project User Defined Field data table. This holds values entered at the Project level as User Defined values.
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
zProjectNumber int
0
zUDCheckBox_1 tinyint
0
zUDCheckBox_2 tinyint
0
zUDCheckBox_3 tinyint
0
zUDCheckBox_4 tinyint
0
zUDCheckBox_5 tinyint
0
zUDCheckBox_6 tinyint
0
zUDCheckBox_7 tinyint
0
zUDCheckBox_8 tinyint
0
zUDCheckBox_9 tinyint
0
zUDCheckBox_10 tinyint
0
zUDCheckBox_11 tinyint
0
zUDCheckBox_12 tinyint
0
zUDCheckBox_13 tinyint
0
zUDCheckBox_14 tinyint
0
zUDCheckBox_15 tinyint
0
zUDCurrency2_1 numeric
0.00
zUDCurrency2_2 numeric
0.00
zUDCurrency2_3 numeric
0.00
zUDCurrency5_1 numeric
0.00
zUDCurrency5_2 numeric
0.00
zUDDate_1 datetime
'1900-01-01'
zUDDate_2 datetime
'1900-01-01'
zUDDate_3 datetime
'1900-01-01'
zUDDate_4 datetime
'1900-01-01'
zUDDate_5 datetime
'1900-01-01'
zUDDate_6 datetime
'1900-01-01'
zUDDate_7 datetime
'1900-01-01'
zUDDate_8 datetime
'1900-01-01'
zUDDate_9 datetime
'1900-01-01'
zUDDate_10 datetime
'1900-01-01'
zUDLong_1 int
0
zUDLong_2 int
0
zUDLong_3 int
0
zUDLong_4 int
0
zUDLong_5 int
0
zUDPercentage_1 numeric
0.00
zUDPercentage_2 numeric
0.00
zUDPercentage_3 numeric
0.00
zUDPercentage_4 numeric
0.00
zUDPercentage_5 numeric
0.00
zUDString20_1 char
''
zUDString20_2 char
''
zUDString20_3 char
''
zUDString20_4 char
''
zUDString20_5 char
''
zUDString20_6 char
''
zUDString20_7 char
''
zUDString20_8 char
''
zUDString20_9 char
''
zUDString30_1 char
''
zUDString30_2 char
''
zUDString30_3 char
''
zUDString30_4 char
''
zUDString30_5 char
''
zUDString50_1 char
''
zUDString50_2 char
''
zUDString50_3 char
''
zUDString50_4 char
''
zUDString50_5 char
''
zUDString50_6 char
''
zUDString50_7 char
''
zUDString50_8 char
''
zUDString50_9 char
''
zUDString50_10 char
''
zUDString50_11 char
''
zUDString50_12 char
''
zUDString50_13 char
''
zUDString50_14 char
''
zUDString50_15 char
''
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
zUDText1 text
''
zUDText2 text
''
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