DROP TABLE PUBBSPCTL; 
CREATE TABLE PUBBSPCTL (
  INST_ID          VARCHAR(20)      NOT NULL, 
  BAT_NO           VARCHAR(20)      NOT NULL, 
  FIL_NM           VARCHAR(60)      DEFAULT ' ' NOT NULL, 
  M_BAT_NO         VARCHAR(20)      NOT NULL, 
  IS_PRIMARY       VARCHAR(1)       DEFAULT 'Y' NOT NULL, 
  EXT_KEY          VARCHAR(60)      NOT NULL, 
  EXT_BAT_NO       VARCHAR(60)      DEFAULT ' ' NOT NULL, 
  PHASE            VARCHAR(1)       DEFAULT '0' NOT NULL, 
  STATUS           VARCHAR(1)       DEFAULT 'U' NOT NULL, 
  PRE_STS          VARCHAR(1)       DEFAULT 'U' NOT NULL, 
  PROC_STS         VARCHAR(1)       DEFAULT 'U' NOT NULL, 
  AFTER_STS        VARCHAR(1)       DEFAULT 'U' NOT NULL, 
  SRV_ID           VARCHAR(2)       DEFAULT ' ' NOT NULL, 
  SND_CNT          NUMBER            DEFAULT 0   NOT NULL, 
  MAX_CNT          NUMBER            DEFAULT 1   NOT NULL,  
  TX_CD            VARCHAR(30)      DEFAULT ' ' NOT NULL, 
  BUS_TYP          VARCHAR(5)       DEFAULT ' ' NOT NULL, 
  AC_DT            VARCHAR(8)       NOT NULL, 
  DUE_DT_CTRL      VARCHAR(1)       DEFAULT '0' NOT NULL, 
  DUE_DT           VARCHAR(8)       DEFAULT '19000101' NOT NULL, 
  DUE_BGN_TM       VARCHAR(6)       DEFAULT '000000' NOT NULL, 
  DUE_END_TM       VARCHAR(6)       DEFAULT '235959' NOT NULL, 
  BAT_MOD          VARCHAR(1)       DEFAULT '1' NOT NULL, 
  SUM_FLG          VARCHAR(1)       DEFAULT 'N' NOT NULL, 
  START_TM         VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  CONFIRM_TM       VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  PRE_STR_TM       VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  PRE_FIN_TM       VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  PROC_STR_TM      VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  PROC_FIN_TM      VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  AFTER_STR_TM     VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  AFTER_FIN_TM     VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  FINISH_TM        VARCHAR(19)      DEFAULT ' ' NOT NULL, 
  CCY_CD           VARCHAR(3)       DEFAULT ' ' NOT NULL, 
  TOTAL_CNT        NUMBER            DEFAULT 0   NOT NULL, 
  TOTAL_AMT        NUMBER            DEFAULT 0   NOT NULL, 
  SUCC_CNT         NUMBER            DEFAULT 0   NOT NULL, 
  SUCC_AMT         NUMBER            DEFAULT 0   NOT NULL, 
  FAIL_CNT         NUMBER            DEFAULT 0   NOT NULL, 
  FAIL_AMT         NUMBER            DEFAULT 0   NOT NULL, 
  CALL_SRV         VARCHAR(8)       NOT NULL, 
  CALL_TX_CD       VARCHAR(20)      NOT NULL, 
  DO_PRE_PROC      VARCHAR(1)       DEFAULT 'N' NOT NULL, 
  PRE_SRV          VARCHAR(8)       DEFAULT ' ' NOT NULL, 
  PRE_TX_CD        VARCHAR(20)      DEFAULT ' ' NOT NULL, 
  DO_AFTER_PROC    VARCHAR(1)       DEFAULT 'N' NOT NULL, 
  AFTER_SRV        VARCHAR(8)       DEFAULT ' ' NOT NULL, 
  AFTER_TX_CD      VARCHAR(20)      DEFAULT ' ' NOT NULL, 
  DTL_TBL          VARCHAR(20)      NOT NULL, 
  UPD_FLG          VARCHAR(1)       DEFAULT 'N' NOT NULL, 
  UPD_FLDS         VARCHAR(512)     DEFAULT ' ' NOT NULL, 
  APPLY_JRN_FLG    VARCHAR(1)       DEFAULT 'N' NOT NULL, 
  REMARK           VARCHAR(100)     DEFAULT ' ' NOT NULL, 
  TM_SMP           VARCHAR(14)      DEFAULT ' ' NOT NULL,  
  PRIMARY KEY (BAT_NO)
); 
CREATE UNIQUE INDEX UI1_PUBBSPCTL ON PUBBSPCTL (EXT_KEY);