DOO_ORDER_CHARGES
Stores the header information about the price waterfall for an order line.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
DOO_ORDER_CHARGES_PK |
ORDER_CHARGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| ORDER_CHARGE_ID | NUMBER | 18 | Yes | Unique Identifier of DOO_ORDER_CHARGES table | ||
| FULFILL_LINE_ID | NUMBER | 18 | Foreign Key to DOO_FULFILL_LINES_ALL table | Obsolete | ||
| 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_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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CHARGE_DEFINITION_CODE | VARCHAR2 | 30 | Yes | A charge definition is a combination of Price Type, Charge Type, Charge Sub Type. Combination of these three attributes is represented as a single code | ||
| CHARGE_TYPE_CODE | VARCHAR2 | 30 | Yes | Type of a given charge. Charge Types could include Goods Sale, Service Sale, Financing vs. Lease, Shipping-related Charges, Restocking Penalties, Special Charges) | ||
| CHARGE_SUBTYPE_CODE | VARCHAR2 | 30 | Yes | Subtype of a given charge type. Examples could include, within Shipping Related Charges: Freight Charge, Shipping Insurance, within Special Charges: Suspend Charge, Resumption Charge) | ||
| CAN_ADJUST_FLAG | VARCHAR2 | 1 | Yes | Defines if the Charge is eligible for Adjustment | ||
| PRICE_TYPE_CODE | VARCHAR2 | 30 | Yes | Price type of a given charge. One-time, Recurring, Usage,Recurring usage. | ||
| CHARGE_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Indicates the currency used for the charge | ||
| GSA_UNIT_PRICE | NUMBER | Unit price amount derived from a matching GSA price list on the strategy for the current transaction | ||||
| PARENT_ENTITY_CODE | VARCHAR2 | 30 | Yes | Parent entity to which charge is applied. Values include Line and Line Coverage | ||
| PARENT_ENTITY_ID | NUMBER | 18 | Yes | Id of the parent entity of the charge | ||
| PRICED_QUANTITY | NUMBER | PricedQuantity = Line.RequestedQuantity for simple product | ||||
| PRICED_QUANTITY_UOM_CODE | VARCHAR2 | 3 | UOM code for priced quantity, for example 'Ton'. Values for this attribute will come either from PIM or the reciprocal service FOM provides | |||
| PRIMARY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this charge is the primary charge | ||
| SEQUENCE_NUMBER | NUMBER | 9 | Yes | Indicates the sequence number for the charge | ||
| CHARGE_APPLIES_TO | VARCHAR2 | 30 | Yes | Indicates whether a charge is applied to Product, Shipping or Return | ||
| ROLLUP_FLAG | VARCHAR2 | 1 | Yes | Marks a charge as a rollup/aggregate charge | ||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 30 | Indicates periodicity for both recurring and recurring usage price types. Viz Month, Year, Quarter | |||
| SOURCE_CHARGE_ID | VARCHAR2 | 120 | The unique internal identifier for the charge as assigned by the system that captured the transaction | |||
| REFERENCE_ORDER_CHARGE_ID | NUMBER | 18 | Used by change mgmt to associate the change order's charge id with the original order's charge id. | |||
| DELTA_TYPE | NUMBER | 18 | Internal column used by change processing framework for tracking type of change like update, cancel..etc | |||
| 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. | ||
| MODIFIED_FLAG | VARCHAR2 | 1 | Indicates that the row has been modified in the version currently submitted | |||
| AVG_UNIT_SELLING_PRICE | NUMBER | It reflects the weighted average selling price which is total sales revenue divided by total units sold. | ||||
| TIER_BASIS_TYPE_CODE | VARCHAR2 | 30 | Abbreviation that identifies the type of tier basis as quantity or amount. The ORA_QP_TIER_BASIS_TYPES lookup type contains the values that you can use for this attribute. | |||
| TIER_AGGREGATION_METHOD | VARCHAR2 | 30 | Abbreviation that identifies the aggregation method for the tier whether at line or order level. The ORA_QP_AGGREGATION_METHODS lookup type contains the values that you can use for this attribute. | |||
| TIER_APPLIES_TO | VARCHAR2 | 30 | Abbreviation that identifies the applicability whether all tiers or highest tier. The ORA_QP_TIER_GRADUATED_TYPES lookup type contains the values that you can use for this attribute. | |||
| USAGE_PRICE_LOCK_FLAG | VARCHAR2 | 1 | Indicates whether the usage pricing is used or not. | |||
| TIERED_FLAG | VARCHAR2 | 1 | Indicates whether the charge has a tier defined or not. | |||
| BLOCK_ALLOWANCE | NUMBER | Block Allowance for non tiered consumption charge. | ||||
| BLOCK_SIZE | NUMBER | Size of the block to use when calculating the charge for a tier. | ||||
| USAGE_UOM_CODE | VARCHAR2 | 3 | UOM Code for the usage price of the product. | |||
| CHARGE_PERIOD_CODE | VARCHAR2 | 3 | Abbreviation that identifies the charge period for the usage charge. The charge period determines how frequently Pricing and Subscription Management add up the usages for a usage charge. Use a time unit of measure when you set the value for CHARGE_PERIOD_CODE. Pricing uses the UOM Class that you set in the RCS_DEFAULT_UOM_SERVICE_DURATION_CLASS profile option to validate the charge period that you set. | |||
| PERIODIC_BILLING_FLAG | VARCHAR2 | 1 | Periodic billing for a subscription. This attribute applies only to one-time charges. | |||
| PERIODIC_REV_RECOGNITION_FLAG | VARCHAR2 | 1 | Periodic revenue recognition for a subscription. This attribute applies only to one-time charges. | |||
| PROMOTION_ITEM_TERM_ID | NUMBER | 18 | This denotes the promotion term that resulted in the promotion item benefit. This attribute is applicable only for the line containing the promotion item. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| doo_order_charge_tiers | doo_order_charges | ORDER_CHARGE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| DOO_ORDER_CHARGES_N1 | Non Unique | Default | REFERENCE_ORDER_CHARGE_ID | |
| DOO_ORDER_CHARGES_N2 | Non Unique | Default | PARENT_ENTITY_ID, PARENT_ENTITY_CODE | |
| DOO_ORDER_CHARGES_PK | Unique | Default | ORDER_CHARGE_ID | |
| DOO_ORDER_CHARGES_U1 | Unique | Default | PARENT_ENTITY_CODE, PARENT_ENTITY_ID, PRICE_TYPE_CODE, CHARGE_TYPE_CODE, CHARGE_SUBTYPE_CODE, ROLLUP_FLAG | Obsolete |
| DOO_ORDER_CHARGES_U2 | Unique | Default | PARENT_ENTITY_CODE, PARENT_ENTITY_ID, CHARGE_DEFINITION_CODE, ROLLUP_FLAG | Obsolete |
| DOO_ORDER_CHARGES_U3 | Unique | Default | PARENT_ENTITY_CODE, PARENT_ENTITY_ID, SEQUENCE_NUMBER | Obsolete |