POS Transaction Analyzer User and Installation Guide, SST Version 1.2

Appendix C 153
Appendix C
Database Mapping with PTLF File
This section provides a list of fields in the POS database and the mapped fields in the PTLF file. A sample
USRPTLFC file to populate transaction date/time and card number in user-defined fields from the PTLF record is
also described in this section.
Table 3 Mapping of PTLF File with Transaction Table
Fields in POS Database Fields in PTLF File Description
transactionID Unique number for a transaction. It can be treated as the
primary key.
acctType auth.tran_cde.aa A code identifying the type of account associated with the
transaction.
cardType auth.tran_cde.t A code identifying the card type associated with the transaction.
cardSubType auth.crd_typ The type of card used to initiate the transaction.
bin head.crd.card.crd_num.num Issuer BIN for specified length.
terminalId head.term.term_id The terminal ID of the terminal at which the transaction occurred.
terminalLN head.term.ln The logical network with which the terminal is associated.
retailerFiid head.retl.ky.rdfkey.fiid The FIID of the institution with which the retailer is associated.
acquirerFiid head.term.fiid The FIID of the institution with which the terminal is associated.
issuerFiid head.crd.fiid The FIID of the institution that issued the card.
retailerGroup head.retl.ky.rdfkey.grp The group to which the retailer belongs.
retailerRegn head.retl.ky.rdfkey.regn The retailer region group to which the retailer belongs.
retailerId head.retl.ky.rdfkey.id The retailer ID identifying the retailer.
userField1 Can be mapped to any field
on the PTLF record
User-defined field.
userField2 Can be mapped to any field
on the PTLF record
User-defined field.
userField3 Can be mapped to any field
on the PTLF record
User-defined field.
nonstopNode NSK System Name.
issuerCode auth.iss_cde The issuer code for the transaction.
locationState auth.term_st The state in which the terminal is located.
resourceNode resourceNode Resource Node.
responseCode auth.resp_cde The response code for the transaction.
responseSource auth.responder Indicates where the response message to this transaction
originated.
routingErrorCode auth.rte_stat A code indicating the status of a message at the system level.
transCode auth.tran_cde.tc A code identifying the type of transaction.
transSource auth.originator Indicates where the transaction originated.
transType auth.typ The specific message type of this record.
reversalCode auth.rvrl_cde A code specifying the reason for reversal or adjustment
transactions.
Appendix C