QP_PRICING_TERMS_INT
This table represents the Interface for Pricing Terms.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
QP_PRICING_TERMS_INT_PK |
PRICING_TERM_INT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICING_TERM_INT_ID | NUMBER | 18 | Yes | Value that uniquely identifies the pricing term in the interface table. | |
| OPERATION_CODE | VARCHAR2 | 30 | Value that identifies the operation to perform on the pricing term. | ||
| SOURCE_ROOT_PARENT_ID | VARCHAR2 | 240 | Value that uniquely identifies the parent entity in the source system. For discount list, it will be the source discount list ID. | ||
| SOURCE_PARENT_ID | VARCHAR2 | 240 | Value that uniquely identifies the parent for this pricing term in the source system. For discount list, it will be the source discount list item ID. | ||
| SOURCE_TERM_ID | VARCHAR2 | 240 | Value that uniquely identifies the pricing term. For discount list, it is the source ID of either simple rule, tiered rule or attribute rule. | ||
| NAME | VARCHAR2 | 80 | Name of the pricing term. For discount list, it is the name of either simple rule, tiered rule or attribute rule. | ||
| PRICING_RULE_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that indicates the type of the discount rule such as simple, tiered, attribute rule. The value as based on lookup type ORA_QP_PRICING_RULE_TYPES. | ||
| PRICE_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that indicates if the price types such as one time, recurring, etc. The values are based on the lookup type ORA_QP_PRICE_TYPES. | ||
| CHARGE_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that indicates the charge type of the Pricing term. The values are based on the lookup type. Not applicable for benefit types Price List and Accrual. The values are based on the lookup type ORA_QP_CHARGE_TYPES. | ||
| CHARGE_SUBTYPE_CODE | VARCHAR2 | 30 | Abbreviation that indicates the charge subtype of the Pricing term. The valeus are based on the lookup type Not applicable for benefit types Price List and Accrual.The values are based on the lookup type ORA_QP_CHARGE_SUBTYPES. | ||
| PRICE_PERIODICITY | VARCHAR2 | 30 | Periodicity unit of measure for a recurring charge or recurring usage charge. | ||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 3 | Abbreviation that indicates the Periodicity unit of measure code for a recurring charge or recurring usage charge. | ||
| ADJUSTMENT_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that indicates the Adjustment type for the pricing term. The values are based on the lookup type ORA_QP_LINE_ADJ_TYPES. | ||
| ADJUSTMENT_AMOUNT | NUMBER | Adjustment amount for the pricing term. | |||
| ADJUSTMENT_BASIS | VARCHAR2 | 80 | Name of the Adjustment basis. Applicable for percentage based adjustments. | ||
| ADJUSTMENT_BASIS_ID | NUMBER | Value that uniquely identifies the Adjustment basis. Applicable for percentage based adjustments. | |||
| APPLY_TO_ROLLUP_FLAG | VARCHAR2 | 30 | Indicates if the Adjustment is applicable to the coverage/model item alone or the rollup (applicable when item on term is a coverage or model item). | ||
| START_DATE | TIMESTAMP | Start date of the pricing term. | |||
| END_DATE | TIMESTAMP | End date of the pricing term. | |||
| PRICING_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the pricing currency code for the pricing term. | ||
| PRICING_TERM_ID | NUMBER | Value that uniquely identifies the pricing term. The application updates this value after it successfully creates the pricing term. | |||
| CHARGE_DEFINITION_ID | NUMBER | Number that uniquely identifies the charge definition for the given price type, charge type and charge sub type. Used internally to validate price periodicity for recurring charges. | |||
| PARENT_ID | NUMBER | Number that uniquely identifies the parent. The application updates this value based on Source Parent ID and is used internally. | |||
| ATTRIBUTE_PRICING_MATRIX_ID | NUMBER | 18 | Number that uniquely identifies the matrix. The application updates this value based on Source Matrix Id and is used internally. | ||
| INTERFACE_STATUS | VARCHAR2 | 30 | Status of a record, such as New, Error, Validated and Imported. | ||
| WEIGHT | NUMBER | 18 | Internally calculated attribute based on the predefined importance of the child records in a pricing batch. This attribute is used to determine weight of the item and helps batching the items so that the weight is distributed equally. | ||
| BATCH_ID | NUMBER | 18 | Value that identifies the pricing batch to process. | ||
| CHILD_BATCH_NAME | VARCHAR2 | 240 | Name of the child pricing batch to be processed. | ||
| BATCH_JOB_ID | NUMBER | 18 | Value that identifies the records in the batch that belong to the current run.This is the request id of the parent ESS job. | ||
| LOAD_REQUEST_ID | NUMBER | Unique ID of the Load ESS job used to import into an interface table. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | 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. | ||
| 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. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PRICING_TERMS_INT_N1 | Non Unique | FUSION_TS_TX_IDX | CHILD_BATCH_NAME, BATCH_JOB_ID, BATCH_ID |
| QP_PRICING_TERMS_INT_N2 | Non Unique | FUSION_TS_TX_IDX | SOURCE_ROOT_PARENT_ID, SOURCE_PARENT_ID |
| QP_PRICING_TERMS_INT_U1 | Unique | FUSION_TS_TX_IDX | PRICING_TERM_INT_ID |