2 "id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
3 "rmanumber" text NOT NULL,
4 "transdate" date DEFAULT date('now'::text),
7 "amount" numeric (15,5),
8 "netamount" numeric (15,5),
10 "taxincluded" boolean,
14 "employee_id" integer,
15 "closed" boolean DEFAULT 'f',
16 "quotation" boolean DEFAULT 'f',
20 "delivery_customer_id" integer,
21 "delivery_vendor_id" integer,
22 "language_id" integer,
24 "department_id" integer DEFAULT 0,
25 "itime" timestamp DEFAULT now(),
31 CREATE TABLE "rmaitems" (
33 "parts_id" integer REFERENCES parts (id),
37 "sellprice" numeric (15,5),
39 "unit" character varying(10),
44 "id" integer DEFAULT nextval('orderitemsid'::text),
45 "itime" timestamp DEFAULT now(),
47 "pricegroup_id" integer,
53 alter table defaults add column rmanumber text;