PA00701 - PA Equipment Master File | Prospr - Dynamics GP Table Reference

PA00701 - PA Equipment Master File

Select * from PA00701

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PAEQUIPTID	PA Equipment ID	String	16	View
PAEQNME	PA Equipment Name	String	32	View
PAEQUIPTCLSID	PA Equipment Class ID	String	16	View
PAinactive	PA Inactive	Boolean	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
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
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
PANOTEINDEX	PA Note Index	Currency	10	View