GTM20003V - GTM_AllGrantBudgetByAccount
Dynamics GP table GTM20003V (GTM_AllGrantBudgetByAccount) contains 11 columns including aaBudgetID, aaBudget, YEAR1....
SQL Query Builder
11 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| aaBudgetID | aaBudgetID | Long Integer | 4 | |
| aaBudget | aaBudget | String | 16 | |
| YEAR1 | Year | Integer | 2 | |
| aaFiscalPeriod | aaFiscalPeriod | Integer | 2 | |
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | |
| aaTrxDim | aaTrxDim | String | 32 | |
| aaTrxDimCode | aaTrxDimCode | String | 32 | |
| STRTDATE | Start Date | Date | 4 | |
| ENDDATE | End Date | Date | 4 | |
| Balance | Balance | Currency | 10 | |
| PERIODDT | Period Date | Date | 4 |
Related Tables
Tables that share columns with GTM20003V. Click "Join" to add to your query.
aaTrxDimCode
aaBudgetID
aaBudget
aaFiscalPeriod