Release Notes
May 2024
We have renamed our DEAR connector to Cin7 Core. This name change applies to the Fivetran dashboard and our documentation.
Effective May 20, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.
These schema changes are required due to the addition of new endpoints.
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.155 total changes • 84 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ADDRESS | |||||
table | Deprecated Table | ADDRESS | Data available in the CUSTOMER_ADDRESS and SUPPLIER_ADDRESS tables. | ||
ATTACHMENT | |||||
table | Deprecated Table | ATTACHMENT | Data available in the PRODUCT_ATTACHMENT , JOURNAL_ATTACHMENT , and PRODUCT_FAMILY_ATTACHMENT tables. | ||
BILL_OF_MATERIAL_PRODUCT | |||||
column | Deprecated Column | wastage_percent | Can be calculated with a query. | ||
BILL_OF_MATERIALS_PRODUCT (new table name: BILL_OF_MATERIAL_PRODUCT) | |||||
table | Rename Table | BILL_OF_MATERIALS_PRODUCT | BILL_OF_MATERIAL_PRODUCT | Updated to adhere to standard naming conventions. | |
BILL_OF_MATERIALS_SERVICE (new table name: BILL_OF_MATERIAL_SERVICE) | |||||
table | Rename Table | BILL_OF_MATERIALS_SERVICE | BILL_OF_MATERIAL_SERVICE | Updated to adhere to standard naming conventions. | |
CONTACTS | |||||
table | Deprecated Table | CONTACTS | Data available in the CUSTOMER_CONTACTS and SUPPLIER_CONTACTS tables. | ||
CREDIT_NOTE (new table name: PURCHASE_CREDIT_NOTE) | |||||
table | Rename Table | CREDIT_NOTE | PURCHASE_CREDIT_NOTE | Updated to adhere to standard naming conventions. | |
CREDIT_NOTE_REFUND (new table name: PURCHASE_CREDIT_NOTE_REFUND) | |||||
table | Rename Table | CREDIT_NOTE_REFUND | PURCHASE_CREDIT_NOTE_REFUND | Updated to adhere to standard naming conventions. | |
CREDIT_NOTE_UNSTOCK (new table name: PURCHASE_CREDIT_NOTE_UNSTOCK) | |||||
table | Rename Table | CREDIT_NOTE_UNSTOCK | PURCHASE_CREDIT_NOTE_UNSTOCK | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | product_id | product_id 🔑 | Added to primary key. | |
CUSTOMER_ADDRESS | |||||
column | Primary Key Change | customer_id | customer_id 🔑 | Added to primary key. | |
CUSTOMER_CONTACTS | |||||
column | Primary Key Change | customer_id | customer_id 🔑 | Added to primary key. | |
column | Deprecated Column | type | The column is unnecessary because it is not returned in the response. | ||
CUSTOMER_PRODUCT_PRICE | |||||
column | Primary Key Change | customer_id | customer_id 🔑 | Added to primary key. | |
column | Deprecated Column | id | The column is unnecessary because it is not returned in the response. | ||
FAMILY_PRODUCT | |||||
column | Deprecated Column | id | The column is unnecessary because it is not returned in the response. | ||
INVENTORY_MOVEMENT (new table name: PURCHASE_INVENTORY_MOVEMENT) | |||||
table | Rename Table | INVENTORY_MOVEMENT | PURCHASE_INVENTORY_MOVEMENT | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | product_id | product_id 🔑 | Added to primary key. | |
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
INVOICE | |||||
table | Deprecated Table | INVOICE | Data available in the PURCHASE_INVOICE table. | ||
INVOICE_ADDITIONAL_CHARGE | |||||
table | Deprecated Table | INVOICE_ADDITIONAL_CHARGE | Data available in the PURCHASE_INVOICE_ADDITIONAL_CHARGE table. | ||
INVOICE_PAYMENT (new table name: PURCHASE_INVOICE_PAYMENT) | |||||
table | Rename Table | INVOICE_PAYMENT | PURCHASE_INVOICE_PAYMENT | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | purchase_id | purchase_id 🔑 | Added to primary key. | |
JOURNAL | |||||
column | Primary Key Change | journal_number | journal_number 🔑 | Added to primary key. | |
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
JOURNAL_ATTACHMENT | |||||
column | Deprecated Column | journal_task_id 🔑 | No longer primary key. | ||
column | Primary Key Change | journal_number 🔑 | New primary key. | ||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
JOURNAL_LINE | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Calculation change. | |
column | Deprecated Column | journal_task_id | The column is unnecessary. | ||
column | New Column | journal_number | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | purchase_id | Added to reflect the changes introduced in the source's latest API version. | ||
LEAD | |||||
table | New Table | LEAD | |||
LOCATION | |||||
table | New Table | LOCATION | |||
LOCATION_BIN | |||||
table | New Table | LOCATION_BIN | |||
MARKUP_PRICE | |||||
table | Deprecated Table | MARKUP_PRICE | Data available in the PRODUCT_MARKUP_PRICE table. | ||
NEW_STOCK_LINE | |||||
table | New Table | NEW_STOCK_LINE | |||
NON_ZERO_STOCK_ON_HAND_PRODUCT | |||||
table | New Table | NON_ZERO_STOCK_ON_HAND_PRODUCT | |||
OPPORTUNITY | |||||
table | New Table | OPPORTUNITY | |||
table | New Table | OPPORTUNITY | |||
OPPORTUNITY_ADDITIONAL_CHARGE | |||||
table | New Table | OPPORTUNITY_ADDITIONAL_CHARGE | |||
OPPORTUNITY_LINE | |||||
table | New Table | OPPORTUNITY_LINE | |||
PRODUCT | |||||
column | Deprecated Column | assembly_instruction_url | The column is unnecessary. | ||
PRODUCT_ATTACHMENT | |||||
column | Deprecated Column | type | The column is unnecessary because it is not returned in the response. | ||
PRODUCT_CUSTOM_PRICE | |||||
column | Deprecated Column | product_cutstom_price_id 🔑 | No longer primary key. | ||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
column | New Column | customer_id | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | price | Added to reflect the changes introduced in the source's latest API version. | ||
PRODUCT_FAMILY | |||||
column | Deprecated Column | short_description | Data available in the description column. | ||
PRODUCT_FAMILY_ATTACHMENT | |||||
column | Deprecated Column | product_family_id | Data available in the object_id column. | ||
column | Primary Key Change | object_id 🔑 | New primary key. | ||
PRODUCT_MARKUP_PRICE | |||||
column | Deprecated Column | id | Data available in the product_id column. | ||
column | Primary Key Change | product_id 🔑 | product_id | No longer primary key. | |
column | New Column | markup_type | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | markup_value | Added to reflect the changes introduced in the source's latest API version. | ||
column | Primary Key Change | tier_number 🔑 | New primary key. | ||
column | New Column | use_price_type | Added to reflect the changes introduced in the source's latest API version. | ||
PRODUCT_MOVEMENT | |||||
column | Primary Key Change | number | number 🔑 | Added to primary key. | |
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
PRODUCT_PRODUCT_FAMILY (new table name: FAMILY_PRODUCT) | |||||
table | Rename Table | PRODUCT_PRODUCT_FAMILY | FAMILY_PRODUCT | Updated to adhere to standard naming conventions. | |
PRODUCT_REORDER_LEVEL | |||||
column | Deprecated Column | location_name | Data available in the LOCATION table. | ||
PURCHASE | |||||
column | Deprecated Column | order_total | Can be calculated by other fields. | ||
column | New Column | blind_receipt | Added to reflect the changes introduced in the source's latest API version. | ||
PURCHASE_CREDIT_NOTE | |||||
column | Deprecated Column | total | Can be calculated by other fields. | ||
column | Deprecated Column | total_before_tax | Can be calculated by other fields. | ||
PURCHASE_CREDIT_NOTE_REFUND | |||||
column | Deprecated Column | credit_note_task_id 🔑 | No longer primary key. | ||
column | Primary Key Change | purchase_credit_not_task_id 🔑 | New primary key. | ||
PURCHASE_CREDIT_NOTE_UNSTOCK | |||||
column | Deprecated Column | credit_note_task_id 🔑 | No longer primary key. | ||
column | Deprecated Column | id | The column is unnecessary because it is not returned in the response. | ||
column | Primary Key Change | purchase_credit_not_task_id 🔑 | New primary key. | ||
PURCHASE_INVENTORY_MOVEMENT | |||||
column | Deprecated Column | id | The column is unnecessary because it is not returned in the response. | ||
PURCHASE_INVOICE | |||||
column | Deprecated Column | advanced_purchase_invoice_purchase_id 🔑 | No longer primary key. | ||
column | Deprecated Column | combine_additional_charges | Can be calculated by other fields. | ||
column | Deprecated Column | invoice_total_amount | Can be calculated by other fields. | ||
column | Deprecated Column | invoice_total_tax_amount | Can be calculated by other fields. | ||
column | Deprecated Column | purchase_list_id 🔑 | No longer primary key. | ||
column | Deprecated Column | tax | Can be calculated by other fields. | ||
column | Deprecated Column | total | Can be calculated by other fields. | ||
column | Deprecated Column | total_before_tax | Can be calculated by other fields. | ||
column | New Column | invoicing_and_receiving_number | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | paid | Added to reflect the changes introduced in the source's latest API version. | ||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
PURCHASE_INVOICE_ADDITIONAL_CHARGE | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Calculation change. | |
column | New Column | purchase_id | Added to reflect the changes introduced in the source's latest API version. | ||
PURCHASE_INVOICE_LINE | |||||
column | Deprecated Column | id | The column is unnecessary because it is not returned in the response. | ||
column | New Column | product_custom_field_1 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_10 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_2 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_3 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_4 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_5 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_6 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_7 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_8 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_9 | Added to reflect the changes introduced in the source's latest API version. | ||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
PURCHASE_INVOICE_PAYMENT | |||||
column | Deprecated Column | invoice_task_id | Data available in the purchase_invoice_task_id column. | ||
column | Primary Key Change | purchase_invoice_task_id 🔑 | New primary key. | ||
PURCHASE_LINE | |||||
table | Deprecated Table | PURCHASE_LINE | The table is unnecessary because it is not returned in the response. | ||
PURCHASE_LIST | |||||
table | Deprecated Table | PURCHASE_LIST | Data available in the PURCHASE table. | ||
PURCHASE_ORDER | |||||
table | Deprecated Table | PURCHASE_ORDER | Data available in the PURCHASE table. | ||
PURCHASE_ORDER_ADDITIONAL_CHARGE | |||||
table | Deprecated Table | PURCHASE_ORDER_ADDITIONAL_CHARGE | Data available in the PURCHASE table. | ||
PURCHASE_ORDER_LINE | |||||
column | Deprecated Column | id | The column is unnecessary because it is not returned in the response. | ||
column | Deprecated Column | purchase_order_task_id 🔑 | No longer primary key. | ||
column | Deprecated Column | tax | Can be calculated by other fields. | ||
column | Deprecated Column | total | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | dimensions_unit | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_1 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_10 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_2 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_3 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_4 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_5 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_6 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_7 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_8 | Added to reflect the changes introduced in the source's latest API version. | ||
column | New Column | product_custom_field_9 | Added to reflect the changes introduced in the source's latest API version. | ||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
column | New Column | quantity | Added to reflect the changes introduced in the source's latest API version. | ||
PURCHASE_STOCK_AND_PUT_AWAY_STATUS | |||||
column | Primary Key Change | purchase_id 🔑 | New primary key. | ||
PURCHASE_STOCK_STATUS (new table name: PURCHASE_STOCK_AND_PUT_AWAY_STATUS) | |||||
table | Rename Table | PURCHASE_STOCK_STATUS | PURCHASE_STOCK_AND_PUT_AWAY_STATUS | Updated to adhere to standard naming conventions. | |
SALE | |||||
table | New Table | SALE | |||
SALE_ATTACHMENT | |||||
table | New Table | SALE_ATTACHMENT | |||
SALE_CREDIT_NOTE | |||||
table | New Table | SALE_CREDIT_NOTE | |||
SALE_CREDIT_NOTE_ADDITIONAL_CHARGE | |||||
table | New Table | SALE_CREDIT_NOTE_ADDITIONAL_CHARGE | |||
SALE_CREDIT_NOTE_LINE | |||||
table | New Table | SALE_CREDIT_NOTE_LINE | |||
SALE_CREDIT_NOTE_REFUND | |||||
table | New Table | SALE_CREDIT_NOTE_REFUND | |||
SALE_CREDIT_NOTE_RESTOCK | |||||
table | New Table | SALE_CREDIT_NOTE_RESTOCK | |||
SALE_FULLFILLMENT | |||||
table | New Table | SALE_FULLFILLMENT | |||
SALE_FULLFILLMENT_PACK_LINE | |||||
table | New Table | SALE_FULLFILLMENT_PACK_LINE | |||
SALE_FULLFILLMENT_PICK_LINE | |||||
table | New Table | SALE_FULLFILLMENT_PICK_LINE | |||
SALE_FULLFILLMENT_SHIP_LINE | |||||
table | New Table | SALE_FULLFILLMENT_SHIP_LINE | |||
SALE_INVENTORY_MOVEMENT | |||||
table | New Table | SALE_INVENTORY_MOVEMENT | |||
SALE_INVOICE | |||||
table | New Table | SALE_INVOICE | |||
SALE_INVOICE_ADDITIONAL_CHARGE | |||||
table | New Table | SALE_INVOICE_ADDITIONAL_CHARGE | |||
SALE_INVOICE_LINE | |||||
table | New Table | SALE_INVOICE_LINE | |||
SALE_ORDER_ADDITIONAL_CHARGE | |||||
table | New Table | SALE_ORDER_ADDITIONAL_CHARGE | |||
SALE_ORDER_LINE | |||||
table | New Table | SALE_ORDER_LINE | |||
SALE_QUOTE_ADDITIONAL_CHARGE | |||||
table | New Table | SALE_QUOTE_ADDITIONAL_CHARGE | |||
SALE_QUOTE_LINE | |||||
table | New Table | SALE_QUOTE_LINE | |||
SALE_TRANSACTION | |||||
table | New Table | SALE_TRANSACTION | |||
STOCK_ADJUSTMENT | |||||
table | New Table | STOCK_ADJUSTMENT | |||
STOCK_ADJUSTMENT_TRANSACTION | |||||
table | New Table | STOCK_ADJUSTMENT_TRANSACTION | |||
STOCK_TAKE | |||||
table | New Table | STOCK_TAKE | |||
STOCK_TAKE_TRANSACTION | |||||
table | New Table | STOCK_TAKE_TRANSACTION | |||
STOCK_TRANSFER | |||||
table | New Table | STOCK_TRANSFER | |||
STOCK_TRANSFER_LINE | |||||
table | New Table | STOCK_TRANSFER_LINE | |||
STOCK_TRANSFER_ORDER_LINE | |||||
table | New Table | STOCK_TRANSFER_ORDER_LINE | |||
SUPPLIER_ADDRESS | |||||
column | Primary Key Change | supplier_id | supplier_id 🔑 | Added to primary key. | |
SUPPLIER_CONTACTS | |||||
column | Primary Key Change | supplier_id | supplier_id 🔑 | Added to primary key. | |
column | Deprecated Column | type | The column is unnecessary because it is not returned in the response. | ||
TASK | |||||
table | New Table | TASK | |||
ZERO_STOCK_ON_HAND_PRODUCT | |||||
table | New Table | ZERO_STOCK_ON_HAND_PRODUCT |
June 2023
Lite connectors are now available for the following sources: