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.
Comments
0 comments
Please sign in to leave a comment.