Home > Technical > Table Definitions > CUSTPRICEITEM

CUSTPRICEITEM

Records the fact that a customer is allowed a special price on this item. The actual sell price is stored in CUSTPRICEITEMSELL.

Column

Type

Description

STRGUID

VARCHAR(36)

A unique code assigned by the system.

LINTCUSTOMERNUM

INT

The number of the customer that will receive the special price.
CUSTOMER.lintCustomerNum

LINTITEMNUMBER

INT

The item number being ordered.
ITEM.lintItemNumber

 

Primary Key: STRGUID

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