/**Begin D:\PDM_UPGRADE\PDM1\HDM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HDM_REGBASEBILL_C') 
 CREATE TABLE T_HDM_REGBASEBILL_C (
FID BIGINT DEFAULT 0 NOT NULL,
FBB_P_TID BIGINT DEFAULT 0 NOT NULL,
FBA_P_TID BIGINT DEFAULT 0 NOT NULL,
FBB_E_TID BIGINT DEFAULT 0 NOT NULL,
FBA_E_TID BIGINT DEFAULT 0 NOT NULL,
FBB_D_TID BIGINT DEFAULT 0 NOT NULL,
FBA_D_TID BIGINT DEFAULT 0 NOT NULL
);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HDM_TRANSFERBILL_C') 
 CREATE TABLE T_HDM_TRANSFERBILL_C (
FID BIGINT DEFAULT 0 NOT NULL,
FBB_P_TID BIGINT DEFAULT 0 NOT NULL,
FBA_P_TID BIGINT DEFAULT 0 NOT NULL,
FBB_E_TID BIGINT DEFAULT 0 NOT NULL,
FBA_E_TID BIGINT DEFAULT 0 NOT NULL,
FBB_D_TID BIGINT DEFAULT 0 NOT NULL,
FBA_D_TID BIGINT DEFAULT 0 NOT NULL
);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HDM_PARTTIMEAPPLYBILL_C') 
 CREATE TABLE T_HDM_PARTTIMEAPPLYBILL_C (
FID BIGINT DEFAULT 0 NOT NULL,
FBB_P_TID BIGINT DEFAULT 0 NOT NULL,
FBA_P_TID BIGINT DEFAULT 0 NOT NULL,
FBB_E_TID BIGINT DEFAULT 0 NOT NULL,
FBA_E_TID BIGINT DEFAULT 0 NOT NULL,
FBB_D_TID BIGINT DEFAULT 0 NOT NULL,
FBA_D_TID BIGINT DEFAULT 0 NOT NULL
);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HDM_PARTTIMEENDBILL_C') 
 CREATE TABLE T_HDM_PARTTIMEENDBILL_C (
FID BIGINT DEFAULT 0 NOT NULL,
FBB_P_TID BIGINT DEFAULT 0 NOT NULL,
FBA_P_TID BIGINT DEFAULT 0 NOT NULL,
FBB_E_TID BIGINT DEFAULT 0 NOT NULL,
FBA_E_TID BIGINT DEFAULT 0 NOT NULL,
FBB_D_TID BIGINT DEFAULT 0 NOT NULL,
FBA_D_TID BIGINT DEFAULT 0 NOT NULL
);



/**End D:\PDM_UPGRADE\PDM1\HDM_table.sql **/
