25 lines
851 B
SQL
25 lines
851 B
SQL
|
|
drop table CAPCHKCMBC;
|
|
-- Create table
|
|
create GLOBAL TEMPORARY table CAPCHKCMBC
|
|
(
|
|
TRNS_DAT VARCHAR2(8) default ' ' not null,
|
|
HOST_NO VARCHAR2(32) default ' ' not null,
|
|
AMOUNT NUMBER(16,2) default 0 not null,
|
|
BALANCE NUMBER(16,2) default 0 not null,
|
|
VOUH_TYP VARCHAR2(10) default ' ' not null,
|
|
VOUH_NO VARCHAR2(10) default ' ' not null,
|
|
SUMMARY VARCHAR2(80) default ' ' not null,
|
|
TRNS_ADDR VARCHAR2(200) default ' ' not null,
|
|
CUS_ACNO VARCHAR2(34) default ' ' not null,
|
|
CUS_ACNAM VARCHAR2(100) default ' ' not null,
|
|
CUS_BNKNAM VARCHAR2(200) default ' ' not null,
|
|
TRNS_TYP VARCHAR2(2) default ' ' not null,
|
|
HOST_TMSMP VARCHAR2(30) default ' ' not null,
|
|
CHK_STS VARCHAR2(1) default '0' not null,
|
|
TM_SMP VARCHAR2(26) default ' ' not null
|
|
)
|
|
ON COMMIT PRESERVE ROWS;
|
|
|
|
|