/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_EB_REPORTPROCESS') 
 CREATE TABLE T_EB_REPORTPROCESS (
FID  BIGINT NOT NULL DEFAULT 0,
FENTITY BIGINT NOT NULL DEFAULT 0,
FVERSION BIGINT NOT NULL DEFAULT 0,
FDATATYPE BIGINT NOT NULL DEFAULT 0,
FPERIOD BIGINT NOT NULL DEFAULT 0,
FTEMPLATE BIGINT NOT NULL DEFAULT 0,
FSTATUS VARCHAR(50) DEFAULT ' ',
FMODEL BIGINT NOT NULL DEFAULT 0,
FCREATER BIGINT NOT NULL DEFAULT 0,
FCREATEDATE DATETIME,
FMODIFIER BIGINT NOT NULL DEFAULT 0,
FMODIFYDATE DATETIME,
FSUBMITUSER BIGINT NOT NULL DEFAULT 0,
FSUBMITDATE DATETIME,
FSUBMITENTITY BIGINT NOT NULL DEFAULT 0,
CONSTRAINT PK_T_EB_REPORTPROCESS PRIMARY KEY (FID)
);


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_table.sql **/