Home > Technical > Table Definitions > ITEMTERM

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.
link.gif (858 bytes) ITEM.lintItemNumber

STRTRADEUNIT

VARCHAR(10)

The trading unit this trading term is applicable to. If empty then applicable to all trading units.
link.gif (858 bytes) TRADUNIT.strTradeCode 

STRSUPPLIERCODE

VARCHAR(10)

The code of the supplier, this trading term applies to for the item.
link.gif (858 bytes) SUPPLIER.strSupplierCode

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.

STRREBATECODE

VARCHAR(20)

Associates a type of rebate with this trading term.
link.gif (858 bytes) REBATETYPE.strRebateCode

DBLREBATERATE

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.

STRREBATETYPE

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.

STRINCOMETYPE

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.

Discount  

Can be claimed. Is included in cost analysis costs. Claimed rebates sent to accounts module.

Target  

Can be viewed in cost analysis. No other used.

Service  

Can be claimed. Does not get included in cost analysis costs. Claimed rebates NOT sent to accounts

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.
link.gif (858 bytes)
CURRENCYCODE.strCurrencyCode
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.

link.gif (858 bytes) DEALLEVEL.intLevel

 

Primary Key: LINTITEMNUMBER + CTRCODE

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