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) |
