MOP_IMP_PROMO_COUPONS

This is the interface table for migrating coupons for promotions from an external data source into fusion. The WHO columns in this table, just reflects when the data was loaded into the interface table or when it was processed. These columns are for information purpose only and will not be used during actual import into Fusion.

Details

• Schema: FUSION

• Object owner: MOP

• Object type: TABLE

• Tablespace: INTERFACE

Primary Key

Name	Columns
MOP_IMP_PROMO_COUPONS_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
BATCH_ID	NUMBER		18	Yes	Primary Key. batch Identifier. Identifier that groups data into a batch.	Active
INTERFACE_ROW_ID	NUMBER		18	Yes	Primary Key. Interface Row Id. Will be used to link this row with rows in the error table.	Active
IMPORT_STATUS_CODE	VARCHAR2	30			Indicates the status of the row to be processed.	Active
ACTION_CODE	VARCHAR2	30			Indicates the operation to be performed on a row such as Insert, Update etc.	Active
INTERNAL_ACTION_CODE	VARCHAR2	30			For Internal Use. Used to evaluate the operation to be performed on a row such as Insert, Update etc.
PROMO_COUPON_CODE	VARCHAR2	100			Promotion Coupon Code. It will be unique across promotions.	Active
PROMOTION_NUM	VARCHAR2	100			Promotion Number.	Active
PROMO_COUPON_ID	NUMBER		18		Used for internal processing. Promotion Coupon Identifier.	Active
PROMOTION_ID	NUMBER		18		Used for internal processing. Promotion Identifier.	Active
FILE_RECORD_NUM	NUMBER				Used by the file import wizard to relate a row in the interface table to the data file that was uploaded.
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.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MOP_IMP_PROMO_COUPONS_N1	Non Unique	FUSION_TS_INTERFACE	BATCH_ID, PROMO_COUPON_CODE	Active
MOP_IMP_PROMO_COUPONS_N2	Non Unique	FUSION_TS_INTERFACE	BATCH_ID, PROMOTION_NUM	Active
MOP_IMP_PROMO_COUPONS_N3	Non Unique	Default	BATCH_ID, INTERNAL_ACTION_CODE, IMPORT_STATUS_CODE
MOP_IMP_PROMO_COUPONS_N4	Non Unique	Default	BATCH_ID, ACTION_CODE, IMPORT_STATUS_CODE
MOP_IMP_PROMO_COUPONS_PK	Unique	FUSION_TS_INTERFACE	BATCH_ID, INTERFACE_ROW_ID	Active