| Parameter | Data Type | M/O/C | Description |
|---|---|---|---|
| payment_method | Varchar(1) | M | Indicates the payment mode used for this transaction. |
| merchantid | Varchar (30) | M | Your Faspay e-Payment Merchant ID |
| merchant_tranid | Varchar(100) | M | Merchant’s own assigned transaction id as passed in from the request. |
| err_code | Varchar(10) | M | Error Code returns from Faspay e-Payment. If transaction is successful, this value will be 0. Any other value than 0 will indicate that the transaction is not successful. |
| err_desc | Varchar(250) | M | Error description from Faspay e-Payment based on the ERR_CODE. |
| usr_code | Varchar(4) | C | User Code returns from Faspay e-Payment. A user code will be used to indicate the appropriate action to be taken by shopper according to different bank response code obtained. In the case of pending status, this value is will an empty value |
| usr_msg | Varchar(200) | C | User Message returns from Faspay e-Payment. A user message will be used to indicate the appropriate action to be taken by shopper according to different bank response code obtained. In the case of pending status, this value is will an empty value |
| txn_status | Varchar(3) | M | Transaction status from Faspay e-Payment. Please refer to Appendix B for full list of transaction status. A – Authorized S – Sales F – Not approved E – Error B – Blocked RC – Reconfirm N – Pending I – Incomplete This value must be stored and it’s the indication whether the transaction is successful, declined or error. |
| custname | Varchar(120) | C | Shopper’s name. In the event of error, this field may be empty. |
| description | Varchar(100) | O | Transaction description as passed in from the request. |
| eui | Varchar(3) | M | End User Indicator (EUI) is use to help merchant determine the response to display on merchant return URL. Please refer to Appendix section for further details. SUC = Success RTY = Retry/Failed ALT = Alert NA = Not Applicable |
| currencycode | Varchar(3) | M | Indicate the currency of this transaction. E.g. MYR, USD, SGD etc. |
| amount | Numeric(10) | M | Transaction amount as passed in from the request. |
| signature | Varchar(40) | M | Transaction signature of response for data integrity checking. Refer to Chapter 5 Transaction Signature for details. |
| transactionid | Integer | M | Faspay e-Payment assigned transaction id if the transaction was stored. This value must be stored and used as reference value to retrieve the transaction from Faspay e-Payment. In the event that if the request parameters are invalid, the transaction is rejected and not stored, this value will be 0. |
| trandate | Varchar (19) | C | Transaction date of when transaction is submitted to Faspay e-Payment. Date format in ‘DD-MM-YYYY hh:mm:ss’ e.g. 24-05-2006 08:24:23 In the event of error, this field may be empty. |
| transactiontype | Varchar(2) | M | Return transaction type corresponding to the original request |