B1 iPayment Server Component - Scheduled Actions worker

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

Workflow:
Get all active schedules

SELECT * FROM "@BOY_E0_SCHEDULE" WHERE "U_GATEWAY" = [Gateways value] AND "U_ACTIVE" = 'Y'

Get all SAP documents depending on FormType and the WHERE condition in the schedule
Filters the documents so only the ones who fulfill the following criteria are processed:
- Document is open
- OpenDocTotal is > 0
- “U_BOY_E0_CCPAYEX” is ‘Y’ or ‘B’
For each document we get the One-time credit card entry or the default BP card depending on value of “U_BOY_E0_ONETIMCC”
One-time:

SELECT * FROM "@BOY_E0_OTCC" WHERE "U_DOCENTRY" = [docEntry] AND "U_OBJECTTYPE" = [objectType]

BP default by contact person:

SELECT * FROM "@BOY_E0_CREDITCAEX" WHERE "U_CardCode" = [“CardCode” from document] AND "U_CONTACTPERSON" = [“CntctCode” from document]

BP default:

SELECT * FROM "@BOY_E0_CREDITCAEX" WHERE "U_TransRef" = (SELECT U_DefaultCard FROM "@BOY_E0_BPEXT" WHERE "U_CardCode" = ["CardCode" from document])

Then we proceed to process the line depending on the “U_ACTIONTYPE” field on the schedule.

ScheduledActionTypes
Authorize = 0,
Settle = 1

We perform the authorization/settlement and add a log entry.
Then we send an internal message with all of the results of the schedule transactions.