Home > Technical > Table Definitions > TAXSYSTEM
Records details about each tax system used in the system.
Column |
Type |
Description |
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. |
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. |
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. |
STRCESSTAXCODE |
VARCHAR(10) |
The tax code that represents
CESS (Singapore only) |
STRSRVCTAXCODE |
VARCHAR(10) |
The tax code that represents
Service Fee (Singapore only) |
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. |
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) |