CST_VAL_UNITS_B
This table contains the valuation unit codes. Valuation units are created in context of cost organization, cost book and valuation structure. Valuation units identify at which the costs are calculated and maintained in the cost management application. Valuation units are referenced in transactions.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_VAL_UNITS_B_PK |
VAL_UNIT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| VAL_UNIT_ID | NUMBER | 18 | Yes | Surrogate key identifying Valuation Unit row in this table. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |||
| VAL_UNIT_CODE | VARCHAR2 | 1000 | Yes | Valuation Unit Code | |||
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization. | |||
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |||
| VAL_STRUCTURE_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Valuation Structure. | |||
| VAL_STRUCTURE_MODE_CODE | VARCHAR2 | 30 | Yes | Valuation Structure Creation Mode | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | Active | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Valuation Unit (CST_VAL_UNITS_B) |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cst_transactions | cst_val_units_b | VAL_UNIT_ID |
| cst_user_adjustments | cst_val_units_b | VAL_UNIT_ID |
| cst_val_unit_details | cst_val_units_b | VAL_UNIT_ID |
| cst_val_units_tl | cst_val_units_b | VAL_UNIT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_VAL_UNITS_B_N1 | Non Unique | Default | UPPER("VAL_UNIT_CODE") |
| CST_VAL_UNITS_B_PK | Unique | APPS_TS_TX_DATA | VAL_UNIT_ID |
| CST_VAL_UNIT_B_U1 | Unique | APPS_TS_TX_DATA | COST_ORG_ID, COST_BOOK_ID, VAL_STRUCTURE_ID, VAL_UNIT_CODE |