Get Description for Cryptic JDE Data
JDE Data contains many codes and numbers that are not readable in plain English. Data Access Studio solves this problem with instant Associated Descriptions. For instance, consider the data in Account ID:
Clearly the data in Account ID is not understandable in plain English. JDE, however, has an Associated Description for Account ID that provides its English description.
For any column that has a JDE Associated Description, simply double-click the Column Header. Alternatively, you can click the Column Header and select Quick Calculation | Enterprise One (or World) | Associated Description:
Example result
The Associated Description calculation creates a new column next to the coded column. The new column shows the English-readable description, which makes your report more understandable.
You may hide the original column once you get its associated description.
If a column does not have an associated description, such as the Amount column, then you will not see the Associated Description on the Column Menu. |