/**Begin D:\PDM\PDM_UPGRADE\pdm1\BCM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BCM_ADJUSTPROGRESSENTIT') 
 CREATE TABLE T_BCM_ADJUSTPROGRESSENTIT (
FID BIGINT DEFAULT 0 NOT NULL,
FMODEL BIGINT DEFAULT 0 NOT NULL,
FOPERATIONTYPE CHAR(1) DEFAULT '0' NOT NULL,
FUSERID BIGINT DEFAULT 0 NOT NULL,
FSTATUS CHAR(1) DEFAULT '1' NOT NULL,
FSCENARIOID BIGINT DEFAULT 0 NOT NULL,
FYEARID BIGINT DEFAULT 0 NOT NULL,
FPERIODID BIGINT DEFAULT 0 NOT NULL,
FBEGINTIME DATETIME,
FENDTIME DATETIME,
FFAILEDLOG NCLOB,
FSUCCESSCOUNT INT DEFAULT 0 NOT NULL,
FERRORCOUNT INT DEFAULT 0 NOT NULL,
FCOUNT INT DEFAULT 0 NOT NULL
);



/**End D:\PDM\PDM_UPGRADE\pdm1\BCM_table.sql **/
