Home > Technical > Table Definitions > ITEMGIFTDTL

ITEMGIFTDTL

Used to determine if items in the transaction meet the criteria for the gift certificate and what actions to take when redeeming.

Column

Type

Description

LINTITEMNUMBER

 

Item Gift Certificate Number

CTRCODE

 

Unique sequential number

STRDEPTCODE

 

Department Code

STRCATCODE

 

Category code

STRGROUPCODE

 

Group code

STRSUBGROUPCODE

 

Subgroup Code

STRCLASSCODE

 

Classification Code

STRFAMILYCODE

 

Family Code

LINTREDEEMITEMNUMBER

 

Redeemable Item number

 

Primary Key: LINTITEMNUMBER

Note: When the Item Gift tables are extracted to POS, only items ranged to the location will be included in the file.

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