Custom Flex Attribute Attribute

In Scope

Technical: CFA_ATTRIB | ID: OR-FND-CFA_ATTRIB-CUSTOM_FLEX_ATTRIBUTE_ATTRIBUTE

Stores the metadata that defines custom attributes for all extended entities. The information stored in this table tells how each attribute is stored, basic data restrictions and how the attribute...

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: CFA_ATTRIB

Field Definitions(5)

Rules & Considerations(39)

validation

constraint

Sample Load Data(4)

_scenario	GROUP_IDR	ATTRIB_IDRPK	DISPLAY_SEQR	VIEW_COL_NAMER	STORAGE_COL_NAMER	BASE_IND	CODE_TYPE	DATA_TYPE	UI_WIDGET	VALUE_REQ	ACTIVE_IND	EDITOR_REQ	ENABLE_IND	REC_GROUP_ID	MAXIMUM_LENGTH	VALIDATION_FUNC	LOWEST_ALLOWED_VALUE	HIGHEST_ALLOWED_VALUE
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	S	SAMP	SAMPLE	SA	S	S	S	S	1	1	SAMPLE	1.0000	1.0000
default	1000000003	1000000003	3	Cfa Attrib Secondary	Cfa Attrib	C	Cfa	Cfa Attrib	da	C	C	N	C	1000000003	3	Cfa Attrib-002-ALT	12.5000	12.5000
default	1000000005	1000000005	5	Cfa Attrib Core	Cfa Attrib	C	Cfa	Cfa Attrib	da	C	C	N	C	1000000005	5	Cfa Attrib-003-EDGE	14.0000	14.0000

Example values from field definitions

GROUP_IDR: 1
ATTRIB_IDRPK: 1
DISPLAY_SEQR: 1
VIEW_COL_NAMER: SAMPLE
STORAGE_COL_NAMER: SAMPLE
BASE_IND: S
CODE_TYPE: SAMP
DATA_TYPE: SAMPLE
UI_WIDGET: SA
VALUE_REQ: S
ACTIVE_IND: S
EDITOR_REQ: S
ENABLE_IND: S
REC_GROUP_ID: 1
MAXIMUM_LENGTH: 1
VALIDATION_FUNC: SAMPLE
LOWEST_ALLOWED_VALUE: 1.0000
HIGHEST_ALLOWED_VALUE: 1.0000

default

GROUP_IDR: 1000000003
ATTRIB_IDRPK: 1000000003
DISPLAY_SEQR: 3
VIEW_COL_NAMER: Cfa Attrib Secondary
STORAGE_COL_NAMER: Cfa Attrib
BASE_IND: C
CODE_TYPE: Cfa
DATA_TYPE: Cfa Attrib
UI_WIDGET: da
VALUE_REQ: C
ACTIVE_IND: C
EDITOR_REQ: N
ENABLE_IND: C
REC_GROUP_ID: 1000000003
MAXIMUM_LENGTH: 3
VALIDATION_FUNC: Cfa Attrib-002-ALT
LOWEST_ALLOWED_VALUE: 12.5000
HIGHEST_ALLOWED_VALUE: 12.5000