PA10000 - PA Timesheet Header File | Prospr - Dynamics GP Table Reference

PA10000 - PA Timesheet Header File

Query Builder

Select * from PA10000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PATSTYP	PA Timesheet TRX Type	Integer	2	View
PATSNO	PA Timesheet No.	String	18	View
PDK_TS_No	PDK TS No.	String	32	View
PADOCDT	PA Document Date	Date	4	View
PAYR	PA Year	Integer	2	View
USERID	User ID	String	16	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
TRXSORCE	TRX Source	String	14	View
PAREFNO	PA Reference Document No.	String	18	View
EMPLOYID	Employee ID	String	16	View
PA_Employed_By	PA Employed By 1 = Standard 2 = Placement Agency 3 = Subcontractor	Integer	2	View
PAREPD	PA Reporting Period	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
PATQTY	PA Total Quantity	Currency	10	View
PAtotcosts	PA Total Costs	Currency	10	View
PATACRV	PA Total Accrued Revenues	Currency	10	View
NOTEINDX	Note Index	Currency	10	View
PAreptsuff	PA Reporting Suffix	String	6	View
PAPD	PA Post Date	Date	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PATS_HDR_Errors	PA TS HDR Errors	Long Integer	4	View
PATS_Dist_Errors	PA TS Distribution Errors	Long Integer	4	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
PDK_Proxy_ID	PDK Proxy ID	String	16	View
Correcting_Trx_Type	Correcting Trx Type	Integer	2	View
PAORIGINLDOCNUM	PA Original Document Number	String	18	View
CREATDDT	Created Date	Date	4	View
CRUSRID	Created User ID	String	16	View

PA10000 - PA Timesheet Header File

Query Builder

Customer Service

Information

My Account

Contact Us