DOO_ORDER_CHARGE_COMPS_INT
This interface table contains pricing charge components for an order. It is used when importing an order.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SOURCE_TRANSACTION_ID | VARCHAR2 | 50 | Unique identifier of the transaction in the system that captured the transaction. | ||
| SOURCE_MPA_ID | VARCHAR2 | 50 | The unique internal identifier for the Manual Price Adjustment as assigned by the system that captured the transaction. | ||
| SOURCE_TRANSACTION_SYSTEM | VARCHAR2 | 30 | System or application that submitted the order request. | ||
| SOURCE_TRANSACTION_LINE_ID | VARCHAR2 | 50 | Unique identifier of the transaction line from the system that captured the transaction. | ||
| SOURCE_TRANSACTION_SCHEDULE_ID | VARCHAR2 | 50 | Unique identifier of a schedule, shipment, or subline, as assigned by the system that captured the transaction. | ||
| SOURCE_CHARGE_ID | VARCHAR2 | 120 | Unique internal identifier of the charge as assigned by the system that captured the transaction. | ||
| SOURCE_CHARGE_COMPONENT_ID | VARCHAR2 | 50 | Unique identifier of the charge component as assigned by the system that captured the transaction. | ||
| SEQUENCE_NUMBER | NUMBER | 9 | Sequence number of the charge component. | ||
| SOURCE_PARENT_CHARGE_COMP_ID | VARCHAR2 | 50 | Unique identifier of the charge component as assigned by the system that captured the transaction. Only populated for charge components where the parent charge is a rollup charge. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 1000 | Code of the currency that was used for the charge. | ||
| CHARGE_CURRENCY_NAME | VARCHAR2 | 1000 | Currency that is associated with the charge component. | ||
| CHARGE_CURRENCY_EXT_AMOUNT | NUMBER | Extended amount in charge currency. Extended amount equals the unit price multiplied by the line requested quantity for simple products and equals the unit price multiplied by the line extended quantity for configurations. | |||
| CHARGE_CURRENCY_UNIT_PRICE | NUMBER | Price or adjustment per unit in the charge currency for the line unit of measure. | |||
| HEADER_CURRENCY_CODE | VARCHAR2 | 1000 | Code of the order header currency. | ||
| HEADER_CURRENCY_NAME | VARCHAR2 | 1000 | Currency on the order header associated with the transaction. | ||
| HEADER_CURRENCY_EXT_AMOUNT | NUMBER | Extended amount in the header currency. | |||
| HEADER_CURRENCY_UNIT_PRICE | NUMBER | Price or adjustment for a unit in the header currency for the line unit of measure. | |||
| PRICE_ELEMENT_CODE | VARCHAR2 | 30 | Code of the elements used in the price elements setup, for example, LISTPRICE and NETPRICE. | ||
| PRICE_ELEMENT | VARCHAR2 | 240 | Factor that is used for pricing calculations. Examples: list price and net price. | ||
| PRICE_ELEMENT_USAGE_CODE | VARCHAR2 | 30 | Used by consuming applications to indicate how the charge component will be used. Values of this attribute come from an Oracle Fusion Pricing lookup. By default, the values include List Price and Net Price. | ||
| PRICE_ELEMENT_USAGE | VARCHAR2 | 240 | Category of one or more price elements. | ||
| ROLLUP_FLAG | VARCHAR2 | 1 | Marks a charge component as a rollup or aggregate value for the charge component price element code. | ||
| TRANSACTIONAL_CURRENCY_CODE | VARCHAR2 | 1000 | Currency code used for the order. | ||
| EXPLANATION | VARCHAR2 | 1000 | Message for display in a price breakdown user interface. | ||
| CHARGE_CURR_DURATION_EXT_AMT | NUMBER | Identifies extended amount over the given duration in the charge currency. | |||
| HEADER_CURR_DURATION_EXT_AMT | NUMBER | Identifies extended amount over the given duration in the header currency. | |||
| 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. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Unique identifier of the import request. | ||
| BATCH_ID | NUMBER | 18 | Id of the batch as part of which this charge component will be processed. | ||
| VALIDATION_BITSET | NUMBER | 20 | Oracle internal use only. This is used to identify attributes that failed validation. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_ORDER_CHARGE_COMPS_INT_N1 | Non Unique | Default | SOURCE_TRANSACTION_ID, SOURCE_TRANSACTION_SYSTEM, LOAD_REQUEST_ID, SOURCE_TRANSACTION_LINE_ID, SOURCE_TRANSACTION_SCHEDULE_ID |
| DOO_ORDER_CHARGE_COMPS_INT_N2 | Non Unique | Default | BATCH_ID |