PA01403 - PA Employee Rate Table LINE | Prospr

PA01403 - PA Employee Rate Table LINE

Query Builder

Select * from PA01403

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PARate_Table_ID	PA Rate Table ID	String	32	View
EMPLOYID	Employee ID	String	16	View
PAPayCode	PA Pay Code	String	8	View
PAUnit_of_Measure	PA Unit of Measure	String	10	View
PAUNITCOST	PA Unit Cost	Currency	10	View
PAProfitType	PA Profit Type 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
PAProfitAmount	PA Profit Amount	Currency	10	View
PAProfitPercent	PA Profit Percent	Currency	10	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
PAOverhead_Group_ID	PA Overhead Group ID	String	16	View
SUTASTAT	Suta State	String	4	View
WRKRCOMP	Workers Comp	String	8	View
PA_Orig_Profit_AmtTM	PA Originating Profit Amount - TM	Currency	10	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

PA01403 - PA Employee Rate Table LINE

Query Builder

Customer Service

Information

My Account

Contact Us