QP_PRICE_BOOK_LINES
This table stores all the price book line items.
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
QP_PRICE_BOOK_LINES_PK |
PRICE_BOOK_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PRICE_BOOK_LINE_ID | NUMBER | 18 | Yes | Value that uniquely identifies the price book line. Oracle Pricing automatically assigns this value. | |
| PRICE_BOOK_ID | NUMBER | 18 | Yes | Value that uniquely identifies the price book. Oracle Pricing automatically assigns this value. | |
| PRICE_BOOK_START_DATE | TIMESTAMP | The date and time on which the price book goes into effect. | |||
| PRICE_BOOK_END_DATE | TIMESTAMP | The date and time on which the price book is no longer effective. | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Value that uniquely identifies the item. Oracle Pricing automatically assigns this value. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Value that uniquely identifies the inventory organization. Oracle Pricing automatically assigns this value. | |
| INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | Yes | Item number of the price book line item. | |
| COMPONENT_ID_PATH | VARCHAR2 | 2000 | The inventory identifier path of the component item. Applicable to components of a configurable item. | ||
| ITEM_TYPE_CODE | VARCHAR2 | 30 | Yes | The BOM item type. Values include 1, 2, and 4. | |
| CATEGORY_CODE | VARCHAR2 | 30 | Yes | The line category code of the item. | |
| PARENT_LINE_ID | NUMBER | 18 | Value that uniquely identifies the parent line for component items. Oracle Pricing automatically assigns this value. | ||
| ROOT_LINE_ID | NUMBER | 18 | Value that uniquely identifies the root model line for component items. Oracle Pricing automatically assigns this value. | ||
| ROOT_COVERAGE_LINE_ID | NUMBER | 18 | Value that uniquely identifies the root line for coverage items. Oracle Pricing automatically assigns this value. | ||
| LINE_QUANTITY | NUMBER | Yes | The quantity of the item for which the price was calculated for the price book line. | ||
| LINE_QUANTITY_UOM_CODE | VARCHAR2 | 3 | Yes | The unit of measure for which the price is calculated. | |
| LINE_TYPE_CODE | VARCHAR2 | 30 | Yes | The line type for which the price is calculated. For sales orders the type is ORA_BUY. | |
| APPLIED_PRICE_LIST_ID | NUMBER | 18 | Value that uniquely identifies the applied price list. Oracle Pricing automatically assigns this value. | ||
| APPLIED_SHIP_CHARGE_LIST_ID | NUMBER | 18 | Value that uniquely identifies the shipping charge list that is applied to the price book line. | ||
| RATE_PLAN_ID | NUMBER | 18 | Value that uniquely identifies the rate plan. Oracle Pricing automatically assigns this value. | ||
| REQUESTED_RATE_PLAN_ID | NUMBER | 18 | Value that uniquely identifies the requested rate plan. Oracle Pricing automatically assigns this value. | ||
| PRICED_ON | TIMESTAMP | Indicates the date on which the price was calculated. | |||
| CUSTOMER_ID | NUMBER | 18 | Value that uniquely identifies the party to which the item is sold. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Value that uniquely identifies the customer to which bills should be sent. | ||
| BILL_TO_PARTY_ID | NUMBER | 18 | Value that uniquely identifies the party to which bills should be sent. | ||
| BILL_TO_PARTY_SITE_ID | NUMBER | 18 | Value that uniquely identifies the site of the party to which bills should be sent. | ||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Value that uniquely identifies the location to which bills should be sent. | ||
| BILL_FROM_LOCATION_ID | NUMBER | 18 | Value that uniquely identifies the location from which bills should be sent. | ||
| SHIP_FROM_LOCATION_ID | NUMBER | 18 | Value that uniquely identifies the location from which the item should be shipped. | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Value that uniquely identifies the location to which the item should be shipped. | ||
| SHIP_METHOD_ID | NUMBER | 18 | Value that uniquely identifies the method by which the item should be shipped. | ||
| SHIP_FROM_PARTY_ID | NUMBER | 18 | Value that uniquely identifies the party from which the item should be shipped. | ||
| SHIP_TO_PARTY_ID | NUMBER | 18 | Value that uniquely identifies the party to which the item should be shipped. | ||
| PRICING_STRATEGY_ID | NUMBER | 18 | Value that uniquely identifies the pricing strategy. Oracle Pricing automatically assigns this value. | ||
| AGREEMENT_HEADER_ID | NUMBER | 18 | Value that uniquely identifies the sales agreement header. | ||
| AGREEMENT_LINE_ID | NUMBER | 18 | Value that uniquely identifies the sales agreement line. | ||
| AGREEMENT_VERSION_NUMBER | NUMBER | 18 | Value that uniquely identifies the sales agreement version. | ||
| ADDITIONAL_ATTRS | CLOB | Additional attributes applicable to line, provided in JSON format. | |||
| ACTION_TYPE_CODE | VARCHAR2 | 30 | The action type of the line. Used for coverage item charges. | ||
| SERVICE_DURATION | NUMBER | The duration of the subscription. Applies to subscription items. | |||
| SERVICE_DURATION_PERIOD_CODE | VARCHAR2 | 10 | The period used for calculating the service agreement pricing. Values include Month, Year. | ||
| SERVICE_START_DATE | DATE | Date on which the subscription goes into effect. | |||
| SERVICE_DURATION_TYPE_CODE | VARCHAR2 | 30 | Attribute indicating type of duration applicable for a service item. | ||
| ITEM_CATALOG_GROUP_ID | NUMBER | 18 | Provides metadata common to all items that share the category. For example, the item catalog category "Engine" describes attributes, functions and other characteristics common to several item numbers, such as Engine M10000 and Engine M20000. | ||
| STYLE_ITEM_ID | NUMBER | 18 | Attribute referring to the associated Style Item. | ||
| STYLE_ITEM_FLAG | VARCHAR2 | 1 | Indicates a style item. A Style represents a silhouette or model item use to group multiple similar items (SKUs) within. Generally, the items group under a particular style item will be differentiated by 1 or more product variant attributes. Examples include color and size for fashion, flavor and size for grocery, etc. | ||
| SERVICE_END_DATE | DATE | Date on which the subscription ends. | |||
| PRICE_BOOK_REQUEST_ID | NUMBER | 18 | Value that uniquely identifies the price book request. Oracle Pricing automatically assigns this value. | ||
| BATCH_ID | NUMBER | 18 | Value that uniquely identifies the batch. Oracle Pricing automatically assigns this value. | ||
| CHILD_BATCH_ID | NUMBER | 18 | Value that uniquely identifies the child batch. Oracle Pricing automatically assigns this value. | ||
| ESS_CHILD_PROCESS_ID | NUMBER | 9 | Value that uniquely identifies the scheduled process child instance that generated the price book line. Oracle Pricing automatically assigns this value. | ||
| STATUS_CODE | VARCHAR2 | 30 | The status of the price book line. | ||
| SALES_PRODUCT_TYPE | VARCHAR2 | 30 | Attribute indicating classification of an item or product for sales processes. | ||
| 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_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. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| QP_PRICE_BOOK_LINES | qp_pb_messages_b | PRICE_BOOK_ID |
| qp_price_book_charges | qp_price_book_lines | PRICE_BOOK_LINE_ID |
| qp_pb_charge_comps_b | qp_price_book_lines | PRICE_BOOK_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| QP_PRICE_BOOK_LINES_N1 | Non Unique | DEFAULT | PRICE_BOOK_ID |
| QP_PRICE_BOOK_LINES_N2 | Non Unique | DEFAULT | PRICING_STRATEGY_ID |
| QP_PRICE_BOOK_LINES_N3 | Non Unique | DEFAULT | STATUS_CODE |
| QP_PRICE_BOOK_LINES_N4 | Non Unique | DEFAULT | PRICED_ON, PRICE_BOOK_ID |
| QP_PRICE_BOOK_LINES_N5 | Non Unique | DEFAULT | AGREEMENT_HEADER_ID, AGREEMENT_LINE_ID |
| QP_PRICE_BOOK_LINES_N6 | Non Unique | DEFAULT | PRICE_BOOK_REQUEST_ID, BATCH_ID, CHILD_BATCH_ID |
| QP_PRICE_BOOK_LINES_N7 | Non Unique | DEFAULT | LINE_TYPE_CODE, LINE_QUANTITY_UOM_CODE, INVENTORY_ITEM_ID, INVENTORY_ORG_ID |
| QP_PRICE_BOOK_LINES_N8 | Non Unique | DEFAULT | CUSTOMER_ID |
| QP_PRICE_BOOK_LINES_U1 | Unique | DEFAULT | PRICE_BOOK_LINE_ID |