Explore the inFlow API data model

See how the various inFlow endpoints relate to each other, using our handy Entity Relationship Diagram

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.

What can you do with your inFlow data?

Connect your AI chatbots & agentic workflows

Our Universal MCP Server lets you query your inFlow data using Claude, ChatGPT or your favourite AI tool.

Empower your BI dashboards

Our inFlow Connector connects your inFlow data to favourite reporting and AI tools.

Your business runs on more than just inFlow

We connect to over 70+ cloud services, letting you manage the data needs of your entire business in a single location.

Endpoints

Browse the data model below, or if you'd prefer, we also have an interactive ERD over here.

AdjustmentReason

Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/AdjustmentReason

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
AdjustmentReasonID guid - -
Timestamp string - -
IsActive boolean - -
IsInternal boolean - -

Category

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 -

Currency

Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Currency

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CurrencyID guid - -
Timestamp string - -
IsoCode string - -
Symbol string - -
IsSymbolFirst boolean - -
DecimalPlaces int - -
DecimalSeparator string - -
ThousandsSeparator string - -
NegativeType string - -

Customer

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 - -
Email 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 -

CustomFieldDefinition

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 -

Location

Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/Location

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
LocationID guid - -
Timestamp string - -
IsActive boolean - -
IsDefault boolean - -
Address1 string - -
Address2 string - -
City string - -
State string - -
Country string - -
PostalCode string - -

ManufacturingOrder

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 - -

OperationType

Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/OperationType

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
OperationTypeID guid - -
Timestamp string - -
IsActive boolean - -
IsDefault boolean - -
TrackTime boolean - -
EstimatedPerHourCost decimal - -

PaymentTerms

Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/PaymentTerms

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
PaymentTermsID guid - -
Timestamp string - -
IsActive boolean - -
DaysDue int - -

PricingScheme

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 -

Product

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 - -

ProductGroup

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 - -

PurchaseOrder

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 - -
Email 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 - -

SalesOrder

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 - -
Email 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 - -

StockAdjustment

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 - -

StockCount

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 - -

StockroomUser

Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/StockroomUser

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
StockroomUserID guid - -
Timestamp string - -
IsActive boolean - -
LastModifiedByID guid - -

StockTransfer

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 - -

TaxCode

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 -

TaxingScheme

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 -

TeamMember

Documentation: https://cloudapi.inflowinventory.com/docs/index.html#tag/TeamMember

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
TeamMemberID guid - -
Timestamp string - -
Email string - -
IsActive boolean - -
IsInternal boolean - -
CanBeSalesRep boolean - -
AccessAllLocations boolean - -

Vendor

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 - -
Email 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 -

CustomerAddress

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 - -

ManufacturingOrderLine

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 - -

ManufacturingOrderPickLine

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 - -

ManufacturingOrderPutLine

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 - -

ProductInventoryLine

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 - -

ProductPrice

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 - -

ProductVendorItem

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 - -

ProductGroupOption

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 - -

PurchaseOrderLine

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 - -

SalesOrderLine

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 - -

StockAdjustmentLine

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 - -

StockCountSheet

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 - -

StockTransferLine

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 - -

VendorAddress

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 - -

ProductGroupOptionValue

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 - -

StockCountSheetLine

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 - -

Need more?

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