"serialnumber" text,
"itime" timestamp DEFAULT now(),
"mtime" timestamp,
- "pricegroup_id" integer
+ "pricegroup_id" integer,
+ "ordnumber" text,
+ "transdate" text,
+ "cusordnumber" text
);
CREATE TABLE "vendor" (
"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" (