GTM01100 - Grant Master
Dynamics GP table GTM01100 (Grant Master) contains 23 columns including GRANTID, GRANTDESC, GRANTSTATUS....
SQL Query Builder
23 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| GRANTID | GTM_GrantID | String | 32 | |
| GRANTDESC | GTM_GrantDescription | String | 52 | |
| GRANTSTATUS | GTM_GrantStatus | Integer | 2 | |
| STRTDATE | Start Date | Date | 4 | |
| ENDDATE | End Date | Date | 4 | |
| GRANTTYPE | GTM_GrantType | String | 16 | |
| VALIDGRANTPERIOD | GTM_ValidateGrantPeriod | Boolean | 2 | |
| GRANTPERIODACTION | GTM_GrantPeriodAction | Integer | 2 | |
| VALIDGRANTTODATE | GTM_ValidateGrantToDate | Boolean | 2 | |
| GRANTTODATEACTION | GTM_GrantToDateAction | Integer | 2 | |
| VALIDGRANTLIFE | GTM_ValidateGrantLife | Boolean | 2 | |
| GRANTLIFEACTION | GTM_GrantLifeAction | Integer | 2 | |
| VALIDGRANTTOTAL | GTM_ValidateGrantTotal | Boolean | 2 | |
| GRANTTOTALTYPE | GTM_GrantTotalType | Integer | 2 | |
| GRANTTOTALACTION | GTM_GrantTotalAction | Integer | 2 | |
| AWARDAMOUNT | GTM_AwardAmount | Currency | 10 | |
| ENABLEGRANTBUDGET | GTM_EnableGrantBudget | Boolean | 2 | |
| UNIQUEGRANTID | GTM_UniqueGrantID | Long Integer | 4 | |
| NOTEINDX | Note Index | Currency | 10 | |
| aaTrxDim | aaTrxDim | String | 32 | |
| aaTrxDimCode | aaTrxDimCode | String | 32 | |
| BUDGETID | Budget ID | String | 16 | |
| GTM_BudgetValidationBy | GTM_BudgetValidationBy | Integer | 2 |
Related Tables
Tables that share columns with GTM01100. Click "Join" to add to your query.
aaTrxDimCode
GRANTTYPE
AWARDAMOUNT