setl

A transaction was settled. The amount has been posted to the specified account. Available balance has changed only if the settlement amount was different from the authorization amount or if the transaction was force-posted. For information on multi-clearing settlements, see Incremental clearing in the Settlement guide.

  • CodeSETL
  • Event trigger — One of the following takes place:
    • Galileo matches the transaction in the card network's batch file with a transaction in its database and posts the settlement.
    • Galileo receives a clearing message for a transaction for which there is no matching authorization and posts the settlement.
  • Process — This process contains the event trigger:
    • Galileo receives a clearing batch file from a card network, and Galileo compares the transactions in the batch file with its own authorization records.

Fields

All fields are strings. Your field names may vary. Default fields are included in the default webhook template. See Default and optional fields for more information.

Field Default Description
act_type X

See Activity Type for possible values. Example: "SE"

amount X

Amount of the settlement. Example: "25.33"

atm_fee

Amount of the ATM fee when mcc: 6011. Not included in amount. Example: "2.50"

auth_id X

Galileo-generated ID for the authorization request. This ID is unique per subnetwork. Example: "12303090"

avail_cash

For debit accounts, the open_to_buy plus available overdraft. Example: "143.11"

avail_credit

For credit accounts, the available credit limit to spend. Example: "432.00"

balance_id X

The balance ID, also called the galileo_account_number. Example: "20211"

billing_amt

Amount to be billed in the currency of the cardholder account (DE006). Example: "24.35"

billing_curr_code

Currency code for billing_amt (DE051). Example: "840"

bookkeeping_auth_id*

Incremental clearing only. The auth_id of the bookkeeping authorization record that is next in the series. Example: "108932"

cad X

Galileo-generated card ID. Example: "12534"

client_id

ID for the customer record. Example: "264539"

credit_balance

For credit accounts, the total amount of unpaid purchases and advances. Example: "325.00"

currency

Currency code for amount, which is the currency of the cardholder account.. Example: "840"

de022

Raw contents of DE022, POS entry mode. See DE022 Codes for possible values. Example: "071"

de063

Additional network information. Example: "MS0337870429"

de39

See Authorization Response Codes for possible values. Example: "00"

driver_number

Driver ID. Fleet cards only. Example: "06123456"

expired_auth_id

The auth_id of the expired authorization that matches this settlement.

fund_pastotb_adj

The available balance of the RTF or Corporate Credit funding account after this transaction takes place. Example: "24365.90"

fund_pmt_ref_no

The PRN of the RTF or Corporate Credit funding account that is associated with this spending account. Example: "122101354223"

interchange_fee

Interchange fee from the network. Example: "0.10059836"

local_currency

Currency code for local_currency_amount (DE049). Example: "124"

local_currency_amount

Amount of the transaction in the currency at the point of sale (DE004). No fees or upcharges included. Example: "1245.20"

mc_installment_detail

Contents of PDS0663. See MSI Installments data to interpret the code. Example: "030600484"

mcc X

Merchant category code (DE018). Example: "5712"

merchant

Concatenation of merchant_name and merchant_location. Example: "RIDESHARE.COM/CHARGES, SAN FRANCISCO, CA"

merchant_location X

Merchant city and state (from remaining part of ISO DE043). Example: "NEW YORK, NY"

merchant_name X

Merchant name (first 22 characters of DE043). Should not be used for matching; instead, use merchant_number. Example: "Widgets Incorporated"

merchant_number X

Merchant number (DE042). Example: "L4DIV6D5LM4X7LF"

merchant_postal_code

The postal code for the merchant. Example: "10021"

msg_event_id

Unique Galileo-generated identifier for this message. Example: "243693"

msg_id

The four-letter code to identify this event. Example: "SETL"

multi_count

Total number of settlements in the sequence. Example: "3"

multi_number

Number in the sequence for this settlement. Example: "2"

network X

See Events Network Codes for possible values. Example: "M"

open_to_buy X

The available balance to spend. Example: "500.00"

opentobuy_ts

The exact date-time at which open_to_buy was captured. Format: YYYY-MM-DD hh:mm:ss.ssssss Example: "2023-03-17 14:06:50.243654"

original_auth_id

The ID of a prior authorization in the sequence. For example, for a completion, this is the auth_id of the preauthorization. For a reversal, this is the auth_id of the transaction that is being reversed. Example: "12303085"

original_multiclearing_auth_id*

Incremental clearing only. The auth_id of the original preauthorization. Example: "456012"

otype X

See Transaction Types for possible values. Example: "5"

pds0180

The tax ID associated with the transaction. This is also known as the Domestic Card Acceptor Tax ID. Required for clients operating in LATAM. Example: "MEX1234567".

pmt_ref_no X

Galileo 12-digit payment reference number (PRN) for the account. Example: "155101003022"

post_date

Date that the transaction posted to the cardholder account. Format: MM/DD/YYYY Example: "03/18/2023"

prod_id X

The product ID of the account. Example: "1701"

prog_id X

The program ID of the account. Example: "305"

rate_date

Mexico domestic only. The date/time at which usd_amt was calculated. Format: YYYY-MM-DD hh:mm:ss Example: "2023-10-10 00:05:00"

rate_id

Mexico domestic only. Identifier for rate_value, which was used to calculate usd_amt. Example: "2366"

rate_value

Mexico domestic only. Rate from Banco de México. Formula: USD x rate_value = MXP. However, the transaction will settle using the rate from Mastercard. Example: "16.8367"

remaining_amount*

Incremental clearing only. The amount of the preauthorization that has not been cleared yet. Example: "6.45"

response_code

See Authorization Response Codes for possible values. Example: "00"

rrn

Retrieval reference number (DE037). Format: Julian date YDDDxxxxxxxx Mastercard only. Example: "314293027549"

settle_currency

Currency code for settle_currency_amount. Example: "840"

settle_currency_amount

Amount of the settlement in the settlement currency. Example: "35.44"

settle_detail_id X

ID that maps back to the settlement record for the transaction. Example: "13354855"

signed_amount

The amount of the settlement plus a negative sign (-) when the amount debits the open_to_buy. This field is not populated in CV. Example: "-25.34"

timestamp X

Date-time when this event was created in Mountain Standard Time (GMT -0700). Format: YYYY-MM-DD hh:mm:ss MST Example: "2025-01-31 17:20:33 MST"

type X

The name of this event: "setl"

usd_amt

Mexico domestic only. The amount of the transaction in U.S. dollars, according to the Banco de México rate in rate_value. However, the transaction settles using the Mastercard rate. Example: "24.00"

user_data

Populated according to your use case and needs by arrangement with Galileo.

vehicle_number

Vehicle ID. Fleet cards only. Example: "03123"

* For existing clients these multi-clearing fields must be enabled by request. The fields might have different names. Check with Galileo for the names used by your program.

Example

# setl example:
{
  "act_type": "SE",
  "amount": "25.33",
  "auth_id": "12303090",
  "avail_cash": "143.11",
  "balance_id": "20211",
  "billing_amt": "24.35",
  "billing_curr_code": "840",
  "bookkeeping_auth_id*": "108932",
  "cad": "12534",
  "client_id": "264539",
  "credit_balance": "325.00",
  "currency": "840",
  "de022": "071",
  "de063": "MS0337870429",
  "de39": "00",
  "driver_number": "06123456",
  "interchange_fee": "0.10059836",
  "local_currency": "124",
  "local_currency_amount": "1245.20",
  "mc_installment_detail": "030600484",
  "mcc": "5712",
  "merchant": "RIDESHARE.COM/CHARGES, SAN FRANCISCO, CA",
  "merchant_location": "NEW YORK, NY",
  "merchant_name": "Widgets Incorporated",
  "merchant_number": "L4DIV6D5LM4X7LF",
  "merchant_postal_code": "10021",
  "msg_event_id": "243693",
  "msg_id": "SETL",
  "multi_count": "3",
  "multi_number": "2",
  "network": "M",
  "open_to_buy": "500.00",
  "opentobuy_ts": "2023-03-17 14:06:50.243654",
  "original_auth_id": "12303085",
  "original_multiclearing_auth_id*": "456012",
  "otype": "5",
  "pds0180": "MEX1234567",
  "pmt_ref_no": "155101003022",
  "post_date": "03/18/2023",
  "prod_id": "1701",
  "prog_id": "305",
  "remaining_amount*": "6.45",
  "response_code": "00",
  "settle_currency": "840",
  "settle_currency_amount": "35.44",
  "settle_detail_id": "13354855",
  "timestamp": "2025-01-31 17:20:33 MST",
  "type": "setl",
  "vehicle_number": "03123"
}