Release Noteslink

February 2021link

We have added a new table, CASH_DRAWERS. See Square's documentation on cash drawers for more information.

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.

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.

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.

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.

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