Home > Technical > Table Definitions > POSCREDIT

POSCREDIT

This table stores details about Gift Certificates and Credit Notes which have been issued via DynaPOS. If a number is not recognised at POS, the details will be stored in POSCREDITBAD.

Column

Type

Description

CTRCODE

BIGINT(8)

A unique number assigned by the system. This is the actual Gift Certificate or Credit Note number.

STRTYPE

VARCHAR(10)

GIFT=Gift Certificate
CN=Credit Note

DTMWHEN

DATETIME(8)

The date the record was added to the system.

STRTRADECODE

VARCHAR(10)

The location at which the credit was issued.

TRADUNIT.strTradeCode

CURVALUE

DECIMAL(9)19,4

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

YSNREDEEMED

VARCHAR(1)

Defaults to 'F' to indicate the credit has not yet been redeemed. Once redeemed this will be set to 'T'.

LINTCUSTOMERNUM

INT(4)

The number of the customer which received the credit.

CUSTOMER.lintCustomerNum

LINTOPERATORID

INT(4)

The operator who gave the credit.

USERCODE.intUserCode

LINTDAILYSALESCODE

BIGINT(8)

Link to the DAILYSALES record which generated the credit.

DAILYSALES.ctrCode

CURREDEEMED

DECIMAL(9)19,4

The amount which has been redeemed.

INTORDERCODE

BIGINT(8)

The transaction number which the credit was in.

DAILYSALES.intOrderCode

DTMREDEEMED

DATETIME(8)

The date the credit was redeemed.

STRGIFTNUM

VARCHAR(10)

 

LINTITEMNUMBER

INT(4)

 

LINTLINKCODE

INT(4)

 

DTMEXPIRY

DATETIME(8)

 

LINTREDEEMEDCUSTOMERNUM

INT(4)

 

STRREDEEMEDTRADECODE

VARCHAR(10)

 

LINTREDEEMEDLINKCODE

INT(4)

 

 

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