ATM Transaction Anayzer User and Installation Guide

Appendix C 155
Table 3 Mapping of TLF File with Transaction Table
Fields in ATM Database Fields in TLF File Description
fromAccNum tlf_auth.from_acct.acct_num The account number of the ‘from’ account for the transaction. If
the ‘from’ account is not needed or known, this field contains
zeros.
userFld1 tlf_auth.user_fld1 User-defined field.
toAccNum tlf_auth.to_acct.acct_num The account number of the ‘to’ account for the transaction. If the
‘to’ account is not needed or known, this field contains zeros.
multAccFlag tlf_auth.mult_acct An indicator used to determine whether the transaction is a
primary-account transaction, a multiple-account transaction, or a
fast cash transaction.
depositryType tlf_auth.dep_typ An indicator used to determine the type of depository used at the
terminal.
cardReturnStatusFlag tlf_auth.u_resp_cde.resp_cde_
r.resp_byte_2
An indicator used to determine whether the card was returned or
retained.
transResponseCode tlf_auth.u_resp_cde.resp_cde_
r.resp_byte_1
A code identifying the reason the transaction was approved or
denied.
acquirerTermLoc tlf_auth.term_name_loc The terminal name and location of the terminal that acquired the
transaction.
acquirerTermOwnerName tlf_auth.term_owner_name The name of the financial institution that owns the terminal that
acquired the transaction.
acquirerTermCity tlf_auth.term_city The city in which the terminal that acquired the transaction is
located.
acquirerTermState tlf_auth.term_st_x The state in which the terminal that acquired the transaction is
located.
acquirerTermCountry tlf_auth.term_cntry_x A code indicating the country in which the terminal that acquired
the transaction is located.
origTransSeqNum tlf_auth.orig.oseq_num The sequence number that identifies the original transaction.
origCrncyCode tlf_auth.orig_crncy_cde The type of currency involved in the original transaction.
userfld2 tlf_auth.u_user_fld2.user_fld2 User-defined field.
reversalReason tlf_auth.rvsl_rsn An indicator used to identify the reason for a reversal (0420) or
adjustment (5400) message type.
PINOffset tlf_auth.pin_ofst The PIN offset value.
sharingGrp tlf_auth.shrg_grp An indicator used to identify the sharing group used to allow the
transaction, if it was a not-on-us transaction; otherwise, this field
contains a zero.
destOrder tlf_auth.dest_order An indicator used to determine which destination performed the
final authorization.
authIdResponse tlf_auth.auth_id_resp The host-generated transaction sequence number used for
logging and extract purposes only.
impactAccFlag tlf_auth.refr.imp_ind An indicator used to determine whether this record should be
considered when impacting a newly refreshed set of account
records.
fromAvailImpact tlf_auth.refr.avail_imp[0] An indicator used to define how the value in the AVAIL- BAL field
is impacted in the PBF account records. The first occurrence
defines impacting on the ‘from’ account and the second
occurrence defines impacting on the ‘to’ account.
fromLedgImpact tlf_auth.refr.ledg_imp[0] An indicator used to define how the value in the LEDG-BAL field
is impacted in the PBF account records. The first occurrence
defines impacting on the ‘from’ account and the second
occurrence defines impacting on the ‘to’ account.
Appendix C