Home > Technical > Table Definitions > ITEMTAX

ITEMTAX

This table has been superceded by ITEMTAXGROUP.

This table 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.
link.gif (858 bytes) TAXSYSTEM.strTaxSystemCode

STRPURCHASETAXCODE

VARCHAR(10)

The tax code used when an item is purchased.
link.gif (858 bytes) TAX.strTaxCode

STRSALESTAXCODE

VARCHAR(10)

The tax code used when an item is sold.
link.gif (858 bytes) TAX.strTaxCode

STRWETTAXCODE

VARCHAR(10)

If the item is subject to the Wine Equalisation Tax (Australia only), this is the tax code that should be used.
link.gif (858 bytes) TAX.strTaxCode

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.

STRTAKEAWAYTAXCODE

VARCHAR(10)

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

link.gif (858 bytes) TAX.strTaxCode

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)