Home > Technical > Table Definitions > ITEMINACTIVE

ITEMINACTIVE

This table records the areas where an item is considered inactive. This used to be determined by the ysnActive flag in ITEM. However, if Merchant is being used across states, it is possible that one state would required the item active while another would see it as inactive. A record exists for each management area where the item is inactive.

Column

Type

Description

LINTITEMNUMBER

INT(4)

The item that is considered inactive.

ITEM.lintItemNumber

STRMANAGEMENTAREA

VARCHAR(10)

The management area where the item is considered inactive.

MANAGEMENTAREA.strAreaCode

 

Primary Key: LINTITEMNUMBER + STRMANAGEMENTAREA

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