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

COMPANY..PDK70101 Table Definition

(COMPANY..PDK Report Options)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
PDK_Start_Doc_No char(31)
''

PDK_End_Doc_No char(31)
''

PASTPROJN char(15)
''

PAENPROJN char(15)
''

Start_Contract_Number char(11)
''

End_Contract_Number char(11)
''

PAStart_ID_Array_1 char(15)
''

PAStart_ID_Array_2 char(15)
''

PAStart_ID_Array_3 char(15)
''

PAStart_ID_Array_4 char(15)
''

PAStart_ID_Array_5 char(15)
''

PAStart_ID_Array_6 char(15)
''

PAStart_ID_Array_7 char(15)
''

PAStart_ID_Array_8 char(15)
''

PAStart_ID_Array_9 char(15)
''

PAStart_ID_Array_10 char(15)
''

PAEnd_ID_Array_1 char(15)
''

PAEnd_ID_Array_2 char(15)
''

PAEnd_ID_Array_3 char(15)
''

PAEnd_ID_Array_4 char(15)
''

PAEnd_ID_Array_5 char(15)
''

PAEnd_ID_Array_6 char(15)
''

PAEnd_ID_Array_7 char(15)
''

PAEnd_ID_Array_8 char(15)
''

PAEnd_ID_Array_9 char(15)
''

PAEnd_ID_Array_10 char(15)
''

PAStart_Name_Array_1 char(31)
''

PAStart_Name_Array_2 char(31)
''

PAStart_Name_Array_3 char(31)
''

PAStart_Name_Array_4 char(31)
''

PAStart_Name_Array_5 char(31)
''

PAStart_Name_Array_6 char(31)
''

PAStart_Name_Array_7 char(31)
''

PAStart_Name_Array_8 char(31)
''

PAStart_Name_Array_9 char(31)
''

PAStart_Name_Array_10 char(31)
''

PAEnd_Name_Array_1 char(31)
''

PAEnd_Name_Array_2 char(31)
''

PAEnd_Name_Array_3 char(31)
''

PAEnd_Name_Array_4 char(31)
''

PAEnd_Name_Array_5 char(31)
''

PAEnd_Name_Array_6 char(31)
''

PAEnd_Name_Array_7 char(31)
''

PAEnd_Name_Array_8 char(31)
''

PAEnd_Name_Array_9 char(31)
''

PAEnd_Name_Array_10 char(31)
''

STDATEIN datetime
'1/1/1900'

ENDATEIN datetime
'1/1/1900'

PASTDOCT smallint
0

PAENDOCT smallint
0

IFFILXST smallint
0

FILEXPNM char(255)
''

EXPTTYPE smallint
0

ASKECHTM tinyint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

PRNTTYPE smallint
0

RPTGRIND smallint
0

RTGRSBIN numeric(19,5)
0.00

RTPACHIN smallint
0

REPORTID smallint
0

RPTGRNMS char(21)
''

PATU smallint
0
PA Transac...(more) Join Now PA01001.PATU
STRTNGDT datetime
'1/1/1900'

ENDINGDT datetime
'1/1/1900'

STTUDEF1 char(21)
''

ENUSRDF1 char(21)
''

STTDOCDT datetime
'1/1/1900'
Field Type...(more) Join Now SVC00670.STTDOCDT
ENDDOCDT datetime
'1/1/1900'
Field Type...(more) Join Now SVC00670.ENDDOCDT
STTPSTDT datetime
'1/1/1900'

ENDPSTDT datetime
'1/1/1900'

SORTBY smallint
0

PARange_By_Array_1 tinyint
0

PARange_By_Array_2 tinyint
0

PARange_By_Array_3 tinyint
0

PARange_By_Array_4 tinyint
0

PARange_By_Array_5 tinyint
0

PARange_By_Array_6 tinyint
0

PARange_By_Array_7 tinyint
0

PARange_By_Array_8 tinyint
0

PARange_By_Array_9 tinyint
0

PARange_By_Array_10 tinyint
0

PAExclude_Array_1 tinyint
0

PAExclude_Array_2 tinyint
0

PAExclude_Array_3 tinyint
0

PAExclude_Array_4 tinyint
0

PAExclude_Array_5 tinyint
0

PAExclude_Array_6 tinyint
0

PAExclude_Array_7 tinyint
0

PAExclude_Array_8 tinyint
0

PAExclude_Array_9 tinyint
0

PAExclude_Array_10 tinyint
0

RANGEBY smallint
0

PAReport_Include smallint
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