Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DTA00301
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Account Analysis Group Codes Group Display Name: Transaction Analysis Table Group
Physical Name: DTA00301
Technical Name: DTA_Account_Group_Codes
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 Group Codes'].ACTINDX AS 'Account Analysis Group Codes-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
DTA00301 AS ['Account Analysis Group Codes']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Account Analysis Group Codes'].ACTINDX = ['Account Index Master'].ACTINDX | ||||||
| 2 | GROUPID | DTA_Group_ID | String | STR15_LBAU | 15 | |
| 3 | CODEID | DTA_Code_ID | String | STR15_LBAU | 15 | |
| 4 | POSTDESC | DTA_Posting_Descr | String | STR50 | 50 | |
| 5 | PERCENTAMOUNT | DTA_Percent_Amount | Integer | INT5_%2 | 5 | |