QP_COST_LIST_CHARGES
This table stores the Cost List Charges details
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_COST_LIST_CHARGES_PK |
COST_LIST_CHARGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_LIST_CHARGE_ID | NUMBER | 18 | Yes | Primary Key of the table,mandatory | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 240 | Value that uniquely identifies the charge for the cost list item in the source system. This attribute is used for uniquely locating the charge record for supporting update scenarios. | ||
| CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | This is used as an alternate key for the Cost List Charge entity to support CRUD service in future release | |
| PARENT_ENTITY_TYPE_CODE | VARCHAR2 | 30 | Yes | Stores the parent entity type.Values available are: Cost List,Item or Cost List Covered Item. | |
| PARENT_ENTITY_ID | NUMBER | 18 | Yes | Primary Key of the Parent Entity | |
| COST_CALCULATION_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates the type of calculation used for determining the cost amount: Fixed ,Percent of Price Element | |
| COST_AMOUNT | NUMBER | Yes | Capture fixed cost value or a parent value for Percent of Price Element | ||
| COST_BASIS_ELEMENT_CODE | VARCHAR2 | 30 | Price Element of type "Price" used when the Cost Calculation Type = Percent of Price Element. | ||
| COST_METHOD_CODE | VARCHAR2 | 30 | Indicated the cost method used to capture the cost.Will come from lookup QP_COST_METHODS.Values include : Standard.Average,FIFO ,Next. | ||
| KIND_OF_COST_CODE | VARCHAR2 | 30 | Integration with Fusion Cost Management to determine cost. | ||
| COST_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates whether the cost will be a static cost(retrieved from the cost list) or will come from cost management.Will come from lookup QP_COST_TYPES | |
| COST_ELEMENT_CODE | VARCHAR2 | 30 | Yes | Price Element Code of type Cost. | |
| COST_PLUS_PRICING_FLAG | VARCHAR2 | 30 | Yes | Specifies how the cost list charged is used. If the flag is set to ???Yes???, this indicates the charge is used for Cost Plus Pricing and Margin calculations. If the flag is set to ???No???, this indicates the charge is used for only Margin | |
| CHARGE_DEFINITION_ID | NUMBER | 18 | Yes | Primary key of the Pricing Charge Definition. | |
| PRICE_PERIODICITY_CODE | VARCHAR2 | 3 | Only Applicable when the price type is Recurring or Recurring Usage. | ||
| USAGE_UOM_CODE | VARCHAR2 | 3 | Only Applicable when the price type is usage or Recurring Usage. | ||
| START_DATE | TIMESTAMP | Indicates the start date for the cost list charge record. | |||
| END_DATE | TIMESTAMP | Indicates the end date for the cost list charge record. | |||
| COST_MATRIX_ID | NUMBER | 18 | Stores the FK to the Pricing Matrix record. | ||
| 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. | |
| 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_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. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_COST_LIST_CHARGES_N1 | Non Unique | FUSION_TS_TX_IDX | PARENT_ENTITY_ID |
| QP_COST_LIST_CHARGES_U1 | Unique | FUSION_TS_TX_IDX | COST_LIST_CHARGE_ID |