MS Dynamics CRM connector specifications

Integrate with MS Dynamics CRM to monitor and manage leads, opportunities, and cases without requiring additional logins.

Version details

Citrix microapps supports the latest MS Dynamics APIs.

Endpoints

Note:

Custom endpoints are not supported.

GET

/api/data/v8.2/
/api/data/v8.2/opportunities
/api/data/v8.2/transactioncurrencies
/api/data/v8.2/positions
/api/data/v8.2/ordercloses
/api/data/v8.2/campaignactivities
/api/data/v8.2/opportunitycloses
/api/data/v8.2/opportunityproducts
/api/data/v8.2/accounts
/api/data/v8.2/contacts
/api/data/v8.2/appointments
/api/data/v8.2/bulkoperations
/api/data/v8.2/campaignresponses
/api/data/v8.2/socialactivities
/api/data/v8.2/teams
/api/data/v8.2/systemusers
/api/data/v8.2/organizations
/api/data/v8.2/serviceappointments
/api/data/v8.2/letters
/api/data/v8.2/phonecalls
/api/data/v8.2/annotations
/api/data/v8.2/incidents
/api/data/v8.2/contracts
/api/data/v8.2/products
/api/data/v8.2/tasks
/api/data/v8.2/emails
/api/data/v8.2/quotecloses
/api/data/v8.2/leads
/api/data/v8.2/incidentresolutions
/api/data/v8.2/businessunits
/api/data/v8.2/recurringappointmentmasters
/api/data/v8.2/faxes
/api/data/v8.2/EntityDefinitions(LogicalName='{entityType}')/Attributes/Microsoft.Dynamics.CRM.StateAttributeMetadata
/api/data/v8.2/EntityDefinitions(LogicalName='{entityType}')/Attributes/Microsoft.Dynamics.CRM.StatusAttributeMetadata
/api/data/v8.2/EntityDefinitions(LogicalName='{entityType}')/Attributes/Microsoft.Dynamics.CRM.PicklistAttributeMetadata

POST

/api/data/v8.2/WinOpportunity
/api/data/v8.2/LoseOpportunity
/api/data/v8.2/CloseIncident

Service Actions

Create entity

  • Account - new account is created
  • Contact - new contact is created
  • Lead - new lead is created
  • Opportunity - new opportunity is created
  • Case - new case is created
  • Phone Call - new phone call is created
  • Appointment - new appointment is created

Update Entity

  • Account - chosen account is updated
  • Contact - chosen contact is updated
  • Lead - chosen lead is updated
  • Opportunity - chosen opportunity is updated
  • Case - chosen case is updated

Create Activity for Entity

  • Task - new task is created
  • Phone Call - new phone call is created
  • Appointment - new appointment is created

Update Activity for Entity

  • Task - new task is created
  • Phone Call - new phone call is created
  • Appointment - new appointment is created

Others

  • Close an Incident - chosen case is closed
  • Close Opportunity as Won - chosen opportunity is closed as won
  • Close Opportunity as Lost - chosen opportunity is closed as lost

Key Entities

The following are the main business entities that this connector addresses:

  • Account
  • Contact
  • Lead
  • Opportunity
  • Case
  • Activities:
    • Task
    • Phone Call
  • Appointment
  • Principal

Entities with Attributes

The following is a full list of entities and their attributes (MS Dynamics CRM v.0.1.2):

account

  • openrevenue: FLOAT(prec=32, scale=8)
  • _primarycontactid_value: STRING(40)
  • telephone2: STRING(512)
  • address1_addressid: STRING(40)
  • _ownerid_value: STRING(40), FK(principal.ownerid)
  • revenue_base: FLOAT(prec=32, scale=8)
  • websiteurl: STRING(512)
  • description: STRING(2048)
  • statuscode: INTEGER(x32)
  • _parentaccountid_value: STRING(40), FK(account.accountid)
  • address1_primarycontactname: STRING(512)
  • statecode: INTEGER(x32)
  • customertypecode: INTEGER(x32), FK(account_customertypecode.Id)
  • telephone1: STRING(512)
  • address1_postalcode: STRING(512)
  • _transactioncurrencyid_value: STRING(40), FK(transactioncurrency.transactioncurrencyid)
  • numberofemployees: INTEGER(x32)
  • accountratingcode: INTEGER(x32)
  • name: STRING(512)
  • accountnumber: STRING(512)
  • address1_line1: STRING(512)
  • accountid: STRING(40), PK
  • address1_composite: STRING(512)
  • entityimage_url: STRING(512)
  • address1_country: STRING(512)
  • address1_line3: STRING(512)
  • address1_city: STRING(512)
  • address1_line2: STRING(512)
  • emailaddress1: STRING(512)
  • opendeals: INTEGER(x32)
  • industrycode: INTEGER(x32), FK(account_industrycode.Id)

activitypointer

  • activityid: STRING(40), PK
  • activitytypecode: INTEGER(x32), FK(activitypointer_type.Id)
  • _ownerid_value: STRING(40), FK(principal.ownerid)
  • createdon: DATETIME
  • statecode: INTEGER(x32), FK(activitypointer_statecode.Id)
  • _regardingobjectid_value: STRING(40)
  • _regardingobjectid_account: STRING(40), FK(account.accountid)
  • _regardingobjectid_contact: STRING(40), FK(contact.contactid)
  • _regardingobjectid_contract: STRING(40), FK(contract.contractid)
  • _regardingobjectid_incident: STRING(40), FK(incident.incidentid)
  • _regardingobjectid_lead: STRING(40), FK(lead.leadid)
  • _regardingobjectid_opportunity: STRING(40), FK(opportunity.opportunityid)
  • regardingobject_type: INTEGER(x32), FK(regardingobject_type.Id)
  • scheduledstart: DATETIME
  • prioritycode: INTEGER(x32)
  • _owningbusinessunit_value: STRING(40), FK(businessunit.businessunitid)
  • scheduledend: DATETIME
  • deliveryprioritycode: INTEGER(x32)
  • actualend: DATETIME
  • instancetypecode: INTEGER(x32)
  • description: STRING(2048)
  • processid: STRING(40)
  • actualstart: DATETIME
  • subject: STRING(512)
  • stageid: STRING(40)
  • category: STRING(512)
  • community: INTEGER(x32)
  • modifiedon: DATETIME

annotation

  • objecttypecode: STRING(512)
  • documentbody: STRING(512)
  • filename: STRING(512)
  • notetext: STRING(2048)
  • createdon: DATETIME
  • annotationid: STRING(40), PK
  • langid: STRING(512)
  • isdocument: BOOLEAN
  • _owningbusinessunit_value: STRING(40), FK(businessunit.businessunitid)
  • _ownerid_value: STRING(40), FK(principal.ownerid)
  • _objectid_value: STRING(40)
  • subject: STRING(512)

appointment

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • globalobjectid: STRING(512)
  • isalldayevent: BOOLEAN
  • location: STRING(512)
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(appointment_statuscode.Id)

bulkoperation

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • statuscode: INTEGER(x32), FK(bulkoperation_statuscode.Id)

businessunit

  • address1_line2: STRING(512)
  • address1_addresstypecode: INTEGER(x32)
  • _organizationid_value: STRING(40), FK(organization.organizationid)
  • emailaddress: STRING(512)
  • address1_telephone1: STRING(512)
  • createdon: DATETIME
  • name: STRING(512)
  • _parentbusinessunitid_value: STRING(40), FK(businessunit.businessunitid)
  • picture: STRING(512)
  • divisionname: STRING(512)
  • websiteurl: STRING(512)
  • address1_line1: STRING(512)
  • address1_city: STRING(512)
  • businessunitid: STRING(40), PK
  • address1_line3: STRING(512)
  • address1_postalcode: STRING(512)
  • _createdby_value: STRING(40), FK(principal.systemuserid)
  • address1_telephone2: STRING(512)
  • address1_country: STRING(512)
  • description: STRING(2048)
  • address1_addressid: STRING(40)

campaignactivity

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • statuscode: INTEGER(x32), FK(campaignactivity_statuscode.Id)

campaignresponse

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • statuscode: INTEGER(x32), FK(campaignresponse_statuscode.Id)

contact

  • employeeid: STRING(512)
  • _parentcustomerid_value: STRING(40), FK(account.accountid)
  • mobilephone: STRING(512)
  • _accountid_value: STRING(40)
  • firstname: STRING(512)
  • department: STRING(512)
  • description: STRING(2048)
  • _ownerid_value: STRING(40), FK(principal.ownerid)
  • address1_composite: STRING(512)
  • websiteurl: STRING(512)
  • _owningbusinessunit_value: STRING(40), FK(businessunit.businessunitid)
  • jobtitle: STRING(512)
  • address1_line2: STRING(512)
  • emailaddress1: STRING(512)
  • address1_city: STRING(512)
  • fullname: STRING(512)
  • address1_addressid: STRING(40)
  • accountrolecode: INTEGER(x32), FK(contact_accountrolecode.Id)
  • contactid: STRING(40), PK
  • salutation: STRING(512)
  • address1_primarycontactname: STRING(512)
  • address1_country: STRING(512)
  • lastname: STRING(512)
  • telephone1: STRING(512)
  • address1_line1: STRING(512)
  • telephone2: STRING(512)
  • entityimage_url: STRING(512)
  • address1_line3: STRING(512)
  • middlename: STRING(512)
  • address1_postalcode: STRING(512)

contract

  • totalprice_base: FLOAT(prec=32, scale=8)
  • billingstarton: DATETIME
  • billingendon: DATETIME
  • contractservicelevelcode: INTEGER(x32)
  • _owningbusinessunit_value: STRING(40), FK(businessunit.businessunitid)
  • contractnumber: STRING(512)
  • title: STRING(512)
  • contractid: STRING(40), PK
  • _customerid_value: STRING(40), FK(account.accountid)
  • netprice_base: FLOAT(prec=32, scale=8)
  • _accountid_value: STRING(40)
  • activeon: DATETIME
  • _contactid_value: STRING(40)
  • expireson: DATETIME
  • _ownerid_value: STRING(40), FK(principal.ownerid)

email

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • _parentactivityid_value: STRING(40)
  • sender: STRING(512)
  • torecipients: STRING(512)
  • messageid: STRING(512)
  • directioncode: BOOLEAN
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(email_statuscode.Id)

fax

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • directioncode: BOOLEAN
  • faxnumber: STRING(-1)
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(fax_statuscode.Id)

incident

  • incidentstagecode: INTEGER(x32)
  • casetypecode: INTEGER(x32), FK(incident_casetypecode.Id)
  • title: STRING(512)
  • numberofchildincidents: INTEGER(x32)
  • _contactid_value: STRING(40)
  • statecode: INTEGER(x32), FK(incident_statecode.Id)
  • customercontacted: BOOLEAN
  • createdon: DATETIME
  • customersatisfactioncode: INTEGER(x32)
  • statuscode: INTEGER(x32), FK(incident_statuscode.Id)
  • _accountid_value: STRING(40)
  • resolveby: DATETIME
  • incidentid: STRING(40), PK
  • servicestage: INTEGER(x32)
  • _productid_value: STRING(40), FK(product.productid)
  • caseorigincode: INTEGER(x32)
  • processid: STRING(40)
  • _contractid_value: STRING(40), FK(contract.contractid)
  • contractservicelevelcode: INTEGER(x32)
  • isescalated: BOOLEAN
  • severitycode: INTEGER(x32)
  • ticketnumber: STRING(512)
  • _ownerid_value: STRING(40), FK(principal.ownerid)
  • _owningbusinessunit_value: STRING(40), FK(businessunit.businessunitid)
  • description: STRING(2048)
  • resolvebyslastatus: INTEGER(x32)
  • _customerid_value: STRING(40), FK(account.accountid)
  • entityimage_url: STRING(512)
  • prioritycode: INTEGER(x32), FK(incident_prioritycode.Id)

incidentresolution

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • _incidentid_value: STRING(40)
  • timespent: INTEGER(x32)
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(incidentresolution_statuscode.Id)

lead

  • subject: STRING(512)
  • address1_telephone2: STRING(512)
  • lastname: STRING(512)
  • description: STRING(2048)
  • address1_city: STRING(512)
  • address1_telephone1: STRING(512)
  • budgetamount_base: FLOAT(prec=32, scale=8)
  • address1_line3: STRING(512)
  • statecode: INTEGER(x32), FK(lead_statecode.Id)
  • leadsourcecode: INTEGER(x32), FK(lead_leadsourcecode.Id)
  • salesstage: INTEGER(x32)
  • initialcommunication: INTEGER(x32)
  • estimatedamount_base: FLOAT(prec=32, scale=8)
  • industrycode: INTEGER(x32)
  • address1_country: STRING(512)
  • middlename: STRING(512)
  • mobilephone: STRING(512)
  • createdon: DATETIME
  • _accountid_value: STRING(40)
  • address1_composite: STRING(512)
  • need: INTEGER(x32), FK(lead_need.Id)
  • purchaseprocess: INTEGER(x32)
  • address1_postalcode: STRING(512)
  • _customerid_value: STRING(40), FK(contact.contactid)
  • entityimage_url: STRING(512)
  • _ownerid_value: STRING(40), FK(principal.ownerid)
  • _contactid_value: STRING(40)
  • telephone2: STRING(512)
  • salutation: STRING(512)
  • numberofemployees: INTEGER(x32)
  • companyname: STRING(512)
  • fullname: STRING(512)
  • _qualifyingopportunityid_value: STRING(40), FK(opportunity.opportunityid)
  • firstname: STRING(512)
  • address1_line2: STRING(512)
  • decisionmaker: BOOLEAN
  • purchasetimeframe: INTEGER(x32), FK(lead_purchasetimeframe.Id)
  • websiteurl: STRING(512)
  • leadqualitycode: INTEGER(x32), FK(lead_leadqualitycode.Id)
  • emailaddress1: STRING(512)
  • stageid: STRING(40)
  • prioritycode: INTEGER(x32)
  • address1_addressid: STRING(40)
  • jobtitle: STRING(512)
  • salesstagecode: INTEGER(x32)
  • leadid: STRING(40), PK
  • statuscode: INTEGER(x32), FK(lead_statuscode.Id)
  • _transactioncurrencyid_value: STRING(40), FK(transactioncurrency.transactioncurrencyid)
  • telephone1: STRING(512)
  • _owningbusinessunit_value: STRING(40), FK(businessunit.businessunitid)
  • address1_line1: STRING(512)
  • confirminterest: BOOLEAN
  • revenue_base: FLOAT(prec=32, scale=8)

letter

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • directioncode: BOOLEAN
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(letter_statuscode.Id)

opportunity

  • identifycustomercontacts: BOOLEAN
  • description: STRING(2048)
  • _ownerid_value: STRING(40), FK(principal.ownerid)
  • salesstage: INTEGER(x32), FK(opportunity_salesstage.Id)
  • actualclosedate: DATE
  • actualvalue_base: FLOAT(prec=32, scale=8)
  • statuscode: INTEGER(x32), FK(opportunity_statuscode.Id)
  • totaltax_base: FLOAT(prec=32, scale=8)
  • totallineitemdiscountamount_base: FLOAT(prec=32, scale=8)
  • opportunityratingcode: INTEGER(x32), FK(opportunity_opportunityratingcode.Id)
  • closeprobability: INTEGER(x32)
  • totalamountlessfreight_base: FLOAT(prec=32, scale=8)
  • estimatedvalue_base: FLOAT(prec=32, scale=8)
  • createdon: DATETIME
  • estimatedclosedate: DATE
  • _transactioncurrencyid_value: STRING(40), FK(transactioncurrency.transactioncurrencyid)
  • need: INTEGER(x32), FK(opportunity_need.Id)
  • totaldiscountamount_base: FLOAT(prec=32, scale=8)
  • stageid: STRING(40)
  • totallineitemamount_base: FLOAT(prec=32, scale=8)
  • _customerid_value: STRING(40), FK(account.accountid)
  • purchaseprocess: INTEGER(x32)
  • discountpercentage: FLOAT(prec=32, scale=8)
  • customerneed: STRING(512)
  • _accountid_value: STRING(40)
  • finaldecisiondate: DATE
  • decisionmaker: BOOLEAN
  • prioritycode: INTEGER(x32)
  • _owningbusinessunit_value: STRING(40), FK(businessunit.businessunitid)
  • discountamount_base: FLOAT(prec=32, scale=8)
  • purchasetimeframe: INTEGER(x32), FK(opportunity_purchasetimeframe.Id)
  • budgetamount_base: FLOAT(prec=32, scale=8)
  • totalamount_base: FLOAT(prec=32, scale=8)
  • statecode: INTEGER(x32), FK(opportunity_statecode.Id)
  • currentsituation: STRING(512)
  • identifycompetitors: BOOLEAN
  • opportunityid: STRING(40), PK
  • name: STRING(512)

opportunityclose

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • _opportunityid_value: STRING(40)
  • actualrevenue_base: FLOAT(prec=32, scale=8)
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(opportunityclose_statuscode.Id)

opportunityproduct

  • priceperunit: FLOAT(prec=32, scale=8)
  • quantity: FLOAT(prec=32, scale=8)
  • productdescription: STRING(512)
  • _transactioncurrencyid_value: STRING(40), FK(transactioncurrency.transactioncurrencyid)
  • baseamount_base: FLOAT(prec=32, scale=8)
  • priceperunit_base: FLOAT(prec=32, scale=8)
  • producttypecode: INTEGER(x32)
  • opportunitystatecode: INTEGER(x32)
  • opportunityproductid: STRING(40), PK
  • entityimage_url: STRING(512)
  • _opportunityid_value: STRING(40), FK(opportunity.opportunityid)
  • manualdiscountamount_base: FLOAT(prec=32, scale=8)
  • _productid_value: STRING(40), FK(product.productid)
  • volumediscountamount_base: FLOAT(prec=32, scale=8)
  • extendedamount_base: FLOAT(prec=32, scale=8)
  • _ownerid_value: STRING(40)

orderclose

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • ordernumber: STRING(-1)
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(orderclose_statuscode.Id)

organization

  • tokenkey: STRING(512)
  • name: STRING(512)
  • organizationid: STRING(40), PK
  • picture: STRING(512)
  • createdon: DATETIME
  • entityimage_url: STRING(512)
  • _createdby_value: STRING(40), FK(principal.systemuserid)
  • systemuserid: STRING(40)

phonecall

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • phonenumber: STRING(512)
  • directioncode: BOOLEAN
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(phonecall_statuscode.Id)

position

  • timezoneruleversionnumber: INTEGER(x32)
  • _parentpositionid_value: STRING(40), FK(position.positionid)
  • exchangerate: FLOAT(prec=32, scale=8)
  • createdon: DATETIME
  • _organizationid_value: STRING(40), FK(organization.organizationid)
  • modifiedon: DATETIME
  • statecode: INTEGER(x32)
  • utcconversiontimezonecode: INTEGER(x32)
  • name: STRING(512)
  • positionid: STRING(40), PK
  • importsequencenumber: INTEGER(x32)
  • _createdby_value: STRING(40), FK(principal.systemuserid)
  • statuscode: INTEGER(x32)
  • versionnumber: INTEGER(x32)
  • description: STRING(2048)
  • overriddencreatedon: DATETIME
  • _transactioncurrencyid_value: STRING(40), FK(transactioncurrency.transactioncurrencyid)

principal

  • ownerid: STRING(40), PK
  • organizationid: STRING(40), FK(organization.organizationid)
  • name: STRING(512)
  • isdefault: BOOLEAN
  • description: STRING(2048)
  • _createdby_value: STRING(40), FK(principal.systemuserid)
  • emailaddress: STRING(512)
  • processid: STRING(40)
  • _businessunitid_value: STRING(40), FK(businessunit.businessunitid)
  • teamtype: INTEGER(x32)
  • stageid: STRING(40)
  • createdon: DATETIME
  • teamid: STRING(40)
  • entityType: STRING(40)
  • nickname: STRING(512)
  • title: STRING(512)
  • firstname: STRING(512)
  • employeeid: STRING(512)
  • jobtitle: STRING(512)
  • skills: STRING(512)
  • internalemailaddress: STRING(512)
  • address1_postalcode: STRING(512)
  • windowsliveid: STRING(512)
  • address1_line3: STRING(512)
  • address1_line2: STRING(512)
  • address1_city: STRING(512)
  • address1_telephone2: STRING(512)
  • sharepointemailaddress: STRING(512)
  • address1_line1: STRING(512)
  • address1_telephone1: STRING(512)
  • systemuserid: STRING(40)
  • address1_country: STRING(512)
  • mobilephone: STRING(512)
  • lastname: STRING(512)
  • address1_composite: STRING(512)
  • accessmode: INTEGER(x32)
  • photourl: STRING(512)
  • isdisabled: BOOLEAN
  • domainname: STRING(512)
  • fullname: STRING(512)
  • salutation: STRING(512)
  • middlename: STRING(512)
  • address1_addresstypecode: INTEGER(x32)
  • _positionid_value: STRING(40), FK(position.positionid)
  • entityimage_url: STRING(512)
  • governmentid: STRING(512)
  • homephone: STRING(512)
  • address1_addressid: STRING(40)

product

  • description: STRING(2048)
  • productstructure: INTEGER(x32)
  • productnumber: STRING(512)
  • vendorname: STRING(512)
  • vendorpartnumber: STRING(512)
  • statecode: INTEGER(x32)
  • productid: STRING(40), PK
  • vendorid: STRING(512)
  • statuscode: INTEGER(x32)
  • producttypecode: INTEGER(x32)
  • producturl: STRING(512)
  • _createdby_value: STRING(40), FK(principal.systemuserid)
  • createdon: DATETIME
  • isstockitem: BOOLEAN
  • name: STRING(512)
  • stockweight: FLOAT(prec=32, scale=8)
  • suppliername: STRING(512)
  • price_base: FLOAT(prec=32, scale=8)
  • currentcost_base: FLOAT(prec=32, scale=8)
  • entityimage_url: STRING(512)
  • stockvolume: FLOAT(prec=32, scale=8)
  • size: STRING(512)
  • hierarchypath: STRING(512)
  • standardcost_base: FLOAT(prec=32, scale=8)
  • _transactioncurrencyid_value: STRING(40), FK(transactioncurrency.transactioncurrencyid)

quoteclose

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(quoteclose_statuscode.Id)

recurringappointment

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • statuscode: INTEGER(x32), FK(recurringappointment_statuscode.Id)

serviceappointment

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • isalldayevent: BOOLEAN
  • location: STRING(512)
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(serviceappointment_statuscode.Id)

socialactivity

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • directioncode: BOOLEAN
  • posturl: STRING(-1)
  • statuscode: INTEGER(x32), FK(socialactivity_statuscode.Id)

task

  • activityid: STRING(40), PK, FK(activitypointer.activityid)
  • percentcomplete: INTEGER(x32)
  • crmtaskassigneduniqueid: STRING(40)
  • subcategory: STRING(-1)
  • statuscode: INTEGER(x32), FK(task_statuscode.Id)

transactioncurrency

  • currencyname: STRING(512)
  • isocurrencycode: STRING(512)
  • createdon: DATETIME
  • _createdby_value: STRING(40), FK(principal.systemuserid)
  • currencyprecision: INTEGER(x32)
  • transactioncurrencyid: STRING(40), PK
  • exchangerate: FLOAT(prec=32, scale=8)
  • modifiedon: DATETIME
  • statecode: INTEGER(x32)
  • currencysymbol: STRING(512)

activitypointer_statecode (Code Values for attribute statecode of entity activitypointer)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

account_customertypecode (Code Values for attribute customertypecode of entity account)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

account_industrycode (Code Values for attribute industrycode of entity account)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

contact_accountrolecode (Code Values for attribute accountrolecode of entity contact)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

incident_prioritycode (Code Values for attribute prioritycode of entity incident)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

incident_statecode (Code Values for attribute statecode of entity incident)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

incident_statuscode (Code Values for attribute statuscode of entity incident)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(incident_statecode.Id)

incident_casetypecode (Code Values for attribute casetypecode of entity incident)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

lead_leadqualitycode (Code Values for attribute leadqualitycode of entity lead)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

lead_need (Code Values for attribute need of entity lead)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

lead_purchasetimeframe (Code Values for attribute purchasetimeframe of entity lead)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

lead_statecode (Code Values for attribute statecode of entity lead)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

lead_statuscode (Code Values for attribute statuscode of entity lead)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(lead_statecode.Id)

lead_leadsourcecode (Code Values for attribute leadsourcecode of entity lead)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

opportunity_need (Code Values for attribute need of entity opportunity)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

opportunity_opportunityratingcode (Code Values for attribute opportunityratingcode of entity opportunity)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

opportunity_purchasetimeframe (Code Values for attribute purchasetimeframe of entity opportunity)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

opportunity_salesstage (Code Values for attribute salesstage of entity opportunity)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

opportunity_statecode (Code Values for attribute statecode of entity opportunity)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)

opportunity_statuscode (Code Values for attribute statuscode of entity opportunity)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(opportunity_statecode.Id)

activitypointer_type (Code Values for attribute type of entity activitypointer)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • Description: STRING(64), PK

appointment_statuscode (Code Values for attribute statuscode of entity appointment)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

bulkoperation_statuscode (Code Values for attribute statuscode of entity bulkoperation)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

campaignactivity_statuscode (Code Values for attribute statuscode of entity campaignactivity)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

campaignresponse_statuscode (Code Values for attribute statuscode of entity campaignresponse)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

email_statuscode (Code Values for attribute statuscode of entity email)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

fax_statuscode (Code Values for attribute statuscode of entity fax)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

incidentresolution_statuscode (Code Values for attribute statuscode of entity incidentresolution)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

letter_statuscode (Code Values for attribute statuscode of entity letter)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

opportunityclose_statuscode (Code Values for attribute statuscode of entity opportunityclose)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

orderclose_statuscode (Code Values for attribute statuscode of entity orderclose)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

phonecall_statuscode (Code Values for attribute statuscode of entity phonecall)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

quoteclose_statuscode (Code Values for attribute statuscode of entity quoteclose)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

recurringappointment_statuscode (Code Values for attribute statuscode of entity recurringappointment)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

serviceappointment_statuscode (Code Values for attribute statuscode of entity serviceappointment)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

socialactivity_statuscode (Code Values for attribute statuscode of entity socialactivity)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

task_statuscode (Code Values for attribute statuscode of entity task)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • State: INTEGER(x32), FK(activitypointer_statecode.Id)

regardingobject_type (Code Values for attribute type of entity regardingobject)

  • Id: INTEGER(x32), PK
  • Name: STRING(64)
  • Description: STRING(64), PK

MS Dynamics CRM connector specifications