POS/2.30/Database Model/customers
Contents |
CUSTOMERS
Description
Columns
This table contains the following columns:
Name | PK | Nullable | Data Type | Default | Description |
ID | Y | N | VARCHAR | ||
SEARCHKEY | N | N | VARCHAR | ||
TAXID | N | Y | VARCHAR | ||
NAME | N | N | VARCHAR | ||
TAXCATEGORY | N | Y | VARCHAR | ||
CARD | N | Y | VARCHAR | ||
MAXDEBT | N | N | DOUBLE | 0 | |
ADDRESS | N | Y | VARCHAR | ||
ADDRESS2 | N | Y | VARCHAR | ||
POSTAL | N | Y | VARCHAR | ||
CITY | N | Y | VARCHAR | ||
REGION | N | Y | VARCHAR | ||
COUNTRY | N | Y | VARCHAR | ||
FIRSTNAME | N | Y | VARCHAR | ||
LASTNAME | N | Y | VARCHAR | ||
N | Y | VARCHAR | |||
PHONE | N | Y | VARCHAR | ||
PHONE2 | N | Y | VARCHAR | ||
FAX | N | Y | VARCHAR | ||
NOTES | N | Y | VARCHAR | ||
VISIBLE | N | N | BOOLEAN | TRUE | |
CURDATE | N | Y | TIMESTAMP | ||
CURDEBT | N | Y | DOUBLE |
Foreign Keys
These are the foreign keys for this table:
Name | Referencing column | Referenced table | Referenced column | Description |
CUSTOMERS_TAXCAT | TAXCATEGORY | TAXCUSTCATEGORIES | 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 |
CUSTOMERS_SKEY_INX | Y | SEARCHKEY --desc1 - | desc1 |
CUSTOMERS_TAXID_INX | N | TAXID - | |
CUSTOMERS_NAME_INX | N | NAME --desc2 - | desc2 |
CUSTOMERS_CARD_INX | N | CARD - |
Languages: |
POS/2.30/Database Model/closedcash | POS/2.30/Database Model/floors