1. Tables and Views for Common Features
  2. FND_KF_STRUCTURES_B_

FND_KF_STRUCTURES_B_

Flexfields: Key Flexfields: Structure (_B) Table.

Details

  • Schema: KFF

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FND_KF_STRUCTURES_B_PK_

LAST_UPDATE_DATE, APPLICATION_ID, KEY_FLEXFIELD_CODE, STRUCTURE_CODE, ENTERPRISE_ID

Columns

Name Datatype Length Precision Comments
ENTERPRISE_ID NUMBER 18 ENTERPRISE_ID
APPLICATION_ID NUMBER 18 APPLICATION_ID
KEY_FLEXFIELD_CODE VARCHAR2 4 KEY_FLEXFIELD_CODE
STRUCTURE_CODE VARCHAR2 30 STRUCTURE_CODE
STRUCTURE_ID NUMBER 18 STRUCTURE_ID
ENABLED_FLAG VARCHAR2 1 ENABLED_FLAG
DELIMITER VARCHAR2 1 DELIMITER
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Actione Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1's and 0s for each row. 1 will be stored if the value has changed and 0 will be stored if the value hasn't.
SEED_DATA_SOURCE VARCHAR2 512 Seed data file from which the row originates.

Indexes

Index Uniqueness Tablespace Columns
FND_KF_STRUCTURES_B_N1_ Non Unique Default APPLICATION_ID, KEY_FLEXFIELD_CODE, STRUCTURE_CODE, ENTERPRISE_ID
FND_KF_STRUCTURES_B_U1_ Non Unique Default LAST_UPDATE_DATE, APPLICATION_ID, KEY_FLEXFIELD_CODE, STRUCTURE_CODE, ENTERPRISE_ID
FND_KF_STRUCTURES_B_U2_ Non Unique Default LAST_UPDATE_DATE, STRUCTURE_ID, ENTERPRISE_ID