| Table a_ar_article |
|
Description: defines an item that can be sold or a service that can be charged for; this can be used for catering, hospitality, store and fees; it can describe a specific book, or a group of equally priced books |
| PRIMARY KEY | ||
|
a_ar_article_code_c
varchar (100) NOT NULL | code that uniquely identifies the item; can also be a code of a group of equally priced items | |
|
a_ar_category_code_c
varchar (100) NOT NULL | this article belongs to a certain category (catering, hospitality, store, fees) | a_ar_category |
|
a_tax_type_code_c
varchar (100) NOT NULL | this article falls into a special tax/VAT category | a_tax_type |
|
a_ar_specific_article_l
boolean | describes whether this describes a specific item, e.g. book, or a group of equally priced items | |
|
a_ar_description_c
varchar (300) | description of this article | |
|
a_ar_local_description_c
varchar (300) | description of this article in the local language | |
|
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
|
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
|
s_date_modified_d
date | The date the record was modified. | |
|
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
|
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY a_ar_article_fk1: a_ar_category_code_c => a_ar_category a_ar_article_fk2: a_tax_type_code_c => a_tax_type a_ar_article_fkcr: s_created_by_c => s_user a_ar_article_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY a_ar_article_price, a_ar_discount, a_ar_invoice_detail | ||