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

COMPANY..PDK10000 Table Definition

(COMPANY..PDK Timesheet HDR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PDK_Timesheet_TRX_Type smallint
0

PDK_TS_No char(31)
''

PDK_Ref_Doc_No char(31)
''

PDK_Document_Status smallint
0

PDK_Trx_Source smallint
0

PDK_Remote_Change tinyint
0

PADOCDT datetime
'1/1/1900'

PAYR smallint
0

EMPLOYID char(15)
''
Employee I...(more) Join Now UPR00100.EMPLOYID
join ... more text available
PAREPD smallint
0

PA_Employed_By smallint
0
1=Companyb...(more) Join Now PA40601.PA_Employed_By
PAREPDT datetime
'1/1/1900'

PAPeriodEndDate datetime
'1/1/1900'

PACOMM char(51)
''

PAUD1 char(21)
''
PA User De...(more) Join Now PA01001.PAUD1
PAUD2 char(21)
''
PA User De...(more) Join Now PA01001.PAUD2
PDK_Total_Quantity numeric(19,5)
0.00

PAtotcosts numeric(19,5)
0.00

PATACRV numeric(19,5)
0.00

NOTEID char(31)
''

PDK_Reporting_Suffix char(5)
''

LNITMSEQ int
0
Line Item ...(more) Join Now PA01301.LNITMSEQ
MANAGER char(15)
''

Manager_Approval_Status smallint
0

SUPERVISOR char(31)
''

Sup_Approval_Status smallint
0

Administrator char(15)
''

Admin_Approval_Status smallint
0

CURNCYID char(15)
''
Currency I...(more) Join Now CM20000
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
RATETPID char(15)
''
A valid Ra...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now CM20200.EXGTBLID
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now CM20200.XCHGRATE
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now CM20200.EXCHDATE
TIME1 datetime
'1/1/1900'
Time see ...(more) Join Now CM20200.TIME1
RTCLCMTD smallint
0
Rate Calcu...(more) Join Now CM20200.RTCLCMTD
DENXRATE numeric(19,7)
0.00
Denominati...(more) Join Now CM20200.DENXRATE
MCTRXSTT smallint
0
MC Transac...(more) Join Now CM20200.MCTRXSTT
PAORIGTOTCOSTS numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

PATSNO char(17)
''

PAREFNO char(17)
''

PDK_Proxy_ID char(15)
''

PDK_TS_App_Update smallint
0

MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
Modified_Time datetime
'1/1/1900'

APRVLUSERID char(15)
''
Approval U...(more) Join Now SY00500.APRVLUSERID
APPRVLDT datetime
'1/1/1900'
Approval D...(more) Join Now SY00500.APPRVLDT
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