ATM Transaction Anayzer User and Installation Guide

Appendix C 158
Table 4 Mapping of TLF File with Termbalancing Table
Fields in ATM Database Fields in TLF File Description
termRegionID head.regn_id The region ID associated with the terminal originating the
transaction.
adminTime term_setl.admin_tim The time the administrative transaction occurred.
adminCode term_setl.admin_cde A code indicating a transaction type that involves increases and
decreases of currency. This code also identifies whether the
transaction was performed by a Device Handler or at a CRT.
hopr_1_Contents
….
….
….
….
hopr_6_Contents
term_setl.hopr[0].contents
….
….
….
….
term_setl.hopr[5].contents
A code used to identify the contents of the hopper.
hopr_1_BegCash
….
….
….
….
hopr_6_BegCash
term_setl.hopr[0].beg_cash
….
….
….
….
term_setl.hopr[5].beg_cash
The amount of currency in the hopper at the start of the current
balancing period.
hopr_1_CashIncr
….
….
….
….
hopr_6_CashIncr
term_setl.hopr[0].cash_incr
….
….
….
….
term_setl.hopr[5].cash_inc
The amount of currency added to the hopper during the current
balancing period.
hopr_1_CashDecr
….
….
….
….
hopr_6_CashDecr
term_setl.hopr[0].cash_decr
….
….
….
….
The amount of currency removed from the hopper during the
current balancing period.
hopr_1_CashOut
….
….
….
….
hopr_6_CashOut
term_setl.hopr[0].cash_out
….
….
….
….
term_setl.hopr[5].cash_out
The amount of currency dispensed from the hopper through
customer withdrawals between terminal balancing periods.
hopr_1_EndCash
….
….
….
….
hopr_6_EndCash
term_setl.hopr[0].end_cash
….
….
….
….
term_setl.hopr[5].end_cash
The amount of currency remaining in the hopper at the end of the
balancing period.
hopr_1_CrncyCode
….
….
….
….
hopr_6_CrncyCode
term_setl.hopr[0].crncy_cde
….
….
….
….
term_setl.hopr[5].crncy_cde
A code identifying the currency in the hopper. Valid values are
listed in the booklet "Codes for the Representation of Currencies
and Funds", ISO 4217:1990.
hopr_1_UserField5
….
….
….
….
hopr_1_UserField5
term_setl.hopr[0].user_fld5
….
….
….
….
term_setl.hopr[5].user_fld5
This field is not used
numDep term_setl.num_dep The number of envelope deposits accepted at the terminal since
the last terminal balancing transaction