B1 iPayment Server Component - PayNow link worker

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

Workflow:
Get all requests for current Gateway

SELECT * FROM "@BOY_E0_PAYNOWR" WHERE "U_GATEWAY" = [Gateways value]

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

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

Get transaction details from the gateway
-----------------------------------------------------------
Cybersource gets the details from the Cloud Connector instead

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

------------------------------------------------------------
If transaction details are found, they are imported into the “@BOY_E0_AUTH_DATAST” table as a GatewayInteractionLine.
If the document is open, we create an Incoming Payment on the document.
If the document has been closed, we create a direct payment on account.
Then we send an internal message about a new payment being received.