Release Notes

---

August 2020

We have added two new tables, PAYMENT and CARD_PAYMENT_DETAILS.

We have added a new column, payment_id, to the REFUND table.

We have added two new columns, card_type and prepaid_type, to the CARD table.

---

January 2020

• We can now delete records with no OrdersFulfillments from the ORDER_FULFILLMENT table.
• You can now configure your Square connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.

---

August 2019

• We have added the following fields to the ORDER table:

  • order_source_name
  • return_amount
  • net_amount
  • rounding_adjustment
  • created_at
  • updated_at
  • closed_at
  • state
  • total_service_charge_money

• We have added the uid field to the following tables:

  • ORDER_LINE_ITEM
  • ORDER_LINE_ITEM_DISCOUNT
  • ORDER_LINE_ITEM_MODIFIER
  • ORDER_LINE_ITEM_TAX

• We have added the order_id field to the TENDER and REFUND tables.

• We have added the following tables to the Square schema:

  • ORDER_RETURN
  • ORDER_RETURN_DISCOUNT
  • ORDER_RETURN_LINE_ITEM
  • ORDER_RETURN_LINE_ITEM_MODIFIER
  • ORDER_RETURN_SERVICE_CHARGE
  • ORDER_RETURN_TAX
  • ORDER_SERVICE_CHARGE

• In order to incorporate changes announced by Square, we will deprecate the TRANSACTION table in the future. All the data in the TRANSACTION table will be available in the ORDER table.

---

April 2019

Square, Inc. is a financial services, merchant services aggregator, and mobile payment company.

Link to Square Documentation