CREATE TABLE "EOD"."TXN_HEADER"
(
   ORGU_CODE_CMPY varchar2(10) NOT NULL,
   ORGU_CODE varchar2(10) NOT NULL,
   TILL_SHORT_DESC varchar2(30) NOT NULL,
   TXHD_TXN_NR DECIMAL(10) NOT NULL,
   TXHD_STATE DECIMAL(5),
   ORGU_CODE_ORIGINAL varchar2(10),
   TILL_DESC_ORIG varchar2(30),
   TXHD_ORIG_TXN_NR DECIMAL(10),
   TXHD_SALE_PER_COD varchar2(60),
   TXHD_TRADING_DATE CHAR(8),
   TXHD_TXN_TYPE DECIMAL(22) NOT NULL,
   TXHD_OPERATOR_CODE varchar2(60),
   TXHD_TRAINING_MODE DECIMAL(38) DEFAULT 0  NOT NULL,
   TXHD_VOIDED DECIMAL(38) DEFAULT 0  NOT NULL,
   RSTY_TYPE varchar2(10),
   RESN_CODE varchar2(10),
   TXHD_VALUE_GROSS DECIMAL(38),
   TXHD_VALUE_NETT DECIMAL(38),
   TXHD_VAL_DISCABLE DECIMAL(38),
   TXHD_VALUE_DUE DECIMAL(38),
   TXHD_VALUE_CHANGE DECIMAL(38),
   TXHD_VAL_ROUNDING DECIMAL(38),
   TXHD_START_DATE CHAR(21),
   TXHD_FINISH_DATE CHAR(21),
   TXHD_VALUE_TAXABLE DECIMAL(38),
   TXHD_VALUE_TAX DECIMAL(38),
   TXHD_RECEIPT_ID varchar2(10),
   CUST_CODE varchar2(100),
   TXHD_VOID_TXN_NR DECIMAL(10),
   TXHD_TAX_EXEMPT DECIMAL(38) DEFAULT 0  NOT NULL,
   TXHD_TAX_EXMT_CERT varchar2(60),
   LOYC_CARD_NO varchar2(100),
   TXHD_SUSP_TXN_NR DECIMAL(10),
   TXHD_TOTAL_TIME CHAR(21),
   TXHD_CUST_DESIG varchar2(60),
   TXHD_LOGON_STRING varchar2(60),
   TXHD_ORIG_DATE CHAR(21),
   LCOUNT DECIMAL(38) DEFAULT 0,
   TXHD_EXTERNAL_REF varchar2(60),
   TXHD_SUPER_CODE varchar2(10),
   VALC_CODE varchar2(10),
   TXHD_SOURCE_SYSTEM varchar2(10),
   TXHD_SEAL_NUMBER varchar2(100),
   TXHD_SUPER_DATE CHAR(21),
   TXHD_TILL_STATUS DECIMAL(38),
   TXHD_PUBLISH_ID DECIMAL(38),
   TXHD_EARN_PTS DECIMAL(38),
   TXHD_PROM_PTS DECIMAL(38),
   TXHD_BONUS_PTS DECIMAL(38),
   TXHD_DEFER_SDIS DECIMAL(38) DEFAULT 0  NOT NULL,
   TXHD_EXPIRY_DATE CHAR(8),
   TXHD_CARD_CHECK_OK DECIMAL(38),
   TXHD_DESCRIPTION varchar2(2048),
   TXHD_PICKUP_NR DECIMAL(38),
   TXHD_CHG_CMPY_CODE varchar2(10),
   TXHD_CHG_STOR_CODE varchar2(10),
   TXHD_CHG_DEPT_CODE varchar2(10),
   TXHD_CHG_EMP_CODE varchar2(10),
   TXHD_TXNRECALL_REF varchar2(60),
   CMPY_CODE_ORIGINAL varchar2(10),
   TXHD_EXTERNAL_ACC varchar2(100),
   SESSIONID DECIMAL(1),
   KNZ varchar2(2) DEFAULT ' '  NOT NULL,
   TIMESTAMP varchar2(20) DEFAULT ' ',
   TXHD_LOYALTY_VALUE DECIMAL(38),
   START_TIMESTAMP varchar2(20),
   END_TIMESTAMP varchar2(20),
   TXHD_IMAGE_VERSION varchar2(50),
   TXHD_MAC_ADDRESS varchar2(60),
   TXHD_AUD_COUNTER varchar2(128),
   CONSTRAINT TXHD_PK PRIMARY KEY (ORGU_CODE_CMPY,ORGU_CODE,TILL_SHORT_DESC,TXHD_TXN_NR)
)
;
CREATE INDEX TXHD_TIMESTAMP ON "EOD"."TXN_HEADER"
(
  TIMESTAMP,
  ORGU_CODE_CMPY
)
;
CREATE UNIQUE INDEX TXHD_PK ON "EOD"."TXN_HEADER"
(
  ORGU_CODE_CMPY,
  ORGU_CODE,
  TILL_SHORT_DESC,
  TXHD_TXN_NR
)
;
CREATE INDEX TXHD_SE ON "EOD"."TXN_HEADER"
(
  ORGU_CODE,
  TILL_SHORT_DESC,
  SESSIONID,
  KNZ,
  TXHD_TXN_NR
)
;