FND_VS_VALUES_B
Flexfields: Value Sets: Value (_B) Table.
Details
-
Schema: VST
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_VS_VALUES_B_PK |
VALUE_ID, ENTERPRISE_ID, SANDBOX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| SANDBOX_ID | VARCHAR2 | 64 | Yes | SANDBOX_ID | |
| VALUE_ID | NUMBER | 18 | Yes | Primary key by itself (See U1 index). Only used to join _B and _TL tables. | |
| VALUE_SET_ID | NUMBER | 18 | Yes | Value is a member of this Value Set. | |
| VALUE | VARCHAR2 | 150 | Yes | VARCHAR2 Value for VARCHAR2 typed value sets. VARCHAR2 representation of Value for NUMBER, DATE, and TIMESTAMP typed value sets. | |
| VALUE_NUMBER | NUMBER | NUMBER Value for NUMBER typed value sets. | |||
| VALUE_DATE | DATE | DATE Value for DATE typed value sets. | |||
| VALUE_TIMESTAMP | TIMESTAMP | TIMESTAMP Value for TIMESTAMP typed value sets. | |||
| INDEPENDENT_VALUE | VARCHAR2 | 150 | For Dependent Value Sets only. VARCHAR2 Independent Value for VARCHAR2 typed independent value sets. VARCHAR2 representation of Independent Value for NUMBER, DATE, and TIMESTAMP typed independent value sets. | ||
| INDEPENDENT_VALUE_NUMBER | NUMBER | NUMBER Independent Value for NUMBER typed independent value sets. | |||
| INDEPENDENT_VALUE_DATE | DATE | DATE Independent Value for DATE typed independent value sets. | |||
| INDEPENDENT_VALUE_TIMESTAMP | TIMESTAMP | TIMESTAMP Independent Value for TIMESTAMP typed independent value sets. | |||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | ENABLED_FLAG | |
| START_DATE_ACTIVE | DATE | START_DATE_ACTIVE | |||
| END_DATE_ACTIVE | DATE | END_DATE_ACTIVE | |||
| SORT_ORDER | NUMBER | 18 | SORT_ORDER | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 60 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE31 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE32 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE33 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE34 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE35 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE36 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE37 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE38 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE39 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE40 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE41 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE42 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE43 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE44 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE45 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE46 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE47 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE48 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE49 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE50 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| SUMMARY_FLAG | VARCHAR2 | 30 | Value Attribute Column: Reserved for 101/GL#/GL_GLOBAL/SUMMARY_FLAG. | ||
| FLEX_VALUE_ATTRIBUTE1 | VARCHAR2 | 30 | Value Attribute Column: Reserved for 101/GL#/GL_GLOBAL/DETAIL_POSTING_ALLOWED. | ||
| FLEX_VALUE_ATTRIBUTE2 | VARCHAR2 | 30 | Value Attribute Column: Reserved for 101/GL#/GL_GLOBAL/DETAIL_BUDGETING_ALLOWED. | ||
| FLEX_VALUE_ATTRIBUTE3 | VARCHAR2 | 30 | Value Attribute Column: Reserved for 101/GL#/GL_ACCOUNT/GL_ACCOUNT_TYPE. | ||
| FLEX_VALUE_ATTRIBUTE4 | VARCHAR2 | 30 | Value Attribute Column: Reserved for 101/GL#/GL_ACCOUNT/GL_CONTROL_ACCOUNT. | ||
| FLEX_VALUE_ATTRIBUTE5 | VARCHAR2 | 30 | Value Attribute Column: Reserved for 101/GL#/GL_ACCOUNT/RECONCILIATION_FLAG. | ||
| FLEX_VALUE_ATTRIBUTE6 | VARCHAR2 | 30 | Value Attribute Column: Reserved for 101/GL#/GL_ACCOUNT/FINANCIAL_CATEGORY. | ||
| FLEX_VALUE_ATTRIBUTE7 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE7 | ||
| FLEX_VALUE_ATTRIBUTE8 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE8 | ||
| FLEX_VALUE_ATTRIBUTE9 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE9 | ||
| FLEX_VALUE_ATTRIBUTE10 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE10 | ||
| FLEX_VALUE_ATTRIBUTE11 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE11 | ||
| FLEX_VALUE_ATTRIBUTE12 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE12 | ||
| FLEX_VALUE_ATTRIBUTE13 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE13 | ||
| FLEX_VALUE_ATTRIBUTE14 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE14 | ||
| FLEX_VALUE_ATTRIBUTE15 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE15 | ||
| FLEX_VALUE_ATTRIBUTE16 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE16 | ||
| FLEX_VALUE_ATTRIBUTE17 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE17 | ||
| FLEX_VALUE_ATTRIBUTE18 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE18 | ||
| FLEX_VALUE_ATTRIBUTE19 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE19 | ||
| FLEX_VALUE_ATTRIBUTE20 | VARCHAR2 | 30 | FLEX_VALUE_ATTRIBUTE20 | ||
| CUSTOM_VALUE_ATTRIBUTE1 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE1 | ||
| CUSTOM_VALUE_ATTRIBUTE2 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE2 | ||
| CUSTOM_VALUE_ATTRIBUTE3 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE3 | ||
| CUSTOM_VALUE_ATTRIBUTE4 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE4 | ||
| CUSTOM_VALUE_ATTRIBUTE5 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE5 | ||
| CUSTOM_VALUE_ATTRIBUTE6 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE6 | ||
| CUSTOM_VALUE_ATTRIBUTE7 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE7 | ||
| CUSTOM_VALUE_ATTRIBUTE8 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE8 | ||
| CUSTOM_VALUE_ATTRIBUTE9 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE9 | ||
| CUSTOM_VALUE_ATTRIBUTE10 | VARCHAR2 | 30 | CUSTOM_VALUE_ATTRIBUTE10 | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | 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. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Seed data file from which the row originates. | ||
| EXTERNAL_DATA_SOURCE | VARCHAR2 | 512 | External data source from which the row originates. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_VS_VALUES_B_N1 | Non Unique | Default | VALUE_SET_ID, VALUE, ENTERPRISE_ID, SANDBOX_ID |
| FND_VS_VALUES_B_N2 | Non Unique | Default | VALUE_SET_ID, UPPER("VALUE"), INDEPENDENT_VALUE, ENTERPRISE_ID, SANDBOX_ID |
| FND_VS_VALUES_B_U1 | Unique | Default | VALUE_ID, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET1 |
| FND_VS_VALUES_B_U11 | Unique | Default | VALUE_ID, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET2 |
| FND_VS_VALUES_B_U2 | Unique | Default | VALUE_SET_ID, INDEPENDENT_VALUE, VALUE, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET1 |
| FND_VS_VALUES_B_U21 | Unique | Default | VALUE_SET_ID, INDEPENDENT_VALUE, VALUE, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET2 |