Flex Fields

Flexfield - A field made up of one or more segments. A segment corresponds to a column in an Oracle table. Each segment has an assigned name and may have assigned data validation rules (Validation Sets).

Key Flexfield - A Key Flexfield represents an intelligent key that uniquely identifies an application entity. These keys identify accounts, part numbers etc. Each key flexfield has an assigned name and a specified set of valid values. Examples: in G/L we have the Accounting Flexfield (Chart of Accounts); in Inventory it is the Item Flexfield, in Projects the Job Flexfield.

Descriptive Flexfield - Allows for the capture of additional information not stored in the default application, or strictly for reference when viewed on a screen. You may create a Flexfield using any of “Attribute(n)” columns. Oracle reserved “Attribute(n)” columns on most of the tables to be setup during installation. These columns are not used by Oracle standard functionality. You may expand the number of Flexfield values by using “context sensitive” feature.

Flexfield Key Terms
Accounting Flexfield : The code you use to identify a general ledger (GL) account in Oracle.
Segment: A subcomponent of a flexfield. Company and natural account are examples of possible segments in the accounting flexfield.

Flexfield Qualifiers : Balancing segment, cost center segment, natural account, inter-company segment.

Segment Values : Numbers or codes attributed to each segment.Value Set: A list of values for one segment, such as the list of companies, list of accounts, or the list of departments.
Code Combination : One full accounting flexfield with all segment values.
Dynamic Insertion / Cross-Validation : Automatic creation of account code combination based on rules defined with code combinations.

GL
REFERENCE1 User Entered or System Auto Generated Batch Name for Every Run
REFERENCE2 User Entered or System Auto Generated Batch Name for Every Run
REFERENCE7 ‘Yes’. This means the following Journal Entry could be reversed
REFERENCE8 Journal Entry Reversal Period in Case it needs to be reversed. This should be the same as Period Name
REFERENCE9 ‘Yes’. To change the Sign for Reversal