Home > Technical > Table Definitions > TAXSYSTEM

TAXSYSTEM

Records details about each tax system used in the system.

Column

Type

Description

STRTAXSYSTEMCODE

VARCHAR(10)

Unique code assigned by the user

STRTAXSYSTEMDESC

VARCHAR(50)

Name of the tax system

STRDEFAULTTAXCODE1

VARCHAR(10)

The default tax code for the tax system. If using a GST/VAT type of tax system then this will be the purchase tax code.
TAX.strTaxCode

STRDEFAULTTAXCODE2

VARCHAR(10)

The default tax code for the tax system. If using a GST/VAT type of tax system then this will be the sales tax code.
TAX.strTaxCode

STRDEFAULTTAXCODE3

VARCHAR(10)

The default tax code for the tax system. If using a GST/VAT type of tax system then this will be the WET tax code.
TAX.strTaxCode

STRCESSTAXCODE

VARCHAR(10)

The tax code that represents CESS (Singapore only)
TAX.strTaxCode

STRSRVCTAXCODE

VARCHAR(10)

The tax code that represents Service Fee (Singapore only)
TAX.strTaxCode

YSNAUTOCHRGSRVCFEE

CHAR

If 'T' then service fee tax will be charged automatically.

YSNSRVCFEEONGROSS

CHAR

If 'T' then service fee will be charged on gross sales value.

If 'F' will be charged on discounted sales value.

STRTAXINVOICENAME

VARCHAR(100)

The name of the tax invoice, for example 'TAX INVOICE'.

STRTAXRETURNNAME

VARCHAR(100)

The name of the return invoice, for example 'ADJUSTMENT NOTE'.

STRMSGALLITEMSTAXED

VARCHAR(100)

The message to print on the receipt when all items on the sale are taxed.

STRMSGSOMEITEMSTAXED

VARCHAR(100)

The message to print on the receipt when only some items on a sale are taxed.

STRMSGRECEIPTTOTALGST

VARCHAR(100)

The message to print on the receipt when displaying the tax amount.

CURMINVALUECUSTREQ

MONEY

The minimum value of the sale when we need to ask for customer details (used in Australia).

STRTAXNAME

VARCHAR(50)

The name of the tax.

STRTAXTYPE

VARCHAR(5)

The type of tax, for example GST, GSTEX, US.

STRTAKEAWAYTAXCODE

VARCHAR(10)

The default takeaway taxcode for the tax system. If using a GST/VAT type of tax system then this will be the tax code used for takeaway items.

TAX.strTaxCode

YSNGSTONSERVICE

VARCHAR(1)

If 'T', GST/VAT will be charged on the service fee.

YSNGSTONCESS

VARCHAR(1)

If 'T', GST/VAT will be charged on the CESS.

INTCOUNTRYCODE

INTEGER

 

STRGRPSVCTAXCODE

VARCHAR(10)

The tax code used for Group Service Charge.

INTGRPSVCCOVERS

INTEGER

The number of covers required on a transaction to invoke group service charge.

 

Primary Key: STRTAXSYSTEMCODE

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