PA01001 - PA Cost Category Master File | Prospr

PA01001 - PA Cost Category Master File

Query Builder

Select * from PA01001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PACOSTCATID	PA Cost Category ID	String	16	View
PACOSTCATNME	PA Cost Category Name	String	32	View
PACOSTCATCLASID	PA Cost Category Class ID	String	16	View
PAinactive	PA Inactive	Boolean	2	View
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PAIV_Item_Checkbox	PA IV Item Checkbox	Boolean	2	View
PAUnit_of_Measure	PA Unit of Measure	String	10	View
UOMSCHDL	U Of M Schedule	String	12	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
PAUNITCOST	PA Unit Cost	Currency	10	View
PAPay_Code_Hourly	PA Pay Code Hourly	String	8	View
PAPay_Code_Salary	PA Pay Code Salary	String	8	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
DECPLCUR	Decimal Places Currency	Integer	2	View
PAcostaxscheduleid	PA Cost Tax Schedule ID	String	16	View
PAPurchase_Tax_Options	PA Purchase Tax Options	Integer	2	View
PAbilltaxscheduleid	PA Billing Tax Schedule ID	String	16	View
PASales_Tax_Options	PA Sales Tax Options	Integer	2	View
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
PAbillnoteidx	PA Billing Note Index	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
PANOTEINDEX	PA Note Index	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
EXCHDATE	Exchange Date	Date	4	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	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

PA01001 - PA Cost Category Master File

Query Builder

Customer Service

Information

My Account

Contact Us