
Eftposreceipts Database Table
Additional information received from eftpos payment providers about the eftpos transaction. This is a simple best effort log of data received.
See also: eftposreceipts2
Distrbuted Access: Application controlled
Fields
- eftrid
- #100, Datatype: Integer
- sid
- #101, Datatype: Integer
- datetime
- #102, Datatype: DateTime
- stan
- #103, Datatype: Integer
- pan
- #104, Datatype: String 24 bytes
Customers Primary Account Number as reported by the eftpos provider, if available. - pansource
- #105, Datatype: String 8 bytes
- txntype
- #106, Datatype: String 8 bytes
Type of transaction that occurredPossible Values
Value Description P Payment PF Payment failed R Refund RF Refund failed N Non payment transaction NF Non payment transaction failed - txn_duration
- #107, Datatype: Integer
How long, in seconds, the Eftpos system took to respond to the POS after payment was requested - receipt0
- #109, Datatype: String 250 bytes
- receipt1
- #110, Datatype: String 250 bytes
- receipt2
- #111, Datatype: String 250 bytes
- receipt3
- #112, Datatype: String 250 bytes
- srcuid
- #114, Datatype: Integer
- srcuidkey
- #115, Datatype: Integer
- physkey
- #121, Datatype: String 44 bytes
- physkey
- #122, Datatype: String 44 bytes
- motoflag
- #123, Datatype: Integer
Set to 1 if transaction was probably a MOTO payment