Reports
Bank rails & accounts

Daily RTP activity

7min

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:

  • API
  • Clearing House (for inbound payments)
  • Partner Portal (when a partner user enters a payment request in COS Explorer)
  • Ops Portal (when CRB Ops enters a payment request in COS Explorer)

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.

Outbound Request for Payment

Document image


Inbound request for payment

Document image


Enum Values for Payment Type

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

Document image

Document image


Values for Payment Source

TypeName

Value

Description

PaymentSource

0

Phone

PaymentSource

1

Fax

PaymentSource

2

Email

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

Document image

Document image


ConfirmedAdditionalInfo values

Document image




🤔
Have a question?
Our super-smart AI, knowledgeable support team and an awesome community will get you an answer in a flash.
To ask a question or participate in discussions, you'll need to authenticate first.