Home > Technical > Table Definitions > POSCREDITBAD

POSCREDITBAD

When a Gift Certicate or Credit Notes is sold, the details are stored in POSCREDIT. When it is redeemed, the POSCREDIT table is updated. However, if the number of the Gift Certificate was not found (generally because it was redeemed at a different store), the details are stored in POSCREDITBAD.

Column

Type

Description

CTRCODE

BIGINT(8)

A unique number assigned by the system. Unlike POSCREDIT, this is NOT the actual Gift Certificate or Credit Note number. It is just an identifying number. This is stored in intCreditNum.

STRTYPE

VARCHAR(10)

GIFT=Gift Certificate
CN=Credit Note

STRTRADECODE

VARCHAR(10)

The location at which the credit was issued.

TRADUNIT.strTradeCode

DTMWHEN

DATETIME(8)

The date the record was added to the system.

INTCREDITNUM

VARCHAR(10)

The Gift Certificate or Credit Note number.

CURVALUE

DECIMAL(9)19,4

The value of the credit. Stored as a positive number.

LINTDAILYSALESCODE

BIGINT(8)

Link to the DAILYSALES record which generated the credit.

DAILYSALES.ctrCode

INTORDERCODE

BIGINT(8)

The transaction number which the credit was in.

DAILYSALES.intOrderCode

LINTREDEEMEDCUSTOMERNUM

INT(4)

 

STRREDEEMEDTRADECODE

VARCHAR(10)

 

LINTREDEEMEDLINKCODE

INT(4)

 

 

Primary Key: CTRCODE + STRTYPE + STRTRADECODE

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