CREATE OR replace VIEW elvw_atm_rec_handoff_1 
(rectype, recseq, record_type, record_sequence, message_type, pan, 
processing_code, transaction_amount, transaction_currency_code, 
settlement_amount, settlement_currency_code, billing_amount, 
billing_currency_code, transaction_date, settlement_date, trace, 
reference_number, switch_log_id, authorization_number, response_code, 
host_error_code, terminal_id, acceptor_id, acquiring_institution_code, rev_flag, 
original_trace_number, from_account, to_account) 
AS 
  SELECT * 
  FROM   (SELECT 'FT', 
                 'count', 
                 'DT', 
                 ROWNUM, 
                 msg_type, 
                 pan, 
                 proc_code, 
                 txn_amt, 
                 txn_ccy_code, 
                 setl_amt, 
                 setl_ccy_code, 
                 bill_amt, 
                 bill_ccy_code, 
                 trans_dt_time, 
                 setl_date, 
                 stan, 
                 trn_ref_no, 
                 'iso field 60', 
                 'isofield 38', 
                 resp_code, 
                 error_code, 
                 term_id, 
                 'ISOmessage42', 
                 acq_ins_id, 
                 Decode(Substr(msg_type, 1, 1), 4, Reverse(msg_type), 
                                                msg_type), 
                 'ISOfield90', 
                 from_acc, 
                 to_acc 
          FROM   swtb_txn_log)