Revision 195883fd
Von Stephan Köhler vor etwa 19 Jahren hinzugefügt
| sql/lx-office.sql | ||
|---|---|---|
| 160 | 160 |
"deliverydate" date, |
| 161 | 161 |
"serialnumber" text, |
| 162 | 162 |
"itime" timestamp DEFAULT now(), |
| 163 |
"mtime" timestamp |
|
| 163 |
"mtime" timestamp, |
|
| 164 |
"pricegroup_id" integer |
|
| 164 | 165 |
); |
| 165 | 166 |
|
| 166 | 167 |
CREATE TABLE "vendor" ( |
| ... | ... | |
| 241 | 242 |
"username" varchar(50), |
| 242 | 243 |
"user_password" varchar(12), |
| 243 | 244 |
"salesman_id" integer, |
| 244 |
"c_vendor_id" text |
|
| 245 |
"c_vendor_id" text, |
|
| 246 |
"klass" integer DEFAULT 0 |
|
| 245 | 247 |
|
| 246 | 248 |
); |
| 247 | 249 |
|
| ... | ... | |
| 394 | 396 |
"serialnumber" text, |
| 395 | 397 |
"id" integer DEFAULT nextval('orderitemsid'::text) PRIMARY KEY,
|
| 396 | 398 |
"itime" timestamp DEFAULT now(), |
| 397 |
"mtime" timestamp |
|
| 399 |
"mtime" timestamp, |
|
| 400 |
"pricegroup_id" integer |
|
| 398 | 401 |
); |
| 399 | 402 |
|
| 400 | 403 |
CREATE TABLE "exchangerate" ( |
| ... | ... | |
| 551 | 554 |
license_id integer |
| 552 | 555 |
); |
| 553 | 556 |
|
| 557 |
-- Preisgruppenverwaltung |
|
| 558 |
CREATE TABLE "pricegroup" ( |
|
| 559 |
"id" integer DEFAULT nextval('id'::text),
|
|
| 560 |
"pricegroup" text not null, |
|
| 561 |
PRIMARY KEY (id) |
|
| 562 |
); |
|
| 563 |
--Preisverwaltung der Preisgruppen |
|
| 564 |
CREATE TABLE "prices" ( |
|
| 565 |
"parts_id" integer REFERENCES parts(id), |
|
| 566 |
"pricegroup_id" integer REFERENCES pricegroup(id), |
|
| 567 |
"price" numeric(15,5) |
|
| 568 |
); |
|
| 569 |
|
|
| 570 |
|
|
| 571 |
|
|
| 572 |
|
|
| 554 | 573 |
-- Table of tax authoritys |
| 555 | 574 |
-- for module ustva |
| 556 | 575 |
-- Lx office |
Auch abrufbar als: Unified diff
Preisgruppenerweiterung auf Basis von Andres Patch - Thanks
Preisgruppenverwaltung
...-Preiseingabe der Preisgruppen in Masken Waren,etc.
-Auswahl der Preisgruppen in den Verkaufsmasken
Erweiterung Datenbankschema