GTM20006V - GTM_NetAmountByAccountInAASubLedger
Dynamics GP table GTM20006V (GTM_NetAmountByAccountInAASubLedger) contains 6 columns including aaTrxDimID, aaTrxCodeID, aaTrxDimCode....
SQL Query Builder
6 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| aaTrxDimID | aaTrxDimID | Long Integer | 4 | |
| aaTrxCodeID | aaTrxCodeID | Long Integer | 4 | |
| aaTrxDimCode | aaTrxDimCode | String | 32 | |
| 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 | |
| GLPOSTDT | GL Posting Date | Date | 4 | |
| NETAMNT | Net Amount | Currency | 10 |
Related Tables
Tables that share columns with GTM20006V. Click "Join" to add to your query.
aaTrxDimCode