/*ALIAS>prop_db*/

/*SQLStart>2554*/
 CREATE TABLE  RENTSDETAILS (
RD_ID INTEGER NOT NULL,
RD_DOCID INTEGER NOT NULL,
RD_MONTH SMALLINT NOT NULL,
RD_YEAR SMALLINT NOT NULL,
RD_CARRIEDINTEREST NUMERIC(10,2),
RD_ANULLED INTEGER,
RD_ANULLEDITED INTEGER,
RD_SELECTEDFLAG INTEGER,
RD_INVOICEID INTEGER,
RD_LOGCARRIEDINTEREST BLOB SUB_TYPE TEXT,
PRIMARY KEY (RD_ID,RD_DOCID,RD_MONTH,RD_YEAR)
);

/*SQLStop*/

/*SQLStart>2555*/
GRANT    ALL ON rentsdetails  to  PUBLIC
/*SQLStop*/

/*SQLStart>2556*/
CREATE GENERATOR RD_ID_GEN;
/*SQLStop*/

/*SQLStart>2557*/
SET GENERATOR RD_ID_GEN TO 0;
/*SQLStop*/

/*SQLStart>2558*/
ALTER TABLE rentsinfo ADD RI_EDITEDCARRIEDINTEREST NUMERIC(10,2);
/*SQLStop*/

/*SQLStart>2559*/

ALTER TABLE rentsinfo ADD RI_LOGCARRIED BLOB SUB_TYPE 1 SEGMENT SIZE 80;
/*SQLStop*/

/*SQLStart>2560*/
update system_strings set sys_str = '6.7.208.1' where sys_id = 1401;  /*BackOffice*/
/*SQLStop*/