PDK10000 - PDK Timesheet HDR | Prospr - Dynamics GP Table Reference

PDK10000 - PDK Timesheet HDR

Query Builder

Select * from PDK10000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PDK_Timesheet_TRX_Type	PDK Timesheet TRX Type	Integer	2	View
PDK_TS_No	PDK TS No.	String	32	View
PDK_Ref_Doc_No	PDK Reference Document No.	String	32	View
PDK_Document_Status	PDK Document Status	Integer	2	View
PDK_Trx_Source	PDK Trx Source	Integer	2	View
PDK_Remote_Change	PDK Remote Change	Boolean	2	View
PADOCDT	PA Document Date	Date	4	View
PAYR	PA Year	Integer	2	View
EMPLOYID	Employee ID	String	16	View
PAREPD	PA Reporting Period	Integer	2	View
PA_Employed_By	PA Employed By 1 = Standard 2 = Placement Agency 3 = Subcontractor	Integer	2	View
PAREPDT	PA Reporting Date	Date	4	View
PAPeriodEndDate	PA Period End Date	Date	4	View
PACOMM	PA Comment	String	52	View
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
PDK_Total_Quantity	PDK Total Quantity	Currency	10	View
PAtotcosts	PA Total Costs	Currency	10	View
PATACRV	PA Total Accrued Revenues	Currency	10	View
NOTEID	Note ID	String	32	View
PDK_Reporting_Suffix	PDK Reporting Suffix	String	6	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
MANAGER	Manager	String	16	View
Manager_Approval_Status	Manager Approval Status	Integer	2	View
SUPERVISOR	Supervisor	String	32	View
Sup_Approval_Status	Supervisor Approval Status	Integer	2	View
Administrator	Administrator	String	16	View
Admin_Approval_Status	Admin Approval Status	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
PAORIGTOTCOSTS	PA Originating Total Costs	Currency	10	View
PAORIACCRREV	PA Originating Accrued Revenues	Currency	10	View
PATSNO	PA Timesheet No.	String	18	View
PAREFNO	PA Reference Document No.	String	18	View
PDK_Proxy_ID	PDK Proxy ID	String	16	View
PDK_TS_App_Update	PDK TS App Update	Integer	2	View
MODIFDT	Modified Date	Date	4	View
Modified_Time	Modified Time	Time	4	View
APRVLUSERID	Approval User ID	String	16	View
APPRVLDT	Approval Date	Date	4	View

PDK10000 - PDK Timesheet HDR

Query Builder

Customer Service

Information

My Account

Contact Us