2024 is the year of the connector - vote here

Explore the Katana Cloud Manufacturing API data model

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

Try our interactive ERD Or, browse below

Pulling data from the Katana Cloud Manufacturing 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 Katana Cloud Manufacturing 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

Customer

Documentation: https://developer.katanamrp.com/reference/customer

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Email string - -
Phone string - -
Currency string - -
Comment string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

Inventory

Documentation: https://developer.katanamrp.com/reference/inventory

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
VariantID long Variant → ID -
LocationID long Location → ID -
ReorderPoint decimal - -
AverageCost decimal - -
ValueInStock decimal - -
QuantityInStock decimal - -
QuantityCommitted decimal - -
QuantityExpected decimal - -
QuantityMissingOrExcess decimal - -

Location

Documentation: https://developer.katanamrp.com/reference/location

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
LegalName string - -
AddressID long - -
IsPrimary boolean - -
SalesAllowed boolean - -
PurchaseAllowed boolean - -
ManufacturingAllowed boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

ManufacturingOrder

Documentation: https://developer.katanamrp.com/reference/getallmanufacturingorders

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Status string - -
OrderNo string - -
VariantID long Variant → ID -
PlannedQuantity decimal - -
ActualQuantity decimal - -
LocationID long Location → ID -
OrderCreatedDate datetime - -
DoneDate datetime - -
ProductionDeadlineDate datetime - -
AdditionalInfo string - -
IsLinkedToSalesOrder boolean - -
SalesOrderID long SalesOrder → ID -
SalesOrderRowID long SalesOrderRow → ID -
IngredientAvailability string - -
MaterialCost decimal - -
SubassembliesCost decimal - -
OperationsCost decimal - -
TotalCost decimal - -
TotalActualTime decimal - -
TotalPlannedTime decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

ManufacturingOrderRecipe

Documentation: https://developer.katanamrp.com/reference/getallmanufacturingorderreciperows

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ManufacturingOrderID long ManufacturingOrder → ID -
VariantID long Variant → ID -
Notes string - -
PlannedQuantityPerUnit decimal - -
TotalActualQuantity decimal - -
IngredientAvailability string - -
IngredientExpectedDate datetime - -
Cost decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

Material

Documentation: https://developer.katanamrp.com/reference/material

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Uom string - -
CategoryName string - -
Type string - -
AdditionalInfo string - -
PurchaseUom string - -
PurchaseUomConversionRate decimal - -
DefaultSupplierID long Supplier → ID -
BatchTracked boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

PriceList

Documentation: https://developer.katanamrp.com/reference/getallpricelists

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CreatedAt datetime - -
UpdatedAt datetime - -
IsActive boolean - -

PriceListRow

Documentation: https://developer.katanamrp.com/reference/getallpricelistrows

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CreatedAt datetime - -
UpdatedAt datetime - -
PriceListID long PriceList → ID -
VariantID long Variant → ID -
AdjustmentMethod string - -
Amount decimal - -

Product

Documentation: https://developer.katanamrp.com/reference/product

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Uom string - -
CategoryName string - -
IsProducible boolean - -
DefaultSupplierID long Supplier → ID -
IsPurchasable boolean - -
Type string - -
PurchaseUom string - -
PurchaseUomConversionRate decimal - -
BatchTracked boolean - -
AdditionalInfo string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

PurchaseOrder

Documentation: https://developer.katanamrp.com/reference/purchase-order#list-all-purchase-orders

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Status string - -
BillingStatus string - -
LastDocumentStatus string - -
OrderNo string - -
SupplierID long Supplier → ID -
Currency string - -
ExpectedArrivalDate datetime - -
OrderCreatedDate datetime - -
AdditionalInfo string - -
LocationID long Location → ID -
Total decimal - -
TotalInBaseCurrency decimal - -
EntityType string - -
IngredientAvailability string - -
IngredientExpectedDate datetime - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

RecipeRow

Documentation: https://developer.katanamrp.com/reference/recipe

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RecipeID long - -
RecipeRowID long - -
ProductID long Product → ID -
ProductVariantID long Variant → ID -
IngredientVariantID long Variant → ID -
Quantity decimal - -
Notes string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Recipe

Documentation: https://developer.katanamrp.com/reference/recipe

Column Type Relates to Notes
RemoteID string - -
RecipeRowRemoteID string RecipeRow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RecipeID long - -

SalesOrder

Documentation: https://developer.katanamrp.com/reference/sales-order#list-all-sales-orders

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CustomerID long Customer → ID -
OrderNo string - -
Source string - -
OrderCreatedDate datetime - -
DeliveryDate datetime - -
PickedDate datetime - -
LocationID long Location → ID -
Status string - -
Currency string - -
ConversionRate decimal - -
Total decimal - -
TotalInBaseCurrency decimal - -
ConversionDate datetime - -
ProductExpectedDate datetime - -
IngredientExpectedDate datetime - -
ProductAvailability string - -
IngredientAvailability string - -
ProductionStatus string - -
InvoicingStatus string - -
AdditionalInfo string - -
EcommerceOrderType string - -
EcommerceStoreName string - -
EcommerceOrderID string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

SalesOrderFulfillment

Documentation: https://developer.katanamrp.com/reference/the-sales-order-fulfillment-object

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
SalesOrderID long SalesOrder → ID -
TrackingNumber string - -
TrackingUrl string - -
TrackingCarrier string - -
TrackingMethod string - -
PickedDate datetime - -
ConversionRate int - -
ConversionDate datetime - -
Status string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

StockAdjustment

Documentation: https://developer.katanamrp.com/reference/findstockadjustments

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
StockAdjustmentDate string - -
LocationID long Location → ID -
StockAdjustmentNumber string - -
Reason string - -
AdditionalInfo string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

Stocktake

Documentation: https://developer.katanamrp.com/reference/findstocktakes

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
StocktakeNumber string - -
LocationID long Location → ID -
Status string - -
Reason string - -
AdditionalInfo string - -
StocktakeCreatedDate datetime - -
StartedDate datetime - -
CompletedDate datetime - -
StatusUpdateInProgress boolean - -
SetRemainingItemsAsCounted boolean - -
StockAdjustmentID long StockAdjustment → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

StocktakeRow

Documentation: https://developer.katanamrp.com/reference/findstocktakerows

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
VariantID long Product → ID -
BatchID long - -
StocktakeID long Stocktake → ID -
Notes string - -
InStockQuantity decimal - -
CountedQuantity decimal - -
DiscrepancyQuantity decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

StockTransfer

Documentation: https://developer.katanamrp.com/reference/findstocktransfers

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
TransferDate string - -
TargetLocationID long Location → ID -
SourceLocationID long Location → ID -
StockTransferNumber string - -
AdditionalInfo string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

Supplier

Documentation: https://developer.katanamrp.com/reference/supplier

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Email string - -
Comment string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

TaxRate

Documentation: https://developer.katanamrp.com/reference/tax-rate

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Rate decimal - -
IsDefaultSales boolean - -
IsDefaultPurchases boolean - -
DisplayName string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

Variant

Documentation: https://developer.katanamrp.com/reference/variant#list-all-variants

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Sku string - -
SalesPrice decimal - -
ProductID long Product → ID -
MaterialID long Material → ID -
PurchasePrice decimal - -
Type string - -
InternalBarcode string - -
RegisteredBarcode string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

MaterialConfig

Column Type Relates to Notes
RemoteID string - -
MaterialRemoteID string Material → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
MaterialID long Material → ID -

ProductConfig

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

PurchaseOrderRow

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
PurchaseOrderID long PurchaseOrder → ID -
Quantity decimal - -
VariantID long Variant → ID -
TaxRateID long TaxRate → ID -
PricePerUnit decimal - -
Total decimal - -
PurchaseUom string - -
Currency string - -
ConversionRate decimal - -
ConversionDate datetime - -
ReceivedDate datetime - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

SalesOrderRow

Column Type Relates to Notes
RemoteID string - -
SalesOrderRemoteID string SalesOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
SalesOrderID long SalesOrder → ID -
Quantity decimal - -
VariantID long Variant → ID -
TaxRateID long TaxRate → ID -
PricePerUnit decimal - -
PricePerUnitInBaseCurrency decimal - -
Total decimal - -
TotalInBaseCurrency decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -

SalesOrderFulfillmentRow

Column Type Relates to Notes
RemoteID string - -
SalesOrderFulfillmentRemoteID string SalesOrderFulfillment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalesOrderFulfillmentID long SalesOrderFulfillment → ID -
SalesOrderRowID long SalesOrderRow → ID
  • 1 Dec 2022 The ID of the sales order row that is fulfilled, not the ID of the fulfillment row
Quantity decimal - -

StockAdjustmentRow

Column Type Relates to Notes
RemoteID string - -
StockAdjustmentRemoteID string StockAdjustment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
StockAdjustmentID long StockAdjustment → ID -
VariantID long Variant → ID -
Quantity decimal - -
CostPerUnit decimal - -
DeletedAt datetime - -

StockTransferRow

Column Type Relates to Notes
RemoteID string - -
StockTransferRemoteID string StockTransfer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
StockTransferID long StockTransfer → ID -
VariantID long Variant → ID -
Quantity decimal - -
CostPerUnit decimal - -

VariantConfigValue

Column Type Relates to Notes
RemoteID string - -
VariantRemoteID string Variant → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
VariantID long Variant → ID -
ConfigName string - -
ConfigValue string - -

VariantSupplierCode

Column Type Relates to Notes
RemoteID string - -
VariantRemoteID string Variant → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
VariantID long Variant → ID -
Code string - -

MaterialConfigValue

Column Type Relates to Notes
RemoteID string - -
MaterialConfigRemoteID string MaterialConfig → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MaterialConfigID long MaterialConfig → ID -
Value string - -

ProductConfigValue

Column Type Relates to Notes
RemoteID string - -
ProductConfigRemoteID string ProductConfig → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductConfigID long ProductConfig → ID -
Value string - -

SalesOrderRowAttribute

Column Type Relates to Notes
RemoteID string - -
SalesOrderRowRemoteID string SalesOrderRow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalesOrderRowID long SalesOrderRow → ID -
Key string - -
Value string - -

SalesOrderRowBatchTransaction

Column Type Relates to Notes
RemoteID string - -
SalesOrderRowRemoteID string SalesOrderRow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalesOrderRowID long SalesOrderRow → ID -
BatchID long - -
Quantity decimal - -

SalesOrderFulfillmentRowBatchTransaction

Column Type Relates to Notes
RemoteID string - -
SalesOrderFulfillmentRowRemoteID string SalesOrderFulfillmentRow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BatchID long - -
Quantity decimal - -

Need more?

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

Connect your own Katana data Querying Katana using regular SQL