GTM01100 - Grant Master | Prospr - Dynamics GP Table Reference

GTM01100 - Grant Master

Query Builder

Select * from GTM01100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
GRANTID	GTM_GrantID	String	32	View
GRANTDESC	GTM_GrantDescription	String	52	View
GRANTSTATUS	GTM_GrantStatus	Integer	2	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
GRANTTYPE	GTM_GrantType	String	16	View
VALIDGRANTPERIOD	GTM_ValidateGrantPeriod	Boolean	2	View
GRANTPERIODACTION	GTM_GrantPeriodAction	Integer	2	View
VALIDGRANTTODATE	GTM_ValidateGrantToDate	Boolean	2	View
GRANTTODATEACTION	GTM_GrantToDateAction	Integer	2	View
VALIDGRANTLIFE	GTM_ValidateGrantLife	Boolean	2	View
GRANTLIFEACTION	GTM_GrantLifeAction	Integer	2	View
VALIDGRANTTOTAL	GTM_ValidateGrantTotal	Boolean	2	View
GRANTTOTALTYPE	GTM_GrantTotalType	Integer	2	View
GRANTTOTALACTION	GTM_GrantTotalAction	Integer	2	View
AWARDAMOUNT	GTM_AwardAmount	Currency	10	View
ENABLEGRANTBUDGET	GTM_EnableGrantBudget	Boolean	2	View
UNIQUEGRANTID	GTM_UniqueGrantID	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View
aaTrxDim	aaTrxDim	String	32	View
aaTrxDimCode	aaTrxDimCode	String	32	View
BUDGETID	Budget ID	String	16	View
GTM_BudgetValidationBy	GTM_BudgetValidationBy	Integer	2	View