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;