1. Tables and Views for SCM
  2. DOO_ORDER_INCENTIVES

DOO_ORDER_INCENTIVES

Table stores sales incentive information on Order Header or Line. A sales incentive encourages a specific buying behavior by either offering a special pricing, rebates, on invoice or off invoice discounts, accruals by either an contractual agreement or by marketing offers or by sales channel programs. Sales Incentives can be of various types like Channel Programs, Marketing Promotion or Sales Agreement. For example, 10% rebate accrued on product X sourced from supplier S. 10% discount on product Y this month if ordered quantity crosses 15000 units for the month. 10% Contractual Discount for all category A products this quarter.

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

DOO_ORDER_INCENTIVES_PK

INCENTIVE_ID

Columns

Name Datatype Length Precision Not-null Comments
INCENTIVE_ID NUMBER 18 Yes Unique identifier of DOO_ORDER_INCENTIVES_TABLE
SOURCE_INCENTIVE_ID VARCHAR2 50 Yes Reference to the unique identifier for the source identifier id
HEADER_ID NUMBER 18 Yes Reference to Unique Identifier of the Order
FULFILL_LINE_ID NUMBER 18 Reference to Unique Identifier of the Fulfill Line
INCENTIVE_ENTITY_TYPE_CODE VARCHAR2 30 Yes Refers to the type of incentive. Values - ORA_CHANNEL_PROGRAM, ORA_MARKETING_PROMOTION
INCENTIVE_ENTITY_SUBTYPE_CODE VARCHAR2 30 Yes Refers to the type of incentive subtype. Values stored - ORA_ON_INVOICE, ORA_OFF_INVOICE, ORA_ACCRUAL
INCENTIVE_ENTITY_KEY_1 VARCHAR2 50 Yes First identifier of the incentive that is applied to Header or Line. Stores program header information.
INCENTIVE_ENTITY_KEY_2 VARCHAR2 50 Second identifier of the incentive that is applied to Header or Line. Stores program line information.
INCENTIVE_ENTITY_KEY_3 VARCHAR2 50 Third identifier of the incentive that is applied to Header or Line. Stores program subline information
INCENTIVE_ENTITY_KEY_4 VARCHAR2 50 Fourth identifier of the incentive that is applied to Header or Line. Stores program version.
INCENTIVE_ENTITY_KEY_5 VARCHAR2 50 Fifth identifier of the incentive that is applied to Header or Line. Stores any other additional information.
DECLINABLE_FLAG VARCHAR2 1 Yes Indicates if an incentive can be declined by a user
MANUALLY_APPLIED_FLAG VARCHAR2 1 Yes Indicates if an incentive is applied by user or system
STATUS_CODE VARCHAR2 30 Yes Indicates the status of incentive
INELIGIBILITY_REASON VARCHAR2 1000 Message explaining why incentive is not eligible
DECLINE_REASON_CODE VARCHAR2 30 Code describing the reason behind declining an incentive
COMMENTS VARCHAR2 2000 Comments for incentive
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.
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.
REFERENCE_INCENTIVE_ID NUMBER 18 Used by change mgmt to associate the change order's incentive id with the original order's incentive id.

Foreign Keys

Table Foreign Table Foreign Key Column
DOO_ORDER_INCENTIVES doo_headers_all HEADER_ID
DOO_ORDER_INCENTIVES doo_fulfill_lines_all FULFILL_LINE_ID

Indexes

Index Uniqueness Tablespace Columns
DOO_ORDER_INCENTIVES_N1 Non Unique Default HEADER_ID, FULFILL_LINE_ID, INCENTIVE_ENTITY_TYPE_CODE, INCENTIVE_ENTITY_SUBTYPE_CODE, INCENTIVE_ENTITY_KEY_1
DOO_ORDER_INCENTIVES_PK Unique Default INCENTIVE_ID