GTM20002V - GTM_AllGrantBudgetByNode
Dynamics GP table GTM20002V (GTM_AllGrantBudgetByNode) contains 10 columns including aaBudgetID, aaBudget, YEAR1....
SQL Query Builder
10 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| aaBudgetID | aaBudgetID | Long Integer | 4 | |
| aaBudget | aaBudget | String | 16 | |
| YEAR1 | Year | Integer | 2 | |
| aaFiscalPeriod | aaFiscalPeriod | Integer | 2 | |
| 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 GTM20002V. Click "Join" to add to your query.
aaTrxDimCode
aaBudgetID
aaBudget
aaFiscalPeriod
Balance