3.1.2 Payment Details
Entity Name: PYMT
Description: This table holds payment details data from product processor.
Data Sequence:
PYMT|Account Number|Transaction Reference Number|Transaction Date and Time|Value DateI Transaction Currency|Transaction Amount|Narration Text|Transaction Type Flag|Original Transaction ref number|Transaction sub sequence number|Original Transaction sub sequence number|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10|udf11|udf12|udf13|udf14|udf15|udf16|udf17|udf18|udf19|udf20|udf21|udf22|udf23|udf24|udf25|udf26|udf27|udf28|udf29|udf30|udf31|udf32|udf33|udf34|udf35|udf36|udf37|udf38|udf39|udf40|udf41|udf42|udf43|udf44|udf45|udf46|udf47|udf48|udf49|udf50
Table 3-2 Payment Details
Field Name | Description | Possible Values / Examples | Data Type | Data Length | Required/Optional |
---|---|---|---|---|---|
Account No | Account Number as stored in Host | - | VARCHAR2 | 30 | Required |
Transaction Reference Number | Transaction Reference Number for payment transaction in host | - | VARCHAR2 | 30 | Required |
Transaction Date and Time | Date and Time of Transaction | - | DATE & TIME | - | Required |
Value Date | Value Date on which the transaction was posted in the host | - | DATE | - | Required |
Transaction Currency | Currency code of the transaction | - | VARCHAR2 | 3 | Required |
Transaction Amount | Payment Amount | - | NUMBER | 36,18 | Required |
Narration Text | Narration text for the transaction | - | VARCHAR2 | 240 | Optional |
Transaction Type Flag | Identify if the transaction is Credit or Debit. |
C - For Credit D - For Debit |
CHAR | 1 | Required |
Original Transaction ref number | Used for cancellation of payments | - | VARCHAR2 | 30 | Optional |
Transaction sub sequence number | Transaction sequence number | - | VARCHAR2 | 30 | Optional |
Original Transaction sub sequence number | Used for cancellation of payments | - | VARCHAR2 | 30 | Optional |
Parent topic: Account Data