Neue Variable p_discount = Rabattprozente pro Position fuer Rechnungen, Auftraege...

[mfinanz.git] / sql / lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 4b1606c7f4278d8d9aa36a6e91d27488ac04dc04..ca5b1d35e52c605fb279f7cd58d95bc23e3b2ca2 100644 (file)
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -161,7 +161,10 @@ CREATE TABLE "invoice" (
        "serialnumber" text,
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp,
-        "pricegroup_id" integer
+        "pricegroup_id" integer,
+        "ordnumber" text,
+        "transdate" text,
+        "cusordnumber" text
 );
 
 CREATE TABLE "vendor" (
@@ -240,7 +243,7 @@ CREATE TABLE "customer" (
         "obsolete" boolean DEFAULT 'f',
         "ustid" varchar(12),
         "username" varchar(50),
-        "user_password" varchar(12),
+        "user_password" text,
         "salesman_id" integer,
         "c_vendor_id" text,
         "klass" integer DEFAULT 0
@@ -394,10 +397,13 @@ CREATE TABLE "orderitems" (
        "reqdate" date,
        "ship" real,
        "serialnumber" text,
-       "id" integer DEFAULT nextval('orderitemsid'::text) PRIMARY KEY,
+       "id" integer DEFAULT nextval('orderitemsid'::text),
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp,
-        "pricegroup_id" integer
+        "pricegroup_id" integer,
+        "ordnumber" text,
+        "transdate" text,
+        "cusordnumber" text
 );
 
 CREATE TABLE "exchangerate" (