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

COMPANY..pc00405 Table Definition

(COMPANY..pcEmployeeUserDefined )
The pc00405 is the Employee User Defined Field data table. This holds values entered and associated with the Employee record User Defined values.
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
zUserNumber int
0
zUDCheckBoxA5_1 tinyint
0
zUDCheckBoxA5_2 tinyint
0
zUDCheckBoxA5_3 tinyint
0
zUDCheckBoxA5_4 tinyint
0
zUDCheckBoxA5_5 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
zUDDateA5_1 datetime
'1900-01-01'
zUDDateA5_2 datetime
'1900-01-01'
zUDDateA5_3 datetime
'1900-01-01'
zUDDateA5_4 datetime
'1900-01-01'
zUDDateA5_5 datetime
'1900-01-01'
zUDLong_1 int
0
zUDLong_2 int
0
zUDLong_3 int
0
zUDLong_4 int
0
zUDLong_5 int
0
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
''
zUDString50A5_1 char
''
zUDString50A5_2 char
''
zUDString50A5_3 char
''
zUDString50A5_4 char
''
zUDString50A5_5 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