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
)
;