Home > Technical > Table Definitions > SUPPTERM

SUPPTERM

Used to record supplier trading term conditions. These terms will apply to a group of items. Terms specific to an item are stored in ITEMTERM. The trading terms are set for groups of products by specifying the required department, category, group and classification. Items in this group which don't get the trading term can be marked as exceptions in SUPPTERMEXCEPTION.

Column Type Description
STRSUPPLIERCODE VARCHAR(10) The code of the supplier, this trading term applies to.
SUPPLIER.strSupplierCode
STRINCOMETYPE VARCHAR(15) Indicates if we simply deduct trading term revenue from invoice or whether we claim it. Off Invoice/Claim
STRTRADEUNIT VARCHAR(10) The trading unit this trading term is applicable to. If empty then applicable to all trading units.
TRADUNIT.strTradeCode 
STRDEPTCODE VARCHAR(10) The department this trading term is applicable to. This is not required if the terms apply to all departments.
DEPT.strDeptCode
STRCATCODE VARCHAR(10) The category this trading term is applicable to. This is not required if the terms apply to all categories within the department.
CATEGORY.strCatCode
STRGROUPCODE VARCHAR(10) The group this trading term is applicable to. This is not required if the terms apply to all groups within the category.
GROUPS.strGroupCode
STRCLASSCODE VARCHAR(10) The classification this trading term is applicable to. This is not required if the terms apply to all classifications.
CLASS.strClassCode
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.
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'.
CURTARGETAMOUNT DECIMAL(19,4) Not currently used.
STRSUBGROUPCODE VARCHAR(10) The subgroup this trading term is applicable to. This is not required if the terms apply to all groups within the group.
SUBGROUP.strSubGroupCode
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 module.

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 this supplier uses for their terms.
CURRENCYCODE.strCurrencyCode

INTLEVEL

INT

Used for 'Off Invoice' terms. 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.

DEALLEVEL.intLevel

 

Primary Key: STRSUPPLIERCODE + CTRCODE

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