Schema Information for Cin7 Core
This topic provides a structured reference to assist you in working with Daton's Cin7 Core connector and the associated fields and tables.
Schema Information for Cin7 Core
This topic provides a structured reference to assist you in working with Daton's Cin7 Core connector and the associated fields and tables.
In this article, we will look at the schema information of the supported APIs and tables for Cin7 Core.
Find the links to other articles related to Cin7 Core below:
Tables/APIs Supported
The tables and APIs associated with the Cin7 Core connector are as follows.
accounts
Purpose: This API is used to fetch all accounts data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/chart-of-accounts/chart-of-accounts/get
Replication Type: Key Based
Field Name |
Data Type |
| Code | STRING |
| Status | STRING |
| Name | STRING |
| Type | STRING |
| Description | STRING |
| Class | STRING |
| ForPayments | BOOLEAN |
| DisplayName | STRING |
| SystemAccount | STRING |
| SystemAccountCode | STRING |
| BankAccountId | STRING |
| BankAccountNumber | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
customers
Purpose: This API is used to fetch all customers data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/customer/customer/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| Name | STRING |
| Currency | STRING |
| PaymentTerm | STRING |
| Discount | NUMERIC |
| TaxRule | STRING |
| Carrier | STRING |
| SalesRepresentative | STRING |
| Location | STRING |
| Comments | STRING |
| AccountReceivable | STRING |
| RevenueAccount | STRING |
| PriceTier | STRING |
| TaxNumber | STRING |
| Status | STRING |
| CreditLimit | NUMERIC |
| IsOnCreditHold | BOOLEAN |
| LastModifiedOn | TIMESTAMP |
| Addresses | RECORD |
| Addresses.Line1 | STRING |
| Addresses.Line2 | STRING |
| Addresses.City | STRING |
| Addresses.State | STRING |
| Addresses.Postcode | STRING |
| Addresses.Country | STRING |
| Addresses.Type | STRING |
| Addresses.DefaultForType | BOOLEAN |
| Addresses.ID | STRING |
| Contacts | RECORD |
| Contacts.JobTitle | STRING |
| Contacts.Phone | STRING |
| Contacts.MobilePhone | STRING |
| Contacts.Fax | STRING |
| Contacts.Email | STRING |
| Contacts.Website | STRING |
| Contacts.c_Default | BOOLEAN |
| Contacts.Comment | STRING |
| Contacts.IncludeInEmail | BOOLEAN |
| Contacts.MarketingConsent | NUMERIC |
| Contacts.ID | STRING |
| Contacts.Name | STRING |
| Tags | STRING |
| AdditionalAttribute1 | STRING |
| AttributeSet | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
suppliers
Purpose: This API is used to fetch all suppliers data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/supplier/supplier/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| Name | STRING |
| Currency | STRING |
| PaymentTerm | STRING |
| TaxRule | STRING |
| Discount | NUMERIC |
| AccountPayable | STRING |
| Status | STRING |
| LastModifiedOn | TIMESTAMP |
| Contacts | RECORD |
| Contacts.Name | STRING |
| Contacts.c_Default | BOOLEAN |
| Contacts.IncludeInEmail | BOOLEAN |
| Contacts.ID | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
transactions
Purpose: This API is used to fetch all transaction related data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/transactions/transactions/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| TaskID | STRING |
| DebitAccountCode | STRING |
| CreditAccountCode | STRING |
| Amount | NUMERIC |
| OriginalAmount | NUMERIC |
| CurrencyRate | NUMERIC |
| EffectiveDate | DATETIME |
| Reference | STRING |
| Transaction | STRING |
| Type | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
products
Purpose: This API is used to fetch all products
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/product/product/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| SKU | STRING |
| Name | STRING |
| Category | STRING |
| Brand | STRING |
| Type | STRING |
| CostingMethod | STRING |
| DropShipMode | STRING |
| DefaultLocation | STRING |
| Length | NUMERIC |
| Width | NUMERIC |
| Height | NUMERIC |
| Weight | NUMERIC |
| UOM | STRING |
| WeightUnits | STRING |
| DimensionsUnits | STRING |
| Barcode | STRING |
| MinimumBeforeReorder | NUMERIC |
| ReorderQuantity | NUMERIC |
| PriceTier1 | NUMERIC |
| PriceTier2 | NUMERIC |
| PriceTier3 | NUMERIC |
| PriceTier4 | NUMERIC |
| PriceTier5 | NUMERIC |
| PriceTier6 | NUMERIC |
| PriceTier7 | NUMERIC |
| PriceTier8 | NUMERIC |
| PriceTier9 | NUMERIC |
| PriceTier10 | NUMERIC |
| AverageCost | NUMERIC |
| ShortDescription | STRING |
| InternalNote | STRING |
| Description | STRING |
| AdditionalAttribute1 | STRING |
| AdditionalAttribute2 | STRING |
| AdditionalAttribute3 | STRING |
| AdditionalAttribute4 | STRING |
| AdditionalAttribute5 | STRING |
| AdditionalAttribute6 | STRING |
| AdditionalAttribute7 | STRING |
| AdditionalAttribute8 | STRING |
| AdditionalAttribute9 | STRING |
| AdditionalAttribute10 | STRING |
| Tags | STRING |
| Status | STRING |
| StockLocator | STRING |
| LastModifiedOn | TIMESTAMP |
| Sellable | BOOLEAN |
| PickZones | STRING |
| BillOfMaterial | BOOLEAN |
| AutoAssembly | BOOLEAN |
| AutoDisassembly | BOOLEAN |
| QuantityToProduce | NUMERIC |
| AlwaysShowQuantity | NUMERIC |
| AssemblyInstructionURL | STRING |
| AssemblyCostEstimationMethod | STRING |
| BOMType | STRING |
| CartonHeight | NUMERIC |
| CartonWidth | NUMERIC |
| CartonLength | NUMERIC |
| CartonQuantity | NUMERIC |
| CartonInnerQuantity | NUMERIC |
| PriceTiers | RECORD |
| PriceTiers.Tier1 | NUMERIC |
| PriceTiers.Tier2 | NUMERIC |
| PriceTiers.Tier3 | NUMERIC |
| PriceTiers.Tier4 | NUMERIC |
| PriceTiers.Tier5 | NUMERIC |
| PriceTiers.Tier6 | NUMERIC |
| PriceTiers.Tier7 | NUMERIC |
| PriceTiers.Tier8 | NUMERIC |
| PriceTiers.Tier9 | NUMERIC |
| PriceTiers.Tier10 | NUMERIC |
| Suppliers | RECORD |
| Suppliers.ProductSupplierID | STRING |
| Suppliers.SupplierID | STRING |
| Suppliers.SupplierName | STRING |
| Suppliers.ProductID | STRING |
| Suppliers.Cost | NUMERIC |
| Suppliers.FixedCost | NUMERIC |
| Suppliers.SupplierInventoryCode | STRING |
| Suppliers.DropShip | BOOLEAN |
| Suppliers.Currency | STRING |
| Suppliers.PurchaseCost | NUMERIC |
| Suppliers.LastSupplied | DATETIME |
| BillOfMaterialsProducts | RECORD |
| BillOfMaterialsProducts.ComponentProductID | STRING |
| BillOfMaterialsProducts.ProductCode | STRING |
| BillOfMaterialsProducts.Name | STRING |
| BillOfMaterialsProducts.Quantity | NUMERIC |
| BillOfMaterialsProducts.WastagePercent | NUMERIC |
| BillOfMaterialsProducts.WastageQuantity | NUMERIC |
| BillOfMaterialsProducts.CostPercentage | NUMERIC |
| Movements | RECORD |
| Movements.TaskID | STRING |
| Movements.Type | STRING |
| Movements.Date | DATETIME |
| Movements.Number | STRING |
| Movements.Quantity | NUMERIC |
| Movements.Amount | NUMERIC |
| Movements.Location | STRING |
| Movements.BatchSN | STRING |
| Movements.ExpiryDate | DATETIME |
| Movements.FromTo | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
product_availability_list
Purpose: This API is used to fetch data related to product availability
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/product/product-availability/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| SKU | STRING |
| Name | STRING |
| Barcode | STRING |
| Location | STRING |
| Batch | STRING |
| OnHand | NUMERIC |
| Allocated | NUMERIC |
| Available | NUMERIC |
| OnOrder | NUMERIC |
| StockOnHand | NUMERIC |
| InTransit | NUMERIC |
| NextDeliveryDate | DATETIME |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
brands
Purpose: This API is used to fetch all brands
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/brand/brand/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| Name | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
tax
Purpose: This API is used to fetch all tax related data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/tax/tax/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| Name | STRING |
| Account | STRING |
| IsActive | BOOLEAN |
| TaxInclusive | BOOLEAN |
| TaxPercent | NUMERIC |
| IsTaxForSale | BOOLEAN |
| IsTaxForPurchase | BOOLEAN |
| Components | RECORD |
| Components.Name | STRING |
| Components.AccountCode | STRING |
| Components.Compound | BOOLEAN |
| Components.ComponentOrder | NUMERIC |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
carriers
Purpose: This API is used to fetch all carrier related information
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/carrier/carrier/get
Replication Type: Key Based
Field Name |
Data Type |
| CarrierID | STRING |
| Description | STRING |
| TrackingURL | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
payment_terms
Purpose: This API is used to fetch all payment terms of the account
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/payment-term/payment-term/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| Name | STRING |
| Duration | NUMERIC |
| Method | STRING |
| IsActive | BOOLEAN |
| IsDefault | BOOLEAN |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
locations
Purpose: This API is used to fetch all locations
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/location/location/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| Name | STRING |
| IsDefault | BOOLEAN |
| IsDeprecated | BOOLEAN |
| FixedAssetsLocation | BOOLEAN |
| IsCoMan | BOOLEAN |
| IsShopFloor | BOOLEAN |
| IsStaging | BOOLEAN |
| ParentID | STRING |
| AddressLine1 | STRING |
| AddressLine2 | STRING |
| AddressCitySuburb | STRING |
| AddressStateProvince | STRING |
| AddressZipPostCode | STRING |
| AddressCountry | STRING |
| PickZones | STRING |
| Bins | RECORD |
| Bins.ID | STRING |
| Bins.Name | STRING |
| Bins.IsDeprecated | BOOLEAN |
| Bins.IsStaging | BOOLEAN |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
disassembly_lists
Purpose: This API is used to fetch all disassembly lists
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/disassembly/disassembly-list/get
Replication Type: Key Based
Field Name |
Data Type |
| TaskID | STRING |
| DisassemblyNumber | STRING |
| Status | STRING |
| ProductID | STRING |
| ProductCode | STRING |
| ProductName | STRING |
| LocationID | STRING |
| Location | STRING |
| WIPAccount | STRING |
| CompletionDate | DATETIME |
| Quantity | NUMERIC |
| AssemblyInstructionURL | STRING |
| PickLines | RECORD |
| PickLines.Date | DATETIME |
| PickLines.BatchSN | STRING |
| PickLines.Available | NUMERIC |
| PickLines.UnitCost | NUMERIC |
| PickLines.Quantity | NUMERIC |
| PickLines.TotalCost | NUMERIC |
| OrderLines | RECORD |
| OrderLines.ProductID | STRING |
| OrderLines.ProductCode | STRING |
| OrderLines.Name | STRING |
| OrderLines.Unit | STRING |
| OrderLines.BatchSN | STRING |
| OrderLines.Account | STRING |
| OrderLines.Quantity | NUMERIC |
| OrderLines.Cost | NUMERIC |
| OrderLines.NonInventory | BOOLEAN |
| OrderLines.BinID | STRING |
| OrderLines.Bin | STRING |
| Notes | STRING |
| Transactions | RECORD |
| Transactions.ID | STRING |
| Transactions.EffectiveDate | DATETIME |
| Transactions.Debit | STRING |
| Transactions.Credit | STRING |
| Transactions.Amount | NUMERIC |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
finished_goods_lists
Purpose: This API is used to fetch all finished goods lists
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/finished-goods/finished-goods-list/get
Replication Type: Key Based
Field Name |
Data Type |
| TaskID | STRING |
| AssemblyNumber | STRING |
| Status | STRING |
| ProductID | STRING |
| ProductCode | STRING |
| ProductName | STRING |
| NonInventory | BOOLEAN |
| LocationID | STRING |
| Location | STRING |
| WIPAccount | STRING |
| WIPDate | DATETIME |
| Account | STRING |
| Quantity | NUMERIC |
| AssemblyInstructionURL | STRING |
| CompletionDate | DATETIME |
| BatchSN | STRING |
| Notes | STRING |
| OrderLines | RECORD |
| OrderLines.ProductID | STRING |
| OrderLines.ProductCode | STRING |
| OrderLines.Name | STRING |
| OrderLines.ExpenseAccount | STRING |
| OrderLines.Quantity | NUMERIC |
| OrderLines.Unit | STRING |
| OrderLines.WastagePercent | NUMERIC |
| OrderLines.WastageQuantity | NUMERIC |
| OrderLines.TotalQuantity | NUMERIC |
| OrderLines.TotalCost | NUMERIC |
| PickLines | RECORD |
| PickLines.ProductID | STRING |
| PickLines.ProductCode | STRING |
| PickLines.Name | STRING |
| PickLines.Quantity | NUMERIC |
| PickLines.Unit | STRING |
| PickLines.Cost | NUMERIC |
| PickLines.NonInventory | BOOLEAN |
| PickLines.BatchSN | STRING |
| CustomField1 | STRING |
| CustomField2 | STRING |
| CustomField3 | STRING |
| CustomField4 | STRING |
| CustomField5 | STRING |
| CustomField6 | STRING |
| CustomField7 | STRING |
| CustomField8 | STRING |
| CustomField9 | STRING |
| CustomField10 | STRING |
| Transactions | RECORD |
| Transactions.ID | STRING |
| Transactions.EffectiveDate | DATETIME |
| Transactions.Debit | STRING |
| Transactions.Credit | STRING |
| Transactions.Amount | NUMERIC |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
inventory_write_off_lists
Purpose: This API is used to fetch the list of inventory write offs
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/inventory-write-off/inventory-write-off-list/get
Replication Type: Key Based
Field Name |
Data Type |
| TaskID | STRING |
| InventoryWriteOffNumber | STRING |
| Status | STRING |
| LocationID | STRING |
| Location | STRING |
| Account | STRING |
| EffectiveDate | DATETIME |
| Notes | STRING |
| Lines | RECORD |
| Lines.ProductID | STRING |
| Lines.ProductCode | STRING |
| Lines.Name | STRING |
| Lines.ExpenseAccount | STRING |
| Lines.Quantity | NUMERIC |
| Lines.Cost | NUMERIC |
| Lines.TotalCost | NUMERIC |
| Transactions | RECORD |
| Transactions.ID | STRING |
| Transactions.EffectiveDate | DATETIME |
| Transactions.Debit | STRING |
| Transactions.Credit | STRING |
| Transactions.Amount | NUMERIC |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
sale_list
Purpose: This API is used to fetch all sales list
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/sale/sale-list/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| Customer | STRING |
| CustomerID | STRING |
| Contact | STRING |
| Phone | STRING |
| STRING | |
| DefaultAccount | STRING |
| SkipQuote | BOOLEAN |
| BaseCurrency | STRING |
| CustomerCurrency | STRING |
| TaxRule | STRING |
| TaxCalculation | STRING |
| Terms | STRING |
| PriceTier | STRING |
| ShipBy | DATETIME |
| Location | STRING |
| SaleOrderDate | DATETIME |
| LastModifiedOn | TIMESTAMP |
| Note | STRING |
| CustomerReference | STRING |
| COGSAmount | NUMERIC |
| Status | STRING |
| CombinedPickingStatus | STRING |
| CombinedPackingStatus | STRING |
| CombinedShippingStatus | STRING |
| FulFilmentStatus | STRING |
| CombinedInvoiceStatus | STRING |
| CombinedPaymentStatus | STRING |
| CombinedTrackingNumbers | STRING |
| CurrencyRate | NUMERIC |
| SalesRepresentative | STRING |
| ServiceOnly | BOOLEAN |
| Type | STRING |
| SourceChannel | STRING |
| BillingAddress | RECORD |
| ShippingAddress | RECORD |
| Quote | RECORD |
| c_Order | RECORD |
| Fulfilments | RECORD |
| Invoices | RECORD |
| CreditNotes | RECORD |
| ManualJournals | RECORD |
| Attachments | RECORD |
| InventoryMovements | RECORD |
| ShippingNotes | STRING |
| Carrier | STRING |
| AdditionalAttributes | RECORD |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
purchase_list
Purpose: This API is used to fetch all purchase lists
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/purchase/purchase-list/get
Replication Type: Key Based
Field Name |
Data Type |
| ID | STRING |
| SupplierID | STRING |
| Supplier | STRING |
| Contact | STRING |
| Phone | STRING |
| InventoryAccount | STRING |
| BlindReceipt | BOOLEAN |
| Approach | STRING |
| BaseCurrency | STRING |
| SupplierCurrency | STRING |
| TaxRule | STRING |
| TaxCalculation | STRING |
| Terms | STRING |
| RequiredBy | DATETIME |
| Location | STRING |
| Note | STRING |
| OrderNumber | STRING |
| OrderDate | DATETIME |
| Status | STRING |
| CurrencyRate | NUMERIC |
| LastUpdatedDate | TIMESTAMP |
| BillingAddress | RECORD |
| ShippingAddress | RECORD |
| c_Order | RECORD |
| StockReceived | RECORD |
| Invoice | RECORD |
| CreditNote | RECORD |
| ManualJournals | RECORD |
| AdditionalAttributes | RECORD |
| Attachments | RECORD |
| Type | STRING |
| CombinedInvoiceStatus | STRING |
| CombinedReceivingStatus | STRING |
| CombinedPaymentStatus | STRING |
| IsServiceOnly | BOOLEAN |
| PutAway | RECORD |
| InventoryMovements | RECORD |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
production_bom
Purpose: This API is used to fetch all Production BOMs of specified product.
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/production/product-production-bom/get
Replication Type: Key Based
Field Name |
Data Type |
| BOMID | STRING |
| OutputQuantity | NUMERIC |
| BufferPercent | NUMERIC |
| InstructionUrl | STRING |
| IgnoreCumulativeLeadTime | BOOLEAN |
| ComponentProductionLeadTime | NUMERIC |
| Version | NUMERIC |
| Name | STRING |
| IsDefault | BOOLEAN |
| CreatedDate | DATETIME |
| IssueMethod | NUMERIC |
| IsTracing | BOOLEAN |
| IssueMethodComponent | NUMERIC |
| IssueMethodParameter | NUMERIC |
| MinQuantity | NUMERIC |
| MaxQuantity | NUMERIC |
| DeviationPercent | NUMERIC |
| RunSize | NUMERIC |
| Operations | RECORD |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
StockTransfer_list
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/stock/stock-transfer-list/get
Replication Type: Key Based
Field Name |
Data Type |
| TaskID | STRING |
| Status | STRING |
| c_From | STRING |
| FromLocation | STRING |
| c_To | STRING |
| ToLocation | STRING |
| Number | STRING |
| CostDistributionType | STRING |
| InTransitAccount | STRING |
| CompletionDate | DATETIME |
| RequiredByDate | DATETIME |
| Reference | STRING |
| SkipOrder | BOOLEAN |
| Lines | RECORD |
| c_Order | RECORD |
| DepartureDate | DATETIME |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |