Home > Technical > Table Definitions > REWARDAUDIT

REWARDAUDIT

This table is used to record rewards which have been given to customers.

Column Type Description

CTRCODE

INT(4)

A unique number assigned by the system.

STRSTORECODE

VARCHAR(10)

The location that the transaction was made in.

link.gif (858 bytes) TRADUNIT.strTradeCode

DTMREWARDED

DATETIME(8)

The trading date the reward was given.

LINTCUSTOMERNUM

INT(4)

The customer the reward was given to.

link.gif (858 bytes) CUSTOMER.lintCustomerNum

LINTREWARDCODE

INT(4)

The code which identifies the transaction this record came from.

link.gif (858 bytes) REWARD.lintCode

DTMREWARDEDDATETIME

DATETIME(8)

The actual date/time the reward was given.

LINTPOINTS

INT(4)

The number of points given as a reward (if any).

 

Primary Key: CTRCODE + STRSTORECODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)