Explore the Vtiger CRM API data model

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.

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