Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SE988977
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Account Rollups Options Columns Group Display Name: Account Rollup Inquiries
Physical Name: SE988977
Technical Name: SE_Options_Columns
Group Technical Name: Account Rollup Inquiries
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | SEOPTNME  | SE Option Name | String | STR20_SE_Alpha | 20 | |
| 2 | SE_Column_Number | SE Column Number | Integer | INT1 | 1 | |
| 3 | SECOL | SE Col Name | String | STR20 | 20 | |
| 4 | SECOLTYP | SE Column Type | Integer | SE Column Type | 0 | |
| 5 | BUDGETID | Budget ID | String | STR15_LBAU | 15 | |
Key to the Budget Master (GL00200).
Click to show/hideSELECT
['Account Rollups Options Columns'].BUDGETID AS 'Account Rollups Options Columns-Budget ID'
,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
SE988977 AS ['Account Rollups Options Columns']
INNER JOIN
GL00200 AS ['Budget Master']
ON
['Account Rollups Options Columns'].BUDGETID = ['Budget Master'].BUDGETID | ||||||
| 6 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Account Rollups Options Columns'].CURRNIDX AS 'Account Rollups Options Columns-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SE988977 AS ['Account Rollups Options Columns']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Account Rollups Options Columns'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||