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

POS/2.30/Database Model/taxes

POS/2.30/Database Model

Index


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 -



POS/2.30/Database Model/taxcustcategories | POS/2.30/Database Model/taxlines 

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

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