Pulling data from the inFlow 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 inFlow 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.
Our Universal MCP Server lets you query your inFlow data using Claude, ChatGPT or your favourite AI tool.
Our inFlow Connector connects your inFlow data to favourite reporting and AI tools.
We connect to over 70+ cloud services, letting you manage the data needs of your entire business in a single location.
Browse the data model below, or if you'd prefer, we also have an interactive ERD over here.
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/AdjustmentReason
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Category
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| CategoryID | guid | - | - |
| Timestamp | string | - | - |
| IsDefault | boolean | - | - |
| ParentCategoryID | guid | Category → CategoryID | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Currency
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Customer/operation/GetCustomers
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| CustomerID | guid | - | - |
| IsActive | boolean | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| ContactName | string | - | - |
| string | - | - | |
| Phone | string | - | - |
| Fax | string | - | - |
| Website | string | - | - |
| Remarks | string | - | - |
| TaxExemptNumber | string | - | - |
| DefaultCarrier | string | - | - |
| DefaultPaymentMethod | string | - | - |
| DefaultSalesRep | string | - | - |
| Discount | decimal | - | - |
| DefaultBillingAddressID | guid | CustomerAddress → CustomerAddressID | - |
| DefaultShippingAddressID | guid | CustomerAddress → CustomerAddressID | - |
| DefaultLocationID | guid | Location → LocationID | - |
| DefaultPaymentTermsID | guid | PaymentTerms → PaymentTermsID | - |
| DefaultSalesRepTeamMemberID | guid | TeamMember → TeamMemberID | - |
| PricingSchemeID | guid | PricingScheme → PricingSchemeID | - |
| TaxingSchemeID | guid | TaxingScheme → TaxingSchemeID | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/CustomFieldDefinition
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| CustomFieldDefinitionID | string | - | - |
| Timestamp | string | - | - |
| Label | string | - | - |
| PropertyName | string | - | - |
| EntityType | string | - | - |
| CustomFieldType | string | - | - |
| IsActive | boolean | - | - |
| CategoryID | guid | Category → CategoryID | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Location
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/ManufacturingOrder/operation/GetManufacturingOrders
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| ManufacturingOrderID | guid | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| ManufacturingOrderNumber | string | - | - |
| Status | string | - | - |
| OrderDate | datetime | - | - |
| DueDate | datetime | - | - |
| CompletedDate | datetime | - | - |
| IsCancelled | boolean | - | - |
| IsCompleted | boolean | - | - |
| IsPrioritized | boolean | - | - |
| NumFinishedProducts | int | - | - |
| PrimaryFinishedProductID | guid | Product → ProductID | - |
| LocationID | guid | Location → LocationID | - |
| AssignedToTeamMemberID | guid | TeamMember → TeamMemberID | - |
| Remarks | string | - | - |
| PickRemarks | string | - | - |
| PutAwayRemarks | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/OperationType
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/PaymentTerms
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/PricingScheme
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| PricingSchemeID | guid | - | - |
| Timestamp | string | - | - |
| IsActive | boolean | - | - |
| IsDefault | boolean | - | - |
| IsTaxInclusive | boolean | - | - |
| CurrencyID | guid | Currency → CurrencyID | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Product/operation/GetProducts
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| Description | string | - | - |
| ProductID | guid | - | - |
| IsActive | boolean | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| Sku | string | - | - |
| ItemType | string | - | - |
| CategoryID | guid | Category → CategoryID | - |
| LastVendorID | guid | Vendor → VendorID | - |
| CreatedDttm | datetime | - | - |
| AutoAssemble | boolean | - | - |
| IncludeQuantityBuildable | boolean | - | - |
| IsManufacturable | boolean | - | - |
| TrackExpiry | boolean | - | - |
| TrackLots | boolean | - | - |
| TrackSerials | boolean | - | - |
| ExpiryNotificationDays | int | - | - |
| SellBeforeExpiryDays | int | - | - |
| ShelfLifeDays | int | - | - |
| Height | decimal | - | - |
| Length | decimal | - | - |
| Width | decimal | - | - |
| Weight | decimal | - | - |
| HsTariffNumber | string | - | - |
| OriginCountry | string | - | - |
| Remarks | string | - | - |
| StandardUomName | string | - | - |
| TotalQuantityOnHand | decimal | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/ProductGroup
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| ProductGroupID | guid | - | - |
| Timestamp | string | - | - |
| IsActive | boolean | - | - |
| CategoryID | guid | Category → CategoryID | - |
| DefaultProductID | guid | Product → ProductID | - |
| DefaultImageID | guid | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/PurchaseOrder/operation/GetPurchaseOrders
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| PurchaseOrderID | guid | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| OrderNumber | string | - | - |
| VendorID | guid | Vendor → VendorID | - |
| VendorOrderNumber | string | - | - |
| OrderDate | datetime | - | - |
| DueDate | datetime | - | - |
| RequestShipDate | datetime | - | - |
| InventoryStatus | string | - | - |
| PaymentStatus | string | - | - |
| IsCancelled | boolean | - | - |
| IsCompleted | boolean | - | - |
| IsQuote | boolean | - | - |
| IsTaxInclusive | boolean | - | - |
| ShowShipping | boolean | - | - |
| Carrier | string | - | - |
| ContactName | string | - | - |
| string | - | - | |
| Phone | string | - | - |
| ShipToCompanyName | string | - | - |
| OrderRemarks | string | - | - |
| ReceiveRemarks | string | - | - |
| ReturnRemarks | string | - | - |
| UnstockRemarks | string | - | - |
| SubTotal | decimal | - | - |
| Freight | decimal | - | - |
| Tax1 | decimal | - | - |
| Tax1Name | string | - | - |
| Tax1Rate | decimal | - | - |
| Tax1OnShipping | boolean | - | - |
| Tax2 | decimal | - | - |
| Tax2Name | string | - | - |
| Tax2Rate | decimal | - | - |
| Tax2OnShipping | boolean | - | - |
| CalculateTax2OnTax1 | boolean | - | - |
| Total | decimal | - | - |
| AmountPaid | decimal | - | - |
| Balance | decimal | - | - |
| ReturnFee | decimal | - | - |
| ReturnExtra | decimal | - | - |
| ExchangeRate | decimal | - | - |
| CurrencyID | guid | Currency → CurrencyID | - |
| LocationID | guid | Location → LocationID | - |
| PaymentTermsID | guid | PaymentTerms → PaymentTermsID | - |
| TaxingSchemeID | guid | TaxingScheme → TaxingSchemeID | - |
| ApproverTeamMemberID | guid | TeamMember → TeamMemberID | - |
| AssignedToTeamMemberID | guid | TeamMember → TeamMemberID | - |
| VendorAddress1 | string | - | - |
| VendorAddress2 | string | - | - |
| VendorCity | string | - | - |
| VendorState | string | - | - |
| VendorCountry | string | - | - |
| VendorPostalCode | string | - | - |
| ShipToAddress1 | string | - | - |
| ShipToAddress2 | string | - | - |
| ShipToCity | string | - | - |
| ShipToState | string | - | - |
| ShipToCountry | string | - | - |
| ShipToPostalCode | string | - | - |
| NonVendorCostsValue | decimal | - | - |
| NonVendorCostsIsPercent | boolean | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/SalesOrder/operation/GetSalesOrders
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| SalesOrderID | guid | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| OrderNumber | string | - | - |
| CustomerID | guid | Customer → CustomerID | - |
| OrderDate | datetime | - | - |
| DueDate | datetime | - | - |
| InvoicedDate | datetime | - | - |
| RequestedShipDate | datetime | - | - |
| InventoryStatus | string | - | - |
| PaymentStatus | string | - | - |
| IsCancelled | boolean | - | - |
| IsCompleted | boolean | - | - |
| IsQuote | boolean | - | - |
| IsInvoiced | boolean | - | - |
| IsPicking | boolean | - | - |
| IsFullyPicked | boolean | - | - |
| IsPrioritized | boolean | - | - |
| IsTaxInclusive | boolean | - | - |
| NeedsConfirmation | boolean | - | - |
| SameBillingAndShipping | boolean | - | - |
| ShowShipping | boolean | - | - |
| ContactName | string | - | - |
| string | - | - | |
| Phone | string | - | - |
| PoNumber | string | - | - |
| ExternalID | string | - | - |
| Source | string | - | - |
| SalesRep | string | - | - |
| ShipToCompanyName | string | - | - |
| OrderRemarks | string | - | - |
| PickRemarks | string | - | - |
| PackRemarks | string | - | - |
| ShipRemarks | string | - | - |
| ReturnRemarks | string | - | - |
| RestockRemarks | string | - | - |
| SubTotal | decimal | - | - |
| OrderFreight | decimal | - | - |
| Tax1 | decimal | - | - |
| Tax1Name | string | - | - |
| Tax1Rate | decimal | - | - |
| Tax1OnShipping | boolean | - | - |
| Tax2 | decimal | - | - |
| Tax2Name | string | - | - |
| Tax2Rate | decimal | - | - |
| Tax2OnShipping | boolean | - | - |
| CalculateTax2OnTax1 | boolean | - | - |
| Total | decimal | - | - |
| AmountPaid | decimal | - | - |
| Balance | decimal | - | - |
| ReturnFee | decimal | - | - |
| ReturnFreight | decimal | - | - |
| ExchangeRate | decimal | - | - |
| CurrencyID | guid | Currency → CurrencyID | - |
| LocationID | guid | Location → LocationID | - |
| PaymentTermsID | guid | PaymentTerms → PaymentTermsID | - |
| PricingSchemeID | guid | PricingScheme → PricingSchemeID | - |
| TaxingSchemeID | guid | TaxingScheme → TaxingSchemeID | - |
| SalesRepTeamMemberID | guid | TeamMember → TeamMemberID | - |
| AssignedToTeamMemberID | guid | TeamMember → TeamMemberID | - |
| ConfirmerTeamMemberID | guid | TeamMember → TeamMemberID | - |
| BillingAddress1 | string | - | - |
| BillingAddress2 | string | - | - |
| BillingCity | string | - | - |
| BillingState | string | - | - |
| BillingCountry | string | - | - |
| BillingPostalCode | string | - | - |
| ShippingAddress1 | string | - | - |
| ShippingAddress2 | string | - | - |
| ShippingCity | string | - | - |
| ShippingState | string | - | - |
| ShippingCountry | string | - | - |
| ShippingPostalCode | string | - | - |
| NonCustomerCostValue | decimal | - | - |
| NonCustomerCostIsPercent | boolean | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockAdjustment/operation/GetStockAdjustments
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| StockAdjustmentID | guid | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| AdjustmentNumber | string | - | - |
| Date | datetime | - | - |
| IsCancelled | boolean | - | - |
| AdjustmentReasonID | guid | AdjustmentReason → AdjustmentReasonID | - |
| LocationID | guid | Location → LocationID | - |
| Remarks | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockCount/operation/GetStockCounts
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| StockCountID | guid | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| StockCountNumber | string | - | - |
| Status | string | - | - |
| StartedDate | datetime | - | - |
| CompletedDate | datetime | - | - |
| IsCancelled | boolean | - | - |
| IsCompleted | boolean | - | - |
| IsPrepared | boolean | - | - |
| IsReviewed | boolean | - | - |
| IsStarted | boolean | - | - |
| LocationID | guid | Location → LocationID | - |
| AssignedToTeamMemberID | guid | TeamMember → TeamMemberID | - |
| Remarks | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockroomUser
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockTransfer/operation/GetStockTransfers
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| StockTransferID | guid | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| TransferNumber | string | - | - |
| Status | string | - | - |
| TransferDate | datetime | - | - |
| SentDate | datetime | - | - |
| ReceivedDate | datetime | - | - |
| IsCancelled | boolean | - | - |
| FromLocationID | guid | Location → LocationID | - |
| ToLocationID | guid | Location → LocationID | - |
| AssignedToTeamMemberID | guid | TeamMember → TeamMemberID | - |
| Remarks | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/TaxCode
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| TaxCodeID | guid | - | - |
| Timestamp | string | - | - |
| IsActive | boolean | - | - |
| Tax1Rate | decimal | - | - |
| Tax2Rate | decimal | - | - |
| TaxingSchemeID | guid | TaxingScheme → TaxingSchemeID | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/TaxingScheme
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| TaxingSchemeID | guid | - | - |
| Timestamp | string | - | - |
| IsActive | boolean | - | - |
| IsDefault | boolean | - | - |
| Tax1Name | string | - | - |
| Tax1OnShipping | boolean | - | - |
| Tax2Name | string | - | - |
| Tax2OnShipping | boolean | - | - |
| CalculateTax2OnTax1 | boolean | - | - |
| DefaultTaxCodeID | guid | TaxCode → TaxCodeID | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/TeamMember
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Vendor/operation/GetVendors
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| VendorID | guid | - | - |
| IsActive | boolean | - | - |
| LastModifiedDateTime | datetime | - | - |
| LastModifiedByID | guid | - | - |
| Timestamp | string | - | - |
| ContactName | string | - | - |
| string | - | - | |
| Phone | string | - | - |
| Fax | string | - | - |
| Website | string | - | - |
| Remarks | string | - | - |
| DefaultCarrier | string | - | - |
| DefaultPaymentMethod | string | - | - |
| Discount | decimal | - | - |
| IsTaxInclusivePricing | boolean | - | - |
| LeadTimeDays | int | - | - |
| DefaultAddressID | guid | VendorAddress → VendorAddressID | - |
| CurrencyID | guid | Currency → CurrencyID | - |
| DefaultPaymentTermsID | guid | PaymentTerms → PaymentTermsID | - |
| TaxingSchemeID | guid | TaxingScheme → TaxingSchemeID | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Customer/operation/GetCustomers
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| CustomerRemoteID | string | Customer → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| CustomerAddressID | guid | - | - |
| Timestamp | string | - | - |
| CustomerID | guid | Customer → CustomerID | - |
| Address1 | string | - | - |
| Address2 | string | - | - |
| City | string | - | - |
| State | string | - | - |
| Country | string | - | - |
| PostalCode | string | - | - |
| AddressRemarks | string | - | - |
| AddressType | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/ManufacturingOrder/operation/GetManufacturingOrders
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| ManufacturingOrderRemoteID | string | ManufacturingOrder → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Description | string | - | - |
| ManufacturingOrderLineID | guid | - | - |
| Timestamp | string | - | - |
| ManufacturingOrderID | guid | ManufacturingOrder → ManufacturingOrderID | - |
| ParentManufacturingOrderLineID | guid | ManufacturingOrderLine → ManufacturingOrderLineID | - |
| ProductID | guid | Product → ProductID | - |
| StandardQuantity | decimal | - | - |
| UomQuantity | decimal | - | - |
| Uom | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/ManufacturingOrder/operation/GetManufacturingOrders
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| ManufacturingOrderRemoteID | string | ManufacturingOrder → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Description | string | - | - |
| ManufacturingOrderPickLineID | guid | - | - |
| Timestamp | string | - | - |
| ManufacturingOrderID | guid | ManufacturingOrder → ManufacturingOrderID | - |
| ProductID | guid | Product → ProductID | - |
| LocationID | guid | Location → LocationID | - |
| LotID | guid | - | - |
| Sublocation | string | - | - |
| PickDate | datetime | - | - |
| StandardQuantity | decimal | - | - |
| UomQuantity | decimal | - | - |
| Uom | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/ManufacturingOrder/operation/GetManufacturingOrders
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| ManufacturingOrderRemoteID | string | ManufacturingOrder → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Description | string | - | - |
| ManufacturingOrderPutLineID | guid | - | - |
| Timestamp | string | - | - |
| ManufacturingOrderID | guid | ManufacturingOrder → ManufacturingOrderID | - |
| ProductID | guid | Product → ProductID | - |
| LocationID | guid | Location → LocationID | - |
| LotID | guid | - | - |
| Sublocation | string | - | - |
| StandardQuantity | decimal | - | - |
| UomQuantity | decimal | - | - |
| Uom | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Product/operation/GetProducts
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| ProductRemoteID | string | Product → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| InventoryLineID | string | - | - |
| Timestamp | string | - | - |
| ProductID | guid | Product → ProductID | - |
| LocationID | guid | Location → LocationID | - |
| LotID | guid | - | - |
| Sublocation | string | - | - |
| Serial | string | - | - |
| QuantityOnHand | decimal | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Product/operation/GetProducts
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| ProductRemoteID | string | Product → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| ProductPriceID | guid | - | - |
| Timestamp | string | - | - |
| ProductID | guid | Product → ProductID | - |
| PricingSchemeID | guid | PricingScheme → PricingSchemeID | - |
| PriceType | string | - | - |
| UnitPrice | decimal | - | - |
| FixedMarkup | decimal | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Product/operation/GetProducts
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| ProductRemoteID | string | Product → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| VendorItemID | guid | - | - |
| Timestamp | string | - | - |
| ProductID | guid | Product → ProductID | - |
| VendorID | guid | Vendor → VendorID | - |
| VendorItemCode | string | - | - |
| Cost | decimal | - | - |
| LeadTimeDays | int | - | - |
| LineNum | int | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/ProductGroup
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| ProductGroupRemoteID | string | ProductGroup → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| ProductGroupOptionID | guid | - | - |
| ProductGroupID | guid | ProductGroup → ProductGroupID | - |
| LineNum | int | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/PurchaseOrder/operation/GetPurchaseOrders
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| PurchaseOrderRemoteID | string | PurchaseOrder → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Description | string | - | - |
| PurchaseOrderLineID | guid | - | - |
| Timestamp | string | - | - |
| PurchaseOrderID | guid | PurchaseOrder → PurchaseOrderID | - |
| ProductID | guid | Product → ProductID | - |
| VendorItemCode | string | - | - |
| UnitPrice | decimal | - | - |
| SubTotal | decimal | - | - |
| Tax1Rate | decimal | - | - |
| Tax2Rate | decimal | - | - |
| TaxCodeID | guid | TaxCode → TaxCodeID | - |
| ServiceCompleted | boolean | - | - |
| ProductHeight | decimal | - | - |
| ProductLength | decimal | - | - |
| ProductWidth | decimal | - | - |
| ProductWeight | decimal | - | - |
| ReturnDate | datetime | - | - |
| StandardQuantity | decimal | - | - |
| UomQuantity | decimal | - | - |
| Uom | string | - | - |
| DiscountValue | decimal | - | - |
| DiscountIsPercent | boolean | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/SalesOrder/operation/GetSalesOrders
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| SalesOrderRemoteID | string | SalesOrder → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Description | string | - | - |
| SalesOrderLineID | guid | - | - |
| Timestamp | string | - | - |
| SalesOrderID | guid | SalesOrder → SalesOrderID | - |
| ProductID | guid | Product → ProductID | - |
| LineNum | int | - | - |
| UnitPrice | decimal | - | - |
| SubTotal | decimal | - | - |
| Tax1Rate | decimal | - | - |
| Tax2Rate | decimal | - | - |
| TaxCodeID | guid | TaxCode → TaxCodeID | - |
| IsDiscarded | boolean | - | - |
| ServiceCompleted | boolean | - | - |
| ReturnDate | datetime | - | - |
| StandardQuantity | decimal | - | - |
| UomQuantity | decimal | - | - |
| Uom | string | - | - |
| DiscountValue | decimal | - | - |
| DiscountIsPercent | boolean | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockAdjustment/operation/GetStockAdjustments
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| StockAdjustmentRemoteID | string | StockAdjustment → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Description | string | - | - |
| StockAdjustmentLineID | guid | - | - |
| Timestamp | string | - | - |
| StockAdjustmentID | guid | StockAdjustment → StockAdjustmentID | - |
| ProductID | guid | Product → ProductID | - |
| LotID | guid | - | - |
| Sublocation | string | - | - |
| StandardQuantity | decimal | - | - |
| UomQuantity | decimal | - | - |
| Uom | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockCount/operation/GetCountSheet
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| StockCountRemoteID | string | StockCount → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| CountSheetID | guid | - | - |
| Timestamp | string | - | - |
| StockCountID | guid | StockCount → StockCountID | - |
| SheetNumber | int | - | - |
| Status | string | - | - |
| StartedDate | datetime | - | - |
| CompletedDate | datetime | - | - |
| IsCancelled | boolean | - | - |
| IsCompleted | boolean | - | - |
| AssignedToTeamMemberID | guid | TeamMember → TeamMemberID | - |
| LastModifiedDateTime | datetime | - | - |
| Remarks | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockTransfer/operation/GetStockTransfers
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| StockTransferRemoteID | string | StockTransfer → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Description | string | - | - |
| StockTransferLineID | guid | - | - |
| Timestamp | string | - | - |
| StockTransferID | guid | StockTransfer → StockTransferID | - |
| ProductID | guid | Product → ProductID | - |
| LotID | guid | - | - |
| FromSublocation | string | - | - |
| ToSublocation | string | - | - |
| StandardQuantity | decimal | - | - |
| UomQuantity | decimal | - | - |
| Uom | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Vendor/operation/GetVendors
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| VendorRemoteID | string | Vendor → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Name | string | - | - |
| VendorAddressID | guid | - | - |
| Timestamp | string | - | - |
| VendorID | guid | Vendor → VendorID | - |
| Address1 | string | - | - |
| Address2 | string | - | - |
| City | string | - | - |
| State | string | - | - |
| Country | string | - | - |
| PostalCode | string | - | - |
| AddressRemarks | string | - | - |
| AddressType | string | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/ProductGroup
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| ProductGroupOptionRemoteID | string | ProductGroupOption → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| ProductGroupOptionValueID | guid | - | - |
| ProductGroupOptionID | guid | ProductGroupOption → ProductGroupOptionID | - |
| Value | string | - | - |
| LineNum | int | - | - |
Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockCount/operation/GetCountSheet
| Column | Type | Relates to | Notes |
|---|---|---|---|
| RemoteID | string | - | - |
| StockCountSheetRemoteID | string | StockCountSheet → RemoteID | - |
| WhenUpsertedIntoDataStore | datetime | - | - |
| MirrorRemoteID | int | - | - |
| IsDeleted | boolean | - | - |
| WhenCreated | datetime | - | - |
| WhenModified | datetime | - | - |
| Description | string | - | - |
| CountSheetLineID | guid | - | - |
| Timestamp | string | - | - |
| CountSheetID | guid | StockCountSheet → CountSheetID | - |
| ProductID | guid | Product → ProductID | - |
| LotID | guid | - | - |
| Sublocation | string | - | - |
| SnapshotStandardQuantity | decimal | - | - |
| CountedStandardQuantity | decimal | - | - |
| CountedUomQuantity | decimal | - | - |
| Uom | string | - | - |
SYNCHUB lives and breathes APIs and data. Keep exploring using the links below.