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

Explore the Odoo API data model

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

Try our interactive ERD Or, browse below

Pulling data from the Odoo 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 Odoo 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

Account

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CompanyCurrencyID long Currency → ID -
CurrencyID long Currency → ID -
CompanyID long Company → ID -
RootID long - -
MessageIsFollower boolean - -
HasMessage boolean - -
MessageNeedaction boolean - -
MessageHasError boolean - -
AccountType string - -
Code string - -
Deprecated boolean - -
Used boolean - -
IncludeInitialBalance boolean - -
NonTrade boolean - -
InternalGroup string - -
OpeningDebit decimal - -
OpeningBalance decimal - -
CurrentBalance decimal - -
RelatedTaxesAmount decimal - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

Company

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
HasMessage boolean - -
MessageNeedaction boolean - -
MessageNeedactionCounter int - -
MessageHasError boolean - -
MessageHasErrorCounter int - -
MessageAttachmentCount int - -
Active boolean - -
ParentID long Company → ID -
RootID long Company → ID -
PartnerID long Company → ID -
CompanyDetails string - -
Logo string - -
LogoWeb string - -
UsesDefaultLogo boolean - -
CurrencyID long - -
CountryID long - -
Street string - -
Street2 string - -
Zip string - -
City string - -
StateID long - -
CountryCode string - -
Email string - -
Phone string - -
Mobile string - -
Website string - -
PrimaryColor string - -
SecondaryColor string - -
AliasDomainName string - -
DefaultCashDifferenceIncomeAccountID long Account → ID -
DefaultCashDifferenceExpenseAccountID long Account → ID -
AccountJournalSuspenseAccountID long Account → ID -
AccountJournalPaymentDebitAccountID long Account → ID -
AccountJournalPaymentCreditAccountID long Account → ID -
AccountJournalEarlyPayDiscountGainAccountID long Account → ID -
AccountJournalEarlyPayDiscountLossAccountID long Account → ID -
IncomeCurrencyExchangeAccountID long Account → ID -
ExpenseCurrencyExchangeAccountID long Account → ID -
AccountSaleTaxID long Tax → ID -
AccountPurchaseTaxID long Tax → ID -
AccountDefaultPosReceivableAccountID long Account → ID -
AccountOpeningDate datetime - -
TransferAccountCodePrefix string - -
AccountFiscalCountryID long - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

Contact

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Active boolean - -
IsSeoOptimized boolean - -
IsPublished boolean - -
CanPublish boolean - -
WebsiteMetaTitle string - -
WebsiteMetaDescription string - -
WebsiteMetaKeywords string - -
WebsiteMetaOgImg string - -
SeoName string - -
WebsiteID long - -
EmailNormalized string - -
CompleteName string - -
MessageNeedaction boolean - -
MessageNeedactionCounter int - -
MessageHasError boolean - -
MessageHasErrorCounter int - -
MessageAttachmentCount int - -
MessageHasSmsError boolean - -
IsBlacklisted boolean - -
MessageBounce int - -
Title long - -
ParentID long - -
Lang string - -
ActiveLangCount int - -
Tz string - -
TzOffset string - -
UserID long User → ID -
Website string - -
Comment string - -
Employee boolean - -
Function string - -
Type string - -
Street string - -
Street2 string - -
Zip string - -
City string - -
CountryCode string - -
PartnerLatitude decimal - -
PartnerLongitude decimal - -
Email string - -
Phone string - -
Mobile string - -
IsCompany boolean - -
IsPublic boolean - -
IndustryID long - -
CompanyType string - -
CompanyID long - -
Color string - -
ContactAddress string - -
CompanyName string - -
Barcode string - -
ImStatus string - -
ContactAddressComplete string - -
ContactAddressInline string - -
MeetingCount int - -
CalendarLastNotifAck datetime - -
CertificationsCount int - -
CertificationsCompanyCount int - -
PaymentTokenCount int - -
SignatureCount int - -
PartnerVatPlaceholder string - -
Credit decimal - -
CreditLimit decimal - -
UsePartnerCreditLimit boolean - -
ShowCreditLimit boolean - -
DaysSalesOutstanding decimal - -
Debit decimal - -
DebitLimit decimal - -
TotalInvoiced decimal - -
CurrencyID long - -
JournalItemCount string - -
PropertyAccountPayableID long Account → ID -
PropertyAccountReceivableID long Account → ID -
BankAccountCount int - -
Trust string - -
SupplierRank decimal - -
CustomerRank decimal - -
OpportunityCount int - -
EmployeesCount int - -
TaskCount int - -
IsUblFormat boolean - -
SaleOrderCount int - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

Lead

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
HasMessage boolean - -
MessageIsFollower boolean - -
MessageNeedaction boolean - -
MessageHasError boolean - -
CampaignID long - -
SourceID long - -
MediumID long - -
ActivityState string - -
ActivityUserID long User → ID -
UserID long User → ID -
CompanyID long Company → ID -
PartnerID long Company → ID -
ActivityTypeID long - -
ActivityTypeIcon string - -
ActivitySummary string - -
ActivityDateDeadline datetime - -
MyActivityDateDeadline datetime - -
PhoneSanitized string - -
EmailNormalized string - -
EmailCc string - -
MobileBlacklisted boolean - -
PhoneBlacklisted boolean - -
IsBlacklisted boolean - -
Referred boolean - -
Active boolean - -
Type string - -
Priority decimal - -
StageID long Stage → ID -
CompanyCurrency long Currency → ID -
LostReasonID long LostReason → ID -
ExpectedRevenue decimal - -
DateClosed datetime - -
DateAutomationLast datetime - -
DateOpen datetime - -
DateLastStageUpdate datetime - -
DateConversion datetime - -
DateDeadline datetime - -
DayOpen decimal - -
DayClose decimal - -
ContactName string - -
PartnerName string - -
Title string - -
EmailFrom string - -
EmailDomainCriterion string - -
LangCode string - -
Street string - -
Street2 string - -
Zip string - -
City string - -
StateID long - -
CountryID long - -
Probability decimal - -
AutomatedProbability decimal - -
DisplayName string - -
WonStatus string - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -

LostReason

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
DisplayName string - -
LeadsCount int - -
Active boolean - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -

Stage

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
DisplayName string - -
IsWon boolean - -
Sequence decimal - -
TeamCount decimal - -
Requirements string - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -

Tag

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
DisplayName string - -
Color int - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -

Currency

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
FullName string - -
Symbol string - -
RateString string - -
Rounding decimal - -
DecimalPlaces int - -
Position string - -
CurrencyUnitLabel string - -
CurrencySubunitLabel string - -
FiscalCountryCodes string - -
DisplayRoundingWarning boolean - -
Date datetime - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

InventoryLocation

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Active boolean - -
Barcode string - -
Comment string - -
CompleteName string - -
CyclicInventoryFrequency int - -
ForecastWeight decimal - -
IsEmpty boolean - -
LastInventoryDate datetime - -
NetWeight decimal - -
NextInventoryDate datetime - -
ParentPath string - -
Posx decimal - -
Posy decimal - -
Posz decimal - -
ReplenishLocation boolean - -
ScrapLocation boolean - -
Usage string - -
CompanyID long Company → ID -
LocationID long InventoryLocation → ID -
RemovalStrategyID long - -
StorageCategoryID long - -
ValuationInAccountID long Account → ID -
ValuationOutAccountID long Account → ID -
WarehouseID long Warehouse → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

InventoryRoute

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Active boolean - -
PackageTypeSelectable boolean - -
ProductCategSelectable boolean - -
ProductSelectable boolean - -
SaleSelectable boolean - -
ShippingSelectable boolean - -
WarehouseSelectable boolean - -
CompanyID long Company → ID -
SuppliedWhID long Warehouse → ID -
SupplierWhID long Warehouse → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

Quant

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
ProductID long ProductVariant → ID -
ProductTmplID long ProductTemplate → ID -
ProductUomID long ProductUnitOfMeasure → ID -
IsFavorite boolean - -
CompanyID long Company → ID -
LocationID long InventoryLocation → ID -
WarehouseID long Warehouse → ID -
StorageCategoryID long - -
CyclicInventoryFrequency int - -
LotID long - -
SnDuplicated boolean - -
PackageID long - -
OwnerID long Contact → ID -
Quantity decimal - -
ReservedQuantity decimal - -
AvailableQuantity decimal - -
InDate datetime - -
Tracking string - -
OnHand boolean - -
ProductCategID long ProductCategory → ID -
InventoryQuantity decimal - -
InventoryQuantityAutoApply decimal - -
InventoryDiffQuantity decimal - -
InventoryDate datetime - -
LastCountDate datetime - -
InventoryQuantitySet boolean - -
IsOutdated boolean - -
UserID long User → ID -
Value decimal - -
CurrencyID long Currency → ID -
AccountingDate datetime - -
CostMethod string - -
DummyID string - -
Image1920 string - -
ProductReferenceCode string - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

StockMove

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Priority string - -
Date datetime - -
DateDeadline datetime - -
DescriptionPicking string - -
ProductUomQty decimal - -
LocationUsage string - -
LocationDestUsage string - -
State string - -
Picked boolean - -
PriceUnit decimal - -
Origin string - -
ProcureMethod string - -
IsInventory boolean - -
Availability decimal - -
Quantity decimal - -
PickingCode string - -
IsStorable boolean - -
Additional boolean - -
IsLocked boolean - -
Reference string - -
NextSerial string - -
ToRefund boolean - -
Weight decimal - -
CompanyID long Company → ID -
ProductID long ProductVariant → ID -
LocationID long InventoryLocation → ID -
LocationDestID long InventoryLocation → ID -
LocationFinalID long InventoryLocation → ID -
PartnerID long Contact → ID -
RestrictPartnerID long Contact → ID -
ProductUom long ProductUnitOfMeasure → ID -
PickingID long - -
ScrapID long - -
GroupID long - -
RuleID long - -
PickingTypeID long - -
PackageLevelID long - -
OrderpointID long - -
PackagingUomID long ProductUnitOfMeasure → ID -
WarehouseID long Warehouse → ID -
PurchaseLineID long PurchaseOrderLine → ID -
SaleLineID long SaleOrderLine → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

StockMoveLine

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
DisplayName string - -
Quantity decimal - -
Date datetime - -
ScheduledDate datetime - -
State string - -
IsInventory boolean - -
IsLocked boolean - -
Reference string - -
Origin string - -
Image1920 string - -
PickingID long - -
PackageID long - -
CarrierID long - -
MoveID long StockMove → ID -
CompanyID long Company → ID -
ProductID long ProductVariant → ID -
OwnerID long Contact → ID -
LocationID long InventoryLocation → ID -
LocationDestID long InventoryLocation → ID -
PickingPartnerID long Contact → ID -
QuantID long Quant → ID -
PickingLocationID long InventoryLocation → ID -
PickingLocationDestID long InventoryLocation → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -

Warehouse

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Active boolean - -
BuyToResupply boolean - -
Code string - -
DeliverySteps string - -
ReceptionSteps string - -
Sequence int - -
CompanyID long Company → ID -
PartnerID long Contact → ID -
DeliveryRouteID long InventoryRoute → ID -
ReceptionRouteID long InventoryRoute → ID -
BuyPullID long - -
MtoPullID long - -
OutTypeID long - -
PackTypeID long - -
StoreTypeID long - -
XdockTypeID long - -
PickTypeID long - -
PosTypeID long - -
QcTypeID long - -
InTypeID long - -
IntTypeID long - -
LotStockID long InventoryLocation → ID -
ViewLocationID long InventoryLocation → ID -
WhInputStockLocID long InventoryLocation → ID -
WhOutputStockLocID long InventoryLocation → ID -
WhPackStockLocID long InventoryLocation → ID -
WhQcStockLocID long InventoryLocation → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

Journal

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Code string - -
AliasName string - -
AliasDomain string - -
AliasDefaults string - -
AliasEmail string - -
AccessUrl string - -
Type string - -
DefaultAccountType long - -
InvoiceReferenceType string - -
InvoiceReferenceModel string - -
Active boolean - -
DefaultAccountID long Account → ID -
SuspenseAccountID long Account → ID -
CompanyID long Company → ID -
CompanyPartnerID long Company → ID -
CountryCode string - -
Color int - -
EntriesCount int - -
HasEntries boolean - -
HasPostedEntries boolean - -
HasSequenceHoles boolean - -
HasUnhashedEntries boolean - -
ShowOnDashboard boolean - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

JournalEntryLine

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
AnalyticPrecision decimal - -
ParentState string - -
Ref string - -
MoveType string - -
Debit decimal - -
Credit decimal - -
Balance decimal - -
CumulatedBalance decimal - -
CurrencyRate decimal - -
AmountCurrency decimal - -
IsSameCurrency boolean - -
CurrencyID long Currency → ID -
ProductID long ProductVariant → ID -
ProductCategoryID long ProductCategory → ID -
MoveID long JournalEntry → ID -
Quantity decimal - -
PriceTotal decimal - -
PriceUnit decimal - -
PriceSubtotal decimal - -
Discount decimal - -
TaxCalculationRoundingMethod string - -
DisplayName string - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -

JournalEntry

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
SequencePrefix string - -
DisplayName string - -
AccessUrl string - -
Ref string - -
Date datetime - -
InvoiceDate datetime - -
InvoiceDateDue datetime - -
DeliveryDate datetime - -
State string - -
PaymentReference string - -
MoveType string - -
IsStorno boolean - -
SequenceNumber int - -
AmountUntaxed decimal - -
AmountTax decimal - -
AmountTotal decimal - -
AmountResidual decimal - -
AmountUntaxedSigned decimal - -
AmountTaxSigned decimal - -
AmountTotalSigned decimal - -
AmountTotalInCurrencySigned decimal - -
AmountResidualSigned decimal - -
TaxTotalAmountUntaxed decimal - -
TaxTotalAmountTotal decimal - -
TaxTotalAmountTotalCompanyCurrnecyDecimal decimal - -
TaxTotalFormattedAmountTotal string - -
TaxTotalFormattedAmountUntaxed string - -
PaymentState string - -
AmountTotalWords string - -
MoveSentValues string - -
InvoiceOrigin string - -
InvoiceUserID long User → ID -
UserID long User → ID -
JournalID long Journal → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -

Message

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Subject string - -
Body string - -
Preview string - -
Model string - -
ResID long - -
RecordCompanyID long Company → ID -
AuthorID long User → ID -
RecordName string - -
MessageType string - -
Date datetime - -
IsInternal boolean - -
Needaction boolean - -
HasError boolean - -
EmailFrom string - -
MessageID string - -
AuthorAvatar string - -
ContactID long Contact → ID -
CompanyID long Company → ID -
JournalID long Journal → ID -
TaxID long Tax → ID -
AccountID long Account → ID -
ProductCategoryID long ProductCategory → ID -
ProductTemplateID long ProductTemplate → ID -
ProductVariantID long ProductVariant → ID -
SaleOrderID long SaleOrder → ID -
LeadID long Lead → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

ProductUnitOfMeasure

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Active boolean - -
Factor decimal - -
FiscalCountryCode string - -
IsPosGroupable boolean - -
PackagingBarcodesCount long - -
ParentPath string - -
RelativeFactor decimal - -
Rounding decimal - -
TimesheetWidget string - -
PackageTypeID long - -
RelativeUomID long ProductUnitOfMeasure → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

Project

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
AliasName string - -
AliasDomain string - -
AliasEmail string - -
AccessUrl string - -
AccessWarning string - -
LabelTasks string - -
PrivacyVisibility string - -
PrivacyVisibilityWarning string - -
RatingStatus string - -
PricingType string - -
BillingType string - -
TaskCount int - -
OpenTaskCount int - -
ClosedTaskCount int - -
TotalTimesheetTime long - -
RemainingHours decimal - -
AllocatedHours decimal - -
EffectiveHours decimal - -
DateStart datetime - -
Date datetime - -
RatingRequestDeadline datetime - -
Active boolean - -
IsFavorite boolean - -
AllowTaskDependencies boolean - -
AllowMilestones boolean - -
RatingActive boolean - -
AllowTimesheets boolean - -
AnalyticAccountActive boolean - -
TaskCompletionPercentage decimal - -
AccountID long Account → ID -
PartnerID long Contact → ID -
CompanyID long Company → ID -
AliasID long - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

ProjectMilestone

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Active boolean - -
AllowBillable boolean - -
Deadline datetime - -
ReachedDate datetime - -
ProductUomQty decimal - -
CompanyID long Company → ID -
MailTemplateID long - -
ProductUomID long - -
SmsTemplateID long - -
SaleLineID long SaleOrderLine → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

ProjectStage

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Active boolean - -
Fold boolean - -
CompanyID long Company → ID -
MailTemplateID long - -
SmsTemplateID long - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

ProjectTask

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
Active boolean - -
IsClosed boolean - -
RatingActive boolean - -
AllowTimesheets boolean - -
AnalyticAccountActive boolean - -
TimerStart datetime - -
TimerPause datetime - -
DateEnd datetime - -
DateAssign datetime - -
DateDeadline datetime - -
DateLastStageUpdate datetime - -
PlannedDateBegin datetime - -
PlannedDateStart datetime - -
WorkingHoursOpen decimal - -
WorkingHoursClose decimal - -
WorkingDaysOpen decimal - -
WorkingDaysClose decimal - -
RemainingHours decimal - -
RemainingHoursPercentage decimal - -
EffectiveHours decimal - -
TotalHoursSpent decimal - -
Progress decimal - -
Overtime decimal - -
SubtaskEffectiveHours decimal - -
CompanyID long Company → ID -
StageID long Stage → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

PurchaseOrder

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
DateOrder datetime - -
DateApprove datetime - -
DatePlanned datetime - -
DateCalendarStart datetime - -
EffectiveDate datetime - -
PartnerRef string - -
State string - -
InvoiceStatus string - -
TaxCalculationRoundingMethod string - -
AmountUntaxed decimal - -
AmountTotal decimal - -
AmountTotalCc decimal - -
CurrencyRate decimal - -
OnTimeRate decimal - -
CountryCode string - -
CompanyPriceInclude string - -
ReceiptStatus string - -
IsLate boolean - -
ShowComparison boolean - -
IsShipped boolean - -
CurrencyID long Currency → ID -
PartnerID long Contact → ID -
DestAddressID long - -
UserID long User → ID -
ProductID long ProductVariant → ID -
TaxCountryID long - -
CompanyID long Company → ID -
CompanyCurrencyID long - -
PickingTypeID long - -
GroupID long - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

PurchaseOrderLine

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
DisplayName string - -
ProductQty decimal - -
ProductUomQty decimal - -
Discount decimal - -
DatePlanned datetime - -
DateOrder datetime - -
DateApprove datetime - -
ProductType string - -
State string - -
QtyReceivedMethod string - -
TaxCalculationRoundingMethod string - -
DisplayType string - -
IsDownpayment boolean - -
PriceUnit decimal - -
PriceUnitDiscounted decimal - -
PriceSubtotal decimal - -
PriceTotal decimal - -
PriceTax decimal - -
QtyInvoiced decimal - -
QtyReceived decimal - -
QtyReceivedManual decimal - -
QtyToInvoice decimal - -
ProductUomID long ProductUnitOfMeasure → ID -
ProductID long ProductVariant → ID -
OrderID long PurchaseOrder → ID -
PartnerID long Contact → ID -
SaleOrderID long SaleOrder → ID -
SaleOrderLineID long SaleOrderLine → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -

ProductCategory

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
ParentID long ProductCategory → ID -
CompleteName string - -
HasMessage boolean - -
MessageNeedaction boolean - -
MessageHasError boolean - -
ProductCount int - -
PackagingReserveMethod string - -
PropertyValuation string - -
PropertyCostMethod string - -
FilterForStockPutawayRule string - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

ProductTemplate

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
IsPublished boolean - -
CanPublish boolean - -
IsSeoOptimized boolean - -
HasMessage boolean - -
MessageNeedaction boolean - -
MessageHasError boolean - -
WebsiteUrl string - -
WebsiteMetaDescription string - -
WebsiteMetaKeywords string - -
SeoName string - -
Sequence decimal - -
DescriptionPurchase string - -
DescriptionSale string - -
Type string - -
ServiceTracking string - -
CategID long ProductCategory → ID -
CurrencyID long Currency → ID -
CostCurrencyID long Currency → ID -
CompanyID long Company → ID -
ListPrice decimal - -
StandardPrice decimal - -
Volume decimal - -
VolumeUomName string - -
Weight decimal - -
WeightUomName string - -
UomName string - -
SaleOk boolean - -
PurchaseOk boolean - -
AvailableInPos boolean - -
Active boolean - -
Barcode string - -
DefaultCode string - -
QtyAvailable decimal - -
VirtualAvailable decimal - -
OutgoingQty decimal - -
IncomingQty decimal - -
CostMethod string - -
Valuation string - -
OutOfStockMessage string - -
BaseUnitName string - -
BaseUnitPrice decimal - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

ProductVariant

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
HasMessage boolean - -
MessageNeedaction boolean - -
MessageHasError boolean - -
PriceExtra decimal - -
LstPrice decimal - -
DefaultCode string - -
Code string - -
PartnerRef string - -
Barcode string - -
Active boolean - -
Volume decimal - -
Weight decimal - -
TaxString string - -
QtyAvailable decimal - -
VirtualAvailable decimal - -
FreeQty decimal - -
IncomingQty decimal - -
OutgoingQty decimal - -
ReorderingMinQty decimal - -
ReorderingMaxQty decimal - -
ValidEan boolean - -
ValueSvl decimal - -
QuantitySvl decimal - -
TotalValue decimal - -
AvgCost decimal - -
Valuation string - -
CostMethod string - -
IsPublished boolean - -
CanPublish boolean - -
IsSeoOptimized boolean - -
WebsiteUrl string - -
WebsiteMetaDescription string - -
WebsiteMetaKeywords string - -
SeoName string - -
DescriptionPurchase string - -
DescriptionSale string - -
Type string - -
ProductTmplID long ProductTemplate → ID -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

SaleOrder

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CompanyID long Company → ID -
PartnerID long Company → ID -
PartnerInvoiceID long Company → ID -
PartnerShippingID long Company → ID -
CurrencyID long Currency → ID -
UserID long User → ID -
TaxCountryID long - -
State string - -
Reference string - -
Note string - -
InvoiceStatus string - -
TaxCalculationRoundingMethod string - -
TermsType string - -
TypeName string - -
Health string - -
Incoterm string - -
PrepaymentPercent decimal - -
CurrencyRate decimal - -
AmountUntaxed decimal - -
AmountTax decimal - -
AmountTotal decimal - -
AmountToInvoice decimal - -
AmountInvoiced decimal - -
InvoiceCount decimal - -
DurationDays decimal - -
RemainingHours decimal - -
AmountUnpaid decimal - -
Locked boolean - -
RequireSignature boolean - -
RequirePayment boolean - -
IsExpired boolean - -
HasArchivedProducts boolean - -
DateOrder datetime - -
ValidityDate datetime - -
NextActionDate datetime - -
EffectiveDate datetime - -
EndDate datetime - -
FirstContractDate datetime - -
StartDate datetime - -
LastInvoiceDate datetime - -
NextInvoiceDate datetime - -
HasMessage boolean - -
HasPickableLines boolean - -
HasReturnableLines boolean - -
IsLate boolean - -
MessageNeedaction boolean - -
MessageHasError boolean - -
TaxTotalAmountUntaxed decimal - -
TaxTotalAmountTotal decimal - -
TaxTotalAmountTotalCompanyCurrnecyDecimal decimal - -
TaxTotalFormattedAmountTotal string - -
TaxTotalFormattedAmountUntaxed string - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

SaleOrderLine

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
OrderID long SaleOrder → ID -
CompanyID long Company → ID -
CurrencyID long Company → ID -
ProductID long ProductVariant → ID -
SalesmanID long User → ID -
State string - -
DisplayType string - -
QtyDeliveredMethod string - -
ProductUomQty decimal - -
PriceUnit decimal - -
Discount decimal - -
PriceSubtotal decimal - -
PriceTotal decimal - -
PriceTax decimal - -
PriceReduceTaxexcl decimal - -
PriceReduceTaxinc decimal - -
QtyDelivered decimal - -
QtyInvoiced decimal - -
QtyToInvoice decimal - -
ProductQty decimal - -
QtyReturned decimal - -
QtyToDeliver decimal - -
DeliveredPriceSubtotal decimal - -
DeliveredPriceTax decimal - -
DeliveredPriceTotal decimal - -
StartDate datetime - -
ReturnDate datetime - -
Sequence decimal - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

Tax

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
TypeTaxUse string - -
AmountType string - -
NameSearchable boolean - -
Active boolean - -
InvoiceLabel string - -
PriceInclude boolean - -
IncludeBaseAmount boolean - -
IsBaseAffected boolean - -
Analytic boolean - -
HideTaxExigibility boolean - -
TaxExigibility string - -
CompanyID long Company → ID -
CashBasisTransitionAccountID long Account → ID -
CountryCode string - -
IsUsed boolean - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

User

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Login string - -
Signature string - -
Active boolean - -
ActivePartner boolean - -
Share boolean - -
LoginDate datetime - -
Email string - -
CompaniesCount int - -
ResUsersSettingsID long User → ID -
CompanyID long Company → ID -
UserGroupWarning boolean - -
TotpEnabled boolean - -
State string - -
Karma long - -
GoldBadge int - -
SilverBadge int - -
BronzeBadge int - -
JobTitle string - -
WorkPhone string - -
MobilePhone string - -
WorkEmail string - -
DepartmentID long - -
Gender string - -
Birthday string - -
PlaceOfBirth string - -
CountryOfBirth string - -
Marital string - -
SpouseCompleteName string - -
SpouseBirthdate string - -
EmergencyContact string - -
EmergencyPhone string - -
ContactAddressInline string - -
CreateDate datetime - -
WriteDate datetime - -
WriteUid long User → ID -
CreateUid long User → ID -
DisplayName string - -

LeadTag

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadID long Lead → ID -
TagID long Tag → ID -

InventoryLocationQuant

Column Type Relates to Notes
RemoteID string - -
InventoryLocationRemoteID string InventoryLocation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InventoryLocationID long InventoryLocation → ID -
QuantID long Quant → ID -

InventoryLocationWarehouse

Column Type Relates to Notes
RemoteID string - -
InventoryLocationRemoteID string InventoryLocation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InventoryLocationID long InventoryLocation → ID -
WarehouseID long Warehouse → ID -

WarehouseResupplyWarehouse

Column Type Relates to Notes
RemoteID string - -
WarehouseRemoteID string Warehouse → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
WarehouseID long Warehouse → ID -
ResupplyWarehouseID long Warehouse → ID -

ProjectMessage

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID long Project → ID -
MessageID long Message → ID -

ProjectTag

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID long Project → ID -
TagID long Tag → ID -

ProjectMilestoneMessage

Column Type Relates to Notes
RemoteID string - -
ProjectMilestoneRemoteID string ProjectMilestone → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectMilestoneID long ProjectMilestone → ID -
MessageID long Message → ID -

ProjectTaskMessage

Column Type Relates to Notes
RemoteID string - -
ProjectTaskRemoteID string ProjectTask → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectTaskID long ProjectTask → ID -
MessageID long Message → ID -

ProjectTaskAssignee

Column Type Relates to Notes
RemoteID string - -
ProjectTaskRemoteID string ProjectTask → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectTaskID long ProjectTask → ID -
UserID long User → ID -

ProjectTaskDependsOnTask

Column Type Relates to Notes
RemoteID string - -
ProjectTaskRemoteID string ProjectTask → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectTaskID long ProjectTask → ID -
DependsOnProjectTaskID long ProjectTask → ID -

PurchaseOrderMessage

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderID long PurchaseOrder → ID -
MessageID long Message → ID -

Need more?

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

Connect your own Odoo data Querying Odoo using regular SQL