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