2024 is the year of the connector - vote here

Explore the Vtiger CRM API data model

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

Try our interactive ERD Or, browse below

Pulling data from the Vtiger CRM 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 Vtiger CRM 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 string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Accountstatus string - -
Accountname string - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
Email1 string - -
Website string - -
Otherphone string - -
Email2 string - -
Phone string - -
Employees int - -
Industry string - -
AnnualRevenue decimal - -
Fax string - -
AccountID string Account → ID -
Ownership string - -
Accounttype string - -
Tickersymbol string - -
NotifyOwner int - -
Emailoptout int - -
Siccode string - -
AccountNo string - -
Isconvertedfromlead int - -
PrimaryTwitter string - -
LastContactedOn datetime - -
LastContactedVia string - -
Slaid string SLAPolicy → ID -
EmailDomain string - -
RecordCurrencyID string Currency → ID -
Region string - -
ProfileScore int - -
ProfileRating int - -
Emailoptin string - -
EmailoptinRequestcount int - -
EmailoptinLastrequestedon datetime - -
Smsoptin string - -
PrimaryPhoneField string - -
PrimaryEmailField string - -
ShipCountry string - -
BillCountry string - -
BillStreet string - -
ShipStreet string - -
BillPobox string - -
ShipPobox string - -
BillCity string - -
ShipCity string - -
BillState string - -
ShipState string - -
BillCode string - -
ShipCode string - -
Imagename string - -

Campaign

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Campaignstatus string - -
Campaignname string - -
Campaignrelstatus string - -
Closingdate datetime - -
AssignedUserID string User → ID -
ProductID string Product → ID -
Campaigntype string - -
Targetaudience string - -
Targetsize int - -
Sponsor string - -
Numsent decimal - -
CampaignNo string - -
Modifiedby string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
RecordCurrencyID string Currency → ID -
Isclosed int - -
Budgetcost decimal - -
Actualcost decimal - -
Expectedrevenue decimal - -
Expectedresponse string - -
Expectedsalescount int - -
Actualsalescount int - -
Expectedresponsecount int - -
Actualresponsecount int - -
Expectedroi decimal - -
Actualroi decimal - -

Contact

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Contactstatus string - -
Salutationtype string - -
Firstname string - -
Lastname string - -
Email string - -
Phone string - -
Mobile string - -
Homephone string - -
Birthday string - -
Otherphone string - -
Fax string - -
AccountID string Account → ID -
Title string - -
Department string - -
ContactID string Contact → ID -
Leadsource string - -
Secondaryemail string - -
Assistant string - -
AssignedUserID string User → ID -
Assistantphone string - -
Donotcall int - -
NotifyOwner int - -
Emailoptout int - -
ContactNo string - -
Modifiedby string User → ID -
Isconvertedfromlead int - -
CreatedUserID string User → ID -
PrimaryTwitter string - -
Source string - -
EngagementScore int - -
LastContactedOn datetime - -
LastContactedVia string - -
Slaid string SLAPolicy → ID -
Contacttype string - -
HappinessRating string - -
RecordCurrencyID string - -
RecordConversionRate string - -
ProfileScore int - -
ProfileRating int - -
ReferredBy string Contact → ID -
Emailoptin string - -
EmailoptinRequestcount int - -
EmailoptinLastrequestedon datetime - -
Smsoptin string - -
Language string - -
PrimaryPhoneField string - -
PrimaryEmailField string - -
Isclosed int - -
SourceCampaign string Campaign → ID -
Platform string - -
Adgroup string - -
FacebookLeadID string - -
Portal int - -
SupportStartDate datetime - -
SupportEndDate datetime - -
Mailingcountry string - -
Othercountry string - -
Mailingstreet string - -
Otherstreet string - -
Mailingpobox string - -
Otherpobox string - -
Mailingcity string - -
Othercity string - -
Mailingstate string - -
Otherstate string - -
Mailingzip string - -
Otherzip string - -
Imagename string - -
PrimaryLinkedin string - -
FollowersLinkedin int - -
PrimaryFacebook string - -
FollowersFacebook int - -

Currency

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
CurrencyName string - -
CurrencyCode string - -
CurrencySymbol string - -
ConversionRate decimal - -
CurrencyStatus string - -
Defaultid int - -

Deal

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
Potentialname string - -
Amount decimal - -
RelatedTo string Account → ID -
ContactID string Contact → ID -
Closingdate datetime - -
Pipeline string - -
SalesStage string - -
Leadsource string - -
Nextstep string - -
OpportunityType string - -
Probability decimal - -
Campaignid string Campaign → ID -
ForecastAmount decimal - -
PotentialNo string - -
Isconvertedfromlead int - -
ForecastCategory string - -
AdjustedAmount decimal - -
LastContactedOn datetime - -
LastContactedVia string - -
CurrentStageEntryTime datetime - -
LostReason string - -
RecordCurrencyID string Currency → ID -
JourneyTemplateID string -
  • 28 Aug 2024 Foreign Key - Refers to `JourneyTemplate` (not implemented).
NextJourney string - -
Progress decimal - -
OppContactrole string - -
PrevSalesStage string - -
HdnDiscountAmount decimal - -
HdnDiscountPercent decimal - -
HdnSubTotal decimal - -
HdnGrandTotal decimal - -
PricebookID string PriceBook → ID -
ItemsSyncWith string Quote → ID -
HdnSHPercent decimal - -
HdnSHAmount decimal - -

Employee

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Createdtime datetime - -
Modifiedtime datetime - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
FirstName string - -
LastName string - -
Employeenumber string - -
Email string - -
Language string - -
Title string - -
Department string - -
PhoneWork string - -
PhoneMobile string - -
BusinessHours int - -
Portal int - -
UserID string User → ID -
AddressCountry string - -
AddressStreet string - -
AddressCity string - -
AddressPostalcode string - -
AddressState string - -
Imagename string - -

Group

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Groupname string - -
Groupemail string - -

Invoice

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
ShippingAndHandling decimal - -
ShippingAndHandlingShtax1 decimal - -
ShippingAndHandlingShtax2 decimal - -
ShippingAndHandlingShtax3 decimal - -
Createdtime datetime - -
Modifiedtime datetime - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
Subject string - -
AccountID string Account → ID -
Invoicedate datetime - -
Duedate datetime - -
ContactID string Contact → ID -
Customerno string - -
SalesorderID string SalesOrder → ID -
Invoicestatus string - -
VtigerPurchaseorder string - -
Exciseduty decimal - -
HdnTaxType string - -
HdnGrandTotal decimal - -
HdnSubTotal decimal - -
InvoiceNo string - -
CurrencyID string Currency → ID -
PreTaxTotal decimal - -
Received decimal - -
Balance decimal - -
PotentialID string Deal → ID -
Projectid string Project → ID -
QuoteID string Quote → ID -
AppliedCredits decimal - -
Stockupdateapplied int - -
Signature string - -
BillCountry string - -
ShipCountry string - -
BillStreet string - -
ShipStreet string - -
BillPobox string - -
ShipPobox string - -
BillCity string - -
ShipCity string - -
BillState string - -
ShipState string - -
BillCode string - -
ShipCode string - -
TxtAdjustment decimal - -
HdnDiscountAmount decimal - -
HdnDiscountPercent decimal - -
HdnSHPercent decimal - -
HdnSHAmount decimal - -
RegionID string -
  • 28 Aug 2024 Potentially refers to TaxRegion which could be a child of the Tax endpoint
PricebookID string PriceBook → ID -
PurchaseCostTotal decimal - -
MarginTotal decimal - -
MarginPercentageTotal decimal - -
MarkupPercentageTotal decimal - -

Lead

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
RecordCurrencyID string Currency → ID -
Salutationtype string - -
Firstname string - -
Lastname string - -
Company string - -
Email string - -
Phone string - -
Designation string - -
Mobile string - -
Industry string - -
Website string - -
Annualrevenue decimal - -
Leadsource string - -
Leadstatus string - -
Fax string - -
Noofemployees int - -
LeadNo string - -
Secondaryemail string - -
Emailoptout int - -
PrimaryTwitter string - -
EngagementScore int - -
LastContactedOn datetime - -
LastContactedVia string - -
Emailoptin string - -
EmailoptinRequestcount int - -
EmailoptinLastrequestedon datetime - -
Smsoptin string - -
Language string - -
PrimaryPhoneField string - -
PrimaryEmailField string - -
SourceCampaign string Campaign → ID -
Platform string - -
Adgroup string - -
FacebookLeadID string - -
Country string - -
Lane string - -
Pobox string - -
Code string - -
City string - -
State string - -
Imagename string - -
DataErased int - -

PriceBook

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Active string - -
Bookname string - -
PricebookNo string - -
CurrencyID string Currency → ID -
Modifiedby string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -

Product

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Discontinued string - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
Productname string - -
Productcode string - -
ProductType string - -
Productcategory string - -
VendorID string Vendor → ID -
SalesStartDate datetime - -
SalesEndDate datetime - -
StartDate datetime - -
ExpiryDate datetime - -
Manufacturer string - -
SerialNo string - -
MfrPartNo string - -
VendorPartNo string - -
Website string - -
Glacct string - -
Productsheet string - -
ProductNo string - -
RecordCurrencyID string Currency → ID -
ItemBarcode string - -
HsnCode string - -
UnitPrice decimal - -
Commissionrate decimal - -
Taxclass string - -
PurchaseCost decimal - -
BillingType string - -
Usageunit string - -
QtyPerUnit decimal - -
Qtyinstock decimal - -
Reorderlevel int - -
Qtyindemand decimal - -
DefectQtyinstock decimal - -
ReorderQty decimal - -
Availablestock decimal - -
Committedstock decimal - -
Incomingstock decimal - -
Imagename string - -

Project

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Projectstatus string - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
Projectname string - -
Linktoaccountscontacts string Account → ID -
Startdate datetime - -
Targetenddate datetime - -
Actualenddate datetime - -
ProjectNo string - -
Isconvertedfrompotential int - -
Potentialid string Deal → ID -
Contactid string Contact → ID -
RecordCurrencyID string Currency → ID -
Targetbudget decimal - -
Projecturl string - -
Projectpriority string - -
Progress string - -

PurchaseOrder

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
ShippingAndHandling decimal - -
ShippingAndHandlingShtax1 decimal - -
ShippingAndHandlingShtax2 decimal - -
ShippingAndHandlingShtax3 decimal - -
Createdtime datetime - -
Modifiedtime datetime - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
Subject string - -
VendorID string Vendor → ID -
Postatus string - -
RequisitionNo string - -
ContactID string Contact → ID -
Duedate datetime - -
HdnGrandTotal decimal - -
HdnTaxType string - -
Salescommission decimal - -
Exciseduty decimal - -
Carrier string - -
TrackingNo string - -
HdnSubTotal decimal - -
PurchaseorderNo string - -
CurrencyID string Currency → ID -
PreTaxTotal decimal - -
Paid decimal - -
Balance decimal - -
Accountid string Account → ID -
SalesorderID string SalesOrder → ID -
Signature string - -
BillCountry string - -
ShipCountry string - -
BillStreet string - -
ShipStreet string - -
BillPobox string - -
ShipPobox string - -
BillCity string - -
ShipCity string - -
BillState string - -
ShipState string - -
BillCode string - -
ShipCode string - -
HdnDiscountAmount decimal - -
HdnDiscountPercent decimal - -
HdnSHPercent decimal - -
HdnSHAmount decimal - -
TxtAdjustment decimal - -
RegionID string -
  • 28 Aug 2024 Potentially refers to TaxRegion which could be a child of the Tax endpoint

Quote

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
ShippingAndHandling decimal - -
ShippingAndHandlingShtax1 decimal - -
ShippingAndHandlingShtax2 decimal - -
ShippingAndHandlingShtax3 decimal - -
Createdtime datetime - -
Modifiedtime datetime - -
Subject string - -
PotentialID string Deal → ID -
Quotestage string - -
Validtill datetime - -
AccountID string Account → ID -
ContactID string Contact → ID -
Carrier string - -
HdnSubTotal decimal - -
Shipping string - -
AssignedUserID string - -
HdnTaxType string - -
QuoteNo string - -
HdnGrandTotal decimal - -
CurrencyID string Currency → ID -
Modifiedby string User → ID -
PreTaxTotal decimal - -
CreatedUserID string User → ID -
Source string - -
Starred int - -
LeadID string Lead → ID -
Isclosed int - -
Signature string - -
BillCountry string - -
ShipCountry string - -
BillStreet string - -
ShipStreet string - -
BillPobox string - -
ShipPobox string - -
BillCity string - -
ShipCity string - -
BillState string - -
ShipState string - -
BillCode string - -
ShipCode string - -
HdnDiscountAmount decimal - -
HdnDiscountPercent decimal - -
HdnSHPercent decimal - -
HdnSHAmount decimal - -
TxtAdjustment decimal - -
RegionID string -
  • 23 Aug 2024 Potentially refers to TaxRegion which could be a child of the Tax endpoint
PricebookID string PriceBook → ID -
SyncLineItems int - -
PurchaseCostTotal decimal - -
MarginTotal decimal - -
MarginPercentageTotal decimal - -
MarkupPercentageTotal decimal - -

Role

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Rolename string - -
Parentrole string - -
Depth int - -
Allowassignedrecordsto int - -
Allowgroupassignedto int - -
Rolerelatedgroups string - -
Roletype string - -
Primaryapp string - -

SalesOrder

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
ShippingAndHandling decimal - -
ShippingAndHandlingShtax1 decimal - -
ShippingAndHandlingShtax2 decimal - -
ShippingAndHandlingShtax3 decimal - -
Createdtime datetime - -
Modifiedtime datetime - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
Subject string - -
PotentialID string Deal → ID -
QuoteID string Quote → ID -
VtigerPurchaseorder string - -
ContactID string Contact → ID -
Customerno string - -
AccountID string Account → ID -
Pending string - -
Sostatus string - -
Duedate datetime - -
HdnSubTotal decimal - -
HdnGrandTotal decimal - -
Carrier string - -
Salescommission decimal - -
Exciseduty decimal - -
HdnTaxType string - -
SalesorderNo string - -
CurrencyID string Currency → ID -
PreTaxTotal decimal - -
Signature string - -
Orderdate datetime - -
EnableRecurring int - -
RecurringFrequency string - -
StartPeriod datetime - -
EndPeriod datetime - -
PaymentDuration string - -
Invoicestatus string - -
ShipCountry string - -
BillCountry string - -
BillStreet string - -
ShipStreet string - -
BillPobox string - -
ShipPobox string - -
BillCity string - -
ShipCity string - -
BillState string - -
ShipState string - -
BillCode string - -
ShipCode string - -
HdnDiscountAmount decimal - -
HdnDiscountPercent decimal - -
HdnSHPercent decimal - -
TxtAdjustment decimal - -
HdnSHAmount decimal - -
RegionID string -
  • 28 Aug 2024 Potentially refers to TaxRegion which could be a child of the Tax endpoint
PricebookID string PriceBook → ID -
PurchaseCostTotal decimal - -
MarginTotal decimal - -
MarginPercentageTotal decimal - -
MarkupPercentageTotal decimal - -

Service

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Discontinued string - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
Isclosed int - -
Servicename string - -
Servicecategory string - -
ServiceUsageunit string - -
QtyPerUnit decimal - -
SalesStartDate datetime - -
SalesEndDate datetime - -
StartDate datetime - -
ExpiryDate datetime - -
Website string - -
ServiceNo string - -
RecordCurrencyID string Currency → ID -
UnitPrice decimal - -
Commissionrate decimal - -
Taxclass string - -
PurchaseCost decimal - -
BillingType string - -

SLAPolicy

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Createdtime datetime - -
Modifiedtime datetime - -
AssignedUserID string User → ID -
Source string - -
Isclosed int - -
PolicyName string - -
OperationalHours string - -
Fremailtemplateid string -
  • 28 Aug 2024 Foreign Key - Refers to `EmailTemplate` (not implemented).
SlaDefault int - -
SlaType string - -

User

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
TimeZone string - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
CreatedOn datetime - -
UserName string - -
UserType string - -
Roleid string Role → ID -
ReportsToID string User → ID -
UserPrimaryGroup string Group → ID -
CurrencyID string Currency → ID -
Language string - -
IsAdmin string - -
Status string - -
LeadView string - -
EndHour string - -
IsOwner int - -
Availability string - -
Dayoftheweek string - -
FirstName string - -
StartHour string - -
LastName string - -
Title string - -
DateFormat string - -
Department string - -
HourFormat string - -
Email1 string - -
ActivityView string - -
Secondaryemail string - -
Callduration int - -
Email2 string - -
Othereventduration int - -
PhoneHome string - -
PhoneWork string - -
Defaulteventstatus string - -
PhoneMobile string - -
Defaultactivitytype string - -
ReminderInterval string - -
PhoneOther string - -
PhoneFax string - -
Calendarsharedtype string - -
Hidecompletedevents int - -
Defaultcalendarview string - -
Taskduration string - -
Theme string - -
Rowheight string - -
LearningScore string - -
Userlabel string - -
SuspendedOn datetime - -
ReactivatedOn datetime - -
AddressStreet string - -
AddressCity string - -
AddressState string - -
AddressCountry string - -
AddressPostalcode string - -

Vendor

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Createdtime datetime - -
Modifiedtime datetime - -
Vendorname string - -
Phone string - -
Email string - -
Website string - -
Glacct string - -
Category string - -
VendorNo string - -
Modifiedby string User → ID -
AssignedUserID string User → ID -
CreatedUserID string User → ID -
Source string - -
Starred int - -
RecordCurrencyID string User → ID -
RecordConversionRate string - -
PrimaryPhoneField string - -
PrimaryEmailField string - -
Country string - -
Street string - -
Pobox string - -
City string - -
State string - -
Postalcode string - -
Isclosed int - -

AccountTag

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

CampaignTag

Column Type Relates to Notes
RemoteID string - -
CampaignRemoteID string Campaign → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CampaignID string Campaign → ID -
Tag string - -

ContactTag

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ID -
Tag string - -

DealLineItem

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DealID string Deal → ID -
ProductID string Product → ID -
ServiceID string Service → ID -
Listprice decimal - -
Quantity decimal - -
DiscountAmount decimal - -
DiscountPercent decimal - -
Netprice decimal - -
SectionNo int - -
SectionName string - -
Comment string - -

DealTag

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealID string Deal → ID -
Tag string - -

EmployeeTag

Column Type Relates to Notes
RemoteID string - -
EmployeeRemoteID string Employee → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeeID string Employee → ID -
Tag string - -

InvoiceLineItem

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
InvoiceID string Invoice → ID -
ProductID string Product → ID -
ServiceID string Service → ID -
SequenceNo int - -
Quantity decimal - -
Listprice decimal - -
DiscountPercent decimal - -
DiscountAmount decimal - -
Comment string - -
Tax1 decimal - -
Tax2 decimal - -
Tax3 decimal - -
Tax4 decimal - -
PurchaseCost decimal - -
Margin decimal - -
Netprice decimal - -
SectionNo int - -
SectionName string - -
MarginPercentage decimal - -
DeliveredQty decimal - -
OutstandingQty decimal - -
ReceivedQty decimal - -
MarkupPercentage decimal - -
CfCreditnotesReason string - -
OverallItemDiscount decimal - -
DiscountedUnitSellingPrice decimal - -

InvoiceTag

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → ID -
Tag string - -

LeadTag

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

PriceBookTag

Column Type Relates to Notes
RemoteID string - -
PriceBookRemoteID string PriceBook → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PriceBookID string PriceBook → ID -
Tag string - -

ProductTag

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

ProjectTag

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

PurchaseOrderLineItem

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
PurchaseOrderID string PurchaseOrder → ID -
ProductID string Product → ID -
ServiceID string Service → ID -
SequenceNo int - -
Quantity decimal - -
Listprice decimal - -
DiscountPercent decimal - -
DiscountAmount decimal - -
Comment string - -
Tax1 decimal - -
Tax2 decimal - -
Tax3 decimal - -
Tax4 decimal - -
PurchaseCost decimal - -
Margin decimal - -
Netprice decimal - -
SectionNo int - -
SectionName string - -
MarginPercentage decimal - -
DeliveredQty decimal - -
OutstandingQty decimal - -
ReceivedQty decimal - -
MarkupPercentage decimal - -
CfCreditnotesReason string - -
OverallItemDiscount decimal - -
DiscountedUnitSellingPrice decimal - -

PurchaseOrderTag

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

QuoteLineItem

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
QuoteID string Quote → ID -
ProductID string Product → ID -
ServiceID string Service → ID -
SequenceNo int - -
Quantity decimal - -
Listprice decimal - -
DiscountPercent decimal - -
DiscountAmount decimal - -
Comment string - -
Tax1 decimal - -
Tax2 decimal - -
Tax3 decimal - -
Tax4 decimal - -
PurchaseCost decimal - -
Margin decimal - -
Netprice decimal - -
SectionNo int - -
SectionName string - -
MarginPercentage decimal - -
DeliveredQty decimal - -
OutstandingQty decimal - -
ReceivedQty decimal - -
MarkupPercentage decimal - -
CfCreditnotesReason string - -
OverallItemDiscount decimal - -
DiscountedUnitSellingPrice decimal - -

QuoteTag

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuoteID string Quote → ID -
Tag string - -

SalesOrderLineItem

Column Type Relates to Notes
RemoteID string - -
SalesOrderRemoteID string SalesOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
SalesOrderID string SalesOrder → ID -
ProductID string Product → ID -
ServiceID string Service → ID -
SequenceNo int - -
Quantity decimal - -
Listprice decimal - -
DiscountPercent decimal - -
DiscountAmount decimal - -
Comment string - -
Tax1 decimal - -
Tax2 decimal - -
Tax3 decimal - -
Tax4 decimal - -
PurchaseCost decimal - -
Margin decimal - -
Netprice decimal - -
SectionNo int - -
SectionName string - -
MarginPercentage decimal - -
DeliveredQty decimal - -
OutstandingQty decimal - -
ReceivedQty decimal - -
MarkupPercentage decimal - -
CfCreditnotesReason string - -
OverallItemDiscount decimal - -
DiscountedUnitSellingPrice decimal - -

SalesOrderTag

Column Type Relates to Notes
RemoteID string - -
SalesOrderRemoteID string SalesOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalesOrderID string SalesOrder → ID -
Tag string - -

ServiceTag

Column Type Relates to Notes
RemoteID string - -
ServiceRemoteID string Service → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ServiceID string Service → ID -
Tag string - -

VendorTag

Column Type Relates to Notes
RemoteID string - -
VendorRemoteID string Vendor → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
VendorID string Vendor → ID -
Tag string - -

Need more?

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

Connect your own Vtiger CRM data Querying Vtiger CRM using regular SQL