FND_COLUMNS (Columns)

Documentation	Oracle EBS Data Dictionary
Name	FND_COLUMNS
Title	Columns
Module	EBS Data Dictionary Diagram

Columns in all the registered application tables.

Columns

		Name	Data type	Attributes	References	Description
	1	APPLICATION_ID	NUMBER(15, 0)		FND_TABLES (Tables)	Application that owns the table that owns this column. Foreign key to FND_TABLE.
Application that owns the table that owns this column. Foreign key to FND_TABLE. References: FND_TABLES (Tables)
	2	TABLE_ID	NUMBER(15, 0)		FND_TABLES (Tables)	Table to which column belongs. Foreign key to FND_TABLES.
Table to which column belongs. Foreign key to FND_TABLES. References: FND_TABLES (Tables)
	3	COLUMN_ID	NUMBER(15, 0)			Column identifier.
Column identifier.
	4	COLUMN_NAME	VARCHAR2(30 BYTE)			Actual database column name.
Actual database column name.
	5	USER_COLUMN_NAME	VARCHAR2(80 BYTE)			Name for column that is meaningful to users.
Name for column that is meaningful to users.
	6	COLUMN_SEQUENCE	NUMBER(15, 0)			Sequence number. Indicates order of columns in created table.
Sequence number. Indicates order of columns in created table.
	7	LAST_UPDATE_DATE	DATE			Standard Who column.
Standard Who column.
	8	LAST_UPDATED_BY	NUMBER(15, 0)			Standard Who column.
Standard Who column.
	9	CREATION_DATE	DATE			Standard Who column.
Standard Who column.
	10	CREATED_BY	NUMBER(15, 0)			Standard Who column.
Standard Who column.
	11	LAST_UPDATE_LOGIN	NUMBER(15, 0)			Standard Who column.
Standard Who column.
	12	COLUMN_TYPE	VARCHAR2(1 BYTE)			Column datatype. D (Date), N (Number), V (Varchar), I (RowID), L (Long), X (Long Raw) are possible values.
Column datatype. D (Date), N (Number), V (Varchar), I (RowID), L (Long), X (Long Raw) are possible values.
	13	WIDTH	NUMBER(15, 0)			Bytes of storage for column value.
Bytes of storage for column value.
	14	NULL_ALLOWED_FLAG	VARCHAR2(1 BYTE)			Y/N flag: Are null values allowed?
Y/N flag: Are null values allowed?
	15	TRANSLATE_FLAG	VARCHAR2(1 BYTE)			Y/N flag: Is value translated?
Y/N flag: Is value translated?
	16	FLEXFIELD_USAGE_CODE	VARCHAR2(1 BYTE)			Code that indicates how the column is used in flexfields. N (not used), K (key flexfield segment), D (descriptive flexfield attribute), Q (?), S (structure identifier), I (key flexfield identifier), and C (category) are possible values.
Code that indicates how the column is used in flexfields. N (not used), K (key flexfield segment), D (descriptive flexfield attribute), Q (?), S (structure identifier), I (key flexfield identifier), and C (category) are possible values.
	17	DESCRIPTION	VARCHAR2(240 BYTE)			Name of flexfield associated with this column.
Name of flexfield associated with this column.
	18	FLEXFIELD_APPLICATION_ID	NUMBER(10, 0)			Flexfield application identifier.
Flexfield application identifier.
	19	FLEXFIELD_NAME	VARCHAR2(30 BYTE)			Flexfield name.
Flexfield name.
	20	FLEX_VALUE_SET_APPLICATION_ID	NUMBER(10, 0)			Flexfield value set application identifier.
Flexfield value set application identifier.
	21	FLEX_VALUE_SET_ID	NUMBER(10, 0)			Flexfield value set identifier.
Flexfield value set identifier.
	22	DEFAULT_VALUE	VARCHAR2(2000 BYTE)			Default value for column, if any.
Default value for column, if any.
	23	PRECISION	NUMBER(15, 0)			Precision for column, if any.
Precision for column, if any.
	24	SCALE	NUMBER(15, 0)			Scale for column, if any.
Scale for column, if any.
	25	IREP_COMMENTS	VARCHAR2(4000 BYTE)			Comments from CASE.
Comments from CASE.
	26	ZD_EDITION_NAME	VARCHAR2(30 BYTE)	Default: 'ORA$BASE'
Default: 'ORA$BASE'
	27	ZD_SYNC	VARCHAR2(30 BYTE)	Default: 'SYNCED'
Default: 'SYNCED'

Relations

Foreign table	Primary table	Join	Title / Name / Description
FND_COLUMNS (Columns)	FND_TABLES (Tables)	FND_COLUMNS.TABLE_ID = FND_TABLES.TABLE_ID FND_COLUMNS.APPLICATION_ID = FND_TABLES.APPLICATION_ID	fk_FND_COLUMNS_FND_TABLES
FND_COLUMNS.TABLE_ID = FND_TABLES.TABLE_ID FND_COLUMNS.APPLICATION_ID = FND_TABLES.APPLICATION_ID Name: fk_FND_COLUMNS_FND_TABLES
FND_FOREIGN_KEY_COLUMNS (Foreign key columns)	FND_COLUMNS (Columns)	FND_FOREIGN_KEY_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_FOREIGN_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID	fk_FND_FOREIGN_KEY_COLUMNS_FND_COLUMNS
FND_FOREIGN_KEY_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_FOREIGN_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID Name: fk_FND_FOREIGN_KEY_COLUMNS_FND_COLUMNS
FND_INDEX_COLUMNS (Index columns)	FND_COLUMNS (Columns)	FND_INDEX_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID FND_INDEX_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_INDEX_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID	fk_FND_INDEX_COLUMNS_FND_COLUMNS
FND_INDEX_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID FND_INDEX_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_INDEX_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID Name: fk_FND_INDEX_COLUMNS_FND_COLUMNS
FND_PRIMARY_KEY_COLUMNS (Primary key columns)	FND_COLUMNS (Columns)	FND_PRIMARY_KEY_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_PRIMARY_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID FND_PRIMARY_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID	fk_FND_PRIMARY_KEY_COLUMNS_FND_COLUMNS
FND_PRIMARY_KEY_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_PRIMARY_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID FND_PRIMARY_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID Name: fk_FND_PRIMARY_KEY_COLUMNS_FND_COLUMNS

Unique keys

	Key name	Columns	Description
	FND_COLUMNS_U1	APPLICATION_ID, ZD_EDITION_NAME, COLUMN_ID, TABLE_ID
	FND_COLUMNS_U2	COLUMN_NAME, ZD_EDITION_NAME, TABLE_ID, APPLICATION_ID
	FND_COLUMNS_U3	APPLICATION_ID, ZD_EDITION_NAME, USER_COLUMN_NAME, TABLE_ID
	FND_COLUMNS_U4	COLUMN_SEQUENCE, ZD_EDITION_NAME, TABLE_ID, APPLICATION_ID

Uses

Name
FND_COLUMNS (Columns)
FND_TABLES (Tables)

Used by

Name
FND_COLUMNS (Columns)
FND_COLUMNS#
FND_FOREIGN_KEY_COLUMNS (Foreign key columns)
FND_INDEX_COLUMNS (Index columns)
FND_PRIMARY_KEY_COLUMNS (Primary key columns)

Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17