These notes are specific to the operation of BCOL.
PAY-API -> BCOL-API -> BCOL WEB SERVICE (SOAP) - Charge Account or Debit Account methods
POST {{pay-api-base-url}}/api/v1/payment-requests
Refunds are not automated for BCOL. When the refund pay-api endpoint
POST {{pay-api-base-url}}/api/v1/payment-requests/{invoiceId}/refunds
is hit a queue event is triggered to the account-mailer in the auth project. It is sent to the emails for the environment variable: BCOL_REFUND_REQUEST_RECIPIENTS.
SBC-PAY calculates the service fee amount and passes it to the bcol_service and determines which BCOL fee code to use and passes that to the BCOL-API.
It determines by the corp_type and service_fee which BCOL fee code to use:
$1.50 or $1.05 -> bcol_code_full_service_fee
$1 -> bcol_code_partial_service_fee
$0 -> bcol_code_no_service_fee
These are the general BCOL fee codes we have in SBC-PAY:
These are the BCOL fees setup in BCONLINE (note we have non-billable fee codes, this is determined by the type of BCOL account):
It's possible to use CPRD to look at payments in BCOL and match them up to payments in SBC-PAY. Example query:
SELECT TS_FEE, RATE, DEV_FEE, TOTAL_AMT FROM BCONLINE_BILLING_RECORD where key = 'REG01788290';
You could include quantity in the query above to determine if it was a refund or not. I'd recommend testing with a billable and non-billable BCOL account.
On the SBC-PAY side it's possible to look at the invoices table, or the transaction table on the staff dashboard.
CSO has a unique implementation as they use a service account to recharge for partial refunds.
They use a service account, which causes the STAFF BCOL fee code to be used typically, but we've overridden this in the segment above.
This allows CSO to bill with a regular BCOL fee code (and avoid the $1 dev fee hopefully).
We have some issues with invoices that seem to disappear (very rarely), not sure if this is an sbc-pay problem or it's BCOL. We're working on a reconciliation platform to make it easier to compare CPRD (BCONLINE data replica) to SBC-PAY.