POS/2.30/Database Model/customers

POS/2.30/Database Model

POS/2.30/Database Model/applications POS/2.30/Database Model/attribute POS/2.30/Database Model/attributeinstance POS/2.30/Database Model/attributeset POS/2.30/Database Model/attributesetinstance POS/2.30/Database Model/attributeuse POS/2.30/Database Model/attributevalue POS/2.30/Database Model/categories POS/2.30/Database Model/closedcash POS/2.30/Database Model/customers POS/2.30/Database Model/floors POS/2.30/Database Model/locations POS/2.30/Database Model/payments POS/2.30/Database Model/people POS/2.30/Database Model/places POS/2.30/Database Model/products POS/2.30/Database Model/products cat POS/2.30/Database Model/products com POS/2.30/Database Model/receipts POS/2.30/Database Model/reservation customers POS/2.30/Database Model/reservations POS/2.30/Database Model/resources POS/2.30/Database Model/roles POS/2.30/Database Model/sharedtickets POS/2.30/Database Model/stockcurrent POS/2.30/Database Model/stockdiary POS/2.30/Database Model/stocklevel POS/2.30/Database Model/taxcategories POS/2.30/Database Model/taxcustcategories POS/2.30/Database Model/taxes POS/2.30/Database Model/taxlines POS/2.30/Database Model/thirdparties POS/2.30/Database Model/ticketlines POS/2.30/Database Model/tickets

Index

Contents 1 CUSTOMERS 1.1 Description 1.2 Columns 1.3 Foreign Keys 1.4 Indexes

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
EMAIL	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 -

---

POS/2.30/Database Model/closedcash | POS/2.30/Database Model/floors