"rfqnumber" text,
"customernumber" text,
"vendornumber" text,
+ "audittrail" bool default 'f',
"articlenumber" text,
"servicenumber" text,
"itime" timestamp DEFAULT now(),
"mtime" timestamp
);
-INSERT INTO defaults (version) VALUES ('2.1.2');
+INSERT INTO defaults (version,audittrail) VALUES ('2.2.0', 't');
+
+CREATE TABLE audittrail (
+ "trans_id" int,
+ "tablename" text,
+ "reference" text,
+ "formname" text,
+ "action" text,
+ "transdate" timestamp default current_timestamp,
+ "employee_id" int
+);
CREATE TABLE "acc_trans" (
"trans_id" integer,
"deliverydate" date,
"serialnumber" text,
"itime" timestamp DEFAULT now(),
- "mtime" timestamp
+ "mtime" timestamp,
+ "pricegroup_id" integer,
+ "ordnumber" text,
+ "transdate" text,
+ "cusordnumber" text
);
CREATE TABLE "vendor" (
"obsolete" boolean DEFAULT 'f',
"ustid" varchar(12),
"username" varchar(50),
- "user_password" varchar(12),
+ "user_password" text,
"salesman_id" integer,
- "c_vendor_id" text
+ "c_vendor_id" text,
+ "klass" integer DEFAULT 0
);
"paid" numeric (15,5),
"datepaid" date,
"duedate" date,
+ "deliverydate" date,
"invoice" boolean DEFAULT 'f',
"shippingpoint" text,
"terms" smallint DEFAULT 0,
);
CREATE TABLE "orderitems" (
- "trans_id" integer REFERENCES oe (id),
+ "trans_id" integer,
"parts_id" integer REFERENCES parts (id),
"description" text,
"qty" real,
"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
+ "mtime" timestamp,
+ "pricegroup_id" integer,
+ "ordnumber" text,
+ "transdate" text,
+ "cusordnumber" text
);
CREATE TABLE "exchangerate" (
CREATE TABLE "project" (
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
- "projectnumber" text,
+ "projectnumber" text UNIQUE,
"description" text,
"itime" timestamp DEFAULT now(),
"mtime" timestamp
"mtime" timestamp
);
+
CREATE TABLE "sic" (
"code" text,
"sictype" character(1),
license_id integer
);
+-- Preisgruppenverwaltung
+CREATE TABLE "pricegroup" (
+ "id" integer DEFAULT nextval('id'::text),
+ "pricegroup" text not null,
+ PRIMARY KEY (id)
+);
+--Preisverwaltung der Preisgruppen
+CREATE TABLE "prices" (
+ "parts_id" integer REFERENCES parts(id),
+ "pricegroup_id" integer REFERENCES pricegroup(id),
+ "price" numeric(15,5)
+);
+
+
+
+
-- Table of tax authoritys
-- for module ustva
-- Lx office