PA00401 - PA Fee Master File | Prospr - Dynamics GP Table Reference

PA00401 - PA Fee Master File

Query Builder

Select * from PA00401

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PAFeeID	PA Fee ID	String	16	View
PAFeeName	PA Fee Name	String	32	View
PAFeeType	PA Fee Type	Integer	2	View
PAFrequency	PA Frequency	Integer	2	View
PAPercent_Cost	PA Percent Cost	Currency	10	View
PAPercent_Revenue	PA Percent Revenue	Currency	10	View
PA_Retention_Percent	PA Retention Percent	Currency	10	View
PAFeeToUse	PA Fee To Use	Integer	2	View
PAFeeAmount	PA Fee Amount	Currency	10	View
PASales_Tax_Options	PA Sales Tax Options	Integer	2	View
PAbilltaxscheduleid	PA Billing Tax Schedule ID	String	16	View
PAtotcbts	PA Label Checkbox - TS	Boolean	2	View
PAtotcbEL	PA Label Checkbox - EL	Boolean	2	View
PAtotcbML	PA Label Checkbox - ML	Boolean	2	View
PAtotcbvi	PA Label Checkbox - VI	Boolean	2	View
PAtotcber	PA Label Checkbox - EE	Boolean	2	View
PAtotcbinv	PA Label Checkbox - INV	Boolean	2	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
PARenew	PA Renew	Boolean	2	View
PARenewal_Date	PA Renewal Date	Date	4	View
PANOTEINDEX	PA Note Index	Currency	10	View
PA_Renew_Day	PA Renew Day	Integer	2	View
PA_Renew_Month	PA Renew Month	Integer	2	View
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View