There are 3 main types of Flexfields:
As taken from:
A flexfield is a field made up of sub-fields, or segments.
There are two types of flexfields: key flexfields and descriptive flexfields.
A key flexfield appears on your form as a normal text field with an appropriate prompt.
A descriptive flexfield appears on your form as a two-character-wide text field with square brackets [ ] as its prompt.
- When opened, both types of flexfield appear as a pop-up window that contains a separate field and prompt for each segment.
- Each segment has a name and a set of valid values.
- The values may also have value descriptions.
Most organizations use “codes” made up of meaningful segments (intelligent keys) to identify general ledger accounts, part numbers, and other business entities.
Each segment of the code can represent a characteristic of the entity.
For example, your organization might use the part number PAD-NR-YEL-8 1/2×14″ to represent a notepad that is narrow-ruled, yellow, and 8 1/2″ by 14″.
Another organization may identify the same notepad with the part number “PD-8×14-Y-NR”.
Both of these part numbers are codes whose segments describe a characteristic of the part.
Although these codes represent the same part, they each have a different segment structure that is meaningful only to the organization using those codes.
The Oracle E-Business Suite stores these “codes” in key flexfields. Key flexfields are flexible enough to let any organization use the code scheme they want, without programming.
Descriptive flexfields provide customizable “expansion space” on your forms.
You can use descriptive flexfields to track additional information, important and unique to your business, that would not otherwise be captured by the form.
Descriptive flexfields can be context sensitive, where the information your application stores depends on other values your users enter in other parts of the form.
A descriptive flexfield appears on a form as a single-character, unnamed field enclosed in brackets.
Just like in a key flexfield, a pop-up window appears when you move your cursor into a customized descriptive flexfield.
And like a key flexfield, the pop-up window has as many fields as your organization needs.
Each field or segment in a descriptive flexfield has a prompt, just like ordinary fields, and can have a set of valid values.
Your organization can define dependencies among the segments or customize a descriptive flexfield to display context-sensitive segments, so that different segments or additional pop-up windows appear depending on the values you enter in other fields or segments.