Cin7 Omni Connector Reference

59 metrics180 dimensions

The Cin7 Omni connector exposes 239 fields (59 metrics, 180 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Cin7 Omni Fields

Cin7 Omni credit_note_line_items fields

The credit_note_line_items report of the Cin7 Omni connector includes 14 fields.

ID Type Name Description
credit_note_line_items__barcode TEXT credit_note_line_items.barcode Barcode.
credit_note_line_items__code TEXT credit_note_line_items.code Line item code.
credit_note_line_items__cogs NUMERIC credit_note_line_items.cogs Cost of goods sold for the line (unit cost times quantity).
credit_note_line_items__credit_note_id TEXT credit_note_line_items.credit_note_id Parent credit note ID.
credit_note_line_items__discount NUMERIC credit_note_line_items.discount Line item discount.
credit_note_line_items__line_id TEXT credit_note_line_items.line_id Line item ID.
credit_note_line_items__name TEXT credit_note_line_items.name Line item name.
credit_note_line_items__product_id TEXT credit_note_line_items.product_id Line item product ID.
credit_note_line_items__product_option_id TEXT credit_note_line_items.product_option_id Product option ID.
credit_note_line_items__qty NUMERIC credit_note_line_items.qty Line item quantity.
credit_note_line_items__qty_shipped NUMERIC credit_note_line_items.qty_shipped Line item quantity shipped.
credit_note_line_items__style_code TEXT credit_note_line_items.style_code Style code.
credit_note_line_items__unit_cost NUMERIC credit_note_line_items.unit_cost Line item unit cost.
credit_note_line_items__unit_price NUMERIC credit_note_line_items.unit_price Line item unit price.

Cin7 Omni credit_notes fields

The credit_notes report of the Cin7 Omni connector includes 25 fields.

ID Type Name Description
credit_notes__branch_id TEXT credit_notes.branch_id Branch ID.
credit_notes__company TEXT credit_notes.company Customer company.
credit_notes__completed_date TIMESTAMP credit_notes.completed_date Completion timestamp.
credit_notes__created_date TIMESTAMP credit_notes.created_date Credit note creation timestamp.
credit_notes__credit_note_date TIMESTAMP credit_notes.credit_note_date Credit note date.
credit_notes__credit_note_id TEXT credit_notes.credit_note_id Credit note ID.
credit_notes__credit_note_number TEXT credit_notes.credit_note_number Credit note number.
credit_notes__currency_code TEXT credit_notes.currency_code Currency code.
credit_notes__currency_rate NUMERIC credit_notes.currency_rate Currency exchange rate.
credit_notes__discount_total NUMERIC credit_notes.discount_total Discount total.
credit_notes__email TEXT credit_notes.email Customer email.
credit_notes__freight_total NUMERIC credit_notes.freight_total Freight total.
credit_notes__is_approved BOOLEAN credit_notes.is_approved Whether the credit note is approved.
credit_notes__member_id TEXT credit_notes.member_id Customer member ID.
credit_notes__modified_date TIMESTAMP credit_notes.modified_date Modification timestamp.
credit_notes__product_total NUMERIC credit_notes.product_total Product total.
credit_notes__reference TEXT credit_notes.reference Credit note reference.
credit_notes__sales_person_id TEXT credit_notes.sales_person_id Sales person ID.
credit_notes__sales_reference TEXT credit_notes.sales_reference Reference to the original sales order.
credit_notes__source TEXT credit_notes.source Credit note source.
credit_notes__status TEXT credit_notes.status Credit note status.
credit_notes__surcharge NUMERIC credit_notes.surcharge Surcharge.
credit_notes__tax_rate PERCENT credit_notes.tax_rate Tax rate.
credit_notes__tax_status TEXT credit_notes.tax_status Tax status.
credit_notes__total NUMERIC credit_notes.total Credit note total.

Cin7 Omni payments fields

The payments report of the Cin7 Omni connector includes 14 fields.

ID Type Name Description
payments__amount NUMERIC payments.amount Payment amount.
payments__batch_reference TEXT payments.batch_reference Batch reference.
payments__branch_id TEXT payments.branch_id Branch ID.
payments__created_date TIMESTAMP payments.created_date Payment creation timestamp.
payments__is_authorized BOOLEAN payments.is_authorized Whether the payment is authorized.
payments__method TEXT payments.method Payment method.
payments__modified_date TIMESTAMP payments.modified_date Payment modification timestamp.
payments__order_id TEXT payments.order_id Order ID the payment applies to.
payments__order_ref TEXT payments.order_ref Order reference.
payments__order_type TEXT payments.order_type Order type.
payments__payment_date TIMESTAMP payments.payment_date Payment timestamp.
payments__payment_id TEXT payments.payment_id Payment ID.
payments__reconcile_date TIMESTAMP payments.reconcile_date Reconciliation timestamp.
payments__transaction_ref TEXT payments.transaction_ref Transaction reference.

Cin7 Omni product_options fields

The product_options report of the Cin7 Omni connector includes 21 fields.

ID Type Name Description
product_options__barcode TEXT product_options.barcode Barcode.
product_options__created_date TIMESTAMP product_options.created_date Option creation timestamp.
product_options__modified_date TIMESTAMP product_options.modified_date Option modification timestamp.
product_options__option_1 TEXT product_options.option_1 Option 1 value.
product_options__option_2 TEXT product_options.option_2 Option 2 value.
product_options__option_3 TEXT product_options.option_3 Option 3 value.
product_options__option_barcode TEXT product_options.option_barcode Product option barcode.
product_options__option_code TEXT product_options.option_code Product option code.
product_options__option_id TEXT product_options.option_id Product option ID.
product_options__price_columns TEXT product_options.price_columns Account price lists as a JSON object.
product_options__product_id TEXT product_options.product_id Parent product ID.
product_options__retail_price NUMERIC product_options.retail_price Retail price.
product_options__size TEXT product_options.size Size.
product_options__special_price NUMERIC product_options.special_price Special price.
product_options__status TEXT product_options.status Option status.
product_options__stock_available NUMERIC product_options.stock_available Available quantity for the option.
product_options__stock_on_hand NUMERIC product_options.stock_on_hand Stock on hand for the option.
product_options__style_code TEXT product_options.style_code Parent product style code.
product_options__supplier_code TEXT product_options.supplier_code Supplier code.
product_options__vip_price NUMERIC product_options.vip_price VIP price.
product_options__wholesale_price NUMERIC product_options.wholesale_price Wholesale price.

Cin7 Omni products fields

The products report of the Cin7 Omni connector includes 21 fields.

ID Type Name Description
products__brand TEXT products.brand Brand.
products__category TEXT products.category Category.
products__created_date TIMESTAMP products.created_date Product creation timestamp.
products__description TEXT products.description Product description.
products__height NUMERIC products.height Product height.
products__image_url IMAGE_URL products.image_url URL of the first product image.
products__length NUMERIC products.length Product length.
products__modified_date TIMESTAMP products.modified_date Product modification timestamp.
products__order_type TEXT products.order_type Order type.
products__product_id TEXT products.product_id Product ID.
products__product_name TEXT products.product_name Product name.
products__product_type TEXT products.product_type Product type.
products__status TEXT products.status Product status.
products__stock_control BOOLEAN products.stock_control Whether stock is controlled.
products__style_code TEXT products.style_code Style code.
products__sub_category TEXT products.sub_category Product sub-category.
products__supplier_id TEXT products.supplier_id Default supplier ID.
products__tags TEXT products.tags Comma-separated product tags.
products__volume NUMERIC products.volume Product volume.
products__weight NUMERIC products.weight Product weight.
products__width NUMERIC products.width Product width.

Cin7 Omni purchase_order_line_items fields

The purchase_order_line_items report of the Cin7 Omni connector includes 13 fields.

ID Type Name Description
purchase_order_line_items__barcode TEXT purchase_order_line_items.barcode Barcode.
purchase_order_line_items__code TEXT purchase_order_line_items.code Line item code.
purchase_order_line_items__discount NUMERIC purchase_order_line_items.discount Line item discount.
purchase_order_line_items__holding_qty NUMERIC purchase_order_line_items.holding_qty Holding quantity.
purchase_order_line_items__line_id TEXT purchase_order_line_items.line_id Line item ID.
purchase_order_line_items__name TEXT purchase_order_line_items.name Line item name.
purchase_order_line_items__product_id TEXT purchase_order_line_items.product_id Line item product ID.
purchase_order_line_items__product_option_id TEXT purchase_order_line_items.product_option_id Product option ID.
purchase_order_line_items__purchase_order_id TEXT purchase_order_line_items.purchase_order_id Parent purchase order ID.
purchase_order_line_items__qty NUMERIC purchase_order_line_items.qty Line item quantity.
purchase_order_line_items__qty_shipped NUMERIC purchase_order_line_items.qty_shipped Line item quantity received.
purchase_order_line_items__style_code TEXT purchase_order_line_items.style_code Style code.
purchase_order_line_items__unit_price NUMERIC purchase_order_line_items.unit_price Line item unit price (supplier cost).

Cin7 Omni purchase_orders fields

The purchase_orders report of the Cin7 Omni connector includes 27 fields.

ID Type Name Description
purchase_orders__branch_id TEXT purchase_orders.branch_id Branch ID.
purchase_orders__cancellation_date TIMESTAMP purchase_orders.cancellation_date Cancellation timestamp.
purchase_orders__company TEXT purchase_orders.company Supplier company.
purchase_orders__created_date TIMESTAMP purchase_orders.created_date Order creation timestamp.
purchase_orders__currency_code TEXT purchase_orders.currency_code Currency code.
purchase_orders__currency_rate NUMERIC purchase_orders.currency_rate Currency exchange rate.
purchase_orders__discount_total NUMERIC purchase_orders.discount_total Discount total.
purchase_orders__estimated_arrival_date TIMESTAMP purchase_orders.estimated_arrival_date Estimated arrival timestamp.
purchase_orders__estimated_delivery_date TIMESTAMP purchase_orders.estimated_delivery_date Estimated delivery timestamp.
purchase_orders__freight_total NUMERIC purchase_orders.freight_total Freight total.
purchase_orders__fully_received_date TIMESTAMP purchase_orders.fully_received_date Fully received timestamp.
purchase_orders__invoice_date TIMESTAMP purchase_orders.invoice_date Invoice timestamp.
purchase_orders__is_approved BOOLEAN purchase_orders.is_approved Whether the order is approved.
purchase_orders__is_void BOOLEAN purchase_orders.is_void Whether the order is void.
purchase_orders__member_id TEXT purchase_orders.member_id Supplier member ID.
purchase_orders__modified_date TIMESTAMP purchase_orders.modified_date Modification timestamp.
purchase_orders__product_total NUMERIC purchase_orders.product_total Product total.
purchase_orders__purchase_order_id TEXT purchase_orders.purchase_order_id Purchase order ID.
purchase_orders__reference TEXT purchase_orders.reference Purchase order reference.
purchase_orders__source TEXT purchase_orders.source Order source.
purchase_orders__stage TEXT purchase_orders.stage Order stage.
purchase_orders__status TEXT purchase_orders.status Order status.
purchase_orders__supplier_invoice_reference TEXT purchase_orders.supplier_invoice_reference Supplier invoice reference.
purchase_orders__surcharge NUMERIC purchase_orders.surcharge Surcharge.
purchase_orders__tax_rate PERCENT purchase_orders.tax_rate Tax rate.
purchase_orders__tax_status TEXT purchase_orders.tax_status Tax status.
purchase_orders__total NUMERIC purchase_orders.total Order total.

Cin7 Omni sales_order_line_items fields

The sales_order_line_items report of the Cin7 Omni connector includes 23 fields.

ID Type Name Description
sales_order_line_items__barcode TEXT sales_order_line_items.barcode Barcode.
sales_order_line_items__code TEXT sales_order_line_items.code Line item code.
sales_order_line_items__cogs NUMERIC sales_order_line_items.cogs Cost of goods sold for the line (unit cost times quantity); order COGS is the sum over the order's line items.
sales_order_line_items__created_date TIMESTAMP sales_order_line_items.created_date Line creation timestamp.
sales_order_line_items__discount NUMERIC sales_order_line_items.discount Line item discount.
sales_order_line_items__holding_qty NUMERIC sales_order_line_items.holding_qty Holding quantity.
sales_order_line_items__line_comments TEXT sales_order_line_items.line_comments Line comments.
sales_order_line_items__line_id TEXT sales_order_line_items.line_id Line item ID.
sales_order_line_items__name TEXT sales_order_line_items.name Line item name.
sales_order_line_items__option_1 TEXT sales_order_line_items.option_1 Option 1 value.
sales_order_line_items__option_2 TEXT sales_order_line_items.option_2 Option 2 value.
sales_order_line_items__option_3 TEXT sales_order_line_items.option_3 Option 3 value.
sales_order_line_items__product_id TEXT sales_order_line_items.product_id Line item product ID.
sales_order_line_items__product_option_id TEXT sales_order_line_items.product_option_id Product option ID.
sales_order_line_items__qty NUMERIC sales_order_line_items.qty Line item quantity.
sales_order_line_items__qty_shipped NUMERIC sales_order_line_items.qty_shipped Line item quantity shipped.
sales_order_line_items__sales_order_id TEXT sales_order_line_items.sales_order_id Parent sales order ID.
sales_order_line_items__sort NUMERIC sales_order_line_items.sort Line sort order.
sales_order_line_items__stock_control BOOLEAN sales_order_line_items.stock_control Whether stock is controlled.
sales_order_line_items__style_code TEXT sales_order_line_items.style_code Style code.
sales_order_line_items__tax_rate PERCENT sales_order_line_items.tax_rate Line item tax rate.
sales_order_line_items__unit_cost NUMERIC sales_order_line_items.unit_cost Line item unit cost.
sales_order_line_items__unit_price NUMERIC sales_order_line_items.unit_price Line item unit price.

Cin7 Omni sales_orders fields

The sales_orders report of the Cin7 Omni connector includes 41 fields.

Cin7 Omni sales_orders fields (sales_orders__billing_city to sales_orders__total)

ID Type Name Description
sales_orders__billing_city CITY sales_orders.billing_city Billing city.
sales_orders__billing_country COUNTRY sales_orders.billing_country Billing country.
sales_orders__billing_postal_code TEXT sales_orders.billing_postal_code Billing postal code.
sales_orders__billing_state REGION sales_orders.billing_state Billing state.
sales_orders__branch_id TEXT sales_orders.branch_id Branch ID.
sales_orders__cancellation_date TIMESTAMP sales_orders.cancellation_date Cancellation timestamp.
sales_orders__company TEXT sales_orders.company Customer company.
sales_orders__created_date TIMESTAMP sales_orders.created_date Sales order creation timestamp.
sales_orders__currency_code TEXT sales_orders.currency_code Currency code.
sales_orders__currency_rate NUMERIC sales_orders.currency_rate Currency exchange rate.
sales_orders__customer_order_no TEXT sales_orders.customer_order_no Customer order number.
sales_orders__delivery_city CITY sales_orders.delivery_city Delivery city.
sales_orders__delivery_country COUNTRY sales_orders.delivery_country Delivery country.
sales_orders__delivery_postal_code TEXT sales_orders.delivery_postal_code Delivery postal code.
sales_orders__delivery_state REGION sales_orders.delivery_state Delivery state.
sales_orders__discount_total NUMERIC sales_orders.discount_total Discount total.
sales_orders__dispatched_date TIMESTAMP sales_orders.dispatched_date Sales order dispatch timestamp.
sales_orders__email TEXT sales_orders.email Customer email.
sales_orders__estimated_delivery_date TIMESTAMP sales_orders.estimated_delivery_date Estimated delivery timestamp.
sales_orders__freight_total NUMERIC sales_orders.freight_total Freight total.
sales_orders__invoice_date TIMESTAMP sales_orders.invoice_date Sales order invoice timestamp.
sales_orders__invoice_number TEXT sales_orders.invoice_number Invoice number.
sales_orders__is_approved BOOLEAN sales_orders.is_approved Whether the sales order is approved.
sales_orders__is_void BOOLEAN sales_orders.is_void Whether the order is void.
sales_orders__logistics_carrier TEXT sales_orders.logistics_carrier Logistics carrier.
sales_orders__member_id TEXT sales_orders.member_id Customer member ID.
sales_orders__modified_date TIMESTAMP sales_orders.modified_date Order modification timestamp.
sales_orders__payment_terms TEXT sales_orders.payment_terms Payment terms.
sales_orders__product_total NUMERIC sales_orders.product_total Product total.
sales_orders__project_name TEXT sales_orders.project_name Project name.
sales_orders__reference TEXT sales_orders.reference Sales order reference.
sales_orders__sales_order_id TEXT sales_orders.sales_order_id Sales order ID.
sales_orders__sales_person_id TEXT sales_orders.sales_person_id Sales person ID.
sales_orders__source TEXT sales_orders.source Order source.
sales_orders__stage TEXT sales_orders.stage Order stage.
sales_orders__status TEXT sales_orders.status Order status.
sales_orders__surcharge NUMERIC sales_orders.surcharge Surcharge.
sales_orders__tax_rate PERCENT sales_orders.tax_rate Order tax rate.
sales_orders__tax_status TEXT sales_orders.tax_status Tax status.
sales_orders__total NUMERIC sales_orders.total Order total.

Cin7 Omni sales_orders fields (sales_orders__voucher_code to sales_orders__voucher_code)

ID Type Name Description
sales_orders__voucher_code TEXT sales_orders.voucher_code Voucher code.

Cin7 Omni stock fields

The stock report of the Cin7 Omni connector includes 19 fields.

ID Type Name Description
stock__available NUMERIC stock.available Available quantity.
stock__barcode TEXT stock.barcode Barcode.
stock__branch_id TEXT stock.branch_id Branch ID.
stock__branch_name TEXT stock.branch_name Branch name.
stock__code TEXT stock.code Product option code.
stock__holding NUMERIC stock.holding Holding quantity.
stock__incoming NUMERIC stock.incoming Incoming quantity.
stock__modified_date TIMESTAMP stock.modified_date Stock modification timestamp.
stock__open_sales NUMERIC stock.open_sales Open sales quantity.
stock__option_1 TEXT stock.option_1 Option 1 value.
stock__option_2 TEXT stock.option_2 Option 2 value.
stock__option_3 TEXT stock.option_3 Option 3 value.
stock__product_id TEXT stock.product_id Product ID.
stock__product_name TEXT stock.product_name Product name.
stock__product_option_id TEXT stock.product_option_id Product option ID.
stock__size TEXT stock.size Size.
stock__stock_on_hand NUMERIC stock.stock_on_hand Stock on hand quantity.
stock__style_code TEXT stock.style_code Style code.
stock__virtual NUMERIC stock.virtual Virtual stock quantity.

Cin7 Omni other fields

The Cin7 Omni connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID Account ID.
account_name TEXT Account Name Account name.
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date Date.
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20