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	-	-
IsWon	boolean	-	-
Sequence	decimal	-	-
TeamCount	decimal	-	-
Requirements	string	-	-
CreateDate	datetime	-	-
WriteDate	datetime	-	-
WriteUid	long	User → ID	-
CreateUid	long	User → ID	-
DisplayName	string	-	-

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

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	long	-	-
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	-	-
EmployeeCountryID	long	-	-
DepartmentID	long	-	-
Gender	string	-	-
Birthday	string	-	-
PlaceOfBirth	string	-	-
CountryOfBirth	long	-	-
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	-	-

AccountCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
AccountRemoteID	string	Account → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AccountID	long	Account → ID	-
FieldName	string	-	-
Value	string	-	-

CompanyCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
FieldName	string	-	-
Value	string	-	-

ContactCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
FieldName	string	-	-
Value	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	-

LeadCustomField

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	-
FieldName	string	-	-
Value	string	-	-

StageCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
StageRemoteID	string	Stage → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
StageID	long	Stage → ID	-
FieldName	string	-	-
Value	string	-	-

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	-

JournalCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
JournalRemoteID	string	Journal → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
JournalID	long	Journal → ID	-
FieldName	string	-	-
Value	string	-	-

JournalEntryLineCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
JournalEntryLineRemoteID	string	JournalEntryLine → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
JournalEntryLineID	long	JournalEntryLine → ID	-
FieldName	string	-	-
Value	string	-	-

JournalEntryCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
JournalEntryRemoteID	string	JournalEntry → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
JournalEntryID	long	JournalEntry → ID	-
FieldName	string	-	-
Value	string	-	-

ProjectCustomField

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	-
FieldName	string	-	-
Value	string	-	-

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	-

ProjectMilestoneCustomField

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	-
FieldName	string	-	-
Value	string	-	-

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	-

PurchaseOrderCustomField

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	-
FieldName	string	-	-
Value	string	-	-

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	-

PurchaseOrderLineCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
PurchaseOrderLineRemoteID	string	PurchaseOrderLine → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PurchaseOrderLineID	long	PurchaseOrderLine → ID	-
FieldName	string	-	-
Value	string	-	-

ProductCategoryCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductCategoryRemoteID	string	ProductCategory → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProductCategoryID	long	ProductCategory → ID	-
FieldName	string	-	-
Value	string	-	-

ProductTemplateCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductTemplateRemoteID	string	ProductTemplate → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProductTemplateID	long	ProductTemplate → ID	-
FieldName	string	-	-
Value	string	-	-

ProductVariantCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductVariantRemoteID	string	ProductVariant → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProductVariantID	long	ProductVariant → ID	-
FieldName	string	-	-
Value	string	-	-

SaleOrderCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
SaleOrderRemoteID	string	SaleOrder → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
SaleOrderID	long	SaleOrder → ID	-
FieldName	string	-	-
Value	string	-	-

SaleOrderLineCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
SaleOrderLineRemoteID	string	SaleOrderLine → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
SaleOrderLineID	long	SaleOrderLine → ID	-
FieldName	string	-	-
Value	string	-	-

UserCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
UserRemoteID	string	User → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
UserID	long	User → ID	-
FieldName	string	-	-
Value	string	-	-

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