SA Expdw Rdwt Detail

This is a sequence base ID to uniquely identify a record on the table.

It indicates the RDWT header record this detail is part of.

This holds the process ID that inserts the record. It ties all records inserted in the same run together.

This holds the sysdate when the record is written.

Type of discount, for example an RMS promo, a coupon, etc. Valid values are associated with code type SADT.

Code for promotional type from code_detail under code_type PRMT.

This contains the promotion number from Merchandising.

This contains the offer ID value from RPM.

Coupon number for a store coupon. It is defined when discount type is SCOUP (store coupon).

Holds any additional reference numbers associated with a coupon. Examples of these reference numbers might be advertising source codes, publication codes, etc.

Number of units sold in this prom type.

Value of units sold in this promotion type.

Value of discount given in this prom type.

Generic reference number for storing information at tran discount level.

Generic reference number for storing information at tran discount level.

Generic reference number for storing information at tran discount level.

Generic reference number for storing information at tran discount level.

This column holds the user ID of the user who created the record.

Date of creation. Oracle Retail target column CREATE_DATETIME on SA_EXPDW_RDWT_DETAIL.

This column holds the user ID of the user who modified the record.

Date of modification. Oracle Retail target column LAST_UPDATE_DATETIME on SA_EXPDW_RDWT_DETAIL.