Daily RTP activity
This document explains the RTP Daily Activity report. This report lets you see all RTP payments for a single given COS partner.
You can use this report to reconcile between what you requested from COS and what COS actually processed.
Glossary
Term | Description |
---|---|
COS | Cross River Bank Operating System |
Partner | CRB’s immediate customer, i.e. you |
The table below shows the different columns included in the report together with descriptions and explanations of the information they represent.
Column | Description |
---|---|
TransactionId | The unique identification number for the related core transaction. |
TransactionAmount | The dollar amount of the payment. |
PaymentStatus | The payment status in COS. |
Payment_TypeName | The core transaction type. For a full list of payment types, see below. |
PaymentSource | The source initiating the payment. This may be one of the following:
|
PartnerName | The name of the COS partner participating in the payment. |
ProductName | The COS product name for the COS account participating in the payment. |
ClientIdentifier | An optional unique internal identifier for the payment, defined by the partner. Note: COS does not enforce uniqueness or idempotency based on this value. It is, however, an important part of implementing a partner’s idempotency solution. This value can be used to search for a payment to check if COS had successfully processed your request when in doubt. This should not be done if the response indicates success. It is only to be used in edge cases when there is doubt regarding the response (i.e. an exception occurred). For more information, see here see here. |
DebtorName | The debtor name for the payment. This can be either the COS customer or external debtor, based on the direction of the payment. |
AccountNumber | The COS master account involved in the payment. |
SubAccountNumber | The COS sub ledger account involved in the payment. |
CreditorName | The creditor name for the payment. This can be either the COS customer or external creditor, based on the direction of the payment. |
CreditorAccountNumber | The creditor account number. This can be the account number for either the COS customer or the external customer, based on the direction of the payment. |
Direction_Desc | The payment direction (Inbound or Outbound). |
Purpose | The payment purpose. |
ReferenceId | The payment reference ID in COS. |
SentAt | The date and time the payment was executed. |
CompletedAt | The date and time the payment completed. |
RejectedAt | The date and time the payment was rejected. If this field is populated, then the CompletedAt field is always empty. |
RTPTransactionStatus | Status of the RTP transaction as reported by the receiving institution. For a list of statuses, see the RtpTransactionStatus table below. |
ConfirmedTransactionStatus | The RTP transaction status, as reported by the receiving institution and confirmed by COS. For information on available statuses, see here. |
ConfirmedReasonCode | The reason the payment did not complete, as confirmed by COS. For information on available reason codes, see below. |
ConfirmedAdditionalInfo | Additional payment information, as confirmed by COS. For a list of values, see ConfirmedAdditionalInfo below. |
TypeName | Value | Description |
---|---|---|
PaymentTypes | 0 | Credit Transfer |
PaymentTypes | 1 | System Timeout |
PaymentTypes | 2 | Return Request |
PaymentTypes | 3 | Return Response |
PaymentTypes | 4 | Remittance Advice |
PaymentTypes | 5 | Request For Information |
PaymentTypes | 6 | Payment Ack |
PaymentTypes | 7 | Request For Payment |
PaymentTypes | 8 | Request For Payment Response |
PaymentTypes | 9 | Request For Information Response |
PaymentTypes | 10 | Request For Payment Cancellation |
PaymentTypes | 99 | Unknown |
TypeName | Value | Description |
---|---|---|
PaymentSource | 0 | Phone |
PaymentSource | 1 | Fax |
PaymentSource | 2 | |
PaymentSource | 3 | Clearing House |
PaymentSource | 4 | Api |
PaymentSource | 5 | Rtp System Timeout |
PaymentSource | 6 | Ops Portal |
PaymentSource | 7 | Partner Portal |
PaymentSource | 8 | Return Of Funds |
PaymentSource | 9 | Auto Resend |