ATM Transaction Anayzer User and Installation Guide

Appendix C 157
Table 3 Mapping of TLF File with Transaction Table
Fields in ATM Database Fields in TLF File Description
origTransAmount tlf_auth.amt_1 The transaction amount requested.
actualTransAmount tlf_auth.amt_2 For most reversal (0420) messages, this field contains the actual
completion amount of the transaction.
balAmount tlf_auth.amt_3 For most response (0210) messages, this field contains a
balance amount.
depBalCrAmount tlf_tlf_auth.dep_bal_cr The amount of credit given on a deposit
entryTime The time the transaction entered the BASE24 system.
transactionTime head.dat_tim The date and time on which the record was logged
transSetlDate tlf_auth.post_dat The date (YYMMDD) on which the transaction will be settled.
acquirerIchgSetlDate tlf_auth.acq_ichg_setl_dat The date (YYMMDD) this transaction will be settled by the
interchange originating the transaction, if the transaction
originates through an interchange.
issuerIchgSetlDate tlf_auth.iss_ichg_setl_dat The date (YYMMDD) this transaction will be settled by the
interchange authorizing the transaction, if an interchange was
involved in processing.
transLogDateTime tlf_auth.tran_dat The date and time on which the transaction began.
origTransDate tlf_auth.orig.otran_dat The date of the original transaction.
origTransTime tlf_auth.orig.otran_tim The time of the original transaction.
origTransB24PostDate tlf_auth.orig.b24_post_dat The BASE24 posting date of the original transaction.
nonStopNode NSK System Name
bin head.crd.pan.num Issuer BIN for specified length.
Table 4 Mapping of TLF File with Termbalancing Table
Fields in ATM Database Fields in TLF File Description
transID Unique number for transaction. It can be treated as primary key.
transactionTime head.dat_tim The date and time on which the record time was logged.
recordType head.rec_typ The type of TLF record logged. The value in this field is set by
the process that creates the TLF record (i.e. Authorization, Device
Handler or Settlement).
authprocess head.auth_ppd The PPD name (without the initial "$") of the Authorization
process that logged the record to the TLF.
terminalLN head.term.ln The logical network associated with the terminal
terminalFIID head.term.fiid The FIID of the financial institution owning the terminal.
terminalID head.term.term_id The terminal ID of the terminal originating the transaction.
cardIssuerLN head.crd.ln The logical network associated with the card issuer.
cardIssuerFIID head.crd.fiid The FIID of the card issuer.
cardHoldPAN head.crd.pan.num The cardholder's Primary Account Number (PAN) for card
initiated transactions. This field will contain an AFT group
number and user number for DCT initiated transactions.
cardHoldMemNum head.crd.mbr_num The member number associated with the account number.
termBranchID head.brch_id The branch ID associated with the terminal originating the
transaction.
Appendix C