UDCs Used in Column Definitions

The JD Edwards EnterpriseOne system provides hard-coded values for these UDC tables:

09/BO (OVFS Balance Type)

The system uses the value that you select from this UDC list to determine the account balances to retrieve from the Account Balances table (F0902). When you access this UDC table from the Revise Column Definition form, you select from a list of the descriptions instead of the numeric code. The numeric code and the description appear on the Work with Column Definitions form.

Values are:

01: Period. The balance based on specific period and fiscal year.
02: Year to Date. The balance from the beginning of the year through the current period.
03: Prior Year Balance. The balance brought forward from the prior fiscal year.
04: Cumulative to Date. The balance from the beginning of the year through the current period plus the prior year posting.
05: Quarter. The total balance for the quarter that includes the period.
06: Quarter to Date. The balance from the beginning of the quarter through the end of the period.
07: Debit Period. The debit-only balance for a specific period and fiscal year.
08: Debit Year to Date. The debit-only balance from the beginning of the year through the current period.

09/SM (OVFS Definition Status)

You select from a list of values to specify whether a financial statements component definition is active, inactive, or a work in progress. The list on the Revise Column Definitions form shows the description instead of the UDC code. The Work with Column Definition form shows both the numeric value and the description.

These codes are for informational purposes. The system does not perform any validations based on these values.

Values are:

01: Work in progress

02: Active

03: Inactive

(09/C1 - 09/C5) OVFS Financial Reporting CatCd1 - OVFS Financial Reporting CatCd5

Category codes that you can use with the OVFS functionality exist in category codes 09/C1-09/C5. You can set up values in these category codes to use for column definitions, row definitions, statement definitions, and statement versions. You can use the category codes to identify the types of data, users, access, or other attributes that you need for the financial statement components. You can also use these category codes to set up security for the components.

To set up security, you assign a category code value to the columns, rows, and statement definitions; or to versions; and then your system security administrator can use the codes to apply security for the component.

Examples of values are:

Data sensitivity
Financial Statement Types