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