Provider tenders

Here is the table definition:

CREATE TABLE public.tender
(
id integer NOT NULL DEFAULT nextval('tender_id_seq'::regclass),
reference character varying(100) DEFAULT NULL::character varying,
name character varying(200) DEFAULT NULL::character varying,
idtendertype numeric(12,0) DEFAULT NULL::numeric,
idproject numeric(12,0) DEFAULT NULL::numeric,
idcallfortender numeric(12,0) DEFAULT NULL::numeric,
idtenderstatus numeric(12,0) DEFAULT NULL::numeric,
iduser numeric(12,0) DEFAULT NULL::numeric,
creationdate date,
idprovider numeric(12,0) DEFAULT NULL::numeric,
externalreference character varying(100) DEFAULT NULL::character varying,
description text,
idstatus numeric(12,0) DEFAULT NULL::numeric,
idresource numeric(12,0) DEFAULT NULL::numeric,
idcontact numeric(12,0) DEFAULT NULL::numeric,
requestdatetime timestamp without time zone,
expectedtenderdatetime timestamp without time zone,
receptiondatetime timestamp without time zone,
evaluationvalue numeric(7,2) DEFAULT NULL::numeric,
evaluationrank numeric(3,0) DEFAULT NULL::numeric,
offervalidityenddate date,
plannedamount numeric(11,2),
taxpct numeric(5,2) DEFAULT NULL::numeric,
plannedtaxamount numeric(11,2),
plannedfullamount numeric(11,2),
untaxedamount numeric(11,2),
initialtaxamount numeric(11,2),
initialfullamount numeric(11,2),
deliverydelay character varying(100) DEFAULT NULL::character varying,
deliverydate date,
paymentcondition character varying(100) DEFAULT NULL::character varying,
evaluation numeric(7,2) DEFAULT NULL::numeric,
result text,
handled numeric(1,0) DEFAULT '0'::numeric,
done numeric(1,0) DEFAULT '0'::numeric,
idle numeric(1,0) DEFAULT '0'::numeric,
cancelled numeric(1,0) DEFAULT '0'::numeric,
handleddate date,
donedate date,
idledate date,
discountamount numeric(11,2),
discountrate numeric(5,2),
idprojectexpense numeric(12,0) DEFAULT NULL::numeric,
discountfrom character varying(10),
CONSTRAINT tender_pkey PRIMARY KEY (id)
)

brilliant - thanks

i'll upgrade over the next few days.

I have a second question, I've tried to include the tender process on the plan. I added an activity to the plan but when I tried to link the activity to the "call to tender", I couldn't find it on the list. I can link the individual tenders but not the "call to tender".

I think it should be an improvement and the workaround works

Thanks