PA00601 - PA Employee MSTR | Prospr - Dynamics GP Table Reference

PA00601 - PA Employee MSTR

Query Builder

Select * from PA00601

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
PAfileemplreim	PA Files Empl Expense	Boolean	2	View
PANOTA1099VENDOR	PA Not a 1099 Vendor	Boolean	2	View
PApmcb	PA Project Manager Check Box	Boolean	2	View
PAbmcb	PA Business Manager Check Box	Boolean	2	View
PAEmployee_Type	PA Employee Type	Integer	2	View
PA_Employed_By	PA Employed By 1 = Standard 2 = Placement Agency 3 = Subcontractor	Integer	2	View
PAPayCode	PA Pay Code	String	8	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
PAUnit_of_Measure	PA Unit of Measure	String	10	View
PAUNITCOST	PA Unit Cost	Currency	10	View
PATMProfitType	PA Profit Type - TM 1 - Billing Rate 2 - Markup % 3 - Profit/Unit-Fixed 4 - Profit/Unit-Variable 5 - Total Profit 6 - % of Baseline 7 - % of Actual 8 - None 9 - Price Level	Integer	2	View
PATMProfitAmount	PA Profit Amount - TM	Currency	10	View
PA_Orig_Profit_AmtTM	PA Originating Profit Amount - TM	Currency	10	View
PATMProfitPercent	PA Profit Percent - TM	Currency	10	View
PAProfit_Type__CP	PA Profit Type - CP 1 - Billing Rate 2 - Markup % 3 - Profit/Unit-Fixed 4 - Profit/Unit-Variable 5 - Total Profit 6 - % of Baseline 7 - % of Actual 8 - None 9 - Price Level	Integer	2	View
PAProfitAmountCP	PA Profit Amount - CP	Currency	10	View
PAProfitPercentCP	PA Profit Percent - CP	Currency	10	View
PAFFProfitType	PA Profit Type - FF 1 - Billing Rate 2 - Markup % 3 - Profit/Unit-Fixed 4 - Profit/Unit-Variable 5 - Total Profit 6 - % of Baseline 7 - % of Actual 8 - None 9 - Price Level	Integer	2	View
PAFFProfitAmount	PA Profit Amount - FF	Currency	10	View
PAFFProfitPercent	PA Profit Percent - FF	Currency	10	View
VENDORID	Vendor ID	String	16	View
PAOverheadRateMethod	PA Overhead Rate Method	Integer	2	View
PAOvhdAmtPerUnit	PA Overhead Amount Per Unit	Currency	10	View
PAOverheaPercentage	PA Overhead Percentage	Currency	10	View
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
PA_Allow_Vendor_For_PO	PA Allow Vendor For PO	Boolean	2	View

PA00601 - PA Employee MSTR

Query Builder

Customer Service

Information

My Account

Contact Us