PA41001 - PA Cost Category Class Setup File | Prospr

PA41001 - PA Cost Category Class Setup File

Query Builder

Select * from PA41001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PACOSTCATCLASID	PA Cost Category Class ID	String	16	View
PACOSTCATCLASNME	PA Cost Category Class Name	String	32	View
PADC	PA Default Class	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
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
PAOverheadRateMethod	PA Overhead Rate Method	Integer	2	View
PAOvhdAmtPerUnit	PA Overhead Amount Per Unit	Currency	10	View
PAOverheaPercentage	PA Overhead Percentage	Currency	10	View
PAbillnoteidx	PA Billing Note Index	Currency	10	View
PANOTEINDEX	PA Note Index	Currency	10	View

PA41001 - PA Cost Category Class Setup File

Query Builder

Customer Service

Information

My Account

Contact Us