View source | Discuss this page | Page history | Printable version   

POS/2.30/Database Model/customers

POS/2.30/Database Model

Index


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

Retrieved from "http://wiki.openbravo.com/wiki/POS/2.30/Database_Model/customers"

This page has been accessed 4,034 times. This page was last modified on 12 August 2009, at 10:02. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.