View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

POS/2.30/Database Model/ticketlines

POS/2.30/Database Model

Index


Contents

TICKETLINES

Description

Columns

This table contains the following columns:

Name PK Nullable Data Type Default Description
TICKET N N VARCHAR
LINE N N INTEGER
PRODUCT N Y VARCHAR
ATTRIBUTESETINSTANCE_ID N Y VARCHAR
UNITS N N DOUBLE
PRICE N N DOUBLE
TAXID N N VARCHAR
ATTRIBUTES N Y BYTEA

Foreign Keys

These are the foreign keys for this table:

Name Referencing column Referenced table Referenced column Description
TICKETLINES_FK_TICKET TICKET TICKETS ID
TICKETLINES_FK_2 PRODUCT PRODUCTS ID
TICKETLINES_ATTSETINST ATTRIBUTESETINSTANCE_ID ATTRIBUTESETINSTANCE ID
TICKETLINES_FK_3 TAXID TAXES ID

Indexes



POS/2.30/Database Model/thirdparties | POS/2.30/Database Model/tickets 

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

This page has been accessed 3,368 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.