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
Key | Name | Data type | Null | 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 Name: fk_FND_COLUMNS_FND_TABLESFND_COLUMNS.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
||||
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 Name: fk_FND_FOREIGN_KEY_COLUMNS_FND_COLUMNSFND_FOREIGN_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID |
||||
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 Name: fk_FND_INDEX_COLUMNS_FND_COLUMNSFND_INDEX_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_INDEX_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID |
||||
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 Name: fk_FND_PRIMARY_KEY_COLUMNS_FND_COLUMNSFND_PRIMARY_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID FND_PRIMARY_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID |
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)
|
Used by
Name |
---|
FND_COLUMNS (Columns)
|
FND_COLUMNS#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17