Home > Technical > Table Definitions > ITEMTERM
Used to record trading term claims for an item. Trading terms for groups of items are stored in SUPPTERM.
Column |
Type |
Description |
||||||
LINTITEMNUMBER |
INT |
The number of the item, this trading term applies to. |
||||||
STRTRADEUNIT |
VARCHAR(10) |
The trading unit this trading term is applicable to. If empty
then applicable to all trading units. |
||||||
STRSUPPLIERCODE |
VARCHAR(10) |
The code of the supplier, this trading term applies to for the
item. |
||||||
CTRCODE |
INT |
A unique number assigned by the system. |
||||||
DTMSTART |
DATETIME |
If entered, the term will only apply to purchases on and after this date. |
||||||
DTMEND |
DATETIME |
If entered, the term will only apply to purchases on and before this date. |
||||||
VARCHAR(20) |
Associates a type of rebate with this trading term. |
|||||||
DECIMAL(19,4) |
This is used in conjunction with strRebateType to work out the deal value. It is simply a number which when used with strRebateType enables the system to calculate the value. A 15% ex- tax deal would have this value set to 15. |
|||||||
VARCHAR(10) |
This is used in conjunction with dblRebateRate to work out the deal value. It allows deals to be expressed in terms of dollar or percentage, ex tax or inc tax. Its values are '% Ex', '$ Ex', '% Inc' or '$ Inc'. A 15% ex- tax deal would have this value set to '% Ex'. If strIncomeType is 'Claim', then '% Ex' and '$ Ex' should not be used. |
|||||||
VARCHAR(15) |
Indicates if we simply deduct trading term revenue from invoice or whether we claim it. Off Invoice/Claim |
|||||||
STRTYPE |
VARCHAR(10) |
Indicates the type of trading term.
|
||||||
YSNPAIDBYSUPPLIER | VARCHAR(1) | 'T' if this rebate will be paid by the supplier directly, 'F' if rebate to be paid by head office. | ||||||
STRCURRENCYCODE | VARCHAR(5) | The currency code used for this
term.![]() |
||||||
INTLEVEL | INT | Used for 'Deal' costs. Indicates the level of the deal. All deals of a certain level will be calculated together then added to the ex-tax cost. The next level of deals will then be calculated on this new subtotal. |
Primary Key: LINTITEMNUMBER + CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |