Exclusive: all our customers get a free six-month subscription to EDNA, a next-gen data and AI learning platform

Explore the Cin7 Core (Dear Inventory) API data model

See how the various Cin7 Core (Dear Inventory) endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Cin7 Core (Dear Inventory) API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Cin7 Core (Dear Inventory) API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Attachment

Column Type Relates to Notes
RemoteID string - -
PurchaseRemoteID string Purchase → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
ContentType string - -
IsDefault boolean - -
FileName string - -
DownloadUrl string - -

ChartOfAccount

Documentation: https://dearinventory.docs.apiary.io/#reference/chart-of-accounts/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
Code string - -
Status string - -
Type string - -
Class string - -
SystemAccount string - -
BankAccountNumber string - -
BankAccountID guid - -
ForPayments boolean - -
DisplayName string - -
OldCode string - -

Customer

Documentation: https://dearinventory.docs.apiary.io/#reference/customer/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
LastModifiedOn datetime - -
Status string - -
Currency string - -
PaymentTerm string - -
Discount decimal - -
TaxRule string - -
Carrier string - -
SalesRepresentative string - -
Location string - -
Comments string - -
AccountReceivable string ChartOfAccount → Code -
RevenueAccount string ChartOfAccount → Code -
PriceTier string - -
TaxNumber string - -
AdditionalAttribute1 string - -
AdditionalAttribute2 string - -
AdditionalAttribute3 string - -
AdditionalAttribute4 string - -
AdditionalAttribute5 string - -
AdditionalAttribute6 string - -
AdditionalAttribute7 string - -
AdditionalAttribute8 string - -
AdditionalAttribute9 string - -
AdditionalAttribute10 string - -
CreditLimit decimal - -
IsOnCreditHold boolean - -
Tags string - -

Disassembly

Documentation: https://dearinventory.docs.apiary.io/#reference/disassembly/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
WIPAccount string ChartOfAccount → Code -
AssemblyInstructionURL string - -
TaskID guid - -
Status string - -
DisassemblyNumber string - -
ProductID guid Product → ID -
Quantity decimal - -
LocationID guid Location → ID -

FactoryCalendar

Documentation: https://dearinventory.docs.apiary.io/#reference/production/factory-calendar/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Year int - -
WeekStart string - -

FinishedGood

Documentation: https://dearinventory.docs.apiary.io/#reference/finished-goods/finished-goods

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
TaskID guid - -
Status string - -
UnitCost decimal - -
Notes string - -
CustomField1 string - -
CustomField2 string - -
CustomField3 string - -
CustomField4 string - -
CustomField5 string - -
CustomField6 string - -
CustomField7 string - -
CustomField8 string - -
CustomField9 string - -
CustomField10 string - -
AssemblyNumber string - -
BatchSN string - -
ExpiryDate datetime - -
ProductID guid Product → ID -
LocationID guid Location → ID -
Quantity decimal - -
Version long - -
NonInventory boolean - -
BinID guid LocationBin → ID -
WIPAccount string - -
WIPDate datetime - -
Account string - -
CompletionDate datetime - -

Location

Documentation: https://dearinventory.docs.apiary.io/#reference/Location/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
IsDefault string - -
IsDeprecated string - -
FixedAssetsLocation string - -
ParentID guid Location → ID -
ParentName string - -
ReferenceCount string - -
AddressLine1 string - -
AddressLine2 string - -
AddressCitySuburb string - -
AddressStateProvince string - -
AddressZipPostCode string - -
AddressCountry string - -
PickZones string -
  • 9 May 2022 Formatted as CSV
IsShopfloor string - -
IsCoMan string - -
IsStaging string - -

Product

Documentation: https://dearinventory.docs.apiary.io/#reference/product/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Description string - -
LastModifiedOn datetime - -
Status string - -
SKU string - -
Category string -
  • 21 Jun 2022 Dear Inventory returns the category name, but unfortunately not the ID, so we are unable to foreign-key this relationship
Brand string - -
Type string - -
CostingMethod string - -
DropShipMode string - -
DefaultLocation string - -
Length string - -
Width string - -
Height string - -
Weight string - -
UOM string - -
WeightUnits string - -
DimensionsUnits string - -
Barcode string - -
MinimumBeforeReorder string - -
ReorderQuantity string - -
AverageCost string - -
ShortDescription string - -
InternalNote string - -
AdditionalAttribute1 string - -
AdditionalAttribute2 string - -
AdditionalAttribute3 string - -
AdditionalAttribute4 string - -
AdditionalAttribute5 string - -
AdditionalAttribute6 string - -
AdditionalAttribute7 string - -
AdditionalAttribute8 string - -
AdditionalAttribute9 string - -
AdditionalAttribute10 string - -
AttributeSet string - -
DiscountRule string - -
StockLocator string - -
COGSAccount string ChartOfAccount → Code -
RevenueAccount string ChartOfAccount → Code -
ExpenseAccount string ChartOfAccount → Code -
InventoryAccount string ChartOfAccount → Code -
PurchaseTaxRule string - -
SaleTaxRule string - -
Sellable boolean - -
PickZones string - -
BillOfMaterial boolean - -
AutoAssembly boolean - -
AutoDisassembly boolean - -
QuantityToProduce decimal - -
AssemblyInstructionURL string - -
AssemblyCostEstimationMethod string - -
BOMType string - -
CountryOfOrigin string - -
CountryOfOriginCode string - -

ProductAvailability

Documentation: https://dearinventory.docs.apiary.io/#reference/product/product-availability/get

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Batch string - -
Location string -
  • 20 Jun 2022 This is the Location Name, rather than a foreign key GUID reference
ExpiryDate datetime - -
Bin string -
  • 20 Jun 2022 This is the Bin Name, rather than a foreign key GUID reference
ProductID guid Product → ID -
SKU string - -
Barcode string - -
OnHand decimal - -
Allocated decimal - -
InTransit decimal - -
NextDeliveryDate datetime - -
Available decimal - -
OnOrder decimal - -
StockOnHand decimal - -

ProductCategory

Documentation: https://dearinventory.docs.apiary.io/#reference/product-categories/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -

ProductFamily

Documentation: https://dearinventory.docs.apiary.io/#reference/product-family/product-family/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Description string - -
LastModifiedOn datetime - -
SKU string - -
Category string - -
DefaultLocation string - -
Brand string - -
CostingMethod string - -
UOM string - -
MinimumBeforeReorder decimal - -
ReorderQuantity string - -
PriceTier1 decimal - -
PriceTier2 decimal - -
PriceTier3 decimal - -
PriceTier4 decimal - -
PriceTier5 decimal - -
PriceTier6 decimal - -
PriceTier7 decimal - -
PriceTier8 decimal - -
PriceTier9 decimal - -
PriceTier10 decimal - -
ShortDescription string - -
DiscountRule string - -
Tags string - -
COGSAccount string ChartOfAccount → Code -
RevenueAccount string ChartOfAccount → Code -
InventoryAccount string ChartOfAccount → Code -
PurchaseTaxRule string - -
SaleTaxRule string - -
DropShipMode string - -
Option1Name string - -
Option2Name string - -
Option3Name string - -
Option1Values string - -
Option2Values string - -
Option3Values string - -

ProductFamilyProductionBOM

Documentation: https://dearinventory.docs.apiary.io/#reference/production/product-production-bom/get

Column Type Relates to Notes
RemoteID string - -
ProductFamilyRemoteID string ProductFamily → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
BOMID guid - -
CreatedDate datetime - -
ProductFamilyID guid ProductFamily → ID -
OutputQuantity decimal - -
BufferPercent decimal - -
InstructionUrl string - -
IgnoreCumulativeLeadTime boolean - -
ComponentProductionLeadTime decimal - -
Version decimal - -
IsDefault boolean - -
DeliveryToID guid Location → ID
  • 17 May 2022 The DeliveryToID refers to the Bin/Location for this BOM
IssueMethod string - -
IsTracing boolean - -
IssueMethodComponent string - -
IssueMethodParameter string - -
MinQuantity decimal - -
MaxQuantity decimal - -
DeviationPercent decimal - -
RunSize decimal - -

ProductionOrder

Documentation: https://dearinventory.docs.apiary.io/#reference/production/production-order/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrderCycleTime decimal -
  • 17 May 2022 Represented in seconds
CostingMethod string - -
WarehouseID guid - -
Unit string - -
SourceName string - -
IsIgnoreLeadTime boolean - -
RetailID guid - -
StartUpdate boolean - -
PlannedBy string - -
ReleasedBy string - -
BOMVersion decimal - -
BOMName string - -
Tags string - -
IssueMethodComponent string - -
IssueMethodParameter string - -
RunSize string - -
ProductionOrderID guid - -
TaskID guid - -
Type string -
  • 17 May 2022 O - Production Order; R - Production Order Run
TypeDescription string - -
ProductID guid Product → ID -
OrderNumber string - -
LocationID guid Location → ID -
Status string - -
OrderStatus string - -
Quantity decimal - -
StartDate datetime - -
ReleaseDate datetime - -
RequiredByDate datetime - -
CompletionDate datetime - -
TotalCount decimal - -
CapacityCalculationType string - -
WIPAccountCode string ChartOfAccount → Code -
FinishedGoodsAccountCode string ChartOfAccount → Code -
Comments string - -
CustomField1 string - -
CustomField2 string - -
CustomField3 string - -
CustomField4 string - -
CustomField5 string - -
CustomField6 string - -
CustomField7 string - -
CustomField8 string - -
CustomField9 string - -
CustomField10 string - -

ProductionOrderRun

Documentation: https://dearinventory.docs.apiary.io/#reference/production/production-run/get

Column Type Relates to Notes
RemoteID string - -
ProductionOrderRemoteID string ProductionOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RunID guid - -
ProductionOrderID guid ProductionOrder → ProductionOrderID -
Number decimal - -
Status string - -
Quantity decimal - -
WIPAccount string ChartOfAccount → Code -
StartDate datetime - -
EndDate datetime - -
DueDate datetime - -
ReceivedDate datetime - -
ScheduleStart datetime - -
ScheduleDue datetime - -
IssueMethodParameter string - -

ProductProductionBOM

Documentation: https://dearinventory.docs.apiary.io/#reference/production/product-production-bom/get

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
BOMID guid - -
CreatedDate datetime - -
ProductID guid Product → ID -
OutputQuantity decimal - -
BufferPercent decimal - -
InstructionUrl string - -
IgnoreCumulativeLeadTime boolean - -
ComponentProductionLeadTime decimal - -
Version decimal - -
IsDefault boolean - -
DeliveryToID guid Location → ID
  • 17 May 2022 The DeliveryToID refers to the Bin/Location for this BOM
IssueMethod string - -
IsTracing boolean - -
IssueMethodComponent string - -
IssueMethodParameter string - -
MinQuantity decimal - -
MaxQuantity decimal - -
DeviationPercent decimal - -
RunSize decimal - -

PurchaseAttachment

Column Type Relates to Notes
RemoteID string - -
PurchaseRemoteID string Purchase → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseID guid Purchase → ID -
AttachmentID guid Attachment → ID -

Purchase

Documentation: https://dearinventory.docs.apiary.io/#reference/purchase/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
SupplierID guid Supplier → ID -
InventoryAccount string ChartOfAccount → Code -
Contact string - -
Phone string - -
BlindReceipt boolean - -
Approach string - -
BaseCurrency string - -
SupplierCurrency string - -
TaxRule string - -
TaxCalculation string - -
Terms string - -
RequiredBy datetime - -
Location string - -
Note string - -
OrderDate datetime - -
CombinedReceivingStatus string - -
CombinedInvoiceStatus string - -
CombinedPaymentStatus string - -
Type string - -
IsServiceOnly boolean - -
RelatedDropShipSaleTask guid - -
CurrencyRate decimal - -
AdditionalAttribute1 string - -
AdditionalAttribute2 string - -
AdditionalAttribute3 string - -
AdditionalAttribute4 string - -
AdditionalAttribute5 string - -
AdditionalAttribute6 string - -
AdditionalAttribute7 string - -
AdditionalAttribute8 string - -
AdditionalAttribute9 string - -
AdditionalAttribute10 string - -
OrderMemo string - -
OrderStatus string - -
OrderTotalBeforeTax decimal - -
OrderTax decimal - -
OrderTotal decimal - -
LastUpdatedDate datetime - -
Status string - -
OrderNumber string - -

PurchaseInventoryMovement

Column Type Relates to Notes
RemoteID string - -
PurchaseRemoteID string Purchase → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseID guid Purchase → ID -
ProductID guid Product → ID -
LineNumber int - -
TaskID guid - -
Date datetime - -
COGS decimal - -

PurchaseInvoiceLine

Column Type Relates to Notes
RemoteID string - -
PurchaseInvoiceRemoteID string PurchaseInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
LineNumber int - -
ProductID guid Product → ID -
SKU string - -
Quantity decimal - -
Price decimal - -
Discount decimal - -
Tax decimal - -
TaxRule string - -
Account string - -
Comment string - -
Total decimal - -

PurchaseInvoice

Column Type Relates to Notes
RemoteID string - -
PurchaseRemoteID string Purchase → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseID guid Purchase → ID -
TaskID guid -
  • 23 Mar 2023 In the case of PurchaseInvoice, the TaskID serves as a unique modifier. If the invoice is a part of a 'Simple Purchase' where there can only be one Invoice, the TaskID will simply mimic the PurchaseID. If it's a part of an advanced purchase, where multiple invoices can be raised, the TaskID will be unique to each invoice
InvoiceDate datetime - -
InvoiceDueDate datetime - -
InvoiceNumber string - -
Status string - -
TotalBeforeTax decimal - -
Tax decimal - -
Total decimal - -
Paid decimal - -

PurchaseOrderLine

Column Type Relates to Notes
RemoteID string - -
PurchaseRemoteID string Purchase → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseID guid Purchase → ID -
LineNumber int - -
ProductID guid Product → ID -
SKU string - -
Quantity decimal - -
Price decimal - -
Discount decimal - -
Tax decimal - -
Total decimal - -
TaxRule string - -
SupplierSKU string - -
Comment string - -

PurchasePayment

Documentation: https://dearinventory.docs.apiary.io/#reference/purchase/advanced-purchase-payments/get

Column Type Relates to Notes
RemoteID string - -
PurchaseRemoteID string Purchase → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
DateCreated datetime - -
PurchaseID guid Purchase → ID -
TaskID guid - -
Type string - -
Reference string - -
Amount decimal - -
DatePaid datetime - -
CurrencyRate decimal - -
Account string ChartOfAccount → Code -

PurchaseStockReceivedLine

Column Type Relates to Notes
RemoteID string - -
PurchaseStockReceivedRemoteID string PurchaseStockReceived → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
PurchaseStockRemoteID string PurchaseStockReceived → RemoteID -
LineNumber int - -
Date datetime - -
Quantity decimal - -
ProductID guid Product → ID -
SKU string - -
LocationID guid Location → ID -
Received boolean - -
BatchSN string - -
SupplierSKU string - -
ExpiryDate datetime - -

PurchaseStockReceived

Column Type Relates to Notes
RemoteID string - -
PurchaseRemoteID string Purchase → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
PurchaseID guid Purchase → ID -
Iterator int - -
TaskID guid - -
Status string - -

SaleAttachment

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SaleID guid Sale → ID -
AttachmentID guid Attachment → ID -

Sale

Documentation: https://dearinventory.docs.apiary.io/#reference/sale/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
LastModifiedOn datetime - -
CustomerID guid Customer → ID -
Contact string - -
Phone string - -
Email string - -
DefaultAccount string - -
SkipQuote boolean - -
ShippingNotes string - -
BaseCurrency string - -
CustomerCurrency string - -
TaxRule string - -
TaxCalculation string - -
Terms string - -
PriceTier string - -
ShipBy datetime - -
Location string - -
SaleOrderDate datetime - -
Note string - -
CustomerReference string - -
COGSAmount decimal - -
Status string - -
CombinedPickingStatus string - -
CombinedPackingStatus string - -
CombinedShippingStatus string - -
FulfilmentStatus string - -
CombinedInvoiceStatus string - -
CombinedPaymentStatus string - -
CombinedTrackingNumbers string - -
Carrier string - -
CurrencyRate decimal - -
SalesRepresentative string - -
Type string - -
SourceChannel string - -
ExternalID string - -
ServiceOnly boolean - -
QuoteMemo string - -
QuoteStatus string - -
QuoteTotalBeforeTax decimal - -
QuoteTax decimal - -
QuoteTotal decimal - -
SaleOrderNumber string - -
SaleOrderStatus string - -
SaleOrderCombineAdditionalCharges boolean - -
OrderMemo string - -
OrderTotalBeforeTax decimal - -
OrderTax decimal - -
OrderTotal decimal - -
AdditionalAttribute1 string - -
AdditionalAttribute2 string - -
AdditionalAttribute3 string - -
AdditionalAttribute4 string - -
AdditionalAttribute5 string - -
AdditionalAttribute6 string - -
AdditionalAttribute7 string - -
AdditionalAttribute8 string - -
AdditionalAttribute9 string - -
AdditionalAttribute10 string - -

SaleCreditNote

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SaleID guid Sale → ID -
CreditNoteNumber string - -
TaskID guid - -
CreditNoteInvoiceNumber string - -
Memo string - -
Status string - -
CreditNoteDate datetime - -
CreditNoteConversionRate decimal - -
TotalBeforeTax decimal - -
Tax decimal - -
Total decimal - -

SaleFulfilment

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SaleID guid Sale → ID -
FulfilmentNumber int - -
TaskID guid -
  • 20 Jun 2022 The TaskID refers to the SaleID this pertains to
LinkedInvoiceNumber string - -
ShippingStatus string - -
ShippingRequireBy datetime - -
ShippingNotes string - -
ShippingDisplayAddressLine1 string - -
ShippingDisplayAddressLine2 string - -
ShippingLine1 string - -
ShippingLine2 string - -
ShippingCity string - -
ShippingState string - -
ShippingPostcode string - -
ShippingCountry string - -
ShippingCompany string - -
ShippingContact string - -
ShippingShipToOther boolean - -
PickStatus string - -
PackStatus string - -

SaleInventoryMovement

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SaleID guid Sale → ID -
ProductID guid Product → ID -
LineNumber int - -
TaskID guid - -
Date datetime - -
COGS decimal - -

SaleInvoice

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SaleID guid Sale → ID -
InvoiceNumber string - -
TaskID guid - -
CombineAdditionalCharges boolean - -
Memo string - -
Status string - -
InvoiceDate datetime - -
InvoiceDueDate datetime - -
CurrencyConversionRate decimal - -
BillingAddressLine1 string - -
BillingAddressLine2 string - -
LinkedFulfilmentNumber int - -
TotalBeforeTax decimal - -
Tax decimal - -
Total decimal - -
Paid decimal - -

SaleOrderLine

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
SaleID guid Sale → ID -
LineNumber int - -
ProductID guid Product → ID -
SKU string - -
Quantity decimal - -
Price decimal - -
Tax decimal - -
AverageCost decimal - -
TaxRule string - -
Comment string - -
DropShip boolean - -
BackorderQuantity decimal - -
Total decimal - -

SalePayment

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
DateCreated datetime - -
SaleID guid Sale → ID -
TaskID guid - -
Reference string - -
Amount decimal - -
DatePaid datetime - -
Account string - -
CurrencyRate decimal - -
Type string - -
CreditID guid - -

SaleQuoteLine

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
SaleID guid Sale → ID -
LineNumber int - -
ProductID guid Product → ID -
SKU string - -
Quantity decimal - -
Price decimal - -
Discount decimal - -
Tax decimal - -
AverageCost decimal - -
TaxRule string - -
Comment string - -
Total decimal - -

SaleQuoteAdditionalCharge

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SaleID guid Sale → ID -
ChargeNumber int - -
Price decimal - -
Quantity decimal - -
Discount decimal - -
Tax decimal - -
Total decimal - -
TaxRule string - -
Comment string - -

Supplier

Documentation: https://dearinventory.docs.apiary.io/#reference/Supplier/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
LastModifiedOn datetime - -
Status string - -
Currency string - -
PaymentTerm string - -
TaxRule string - -
Discount decimal - -
Comments string - -
AccountPayable string - -
TaxNumber string - -
AdditionalAttribute1 string - -
AdditionalAttribute2 string - -
AdditionalAttribute3 string - -
AdditionalAttribute4 string - -
AdditionalAttribute5 string - -
AdditionalAttribute6 string - -
AdditionalAttribute7 string - -
AdditionalAttribute8 string - -
AdditionalAttribute9 string - -
AdditionalAttribute10 string - -

WorkCenter

Documentation: https://dearinventory.docs.apiary.io/#reference/production/work-centers/get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
WorkCenterID guid - -
IsActive boolean - -
Code string - -
IsCoMan boolean - -
SupplierID guid Supplier → ID -
CoManProcurementType string - -

CustomerProduct

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
CustomerID guid Customer → ID -
Price decimal - -

CustomerContact

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
CustomerID guid Customer → ID -
JobTitle string - -
Phone string - -
MobilePhone string - -
Fax string - -
Email string - -
Website string - -
Default boolean - -
Comment string - -
IncludeInEmail boolean - -

CustomerAddress

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
CustomerID guid Customer → ID -
Line1 string - -
Line2 string - -
City string - -
State string - -
Postcode string - -
Country string - -
Type string - -
DefaultForType boolean - -

CustomerTag

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomerID guid Customer → ID -
Number int - -
Tag string - -

DisassemblyPickLine

Column Type Relates to Notes
RemoteID string - -
DisassemblyRemoteID string Disassembly → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisassemblyID guid Disassembly → TaskID -
BinID guid LocationBin → ID -
BatchSN string - -
ExpiryDate datetime - -
Available decimal - -
UnitCost decimal - -
Quantity decimal - -
TotalCost decimal - -
CompletionDate datetime - -

DisassemblyOrderLine

Column Type Relates to Notes
RemoteID string - -
DisassemblyRemoteID string Disassembly → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisassemblyID guid Disassembly → TaskID -
ProductID guid Product → ID -
BinID guid LocationBin → ID -
Unit string - -
BatchSN string - -
ExpiryDate datetime - -
Account string ChartOfAccount → Code -
Cost decimal - -
Quantity decimal - -

DisassemblyOrderServiceLine

Column Type Relates to Notes
RemoteID string - -
DisassemblyRemoteID string Disassembly → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
DisassemblyID guid Disassembly → TaskID -
ProductID guid Product → ID -
Account string ChartOfAccount → Code -
Comments string - -
Amount decimal - -

FactoryCalendarDay

Column Type Relates to Notes
RemoteID string - -
FactoryCalendarRemoteID string FactoryCalendar → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Year int FactoryCalendar → Year -
DayOfWeek string - -
IsWeekend boolean - -
StartTime decimal - -
EndTime decimal - -
BreakStartTime decimal - -
BreakEndTime decimal - -
Capacity decimal - -

FactoryCalendarSpecialDay

Column Type Relates to Notes
RemoteID string - -
FactoryCalendarRemoteID string FactoryCalendar → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Year int FactoryCalendar → Year -
IsHoliday boolean - -
Date datetime - -
IsWeekend boolean - -
StartTime decimal - -
EndTime decimal - -
BreakStartTime decimal - -
BreakEndTime decimal - -
Comment string - -
Capacity decimal - -

FinishedGoodOrderLine

Column Type Relates to Notes
RemoteID string - -
FinishedGoodRemoteID string FinishedGood → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
FinishedGoodID guid FinishedGood → ID -
ProductID guid Product → ID -
ExpenseAccount string - -
Quantity decimal - -
Unit string - -
WastagePercent decimal - -
WastageQuantity decimal - -
TotalQuantity decimal - -
TotalCost decimal - -

FinishedGoodPickLine

Column Type Relates to Notes
RemoteID string - -
FinishedGoodRemoteID string FinishedGood → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
FinishedGoodID guid FinishedGood → ID -
ProductID guid Product → ID -
Iterator int - -
BatchSN string - -
ProductCode string - -
BinID guid - -
Bin string - -
ExpiryDate datetime - -
Quantity decimal - -
Unit string - -
Cost decimal - -

LocationBin

Column Type Relates to Notes
RemoteID string - -
LocationRemoteID string Location → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
LocationID guid Location → ID -
IsDeprecated boolean - -
IsStaging boolean - -

LocationPickZone

Column Type Relates to Notes
RemoteID string - -
LocationRemoteID string Location → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
LocationID guid Location → ID -

ProductTag

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
Tag string - -

ProductReorderLevel

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
LocationID guid - -
MinimumBeforeReorder decimal - -
ReorderQuantity decimal - -
StockLocator string -
  • 9 May 2022 The location of this product in your warehouse
PickZones string -
  • 9 May 2022 CSV string of pick zones for this product in this warehouse

ProductSupplier

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
SupplierID guid Supplier → ID -
SupplierInventoryCode string - -
SupplierProductName string - -
Cost decimal - -
FixedCost decimal - -
Currency string - -
DropShip boolean - -
URL string - -

ProductMovement

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
MovementNumber int - -
TaskID guid -
  • 9 May 2022 The TaskID directs to a different entity depending on the Type property. For example, if this is Type='Adjustment', then the TaskID is actually a StockAdjustmentID
StockAdjustmentTaskID guid - -
PurchaseTaskID guid - -
Type string - -
Date datetime - -
Number string - -
Quantity decimal - -
Amount decimal - -
Location string - -
BatchSN string - -
ExpiryDate datetime - -
FromTo string - -

ProductCustomPrice

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
CustomerID guid Customer → ID -
CustomerCurrency string - -
Price decimal - -

ProductBOMProduct

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
ComponentProductID guid - -
Quantity decimal - -
WastagePercent decimal - -
WastageQuantity decimal - -
CostPercentage decimal - -

ProductPriceTier

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
PriceTierName string - -
Price decimal - -

ProductBOMService

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID guid Product → ID -
ComponentProductID guid - -
Quantity decimal - -
ExpenseAccount string ChartOfAccount → Code -
PriceTier int - -

ProductFamilyProduct

Column Type Relates to Notes
RemoteID string - -
ProductFamilyRemoteID string ProductFamily → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid Product → ID -
Name string - -
ProductFamilyID guid ProductFamily → ID -
SKU string - -
Option1 string - -
Option2 string - -
Option3 string - -

ProductFamilyTag

Column Type Relates to Notes
RemoteID string - -
ProductFamilyRemoteID string ProductFamily → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductFamilyID guid ProductFamily → ID -
Tag string - -

ProductFamilyProductionBOMOperation

Column Type Relates to Notes
RemoteID string - -
ProductFamilyProductionBOMRemoteID string ProductFamilyProductionBOM → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
OperationID guid - -
ProductFamilyProductionBOMID guid ProductFamilyProductionBOM → BOMID -
Order decimal - -
CycleTime decimal -
  • 17 May 2022 Specified in seconds
UnitsPerCycle decimal - -
WorkCenterID guid WorkCenter → WorkCenterID -
WorkCenterCoManProcurementType string - -
OperationType string - -
IsDropShip boolean - -

ProductProductionBOMOperation

Column Type Relates to Notes
RemoteID string - -
ProductProductionBOMRemoteID string ProductProductionBOM → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
OperationID guid - -
ProductProductionBOMID guid ProductProductionBOM → BOMID -
Order decimal - -
CycleTime decimal -
  • 17 May 2022 Specified in seconds
UnitsPerCycle decimal - -
WorkCenterID guid WorkCenter → WorkCenterID -
WorkCenterCoManProcurementType string - -
OperationType string - -
DeliveryToID guid Location → ID
  • 17 May 2022 The DeliveryToID refers to the Bin/Location for this BOM
DeliveryToName string - -
IssueMethod string - -
IsDropShip boolean - -
IsBackflush boolean - -

SaleCreditNoteLine

Column Type Relates to Notes
RemoteID string - -
SaleCreditNoteRemoteID string SaleCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
LineNumber int - -
ProductID guid Product → ID -
SKU string - -
Quantity decimal - -
Price decimal - -
Discount decimal - -
Tax decimal - -
Total decimal - -
AverageCost decimal - -
TaxRule string - -
Account string - -
Comment string - -

SaleCreditNoteAdditionalCharge

Column Type Relates to Notes
RemoteID string - -
SaleCreditNoteRemoteID string SaleCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
ChargeNumber int - -
Quantity decimal - -
Price decimal - -
Discount decimal - -
Tax decimal - -
Total decimal - -
TaxRule string - -
Account string - -
Comment string - -

SaleCreditNoteRefund

Column Type Relates to Notes
RemoteID string - -
SaleCreditNoteRemoteID string SaleCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Reference string - -
Amount decimal - -
DatePaid datetime - -
CurrencyRate decimal - -
DateCreated datetime - -

SaleCreditNoteRestock

Column Type Relates to Notes
RemoteID string - -
SaleCreditNoteRemoteID string SaleCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ProductID guid Product → ID -
LocationID guid Location → ID -
SKU string - -
Quantity decimal - -
BatchSN string - -
ExpiryDate datetime - -
Box string - -
NonInventory boolean - -
WarrantyRegistrationNumber string - -
RestockLocationID guid Location → ID -

SaleFulfilmentShipLine

Column Type Relates to Notes
RemoteID string - -
SaleFulfilmentRemoteID string SaleFulfilment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
ShipmentDate datetime - -
Carrier string - -
Boxes string - -
TrackingNumber string - -
TrackingURL string - -
IsShipped boolean - -
LineNumber int - -

SaleFulfilmentPickPackLine

Column Type Relates to Notes
RemoteID string - -
SaleFulfilmentRemoteID string SaleFulfilment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Type string - -
LineNumber int - -
ProductID guid Product → ID -
SKU string - -
LocationID guid Location → ID -
Quantity decimal - -
BatchSN string - -
ExpiryDate datetime - -
Box string -
  • 20 Jun 2022 The Box is only relevant to 'Pack' lines
NonInventory boolean - -
WarrantyRegistrationNumber string - -
RestockLocation string - -
RestockLocationID guid Location → ID -

SaleInvoiceLine

Column Type Relates to Notes
RemoteID string - -
SaleInvoiceRemoteID string SaleInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
LineNumber int - -
ProductID guid Product → ID -
SKU string - -
Quantity decimal - -
Price decimal - -
Discount decimal - -
Tax decimal - -
Total decimal - -
AverageCost decimal - -
TaxRule string - -
Account string - -
Comment string - -

SaleInvoiceAdditionalCharge

Column Type Relates to Notes
RemoteID string - -
SaleInvoiceRemoteID string SaleInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
LineNumber int - -
Quantity decimal - -
Price decimal - -
Discount decimal - -
Tax decimal - -
Total decimal - -
TaxRule string - -
Account string - -
Comment string - -

SupplierContact

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
SupplierID guid Supplier → ID -
Phone string - -
MobilePhone string - -
Fax string - -
Email string - -
Website string - -
Default boolean - -
Comment string - -
IncludeInEmail boolean - -

SupplierAddress

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
SupplierID guid Supplier → ID -
Line1 string - -
Line2 string - -
City string - -
State string - -
Postcode string - -
Country string - -
Type string - -
DefaultForType boolean - -

WorkCenterLocation

Column Type Relates to Notes
RemoteID string - -
WorkCenterRemoteID string WorkCenter → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
WorkCenterID guid WorkCenter → WorkCenterID -
LocationID guid Location → ID -
Type string - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Cin7 data Querying Cin7 using regular SQL