Release Noteslink
May 2024link
We have released a new May 2024 schema on May 22, 2024. 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.
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.
149 total changes • 79 possible breaking changes
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ADDRESS | |||||
column | Deprecated Column | customer_id | Data now available in the object_id column. | ||
column | Deprecated Column | supplier_id | Data now available in the object_id column. | ||
column | New Column | address_type | Utilize it for data filtering, encompassing only three values: customer, supplier, and lead. | ||
column | Primary Key Change | object_id 🔑 | New primary key. | ||
ATTACHMENT | |||||
column | Primary Key Change | object_id 🔑 | New primary key. | ||
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. | |
CONTACT | |||||
column | Deprecated Column | customer_id | Data now available in the object_id column. | ||
column | Deprecated Column | supplier_id | Data now available in the object_id column. | ||
column | Primary Key Change | object_id 🔑 | New primary key. | ||
CONTACTS (new table name: CONTACT) | |||||
table | Rename Table | contacts | contact | Updated to adhere to standard naming conventions. | |
CREDIT_NOTE (new table name: PURCHASE_CREDIT_NOTE) | |||||
table | Rename Table | credit_note | purchase_credit_note | Updated to adhere to standard naming conventions. | |
column | Primary Key Change | credit_note_number | credit_note_number 🔑 | Added to primary key. | |
column | Primary Key Change | task_id 🔑 | task_id | No longer primary key. | |
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_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. | ||
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 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | journal_task_id | The field is unnecessary. | ||
column | New Column | journal_number | |||
column | New Column | purchase_id | |||
LEAD | |||||
table | New Table | LEAD | |||
LOCATION | |||||
table | New Table | LOCATION | |||
LOCATION_BIN | |||||
table | New Table | LOCATION_BIN | |||
MARKUP_PRICE (new table name: PRODUCT_MARKUP_PRICE) | |||||
table | Rename Table | markup_price | product_markup_price | Updated to adhere to standard naming conventions. | |
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 | This column is unnecessary. | ||
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 | |||
column | New Column | price | |||
PRODUCT_FAMILY | |||||
column | Deprecated Column | short_description | Can be viewed in the description field. | ||
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_note_number 🔑 | New primary key. | ||
PURCHASE_CREDIT_NOTE_UNSTOCK | |||||
column | Deprecated Column | credit_note_task_id 🔑 | No longer primary key. | ||
column | Primary Key Change | purchase_credit_note_number 🔑 | New primary key. | ||
PURCHASE_INVENTORY_MOVEMENT | |||||
column | Deprecated Column | id | The field is unnecessary. | ||
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 | Primary Key Change | invoice_number | invoice_number 🔑 | Added to primary key. | |
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 | Primary Key Change | task_id 🔑 | task_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 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | purchase_invoice_task_id | 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. | ||
column | New Column | purchase_invoice_number | Added to reflect the changes introduced in the source's latest API version. | ||
PURCHASE_INVOICE_LINE | |||||
column | Deprecated Column | purchase_invoice_task_id 🔑 | No longer primary key. | ||
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 | Primary Key Change | purchase_invoice_number 🔑 | New primary key. | ||
PURCHASE_INVOICE_PAYMENT | |||||
column | Deprecated Column | invoice_task_id | The column is unnecessary. | ||
column | Primary Key Change | purchase_invoice_number 🔑 | New primary key. | ||
PURCHASE_LINE | |||||
table | Deprecated Table | purchase_line | Data available in the PURCHASE_INVOICE_LINE table. | ||
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 is available in the PURCHASE table. | ||
PURCHASE_ORDER_LINE | |||||
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 | Can be calculated by other fields. | ||
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 | |||
TASK | |||||
table | New Table | TASK | |||
ZERO_STOCK_ON_HAND_PRODUCT | |||||
table | New Table | ZERO_STOCK_ON_HAND_PRODUCT |
June 2023link
Lite connectors are now available for the following sources: