Home > Technical > Table Definitions > CUSTPRICEITEMSELL

CUSTPRICEITEMSELL

Records the special sell prices that apply to a customer. The item to which this sell price belongs is stored in CUSTPRICEITEM.

Column

Type

Description

STRMAINGUID

VARCHAR(36)

The CUSTPRICEITEM to which this record belongs.
CUSTPRICEITEM.strGuid

STRGUID

VARCHAR(36)

A unique code assigned by the system.

DTMEFFECTIVE

DATETIME

The effective date of the sell price.

DTMEXPIRY

DATETIME

The expiry date of the sell price.

STREXPECTEDSELLTAX

VARCHAR(10)

Expected tax code for the item.

CUREXPECTEDUNITCOST

DECIMAL(19,4)

Expected unit cost for the item.

CURSELL

DECIMAL(19,4)

The sell price of the item.

DBLMARGIN

DECIMAL(19,4)

The margin % based on the sell price and the unit cost.

CURGP

DECIMAL(19,4)

The profit based on the sell price and the unit cost.

 

Primary Key: STRMAINGUID + STRGUID

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