X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Flx-office.sql;h=240803396ca033465638eeda868ead1eebc7e720;hb=028a47070f1c96c07828b9c8e802be253224df4f;hp=4b1606c7f4278d8d9aa36a6e91d27488ac04dc04;hpb=195883fdfd3b10f329036767f027baa6e7c402b9;p=kivitendo-erp.git

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 4b1606c7f..240803396 100644
--- 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" (
@@ -397,7 +400,10 @@ CREATE TABLE "orderitems" (
 	"id" integer DEFAULT nextval('orderitemsid'::text) PRIMARY KEY,
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp,
-        "pricegroup_id" integer
+        "pricegroup_id" integer,
+        "ordnumber" text,
+        "transdate" text,
+        "cusordnumber" text
 );
 
 CREATE TABLE "exchangerate" (