Home > Technical > Table Definitions > SUPPTERMEXCEPTION

SUPPTERMEXCEPTION

This table stores details about items which are excluded from general trading terms for groups of items set up in SUPPTERM.

Column

Type

Description

STRSUPPLIERCODE

VARCHAR(10)

The code of the supplier, this exception belongs to
SUPPLIER.strSupplierCode

INTSUPPTERMCODE

INT

Link to the specific trading term this exception is for.
SUPPTERM.ctrCode 

LINTITEMNUMBER

INT

The number of the item that is to be excluded.
ITEM.lintItemNumber

 

Primary Key: STRSUPPLIERCODE + INTSUPPTERMCODE + LINTITEMNUMBER

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