/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BASE_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BAS_COSTCENTERNH')
CREATE TABLE T_BAS_COSTCENTERNH (
                                  FENTRYID BIGINT DEFAULT 0 NOT NULL,
                                  FID BIGINT DEFAULT 0 NOT NULL,
                                  FSEQ INT DEFAULT 0 NOT NULL,
                                  FNAME NVARCHAR(255) DEFAULT ' ' NOT NULL,
                                  FENABLE CHAR(1) DEFAULT '1' NOT NULL,
                                  FSTARTDATE DATETIME,
                                  FENDDATE DATETIME,
                                  FCREATORID BIGINT DEFAULT 0 NOT NULL,
                                  FCREATETIME DATETIME,
                                  FMODIFIERID BIGINT DEFAULT 0 NOT NULL,
                                  FMODIFYTIME DATETIME
);

IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BAS_COSTCENTERNH_L')
CREATE TABLE T_BAS_COSTCENTERNH_L (
                                    FPKID VARCHAR(36) DEFAULT ' ' NOT NULL,
                                    FENTRYID BIGINT DEFAULT 0 NOT NULL,
                                    FLOCALEID VARCHAR(10) DEFAULT ' ' NOT NULL,
                                    FNAME NVARCHAR(255) DEFAULT ' ' NOT NULL
);
/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BASE_table.sql **/
