POS Transaction Analyzer User and Installation Guide, SST Version 1.2

Appendix C 154
Table 3 Mapping of PTLF File with Transaction Table
Fields in POS Database Fields in PTLF File Description
transactionAmount auth.amt_1 The transaction amount requested. For adjustment transactions,
this field contains the original amount. For purchase with cash
back transactions, this field contains the total amount (purchase
plus cash back). The cash back amount is contained in the
auth.amt_2 field. For preauthorization completions, this field
contains the completed amount.
entryTime auth.entry_tim The time at which the transaction data entered the Application
server.
transactionTime head.dat_tim The date and time the record was logged
responseTime auth.re_entry_tim -
auth.entry_tim
Response Time
interChangeResponseTime auth.re_entry_tim -
auth.exit_tim
Interchange response time
origTransactionTime auth.tran_tim
auth.tran_dat
The date and time on which the transaction began
authorizer auth.authorizer The symbolic name of the authorizer of the transaction
retailerTermId head.retl.term_id The terminal ID of the retailer at which the transaction occurred
approvalCode auth.apprv_cde The approval code generated by the transaction authorizer. This
code can be generated by an interchange or host, as well as by
BASE24-pos Authorization. If BASE24 generates the code, a _B
(B preceded by a space) is inserted into the last byte of this field
seqNum auth.seq_num The transaction sequence number generated by the terminal or
the Device Handler
transCategory auth.tran_cde.c A code identifying the transaction category associated with the
transaction
acqInstIDNum auth.acq_inst_id_num The route/transit number of the terminal owner as defined in the
PTDF. The value in this field is set by the Device Handler if the
transaction originates at a directly-connected device.
rcvInstIDNum auth.rcv_inst_id_num The route/transit number of the card issuer as defined in the
Institution Definition File (IDF).
ptSrvCondCode auth.pt_srv_cond_cde A code identifying the transaction origin. The code indicates a
special condition that exists at the time the transaction is
initiated.
cardNum head.crd.card.crd_num.num The card number identifying the card used in the transaction.
mbrNum head.crd.card.mbr_num The member number associated with the card used in the
transaction.
transactionAmount2 auth.amt_2 For adjustment transactions, this field contains the new amount.
For purchase with cash back transactions, this field contains the
cash back amount. For chargebacks, this field contains the
replacement amount.