QP_TOTAL_DEFINITIONS_B
A Fusion Pricing entity that acts as a handle to the STS Total Algorithm and that allows users to specify whether the total can be referenced in guidelines, be calculated at runtime, be returned if it is a null total, and be adjusted during a ordering or quoting process.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
QP_TOTAL_DEFINITIONS_B_PK |
TOTAL_DEFINITION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TOTAL_DEFINITION_ID | NUMBER | 18 | Yes | Primary Key (system generated sequence id) of the Total Definition table. | |
| TOTAL_CODE | VARCHAR2 | 30 | Yes | Code of the pricing total definition. This field is non-translatable. This is unique in the table. | |
| ALGORITHM_NAME | VARCHAR2 | 250 | It is the Process name that is defined in the STS Algorithm. The algorithm name that is referenced here is linked with manage pricing total guideline via the total definition Code atatched to this guideline. | ||
| PRICING_GUIDELINE_ENABLED_FLAG | VARCHAR2 | 30 | Indicates whether the pricing total definition can be referenced in pricing guideline definitions. Valid values are ???Y??? and ???N???. Defaults to ???N???. ) Only when the Pricing Guideline Enabled Flag is set to ???Y???, can the pricing total definition be referenced in pricing guidelines definitions. The value of this flag will not be evaluated in the Calculate Pricing Totals service. | ||
| TRANSACTION_ENABLED_FLAG | VARCHAR2 | 30 | Indicates whether pricing total algorithm linked to this pricing total definition will be calculated by the Calculate Pricing Totals definition. Valid values are ???Y??? and ???N???. Defaults to ???N???. When the Transaction Enabled flag is set to ???Y???, the pricing STS total algorithm linked to the total definition can be executed by the Calculate Pricing Totals service. | ||
| RETURN_NULL_TOTAL_FLAG | VARCHAR2 | 30 | Indicates whether the Calculate Pricing Totals service will return the pricing total as a zero amount total if the total is a null total. Valid values are ???Y??? and ???N???. Defaults to ???Y???. UI label is Return As Null Total. | ||
| SEEDED_FLAG | VARCHAR2 | 30 | Indicates whether the total definition is seeded. Valid values are ???Y??? and ???N???. The default value of this attribute is set by the system. Pricing total definitions with seeded flag set to ???Y??? cannot be deleted. | ||
| 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. | |
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| qp_total_definitions_tl | qp_total_definitions_b | TOTAL_DEFINITION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_TOTAL_DEFINITIONS_B_PK | Unique | FUSION_TS_SEED | TOTAL_DEFINITION_ID, ORA_SEED_SET1 |
| QP_TOTAL_DEFINITIONS_B_PK1 | Unique | FUSION_TS_SEED | TOTAL_DEFINITION_ID, ORA_SEED_SET2 |
| QP_TOTAL_DEFINITIONS_B_U1 | Unique | FUSION_TS_TX_IDX | TOTAL_CODE, ORA_SEED_SET1 |
| QP_TOTAL_DEFINITIONS_B_U11 | Unique | FUSION_TS_TX_IDX | TOTAL_CODE, ORA_SEED_SET2 |