Edit Codes
Edit codes are user-defined codes that indicate different scenarios for the presentation of numeric fields. The default edit code for a numeric value is derived from the associated data dictionary item. However, you can override the edit code in the field properties in RDA. The Edit Code table that is presented in this section can help you select the edit code that best meets your business needs.
Not all fields that present a numeric value can be formatted using edit codes. The Company field displays a number, but the field is actually defined as a string data type in data dictionary. Typically, you can select edit codes for fields that are defined as either numeric or currency in the data dictionary.
To select the appropriate edit code for the report, review the Negative Amount Notation column in the Edit Code table that is included in this section and select the appropriate option. The Negative Amount Notation information helps you narrow the possibilities to four codes. For example, if you select a trailing minus sign as your negative amount notation, your search is narrowed to the selection of options J, K, L, or M.
Next, review the Zero Balance column in the Edit Code table that is included in this section and determine whether you want to print zero balances in the report. The Zero Balance information narrows the search to two codes. For example, if you print zero balances, your search is narrowed to the selection of J or L.
Next, review the Commas column in the Edit Code table that is included in this section and determine whether you want to include commas in the numeric values on the report. For example, if you want commas in the numeric value, select J. If not, select L.
This Edit Code table lists the available edit codes and their characteristics:
Edit Code |
Commas Y/N |
Zero Balance Y/N |
Negative Amount Notation |
|---|---|---|---|
A |
Y |
Y |
Cr |
B |
Y |
N |
Cr |
C |
N |
Y |
Cr |
D |
N |
N |
Cr |
J |
Y |
Y |
- Trailing |
K |
Y |
N |
- Trailing |
L |
N |
Y |
- Trailing |
M |
N |
N |
- Trailing |
N |
Y |
Y |
- Preceding |
O |
Y |
N |
- Preceding |
P |
N |
Y |
- Preceding |
Q |
N |
N |
- Preceding |
R |
Y |
Y |
< > |
S |
Y |
N |
< > |
T |
N |
Y |
< > |
U |
N |
N |
< > |
1 |
Y |
Y |
No sign |
2 |
Y |
N |
No sign |
3 |
N |
Y |
No sign |
4 |
N |
N |
No sign |