QP_COST_LIST_CHARGES_INT
Interface table for the data from cost list charges.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
QP_COST_LIST_CHARGES_INT_PK |
COST_LIST_CHARGE_INT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_LIST_CHARGE_INT_ID | NUMBER | Yes | Unique ID for interface table. System generated. | ||
| 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. | ||
| OPERATION_CODE | VARCHAR2 | 30 | Indicates the operation on the records to be imported. | ||
| SOURCE_COST_LIST_ID | VARCHAR2 | 240 | Unique ID for a cost list in the source system. | ||
| SOURCE_CHARGE_ID | VARCHAR2 | 240 | Unique ID for a charge in the source system. | ||
| NEW_SOURCE_CHARGE_ID | VARCHAR2 | 240 | Value that uniquely identifies the new charge for the cost list item in the source system. This attribute is applicable for supporting End and Insert charges scenarios. | ||
| PARENT_ENTITY_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that identifies the parent entity type for the charge(s) of the item in the cost list. Valid value is COST_LIST_ITEM. | ||
| PARENT_SOURCE_ID | VARCHAR2 | 240 | Unique ID of parent source for a cost list charge. | ||
| CHARGE_LINE_NUMBER | NUMBER | 9 | Line number for a cost list charge. | ||
| COST_ELEMENT_CODE | VARCHAR2 | 30 | Indicates the cost element used to capture the cost. | ||
| CHARGE_DEFINITION_CODE | VARCHAR2 | 30 | Code for charge definition for a cost list charge. | ||
| CHARGE_DEFINITION_ID | NUMBER | 18 | Number that uniquely identifies the charge definition for a cost list charge. | ||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 3 | Periodicity unit of measure code for a recurring charge. | ||
| PRICE_PERIODICITY_NAME | VARCHAR2 | 80 | Periodicity unit of measure for the recurring charge in the cost list. | ||
| COST_CALCULATION_TYPE_CODE | VARCHAR2 | 30 | Indicates the type of calculation used for determining the cost amount: Fixed, Percent of Price Element. | ||
| COST_BASIS_ELEMENT_CODE | VARCHAR2 | 30 | This is required when Cost Calculation Type is 'PERCENT_PRICE_ELEMENT'. | ||
| COST_AMOUNT | NUMBER | Calculation Amount in percentage or absolute value depending upon the Cost Calculation Type Code. | |||
| COST_PLUS_PRICING_FLAG | VARCHAR2 | 30 | Specifies how the cost list charged is used. If the flag is set to 'Y', this indicates the charge is used for Cost Plus Pricing and Margin calculations. If the flag is set to 'N', this indicates the charge is used for only Margin. | ||
| COST_METHOD_CODE | VARCHAR2 | 30 | Indicates the cost method used to capture the cost. | ||
| START_DATE | TIMESTAMP | Start date of the effective period of a charge. | |||
| END_DATE | TIMESTAMP | End date of the effective period of a charge. | |||
| INTERFACE_STATUS | VARCHAR2 | 30 | Status of a record, such as New, Error, Imported, and Validated. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Unique ID of the Load ESS job used to import into an interface table. | ||
| BATCH_NAME | VARCHAR2 | 50 | Identifies the batch to be processed. | ||
| 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. | ||
| COST_LIST_CHARGE_ID | NUMBER | ID of the row created in Cost List Charge after successful import. | |||
| PARENT_ID | NUMBER | 18 | Number that uniquely identifies the parent of the cost list charge. | ||
| COST_LIST_ID | NUMBER | 18 | Number that uniquely identifies the cost list. The application updates this value based on Source Cost List Id and is used internally. | ||
| WEIGHT | NUMBER | 18 | Internally calculated attribute based on the predefined importance of the child records in a pricing batch. | ||
| BATCH_ID | NUMBER | 18 | Value that identifies the pricing batch to process. | ||
| CHILD_BATCH_NAME | VARCHAR2 | 50 | 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 main job. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of 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_COST_LIST_CHARGES_INT_N1 | Non Unique | Default | BATCH_ID, BATCH_JOB_ID, CHILD_BATCH_NAME, PARENT_SOURCE_ID, SOURCE_COST_LIST_ID, COST_LIST_CHARGE_ID |
| QP_COST_LIST_CHARGES_INT_N2 | Non Unique | Default | LOAD_REQUEST_ID, SOURCE_COST_LIST_ID, PARENT_SOURCE_ID |
| QP_COST_LIST_CHARGES_INT_U1 | Unique | Default | COST_LIST_CHARGE_INT_ID |