Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DTA00300
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Account Analysis Groups Group Display Name: Transaction Analysis Table Group
Physical Name: DTA00300
Technical Name: DTA_Account_Groups
Group Technical Name: DTA_Analysis_Table_Group
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | ACTINDX  | Account Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Account Analysis Groups'].ACTINDX AS 'Account Analysis Groups-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
DTA00300 AS ['Account Analysis Groups']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Account Analysis Groups'].ACTINDX = ['Account Index Master'].ACTINDX | ||||||
| 2 | GROUPID | DTA_Group_ID | String | STR15_LBAU | 15 | |
| 3 | DTA_Quantities | DTA_Quantities | Boolean | DTA_Quantities | 0 | |
| 4 | ACCTSTAT | DTA_DDL_Account_Status | Integer | DTA_DDL_Account_Status | 0 | |
| 5 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 | |