/**Begin D:\software\PDM_UPGRADE\PDM1\FPM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_FPM_DEFULT_SYSTEM')
CREATE TABLE T_FPM_DEFULT_SYSTEM (
                                     FID BIGINT DEFAULT 0 NOT NULL,
                                     FBILLNO VARCHAR(30) DEFAULT ' ' NOT NULL,
                                     FBILLSTATUS VARCHAR(50) DEFAULT ' ' NOT NULL,
                                     FCREATORID BIGINT DEFAULT 0 NOT NULL,
                                     FMODIFIERID BIGINT DEFAULT 0 NOT NULL,
                                     FAUDITORID BIGINT DEFAULT 0 NOT NULL,
                                     FAUDITDATE DATETIME,
                                     FMODIFYTIME DATETIME,
                                     FCREATETIME DATETIME,
                                     FDEFAULTSYSTEMID BIGINT DEFAULT 0 NOT NULL,
                                     FUSERID BIGINT DEFAULT 0 NOT NULL
);



/**End D:\software\PDM_UPGRADE\PDM1\FPM_table.sql **/
