Home > Technical > Table Definitions > POSCREDITBLOCKED

POSCREDITBLOCKED

This table shows the POSCREDIT records which have been blocked from use, for example lost or stolen gift certificates. When POS validates a POSCredit number, it checks this table. If the number appears in this table, it can't be accepted at POS.

Column Type Description
STRTYPE VARCHAR(10) The type of POSCREDIT.

GIFT=Gift Certificate

CN=Credit Note

STRPOSCREDITNUM VARCHAR(10) The number of the gift certificate or credit note.
INTREASON INT Reason for the blockage. 2= Lost, 3= Stolen
LINTLINKCODE INT A link back to the POSCREDITENTRY which created this record.
POSCREDITENTRY.ctrCode
 

Primary Key: STRTYPE + STRPOSCREDITNUM

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