B1 iPayment Server Component - One-time Credit Card link worker

Runs every 5 minutes (Live) - every 5 seconds (Debug)

Workflow:
Get all requests

SELECT * FROM "@BOY_E0_OTCCL" WHERE "U_IDENTIFIER" <> '0' AND "U_OBJECTTYPE" <> ''

If request is older than 30 days request is deleted (and removed from Cloud connector) “U_TIMESTAMP”
Get visited status from Cloud Connector

SELECT Visited FROM [dbo].[AddCreditCardLinks] WHERE Reference = ‘[Reference sent from addon]’ [Note: iPayment Azure DB]

If the link is visited we try to find the card at the gateway
If we find it and there are no existing cards on the document we try to add it (See AddCreditCardMonitor section for details on how each gateway does that)
If the document already has a card or is no longer open an internal message is sent
Then the request is removed from the DB.