Release Noteslink
February 2021link
We have added a new table, CASH_DRAWERS
. See Square's documentation on cash drawers for more information.
January 2021link
We have added a new field, customer_id
, to the ORDER
table. See Square's Order object documentation for more information.
We have added two new columns, present_at_location_ids
and absent_at_location_ids
, to the CATALOG_OBJECT
table.
August 2020link
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 2020link
-
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 2019link
-
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 theTENDER
andREFUND
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 theTRANSACTION
table will be available in theORDER
table.
April 2019link
Square, Inc. is a financial services, merchant services aggregator, and mobile payment company.