Home > Technical > Table Definitions > 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. |
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) |