Home > Technical > Table Definitions > POSCREDITENTRY
A POSCREDIT is a gift certificate or credit note. This table keeps details about bulk created gift certs/credit notes or gift certs/credit notes which have been marked as lost or stolen.
|CTRCODE||INT||Unique number assigned by the system.|
where the record was created.
|STRTYPE||VARCHAR(10)||The type of
POSCREDIT being adjusted.
for creating this record.
|STRPOSCREDITFROM||VARCHAR(10)||The first number in the range of gift cert/credit notes.|
|STRPOSCREDITTO||VARCHAR(10)||The last number in the range of the gift cert/credit notes.|
|DTMWHEN||DATETIME||The date the record was created.|
|STRWHO||VARCHAR(20)||The user who created the record.|
|MEMCOMMENT||TEXT||A comment about why this record was created.|
record was being used to bulk create gift cert/credit notes, this
is the number of the item that was created.
|CURVALUE||DECIMAL(19,4)||If the record was being used to bulk create gift cert/credit notes, this is the value of the gift cert/ credit note.|
|DTMEXPIRY||DATETIME||If the record was being used to bulk create gift cert/credit notes, this is the expiry date of the gift cert/ credit note.|
Primary Key: CTRCODE
|Converted from CHM to HTML with chm2web Pro 2.85 (unicode)|