POS/2.30/Database Model/taxes
Contents |
TAXES
Description
Columns
This table contains the following columns:
| Name | PK | Nullable | Data Type | Default | Description |
| ID | Y | N | VARCHAR | ||
| NAME | N | N | VARCHAR | ||
| CATEGORY | N | N | VARCHAR | ||
| CUSTCATEGORY | N | Y | VARCHAR | ||
| PARENTID | N | Y | VARCHAR | ||
| RATE | N | N | DOUBLE | ||
| RATECASCADE | N | N | BOOLEAN | FALSE | |
| RATEORDER | N | Y | INTEGER |
Foreign Keys
These are the foreign keys for this table:
| Name | Referencing column | Referenced table | Referenced column | Description |
| TAXES_CAT_FK | CATEGORY | TAXCATEGORIES | ID | |
| TAXES_CUSTCAT_FK | CUSTCATEGORY | TAXCUSTCATEGORIES | ID | |
| TAXES_TAXES_FK | PARENTID | TAXES | ID |
Indexes
These are the indexes for this table (for each index there is a list of the columns included within it):
| Name | Unique | Reference | Description |
| TAXES_NAME_INX | Y | NAME - |
| Languages: |
POS/2.30/Database Model/taxcustcategories | POS/2.30/Database Model/taxlines