32 lines
716 B
SQL
32 lines
716 B
SQL
|
|
|
|
|
|
--批量临时表
|
|
|
|
|
|
|
|
|
|
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
|
|
);
|
|
|