ReconcilePostedTransactionEvent

What is it?

This is an event we create manually in case of missing transaction (see looker dashboard to follow mismatch betweeen Galileo RDF and our list of transactions in DW)
To reconcile missing transactions we create 'ReconcilePostedTransactionEvent' events that are picked up by Galileo service
What do we put in these events?
Here is an example:

{
    "AccountId": 178599,
    "ActivityType": {
        "Name": "Adjustment",
        "Value": "AD"
    },
    "Amount": -65.0000,
    "AuthId": 10433868,
    "CardId": null,
    "Currency": null,
    "ExternalTransactionId": "dde89692-f375-4cbc-8",
    "Mcc": null,
    "MerchantCountry": null,
    "MerchantId": null,
    "MerchantLocation": null,
    "MerchantName": null,
    "MerchantNameAndLocation": null,
    "MerchantState": null,
    "Network": null,
    "OType": "M",
    "PaymentReferenceNumber": "552106914120",
    "PostDate": "2024-04-03T06:00:00.0000000Z",
    "ProductId": 26264,
    "ProgramId": 2631,
    "Timestamp": "2024-04-03T13:03:11.0000000Z",
    "TransactionType": "ADM",
    "UserData1": null,
    "UserData2": null
}

Known issues

• Receiving settlement event (todo: find exact name of the event) before creating the ReconcilePostedTransactionEvent seem to block the flow (todo: explain more).