SA Tran Disc Rev

Store number to be used for table partitioning.

Day number to be used for table partitioning. This is derived from the sa_store_day.business_date column by calling the function SA_DATE_HASH.

The sales audit systems transaction identifier. Foreign key for SA_TRAN_HEAD.

Sequence number of items within a transaction.

Sequence number of discounts for an item within a transaction.

Type of discount given to the customer for these item(s). Valid values stored on the codes table.

This field contains the number of the promotion which defines the discount.

Type of discount, for example an RMS promo, a coupon, etc.

Coupon number for a store coupon.

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

This is an incremental counter unique to each version of a transaction stored on the database.

The number of these items purchased at this discount price.

Discount per unit of the item. Held in the local currency.

Contains the units of this item discounted as if the item were discounted in the standard unit of measure.

Contains the unit discount amount of the item as if the item were discounted in the standard unit of measure.

This field contains any additional information about the discount that the retailer chooses to store.

This field contains any additional information about the discount that the retailer chooses to store.

This field contains any additional information about the discount that the retailer chooses to store.

This field contains any additional information about the discount that the retailer chooses to store.

This column is used to determine if functional errors exist for this record.

Contains the weight of an item sold. If the tiem doesnt have a weight the this field will contain the quantity sold.

Indicates that the value in UOM_QUANTITY is a catchweight.

Contains the offer ID value from RPM.