Home > Technical > Table Definitions > ITEMTAXGROUP

ITEMTAXGROUP

This table supercedes the ITEMTAX table and contains details about the taxes required for each item. The system can support multiple tax systems and so there needs to be multiple records for each item.

Column

Type

Description

LINTITEMNUMBER

INT

The item that this tax record belongs to.

ITEM.lintItemNumber

STRTAXSYSTEMCODE

VARCHAR(10)

The tax system for which these tax details will be used.
TAXSYSTEM.strTaxSystemCode

STRPURCHASEGROUPCODE

VARCHAR(10)

The tax group code used when an item is purchased.
TAX.strTaxCode

STRSALESGROUPCODE

VARCHAR(10)

The tax group code used when an item is sold.

STRWETGROUPCODE

VARCHAR(10)

If the item is subject to the Wine Equalisation Tax (Australia only), this is the tax group code that should be used.

STRTAKEAWAYGROUPCODE

VARCHAR(10)

The tax group code used when the item is sold as a takeaway item.

YSNCHARGESERVICE

VARCHAR(1)

'T' if a service fee can be charged on this item.

YSNCHARGECESS

VARCHAR(1)

'T' if a CESS fee can be charged on this item.

YSNTAKECHARGESERVICE

VARCHAR(1)

'T' if a service fee can be charged on this item when sold as takeaway.

YSNTAKECHARGECESS

VARCHAR(1)

'T' if a CESS can be charged on this item when sold as takeaway.

 

Primary Key: LINTITEMNUMBER + STRTAXSYSTEMCODE

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