--批量临时表 




create table CMMTEMRULE_BATCH
(
  rul_no  CHAR(4) default '0001' not null,
  rul_lvl INTEGER default 0 not null,
  tra_cd  CHAR(7) default '',
  ymcc_cd VARCHAR2(6) default '',
  rard_cd CHAR(4) default '',
  crd_flg CHAR(2) default '',
  bnk_typ VARCHAR2(4) default '',
  bnk_nm  VARCHAR2(40) default '',
  atm_low VARCHAR2(11),
  atm_up  VARCHAR2(11),
  dat_low CHAR(8) default '',
  dat_up  CHAR(8) default '',
  tim_low CHAR(6) default '',
  tim_up  CHAR(6) default '',
  corg_no VARCHAR2(12) default '',
  corg_nm VARCHAR2(100) default '',
  rul_sts CHAR(1) default '0' not null,
  tm_smp  CHAR(26) default '' not null,
  weight  NUMBER(3) default 0
);