DOO_FS_CHARGE_COMPONENTS_INT
Charge component details in the fulfillment system response.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
DOO_FS_CHARGE_COMPS_INT_PK |
CHARGE_COMPONENT_IF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHARGE_COMPONENT_IF_ID | NUMBER | 18 | Yes | Unique internal identifier for a charge component interface record, generated by sequence. | |
| FULFILLMENT_SYSTEM_RESPONSE_ID | VARCHAR2 | 50 | Unique identifier that fulfillment system may send and can be used to correlate the response relayed back to the fulfillment system. | ||
| FULFILL_LINE_INTERFACE_KEY | VARCHAR2 | 120 | An identifier that distinguishes a fulfillment line record from another one for a given fulfillment system response identifier. | ||
| CHARGE_INTERFACE_KEY | VARCHAR2 | 50 | Unique internal identifier of the charge as assigned by the system that captured the transaction. | ||
| CHARGE_COMPONENT_IF_KEY | VARCHAR2 | 50 | The unique internal identifier for the charge component as assigned by the system that captured the transaction | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Unique identifier of a data set pertaining to fulfillment system responses to one or more fulfillment system requests. | ||
| 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. | |||
| 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. | |
| CHARGE_CURRENCY_NAME | VARCHAR2 | 1000 | Name of the currency that was used for the charge component. E.g., US Dollar. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 1000 | Code of the currency that was used for the charge component. E.g., USD. | ||
| HEADER_CURRENCY_NAME | VARCHAR2 | 1000 | Name of the header currency. E.g., US Dollar. | ||
| HEADER_CURRENCY_CODE | VARCHAR2 | 1000 | Code of the order header currency. E.g., USD. | ||
| HEADER_CURRENCY_EXT_AMOUNT | NUMBER | Extended amount in the header currency. | |||
| PRICE_ELEMENT | VARCHAR2 | 80 | Meaning of the price element code from the price element setup. | ||
| PRICE_ELEMENT_CODE | VARCHAR2 | 30 | Code of the elements used in the price elements setup, for example, LISTPRICE and NETPRICE. | ||
| SEQUENCE_NUMBER | NUMBER | 9 | Sequence number of the charge component. | ||
| PRICE_ELEMENT_USAGE | VARCHAR2 | 80 | Meaning of the price element usage code which indicates how the charge component will be used. | ||
| 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. | ||
| CHARGE_CURRENCY_UNIT_PRICE | NUMBER | Price or adjustment per unit in the charge currency for the line unit of measure. | |||
| HEADER_CURRENCY_UNIT_PRICE | NUMBER | Price or adjustment for a unit in the header currency for the line unit of measure. | |||
| ROLLUP_FLAG | VARCHAR2 | 1 | Marks a charge component as a rollup or aggregate value for the charge component price element code. | ||
| PARENT_CHARGE_COMPONENT_IF_KEY | VARCHAR2 | 50 | Charge Component Id of the contributing charge as assigned by the system that captured the transaction. Only populated for charge components where the parent charge is a rollup charge | ||
| 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. | |||
| EXPLANATION | VARCHAR2 | 1000 | Message for display in a price breakdown user interface. | ||
| PERCENT_OF_COMPARISON_ELEMENT | NUMBER | The percentage that this unit price is of the basis charge component unit price. By default the basis is the List Price. This attribute captures the Margin %, the % the Net Price is of the List Price etc. | |||
| PRICING_SOURCE_ID | VARCHAR2 | 30 | Id of the lowest level pricing source. E.g. priceListLineId, Tier Rule Id, CP Rule Id, Formula Id, AP Id, shipping line id, etc. | ||
| EXPLANATION_MESSAGE_NAME | VARCHAR2 | 30 | Message name of the explanation for the price break down UI. | ||
| TAX_INCLUDED_FLAG | VARCHAR2 | 1 | Indicates whether tax is included in the price for a given charge component. | ||
| INTERFACE_SOURCE_CODE | VARCHAR2 | 30 | Identifies the source used to insert data in this interface table. For example, ORA_FS_RESPONSE_FBDI and ORA_FS_RESPONSE_API for data imported using file and API respectively. | ||
| FULFILL_LINE_ID | NUMBER | 18 | Unique Identifier for a fulfillment line |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| DOO_FS_CHARGE_COMPS_INT_PK | Unique | Default | CHARGE_COMPONENT_IF_ID | |
| DOO_FS_CHRG_COMP_INT_N1 | Non Unique | Default | INTERFACE_SOURCE_CODE, LOAD_REQUEST_ID, FULFILL_LINE_INTERFACE_KEY, CHARGE_INTERFACE_KEY, CHARGE_COMPONENT_IF_KEY | Obsolete |
| DOO_FS_CHRG_COMP_INT_N2 | Non Unique | Default | FULFILL_LINE_ID, FULFILL_LINE_INTERFACE_KEY |