Universal Data Models

Universal Data Models

Universal Data Models (UDM) let you work with data from third-party applications in a standardized way—without knowing anything about the underlying data structure.

Connectors provide mappings from and to UDM for relevant data models.

You can find currently supported Universal Data Models below.


Activities

Fields Schema

FieldTypeNotes
idstringRead Only
titlestring
descriptionstring
typestring
durationSecondsnumber
locationstring
isRecurrentboolean
participantslistitem: object
userIdstring
contactIdstring
statusstring
companyIdstring
dealIdstring
leadIdstring
ownerIdstring
startTimestringFormat: date-time
endTimestringFormat: date-time
dueTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Bills

Fields Schema

FieldTypeNotes
idstringRead Only
numberstring
namestring
memostring
statusstring
paymentMethodstring
supplierIdstring
currencystring
paymentslistitem: string
lineItemslistitem: object
  idstring
  itemNamestring
  descriptionstring
  codestring
  typestring
  companyIdstring
  ledgerAccountIdstring
  quantitynumber
  unitPricenumber
  unitOfMeasurestring
  purchasePricenumber
  salesPricenumber
  taxableboolean
  taxAmountnumber
  totalAmountnumber
totalAmountnumber
totalTaxnumber
exchangeRatenumber
totalDiscountnumber
subTotalnumber
balancenumber
ledgerAccountIdstring
issueDatestringFormat: date-time
dueDatestringFormat: date-time
paidOnDatestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Campaign Members

Fields Schema

FieldTypeNotes
idstringRead Only
fullNamestring
firstNamestring
lastNamestring
primaryEmailstring
campaignIdstring
contactIdstring
leadIdstring
sourcestring
statusstring
companyIdstring
jobTitlestring
hasOptedOutOfEmailboolean
createdTimestringFormat: date-time
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Campaigns

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
costnumber
descriptionstring
sourcestring
stagestring
typestring
ownerIdstring
sentCountnumberRead Only
replyCountnumberRead Only
openCountnumberRead Only
clickCountnumberRead Only
startTimestringFormat: date-time
endTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only
lastActivityTimestringFormat: date-time, Read Only

Companies

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
websiteUrlstring
phoneslistitem: object
  valuestring
  typestring
primaryPhonestring
descriptionstring
currencystring
industrystring
ownerIdstring
primaryAddressobject
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
addresseslistitem: object
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
numberOfEmployeesnumber
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only
lastActivityTimestringFormat: date-time, Read Only

Contacts

Fields Schema

FieldTypeNotes
idstringRead Only
fullNamestring
firstNamestring
lastNamestring
primaryEmailstring
emailslistitem: object
  valuestring
  typestring
primaryPhonestring
phoneslistitem: object
  valuestring
  typestring
primaryAddressobject
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
addresseslistitem: object
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
stagestring
companyNamestring
companyIdstring
ownerIdstring
jobTitlestring
sourcestring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only
lastActivityTimestringFormat: date-time, Read Only

Contact Lists

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
descriptionstring
sourcestring
typestring
ownerIdstring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Credit Notes

Fields Schema

FieldTypeNotes
idstringRead Only
numberstring
memostring
statusstring
customerIdstring
currencystring
exchangeRatenumber
paymentslistitem: string
lineItemslistitem: object
  idstring
  itemNamestring
  descriptionstring
  quantitynumber
  totalLineAmountnumber
  companyIdstring
  ledgerAccountIdstring
  unitPricenumber
  taxRatestring
allocationslistitem: object
  idstring
  typestringEnum: invoice, order, expense, credit_memo, over_payment, pre...
  amountnumber
totalAmountnumber
totalTaxnumber
totalDiscountnumber
subTotalnumber
balancenumber
ledgerAccountIdstring
issueDatestringFormat: date-time
paidOnDatestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Customers

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
codestring
descriptionstring
firstNamestring
lastNamestring
companyNamestring
companyIdstring
statusany
currencystring
addresseslistitem: object
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
phoneslistitem: object
  valuestring
  typestring
emailslistitem: object
  valuestring
  typestring
websiteUrlstring
notesstring
tax_numberstring
orderIdslistitem: string
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Deal Products

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
quantitynumber
pricenumber
dealIdstring
productIdstring
isActiveboolean
createdTimestringFormat: date-time
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Deals

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
amountnumber
currencystring
companyIdstring
contactIdstring
campaignIdstring
sourcestring
descriptionstring
stagestring
stageIdstring
statusstringEnum: open, won, lost
typestring
ownerIdstring
probabilitynumber
closeTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only
lastActivityTimestringFormat: date-time, Read Only

Deal Stages

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
statestringEnum: open, won, lost

Documents

Fields Schema

FieldTypeNotes
idstringRead Only
uristringRead Only
titlestring
parentDocumentIdstring
canHaveChildrenbooleanRead Only
isDownloadablebooleanDefault: true, Read Only
textstring
ownerIdstring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Drives

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
descriptionstring
ownerIdstring
uristringRead Only
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Drive Items

Fields Schema

FieldTypeNotes
idstringRead Only
itemTypestringEnum: file, folder, Allow Custom: true
namestring
mimeTypestring
descriptionstring
previewUristringRead Only
sizeintegerRead Only
pathstringRead Only
folderIdstring
ownerIdstring
driveIdstring
downloadUristringRead Only
uristringRead Only
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Eeocs

Fields Schema

FieldTypeNotes
idstring
candidateIdstring
racestring
genderstring
veteranStatusstring
disabilityStatusstring
submittedTimestringFormat: date-time, Read Only
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Emails

Fields Schema

FieldTypeNotes
idstringRead Only
threadIdstringRead Only
tolistitem: string
cclistitem: string
bcclistitem: string
fromstring
replyTostring
subjectstring
bodystring
html_bodystring
statusstring
ownerIdstring
contactIdstring
leadIdstring
companyIdstring
dealIdstring
attachmentslistitem: object
  idstring
  typestring
  namestring
  urlstring
  contentstring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Employees

Fields Schema

FieldTypeNotes
idstringRead Only
fullNamestring
firstNamestring
lastNamestring
userNamestring
preferredNamestring
personalEmailstring
workEmailstring
mobileNumberstring
homeAddressobject
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
workAddressobject
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
employmentStatusstringEnum: active, inactive, terminated, other
companyIdstring
departmentIdstring
startDatestringFormat: date-time
terminationDatestringFormat: date-time
genderstringEnum: male, female, other, not_specified, Allow Custom: true
ethnicitystring
birthdaystringFormat: date-time
photoUrlstring
timezonestring
titlestring
employmentslistitem: any
compensationslistitem: object
  idstring
  jobIdstring
  ratenumber
  paymentUnitstring
  currencystring
  paymentFrequencystring
  flsaStatusstring
  effectiveDatestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Files

Fields Schema

FieldTypeNotes
idstringRead Only
mimeTypestring
namestring
descriptionstring
previewUristringRead Only
sizeintegerRead Only
pathstringRead Only
folderIdstring
ownerIdstring
driveIdstring
downloadUristringRead Only
uristringRead Only
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Folders

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
descriptionstring
sizeintegerRead Only
pathstringRead Only
parentFolderIdstring
ownerIdstring
driveIdstring
downloadUristringRead Only
uristringRead Only
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Invoices

Fields Schema

FieldTypeNotes
idstringRead Only
numberstring
namestring
memostring
statusstring
paymentMethodstring
customerIdstring
currencystring
paymentslistitem: string
lineItemslistitem: object
  idstring
  itemNamestring
  descriptionstring
  codestring
  typestring
  statusstring
  companyIdstring
  ledgerAccountIdstring
  quantitynumber
  unitOfMeasurestring
  unitPricenumber
  purchasePricenumber
  salesPricenumber
  taxableboolean
  taxAmountnumber
  totalAmountnumber
  inventoryDatestringFormat: date-time
totalAmountnumber
totalTaxnumber
exchangeRatenumber
totalDiscountnumber
subTotalnumber
balancenumber
ledgerAccountIdstring
issueDatestringFormat: date-time
dueDatestringFormat: date-time
paidOnDatestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Job Applications

Fields Schema

FieldTypeNotes
idstring
candidateIdstring
jobIdstring
appliedAtstringFormat: date-time
statusstring
currentStagestring
sourcestring
rejectedTimestringFormat: date-time
rejectionReasonstring
creditedTostring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Job Candidates

Fields Schema

FieldTypeNotes
idstring
fullNamestring
firstNamestring
lastNamestring
companystring
titlestring
addresseslistitem: object
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
phoneslistitem: object
  valuestring
  typestring
primaryEmailstring
primaryPhonestring
emailslistitem: object
  valuestring
  typestring
urlslistitem: object
  valuestring
  typestring
applicationIdslistitem: string
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Job Interviews

Fields Schema

FieldTypeNotes
idstring
candidateIdstring
organizerIdstring
interviewerIdslistitem: string
stagestring
statusstring
locationstring
startTimestringFormat: date-time
endTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Job Offers

Fields Schema

FieldTypeNotes
idstring
jobApplicationIdstring
statusstring
sentTimestringFormat: date-time
closedTimestringFormat: date-time
startDatestringFormat: date
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Jobs

Fields Schema

FieldTypeNotes
idstring
namestring
descriptionstring
codestring
statusstring
isConfidentialboolean
hiringManagersIdslistitem: string
recruitersIdslistitem: string
departmentsIdslistitem: string
officesIdslistitem: string
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Journal Entries

Fields Schema

FieldTypeNotes
idstringRead Only
numberstring
titlestring
memostring
currencystring
companyIdstring
lineItemslistitem: object
  idstring
  descriptionstring
  typestringEnum: debit, credit
  amountnumber
  ledgerAccountIdstring
  companyIdstring
  contactIdstring
exchangeRatenumber
taxTypestring
taxCodestring
ledgerAccountIdstring
paymentslistitem: string
transactionDatestringFormat: date-time
createdTimestringFormat: date-time, Read Only
updatedTimestringFormat: date-time, Read Only

Leads

Fields Schema

FieldTypeNotes
idstringRead Only
fullNamestring
firstNamestring
lastNamestring
primaryEmailstring
emailslistitem: object
  valuestring
  typestring
primaryPhonestring
phoneslistitem: object
  valuestring
  typestring
primaryAddressobject
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
addresseslistitem: object
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
stagestring
valuenumber
companyNamestring
companyIdstring
ownerIdstring
jobTitlestring
sourcestring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only
lastActivityTimestringFormat: date-time, Read Only

Ledger Accounts

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
codestring
descriptionstring
classificationstringEnum: Asset, Liability, Equity, Revenue, Expense
typestring
statusstringEnum: Active, Inactive, Archived
currentBalancenumber
currencystring
taxRateIdstring
companyIdstring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Meetings

Fields Schema

FieldTypeNotes
idstringRead Only
titlestring
descriptionstring
durationSecondsnumber
locationstring
isRecurrentboolean
participantslistitem: object
userIdstring
contactIdstring
leadIdstring
statusstring
companyIdstring
dealIdstring
ownerIdstring
startTimestringFormat: date-time
endTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Messages

Fields Schema

FieldTypeNotes
idstringRead Only
subjectstring
channelIdstring
threadIdstring
textstring
ownerIdstring
statusstring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Notes

Fields Schema

FieldTypeNotes
idstringRead Only
titlestring
contentstring
statusstring
ownerIdstring
contactIdstring
leadIdstring
companyIdstring
dealIdstring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Orders

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
notesstring
statusstringEnum: open, closed
customerIdstring
currencystring
totalAmountnumber
paymentMethodstring
paymentStatusstring
fullFillmentStatusstring
billingAddressobject
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
shippingAddressobject
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
lineItemslistitem: object
  namestring
  productIdstring
  skustring
  quantitynumber
  unitPricenumber
  totalAmountnumber
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Payments

Fields Schema

FieldTypeNotes
idstringRead Only
statusstring
typestring
notesstring
currencystring
exchangeRatestring
totalAmountnumber
supplierIdstring
customerIdstring
ledgerAccountIdstring
paymentMethodstring
transactionDatestringFormat: date-time
isReconciledboolean
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Payrolls

Fields Schema

FieldTypeNotes
idstringRead Only
employeeIdstring
companyIdstring
runStatestringEnum: PAID, DRAFT, APPROVED, CLOSED, Allow Custom: true
runTypestringEnum: REGULAR, OFF_CYCLE, UNSCHEDULED, CORRECTION, TERMINATI..., Allow Custom: true
isProcessedboolean
processedTimestringFormat: date-time
checkTimestringFormat: date-time
startTimestringFormat: date-time
endTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Products

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
descriptionstring
codestring
typestring
weightnumber
isActiveboolean
pricenumber
statusstring
optionslistitem: object
  idstring
  namestring
  valueslistitem: string
variantslistitem: object
  idstring
  namestring
  pricenumber
  skustring
  weightnumber
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Projects

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
descriptionstring
typestring
parentIdstring
ownerIdstring
startTimestringFormat: date-time
dueTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Suppliers

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
codestring
descriptionstring
firstNamestring
lastNamestring
companyNamestring
companyIdstring
statusstring
currencystring
addresseslistitem: object
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
phoneslistitem: object
  valuestring
  typestring
emailslistitem: object
  valuestring
  typestring
websiteUrlstring
notesstring
taxNumberstring
orderIdslistitem: string
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Tasks

Fields Schema

FieldTypeNotes
idstringRead Only
subjectstring
contentstring
statusstring
typestring
prioritystring
ownerIdstring
assigneeIdstring
followerIdslistitem: string
parentTaskIdstring
projectIdstring
tagslistitem: string
contactIdstring
leadIdstring
companyIdstring
dealIdstring
dueTimestringFormat: date-time
startTimestringFormat: date-time
endTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Tax Rates

Fields Schema

FieldTypeNotes
idstringRead Only
namestring
codestring
descriptionstring
effectiveTaxRatenumber
totalTaxRatenumber
typestring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Users

Fields Schema

FieldTypeNotes
idstringRead Only
titlestring
fullNamestring
firstNamestring
lastNamestring
userNamestring
primaryEmailstring
emailslistitem: object
  valuestring
  typestring
primaryPhonestring
phoneslistitem: object
  valuestring
  typestring
primaryAddressobject
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
addresseslistitem: object
  typestring
  fullstring
  streetstring
  citystring
  statestring
  countrystring
  zipstring
companyNamestring
companyIdstring
imageUrlstring
timezonestring
isActiveboolean
roleIdstring
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Timeoff Balances

Fields Schema

FieldTypeNotes
idstringRead Only
employeeIdstring
balanceHoursnumber
usedHoursnumber
policyTypestringEnum: VACATION, SICK, PERSONAL, JURY_DUTY, VOLUNTEER, BEREAVE..., Allow Custom: true
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only

Timeoff Requests

Fields Schema

FieldTypeNotes
idstringRead Only
employeeIdstring
approverIdstring
statusstringEnum: REQUESTED, APPROVED, DECLINED, CANCELLED, Allow Custom: true
employeeNotestring
unitsstringEnum: DAYS, HOURS, Allow Custom: true
amountnumber
requestTypestringEnum: VACATION, SICK, PERSONAL, JURY_DUTY, VOLUNTEER, BEREAVE..., Allow Custom: true
startTimestringFormat: date-time
endTimestringFormat: date-time
createdTimestringFormat: date-time, Read Only
createdBystringRead Only
updatedTimestringFormat: date-time, Read Only
updatedBystringRead Only


Tip:
Universal Data Models make it easy to build integrations that work across many apps, by providing a consistent schema for common business objects.
For more details on mapping and usage, see the Connector Builder documentation.