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 |