/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\HPDI_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HPDI_BIZDATAERRORLOG') 
 CREATE TABLE T_HPDI_BIZDATAERRORLOG (
FID BIGINT DEFAULT 0 NOT NULL,
FBILLNO VARCHAR(255) DEFAULT ' ' NOT NULL,
FOPERATESTAGE VARCHAR(2) DEFAULT ' ' NOT NULL,
FBIZITEMGROUPID BIGINT DEFAULT 0 NOT NULL,
FCREATORID BIGINT DEFAULT 0 NOT NULL,
FOPERATETIME DATETIME,
FOPERATENUM BIGINT DEFAULT 0 NOT NULL,
FOVERINPUTNUM BIGINT DEFAULT 0 NOT NULL,
FNOTINTIMEWINDOWNUM BIGINT DEFAULT 0 NOT NULL,
FNOTPASSAUDITNUM BIGINT DEFAULT 0 NOT NULL,
FNOTMATCHFILENUM BIGINT DEFAULT 0 NOT NULL,
FMATCHMOREFILENUM BIGINT DEFAULT 0 NOT NULL,
FOTHERNUM BIGINT DEFAULT 0 NOT NULL,
FTOTALNUM BIGINT DEFAULT 0 NOT NULL
);



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