create table EXPRESS_PAY_ORDER
(
  REFERENCE_NBR           VARCHAR2(8) not null,
  ORDER_DATE              DATE not null,
  SND_CUST_LAST_NAME      VARCHAR2(20),
  SND_CUST_FIRST_NAME     VARCHAR2(14),
  SND_CUST_ADDR1          VARCHAR2(30),
  SND_CUST_CITY           VARCHAR2(20),
  SND_CUST_STATE_PROVINCE VARCHAR2(2),
  SND_CUST_ZIPCODE        VARCHAR2(9),
  SND_CUST_PHONE_NBR      VARCHAR2(14),
  SND_AMT                 NUMBER(11,2),
  RCV_AGENT_ID            VARCHAR2(6),
  RCV_ACCT_NBR_R          VARCHAR2(20),
  COL_AGENT_ID            NUMBER(8),
  EXT_RCV_AGENCY_ID       VARCHAR2(4),
  RCV_MESSAGE_1           VARCHAR2(40),
  RCV_MESSAGE_2           VARCHAR2(40),
  STATUS                  VARCHAR2(6),
  SND_AGENT_ID            VARCHAR2(6),
  SND_COLUMBUS_AGENT_ID   NUMBER(8),
  RCV_COLUMBUS_MAINOFFICE NUMBER(8),
  INSERT_DATE             DATE default SYSDATE not null,
  LAST_UPDATE_DATE        DATE default SYSDATE not null,
  RCV_DATE                DATE,
  TRK_EFF_DATE            DATE,
  TRAN_CHG_CODE           CHAR(1) default 'N' not null,
  SND_CUST_CNTRY_CODE     VARCHAR2(3),
  PRT_RCPT_CNT            NUMBER(2) default 0,
  LAST_PRT_RCPT_DATE      DATE,
  RCV_ACCT_NBR_R_LGTH_CNT NUMBER(2),
  CLR_UNPRNTD_RCPT_DATE   DATE,
  TRAN_NOTE_TEXT          VARCHAR2(255)
)

indexes on the table are 
IDX1_EXPRESS_PAY_ORDER	Normal	ORDER_DATE
IDX2_EXPRESS_PAY_ORDER	Normal	SND_CUST_LAST_NAME
IDX5_EXPRESS_PAY_ORDER	Normal	RCV_DATE
IDX_EXPRESS_PAY_ORDER	Normal	COL_AGENT_ID, ORDER_DATE, STATUS, SND_AMT, SND_CUST_LAST_NAME, SND_CUST_PHONE_NBR, RCV_ACCT_NBR_R, SND_CUST_FIRST_NAME
IX4_EXPRESS_PAY_ORDER	Normal	RCV_COLUMBUS_MAINOFFICE, ORDER_DATE, RCV_DATE, COL_AGENT_ID, LAST_PRT_RCPT_DATE, CLR_UNPRNTD_RCPT_DATE
IX6_EXPRESS_PAY_ORDER	Normal	COL_AGENT_ID, TRK_EFF_DATE
PK_EXPRESS_PAY_ORDER	Unique	REFERENCE_NBR, ORDER_DATE



create table TRANSACTION_ENCRYP_ITEM
(
  TRAN_REF_ID     VARCHAR2(8 CHAR) not null,
  SND_TRAN_DATE   DATE not null,
  TRAN_ITEM_CODE  VARCHAR2(2 CHAR) not null,
  ENCRYP_ITEM_VAL RAW(64) not null
)

indexes are 
PK_TRANSACTION_ENCRYP_ITEM	Unique	TRAN_REF_ID, SND_TRAN_DATE, TRAN_ITEM_CODE


And agent is a materialized view.