B1 iPayment Server Component - Authorization Expired

- Runs every 12 hours (Live) - every 12 seconds (Debug)

Workflow:

Gets all expired authorizations for the current gateway

Trust Payments (Secure Trading)
SELECT * FROM "@BOY_E0_AUTH_DATAST" WHERE "U_Gateway" = 1 AND DATEADD(day, (SELECT "U_STREAUTHD" FROM "@BOY_E0_CONFIG"),"U_TimeStamp") < CURRENT_TIMESTAMP

AuthorizeNet

SELECT * FROM "@BOY_E0_AUTH_DATAST" WHERE "U_Gateway" = 2 AND DATEADD(day, (SELECT "U_AUREAUTHD" FROM "@BOY_E0_CONFIG"),"U_TimeStamp") < CURRENT_TIMESTAMP

Cybersource

SELECT * FROM "@BOY_E0_AUTH_DATAST" WHERE "U_Gateway" = 3 AND DATEADD(day, (SELECT "U_CYBERREAUTHDAYS" FROM "@BOY_E0_CONFIG"),"U_TimeStamp") < CURRENT_TIMESTAMP

Eway

SELECT * FROM "@BOY_E0_AUTH_DATAST" WHERE "U_Gateway" = 4 AND DATEADD(day, (SELECT "U_EWAYREAUTHDAYS" FROM "@BOY_E0_CONFIG"),"U_TimeStamp") < CURRENT_TIMESTAMP

Moneris

SELECT * FROM "@BOY_E0_AUTH_DATAST" WHERE "U_Gateway" = 5 AND DATEADD(day, (SELECT "U_MONREAUTHDAYS" FROM "@BOY_E0_CONFIG"),"U_TimeStamp") < CURRENT_TIMESTAMP

Cayan

SELECT * FROM "@BOY_E0_AUTH_DATAST" WHERE "U_Gateway" = 6 AND DATEADD(day, (SELECT "U_CAYANREAUTHDAYS" FROM "@BOY_E0_CONFIG"),"U_TimeStamp") < CURRENT_TIMESTAMP

ProPay

SELECT * FROM "@BOY_E0_AUTH_DATAST" WHERE "U_Gateway" = 7 AND DATEADD(day, (SELECT "U_PROREAUTHDAYS" FROM "@BOY_E0_CONFIG"),"U_TimeStamp") < CURRENT_TIMESTAMP

Square

SELECT * FROM "@BOY_E0_AUTH_DATAST" WHERE "U_Gateway" = 8 AND DATEADD(day, (SELECT "U_SQREAUTHDAYS" FROM "@BOY_E0_CONFIG"),"U_TimeStamp") < CURRENT_TIMESTAMP

Check that status for document is either Authorized or Expired

SELECT "U_Status" FROM "@BOY_E0_DOC_STATUS" WHERE "U_DocEntry" = [docEntry] AND "U_ObjectType" = [objectType]

If the document is open and “@BOY_E0_CONFIG”.”U_AUTOREAUTH” is enabled, we will try performing a reauthorization (Essentially we create a new authorization for the same amount)
Else, if the document status is not yet Expired, we check whether any other authorizations are still authorized, and if not, we mark the document status as Expired.

DocStatus
None = 1,
Authorized = 2,
Settled = 3,
Refunded = 4,
Void = 5,
AuthorizationExpired = 6,
Error = 99