Share via


Entity and attribute mappings

 

Applies To: Dynamics CRM 2013

This table shows all the default system entity and field mappings.

Default entity and field mappings

The names used in this table are lowercase versions of the entity and field Name values, not the Display Name values.

Source Entity Name

Target Entity Name

Source Attribute Name

Target Attribute Name

account

account

defaultpricelevelid

defaultpricelevelid

account

account

accountid

parentaccountid

account

account

transactioncurrencyid

transactioncurrencyid

account

contact

transactioncurrencyid

transactioncurrencyid

account

contact

telephone1

telephone1

account

contact

accountid

parentcustomerid

account

contact

paymenttermscode

paymenttermscode

account

contact

defaultpricelevelid

defaultpricelevelid

account

contact

address1_addresstypecode

address1_addresstypecode

account

contact

address1_city

address1_city

account

contact

address1_country

address1_country

account

contact

address1_county

address1_county

account

contact

address1_freighttermscode

address1_freighttermscode

account

contact

address1_line1

address1_line1

account

contact

address1_line2

address1_line2

account

contact

address1_line3

address1_line3

account

contact

address1_name

address1_name

account

contact

address1_postalcode

address1_postalcode

account

contact

address1_postofficebox

address1_postofficebox

account

contact

address1_shippingmethodcode

address1_shippingmethodcode

account

contact

address1_stateorprovince

address1_stateorprovince

account

contact

address1_telephone1

address1_telephone1

account

contract

accountid

customerid

account

contract

transactioncurrencyid

transactioncurrencyid

account

customeropportunityrole

accountid

customerid

account

customerrelationship

accountid

customerid

account

incident

accountid

customerid

account

invoice

accountid

customerid

account

invoice

paymenttermscode

paymenttermscode

account

invoice

defaultpricelevelid

pricelevelid

account

invoice

address1_shippingmethodcode

shippingmethodcode

account

invoice

transactioncurrencyid

transactioncurrencyid

account

opportunity

accountid

parentaccountid

account

opportunity

defaultpricelevelid

pricelevelid

account

opportunity

accountid

customerid

account

opportunity

transactioncurrencyid

transactioncurrencyid

account

quote

transactioncurrencyid

transactioncurrencyid

account

quote

accountid

customerid

account

quote

paymenttermscode

paymenttermscode

account

quote

defaultpricelevelid

pricelevelid

account

quote

address1_shippingmethodcode

shippingmethodcode

account

quote

address1_freighttermscode

freighttermscode

account

salesorder

address1_freighttermscode

freighttermscode

account

salesorder

address1_shippingmethodcode

shippingmethodcode

account

salesorder

defaultpricelevelid

pricelevelid

account

salesorder

paymenttermscode

paymenttermscode

account

salesorder

accountid

customerid

account

salesorder

transactioncurrencyid

transactioncurrencyid

businessunit

businessunit

businessunitid

parentbusinessunitid

businessunit

constraintbasedgroup

businessunitid

businessunitid

businessunit

equipment

businessunitid

businessunitid

businessunit

role

businessunitid

businessunitid

businessunit

systemuser

businessunitid

businessunitid

businessunit

team

businessunitid

businessunitid

campaign

campaignactivity

campaignid

regardingobjectid

campaign

campaignactivity

transactioncurrencyid

transactioncurrencyid

campaign

campaignresponse

campaignid

regardingobjectid

campaign

lead

campaignid

campaignid

campaign

opportunity

campaignid

campaignid

campaign

quote

campaignid

campaignid

campaign

salesorder

campaignid

campaignid

contact

contact

address1_stateorprovince

address1_stateorprovince

contact

contact

address1_telephone1

address1_telephone1

contact

contact

address1_shippingmethodcode

address1_shippingmethodcode

contact

contact

address1_postofficebox

address1_postofficebox

contact

contact

address1_country

address1_country

contact

contact

address1_postalcode

address1_postalcode

contact

contact

address1_name

address1_name

contact

contact

address1_line3

address1_line3

contact

contact

address1_line2

address1_line2

contact

contact

address1_line1

address1_line1

contact

contact

address1_freighttermscode

address1_freighttermscode

contact

contact

address1_county

address1_county

contact

contact

address1_city

address1_city

contact

contact

address1_addresstypecode

address1_addresstypecode

contact

contact

defaultpricelevelid

defaultpricelevelid

contact

contact

contactid

parentcustomerid

contact

contact

fax

fax

contact

contact

mobilephone

mobilephone

contact

contact

transactioncurrencyid

transactioncurrencyid

contact

contact

telephone1

telephone1

contact

contact

telephone2

telephone2

contact

contract

transactioncurrencyid

transactioncurrencyid

contact

contract

contactid

customerid

contact

customeropportunityrole

contactid

customerid

contact

customerrelationship

contactid

customerid

contact

incident

contactid

customerid

contact

invoice

contactid

customerid

contact

invoice

paymenttermscode

paymenttermscode

contact

invoice

defaultpricelevelid

pricelevelid

contact

invoice

address1_shippingmethodcode

shippingmethodcode

contact

invoice

transactioncurrencyid

transactioncurrencyid

contact

opportunity

transactioncurrencyid

transactioncurrencyid

contact

opportunity

defaultpricelevelid

pricelevelid

contact

opportunity

contactid

parentcontactid

contact

opportunity

contactid

customerid

contact

quote

contactid

customerid

contact

quote

address1_freighttermscode

freighttermscode

contact

quote

defaultpricelevelid

pricelevelid

contact

quote

paymenttermscode

paymenttermscode

contact

quote

address1_shippingmethodcode

shippingmethodcode

contact

quote

transactioncurrencyid

transactioncurrencyid

contact

salesorder

transactioncurrencyid

transactioncurrencyid

contact

salesorder

address1_shippingmethodcode

shippingmethodcode

contact

salesorder

paymenttermscode

paymenttermscode

contact

salesorder

defaultpricelevelid

pricelevelid

contact

salesorder

address1_freighttermscode

freighttermscode

contact

salesorder

contactid

customerid

contract

contractdetail

customeridtype

customeridtype

contract

contractdetail

customerid

customerid

contract

contractdetail

contractid

contractid

contract

contractdetail

activeon

activeon

contract

contractdetail

accountid

accountid

contract

contractdetail

contactid

contactid

contract

contractdetail

effectivitycalendar

effectivitycalendar

contract

contractdetail

expireson

expireson

contract

contractdetail

serviceaddress

serviceaddress

contract

contractdetail

transactioncurrencyid

transactioncurrencyid

contract

incident

accountid

accountid

contract

incident

contractid

contractid

contract

incident

contactid

contactid

contract

incident

customerid

customerid

contract

incident

customeridtype

customeridtype

contractdetail

incident

customeridtype

customeridtype

contractdetail

incident

customerid

customerid

contractdetail

incident

contractdetailid

contractdetailid

contractdetail

incident

contractid

contractid

contractdetail

incident

accountid

accountid

contractdetail

incident

contactid

contactid

contractdetail

incident

productid

productid

contractdetail

incident

productserialnumber

productserialnumber

contracttemplate

contract

allotmenttypecode

allotmenttypecode

contracttemplate

contract

billingfrequencycode

billingfrequencycode

contracttemplate

contract

contractservicelevelcode

contractservicelevelcode

contracttemplate

contract

contracttemplateid

contracttemplateid

contracttemplate

contract

name

contracttemplateidname

contracttemplate

contract

usediscountaspercentage

usediscountaspercentage

discounttype

discount

transactioncurrencyid

transactioncurrencyid

discounttype

discount

discounttypeid

discounttypeid

emailserverprofile

mailbox

emailserverprofileid

emailserverprofile

equipment

account

equipmentid

preferredequipmentid

equipment

contact

equipmentid

preferredequipmentid

goal

goal

goalid

parentgoalid

goal

goal

goalenddate

goalenddate

goal

goal

goalstartdate

goalstartdate

goal

goal

fiscalperiod

fiscalperiod

goal

goal

fiscalyear

fiscalyear

goal

goal

isfiscalperiodgoal

isfiscalperiodgoal

goal

goal

metricid

metricid

incident

lead

customeridtype

customeridtype

incident

lead

contactid

contactid

incident

lead

customerid

customerid

incident

lead

accountid

accountid

incident

lead

title

subject

invoice

invoicedetail

shipto_telephone

shipto_telephone

invoice

invoicedetail

shipto_stateorprovince

shipto_stateorprovince

invoice

invoicedetail

shipto_city

shipto_city

invoice

invoicedetail

shipto_country

shipto_country

invoice

invoicedetail

shipto_fax

shipto_fax

invoice

invoicedetail

shipto_freighttermscode

shipto_freighttermscode

invoice

invoicedetail

shipto_line1

shipto_line1

invoice

invoicedetail

shipto_line2

shipto_line2

invoice

invoicedetail

shipto_line3

shipto_line3

invoice

invoicedetail

shipto_name

shipto_name

invoice

invoicedetail

shipto_postalcode

shipto_postalcode

invoice

invoicedetail

transactioncurrencyid

transactioncurrencyid

invoice

invoicedetail

willcall

willcall

invoice

invoicedetail

invoiceid

invoiceid

lead

account

fax

fax

lead

account

industrycode

industrycode

lead

account

emailaddress1

emailaddress1

lead

account

donotsendmm

donotsendmm

lead

account

companyname

name

lead

account

numberofemployees

numberofemployees

lead

account

leadid

originatingleadid

lead

account

owneridtype

owneridtype

lead

account

ownerid

ownerid

lead

account

fullname

originatingleadidname

lead

account

preferredcontactmethodcode

preferredcontactmethodcode

lead

account

revenue

revenue

lead

account

address1_city

address1_city

lead

account

address1_country

address1_country

lead

account

address1_line1

address1_line1

lead

account

address1_line2

address1_line2

lead

account

address1_line3

address1_line3

lead

account

address1_postalcode

address1_postalcode

lead

account

address1_stateorprovince

address1_stateorprovince

lead

account

donotbulkemail

donotbulkemail

lead

account

donotemail

donotemail

lead

account

donotfax

donotfax

lead

account

donotphone

donotphone

lead

account

donotpostalmail

donotpostalmail

lead

account

description

description

lead

account

yomicompanyname

yominame

lead

account

websiteurl

websiteurl

lead

account

transactioncurrencyid

transactioncurrencyid

lead

account

sic

sic

lead

account

telephone3

telephone2

lead

account

telephone1

telephone1

lead

contact

telephone3

telephone3

lead

contact

telephone2

telephone2

lead

contact

transactioncurrencyid

transactioncurrencyid

lead

contact

telephone1

telephone1

lead

contact

yomifirstname

yomifirstname

lead

contact

yomilastname

yomilastname

lead

contact

yomimiddlename

yomimiddlename

lead

contact

websiteurl

websiteurl

lead

contact

description

description

lead

contact

donotsendmm

donotsendmm

lead

contact

donotpostalmail

donotpostalmail

lead

contact

donotphone

donotphone

lead

contact

donotfax

donotfax

lead

contact

donotemail

donotemail

lead

contact

donotbulkemail

donotbulkemail

lead

contact

address1_stateorprovince

address1_stateorprovince

lead

contact

address2_country

address2_country

lead

contact

address2_county

address2_county

lead

contact

address2_fax

address2_fax

lead

contact

address2_latitude

address2_latitude

lead

contact

address1_postalcode

address1_postalcode

lead

contact

address1_name

address1_name

lead

contact

address1_line3

address1_line3

lead

contact

address1_line2

address1_line2

lead

contact

address1_line1

address1_line1

lead

contact

address1_country

address1_country

lead

contact

address1_city

address1_city

lead

contact

salutation

salutation

lead

contact

preferredcontactmethodcode

preferredcontactmethodcode

lead

contact

leadid

originatingleadid

lead

contact

fullname

originatingleadidname

lead

contact

owneridtype

owneridtype

lead

contact

pager

pager

lead

contact

ownerid

ownerid

lead

contact

mobilephone

mobilephone

lead

contact

firstname

firstname

lead

contact

fax

fax

lead

contact

emailaddress2

emailaddress2

lead

contact

emailaddress3

emailaddress3

lead

contact

emailaddress1

emailaddress1

lead

contact

isprivate

isprivate

lead

contact

jobtitle

jobtitle

lead

contact

lastname

lastname

lead

contact

leadsourcecode

leadsourcecode

lead

opportunity

initialcommunication

initialcommunication

lead

opportunity

subject

name

lead

opportunity

need

need

lead

opportunity

leadid

originatingleadid

lead

opportunity

leadqualitycode

opportunityratingcode

lead

opportunity

parentaccountid

parentaccountid

lead

opportunity

owneridtype

owneridtype

lead

opportunity

parentcontactid

parentcontactid

lead

opportunity

ownerid

ownerid

lead

opportunity

fullname

originatingleadidname

lead

opportunity

purchaseprocess

purchaseprocess

lead

opportunity

purchasetimeframe

purchasetimeframe

lead

opportunity

qualificationcomments

qualificationcomments

lead

opportunity

prioritycode

prioritycode

lead

opportunity

budgetamount

budgetamount

lead

opportunity

budgetstatus

budgetstatus

lead

opportunity

campaignid

campaignid

lead

opportunity

description

description

lead

opportunity

decisionmaker

decisionmaker

lead

opportunity

transactioncurrencyid

transactioncurrencyid

metric

rollupfield

name

metricidname

metric

rollupfield

metricid

metricid

msdyn_postconfig

msdyn_postruleconfig

msdyn_postconfigid

msdyn_postconfigid

msdyn_postconfig

msdyn_postruleconfig

msdyn_entitydisplayname

msdyn_postconfigidname

msdyn_postconfig

msdyn_wallsavedquery

msdyn_postconfigid

msdyn_postconfigurationid

msdyn_postconfig

msdyn_wallsavedquery

msdyn_entitydisplayname

msdyn_postconfigurationidname

msdyn_wallsavedquery

msdyn_wallsavedqueryusersettings

msdyn_wallsavedqueryid

msdyn_wallsavedqueryid

msdyn_wallsavedquery

msdyn_wallsavedqueryusersettings

msdyn_entityname

msdyn_wallsavedqueryidname

opportunity

customeropportunityrole

name

opportunityidname

opportunity

customeropportunityrole

opportunityid

opportunityid

opportunity

invoice

opportunityid

opportunityid

opportunity

invoice

name

opportunityidname

opportunity

invoice

name

name

opportunity

invoice

freightamount

freightamount

opportunity

invoice

pricelevelid

pricelevelid

opportunity

invoice

customeridtype

customeridtype

opportunity

invoice

discountamount

discountamount

opportunity

invoice

discountpercentage

discountpercentage

opportunity

invoice

customerid

customerid

opportunity

invoice

contactid

contactid

opportunity

invoice

accountid

accountid

opportunity

invoice

transactioncurrencyid

transactioncurrencyid

opportunity

invoice

totaldiscountamount

totaldiscountamount

opportunity

invoice

totallineitemamount

totallineitemamount

opportunity

invoice

totallineitemdiscountamount

totallineitemdiscountamount

opportunity

invoice

totaltax

totaltax

opportunity

invoice

totalamount

totalamount

opportunity

invoice

totalamountlessfreight

totalamountlessfreight

opportunity

opportunityproduct

transactioncurrencyid

transactioncurrencyid

opportunity

opportunityproduct

name

opportunityidname

opportunity

opportunityproduct

opportunityid

opportunityid

opportunity

quote

opportunityid

opportunityid

opportunity

quote

name

opportunityidname

opportunity

quote

name

name

opportunity

quote

freightamount

freightamount

opportunity

quote

pricelevelidname

pricelevelidname

opportunity

quote

priceleveliddsc

priceleveliddsc

opportunity

quote

pricelevelid

pricelevelid

opportunity

quote

accountid

accountid

opportunity

quote

campaignid

campaignid

opportunity

quote

contactid

contactid

opportunity

quote

customerid

customerid

opportunity

quote

discountpercentage

discountpercentage

opportunity

quote

discountamount

discountamount

opportunity

quote

customeridtype

customeridtype

opportunity

quote

transactioncurrencyid

transactioncurrencyid

opportunity

quote

totaltax

totaltax

opportunity

quote

totallineitemdiscountamount

totallineitemdiscountamount

opportunity

quote

totallineitemamount

totallineitemamount

opportunity

quote

totaldiscountamount

totaldiscountamount

opportunity

quote

totalamountlessfreight

totalamountlessfreight

opportunity

quote

totalamount

totalamount

opportunity

salesorder

totalamountlessfreight

totalamountlessfreight

opportunity

salesorder

totalamount

totalamount

opportunity

salesorder

totaldiscountamount

totaldiscountamount

opportunity

salesorder

totallineitemamount

totallineitemamount

opportunity

salesorder

totallineitemdiscountamount

totallineitemdiscountamount

opportunity

salesorder

totaltax

totaltax

opportunity

salesorder

transactioncurrencyid

transactioncurrencyid

opportunity

salesorder

customeridtype

customeridtype

opportunity

salesorder

discountpercentage

discountpercentage

opportunity

salesorder

discountamount

discountamount

opportunity

salesorder

customerid

customerid

opportunity

salesorder

contactid

contactid

opportunity

salesorder

campaignid

campaignid

opportunity

salesorder

accountid

accountid

opportunity

salesorder

pricelevelid

pricelevelid

opportunity

salesorder

freightamount

freightamount

opportunity

salesorder

opportunityid

opportunityid

opportunity

salesorder

name

name

opportunity

salesorder

name

opportunityidname

opportunityproduct

invoicedetail

extendedamount

extendedamount

opportunityproduct

invoicedetail

manualdiscountamount

manualdiscountamount

opportunityproduct

invoicedetail

isproductoverridden

isproductoverridden

opportunityproduct

invoicedetail

lineitemnumber

lineitemnumber

opportunityproduct

invoicedetail

ispriceoverridden

ispriceoverridden

opportunityproduct

invoicedetail

priceperunit

priceperunit

opportunityproduct

invoicedetail

pricingerrorcode

pricingerrorcode

opportunityproduct

invoicedetail

productdescription

productdescription

opportunityproduct

invoicedetail

productid

productid

opportunityproduct

invoicedetail

quantity

quantity

opportunityproduct

invoicedetail

baseamount

baseamount

opportunityproduct

invoicedetail

description

description

opportunityproduct

invoicedetail

transactioncurrencyid

transactioncurrencyid

opportunityproduct

invoicedetail

uomid

uomid

opportunityproduct

invoicedetail

uomiddsc

uomiddsc

opportunityproduct

invoicedetail

volumediscountamount

volumediscountamount

opportunityproduct

invoicedetail

uomidname

uomidname

opportunityproduct

invoicedetail

tax

tax

opportunityproduct

quotedetail

tax

tax

opportunityproduct

quotedetail

uomidname

uomidname

opportunityproduct

quotedetail

volumediscountamount

volumediscountamount

opportunityproduct

quotedetail

uomiddsc

uomiddsc

opportunityproduct

quotedetail

uomid

uomid

opportunityproduct

quotedetail

transactioncurrencyid

transactioncurrencyid

opportunityproduct

quotedetail

description

description

opportunityproduct

quotedetail

baseamount

baseamount

opportunityproduct

quotedetail

quantity

quantity

opportunityproduct

quotedetail

productid

productid

opportunityproduct

quotedetail

productiddsc

productiddsc

opportunityproduct

quotedetail

productdescription

productdescription

opportunityproduct

quotedetail

pricingerrorcode

pricingerrorcode

opportunityproduct

quotedetail

priceperunit

priceperunit

opportunityproduct

quotedetail

ispriceoverridden

ispriceoverridden

opportunityproduct

quotedetail

isproductoverridden

isproductoverridden

opportunityproduct

quotedetail

lineitemnumber

lineitemnumber

opportunityproduct

quotedetail

manualdiscountamount

manualdiscountamount

opportunityproduct

quotedetail

extendedamount

extendedamount

opportunityproduct

salesorderdetail

extendedamount

extendedamount

opportunityproduct

salesorderdetail

manualdiscountamount

manualdiscountamount

opportunityproduct

salesorderdetail

lineitemnumber

lineitemnumber

opportunityproduct

salesorderdetail

isproductoverridden

isproductoverridden

opportunityproduct

salesorderdetail

ispriceoverridden

ispriceoverridden

opportunityproduct

salesorderdetail

priceperunit

priceperunit

opportunityproduct

salesorderdetail

pricingerrorcode

pricingerrorcode

opportunityproduct

salesorderdetail

productdescription

productdescription

opportunityproduct

salesorderdetail

productid

productid

opportunityproduct

salesorderdetail

quantity

quantity

opportunityproduct

salesorderdetail

productidname

productidname

opportunityproduct

salesorderdetail

baseamount

baseamount

opportunityproduct

salesorderdetail

description

description

opportunityproduct

salesorderdetail

transactioncurrencyid

transactioncurrencyid

opportunityproduct

salesorderdetail

uomid

uomid

opportunityproduct

salesorderdetail

volumediscountamount

volumediscountamount

opportunityproduct

salesorderdetail

uomidname

uomidname

opportunityproduct

salesorderdetail

tax

tax

pricelevel

productpricelevel

transactioncurrencyid

transactioncurrencyid

pricelevel

productpricelevel

name

pricelevelidname

pricelevel

productpricelevel

pricelevelid

pricelevelid

product

productpricelevel

name

productidname

product

productpricelevel

productid

productid

product

productpricelevel

defaultuomid

uomid

product

productpricelevel

defaultuomscheduleid

uomscheduleid

product

productpricelevel

defaultuomscheduleiddsc

uomscheduleiddsc

quote

quotedetail

willcall

willcall

quote

quotedetail

transactioncurrencyid

transactioncurrencyid

quote

quotedetail

shipto_telephone

shipto_telephone

quote

quotedetail

shipto_stateorprovince

shipto_stateorprovince

quote

quotedetail

shipto_postalcode

shipto_postalcode

quote

quotedetail

shipto_name

shipto_name

quote

quotedetail

shipto_line3

shipto_line3

quote

quotedetail

shipto_line2

shipto_line2

quote

quotedetail

shipto_freighttermscode

shipto_freighttermscode

quote

quotedetail

shipto_line1

shipto_line1

quote

quotedetail

shipto_fax

shipto_fax

quote

quotedetail

shipto_country

shipto_country

quote

quotedetail

shipto_city

shipto_city

quote

quotedetail

shipto_contactname

shipto_contactname

quote

quotedetail

quoteid

quoteid

quote

quotedetail

shipto_addressid

shipto_addressid

quote

salesorder

shipto_addressid

shipto_addressid

quote

salesorder

shippingmethodcode

shippingmethodcode

quote

salesorder

requestdeliveryby

requestdeliveryby

quote

salesorder

quoteid

quoteid

quote

salesorder

name

quoteidname

quote

salesorder

pricelevelid

pricelevelid

quote

salesorder

paymenttermscode

paymenttermscode

quote

salesorder

pricingerrorcode

pricingerrorcode

quote

salesorder

freightamount

freightamount

quote

salesorder

freighttermscode

freighttermscode

quote

salesorder

opportunityid

opportunityid

quote

salesorder

name

name

quote

salesorder

description

description

quote

salesorder

discountamount

discountamount

quote

salesorder

discountpercentage

discountpercentage

quote

salesorder

customeridtype

customeridtype

quote

salesorder

customerid

customerid

quote

salesorder

billto_addressid

billto_addressid

quote

salesorder

billto_city

billto_city

quote

salesorder

billto_contactname

billto_contactname

quote

salesorder

billto_country

billto_country

quote

salesorder

billto_fax

billto_fax

quote

salesorder

billto_line1

billto_line1

quote

salesorder

billto_telephone

billto_telephone

quote

salesorder

billto_stateorprovince

billto_stateorprovince

quote

salesorder

billto_line2

billto_line2

quote

salesorder

billto_line3

billto_line3

quote

salesorder

billto_name

billto_name

quote

salesorder

billto_postalcode

billto_postalcode

quote

salesorder

campaignid

campaignid

quote

salesorder

contactid

contactid

quote

salesorder

accountid

accountid

quote

salesorder

shipto_contactname

shipto_contactname

quote

salesorder

shipto_city

shipto_city

quote

salesorder

shipto_country

shipto_country

quote

salesorder

shipto_fax

shipto_fax

quote

salesorder

shipto_line1

shipto_line1

quote

salesorder

shipto_line2

shipto_line2

quote

salesorder

shipto_line3

shipto_line3

quote

salesorder

shipto_name

shipto_name

quote

salesorder

shipto_postalcode

shipto_postalcode

quote

salesorder

shipto_stateorprovince

shipto_stateorprovince

quote

salesorder

shipto_telephone

shipto_telephone

quote

salesorder

totalamount

totalamount

quote

salesorder

totalamountlessfreight

totalamountlessfreight

quote

salesorder

totaltax

totaltax

quote

salesorder

totallineitemdiscountamount

totallineitemdiscountamount

quote

salesorder

totallineitemamount

totallineitemamount

quote

salesorder

totaldiscountamount

totaldiscountamount

quote

salesorder

transactioncurrencyid

transactioncurrencyid

quote

salesorder

willcall

willcall

quotedetail

salesorderdetail

willcall

willcall

quotedetail

salesorderdetail

uomidname

uomidname

quotedetail

salesorderdetail

volumediscountamount

volumediscountamount

quotedetail

salesorderdetail

uomid

uomid

quotedetail

salesorderdetail

uomiddsc

uomiddsc

quotedetail

salesorderdetail

transactioncurrencyid

transactioncurrencyid

quotedetail

salesorderdetail

tax

tax

quotedetail

salesorderdetail

shipto_telephone

shipto_telephone

quotedetail

salesorderdetail

shipto_postalcode

shipto_postalcode

quotedetail

salesorderdetail

shipto_stateorprovince

shipto_stateorprovince

quotedetail

salesorderdetail

shipto_name

shipto_name

quotedetail

salesorderdetail

shipto_line3

shipto_line3

quotedetail

salesorderdetail

shipto_line2

shipto_line2

quotedetail

salesorderdetail

shipto_line1

shipto_line1

quotedetail

salesorderdetail

shipto_fax

shipto_fax

quotedetail

salesorderdetail

shipto_freighttermscode

shipto_freighttermscode

quotedetail

salesorderdetail

shipto_country

shipto_country

quotedetail

salesorderdetail

shipto_contactname

shipto_contactname

quotedetail

salesorderdetail

baseamount

baseamount

quotedetail

salesorderdetail

description

description

quotedetail

salesorderdetail

extendedamount

extendedamount

quotedetail

salesorderdetail

ispriceoverridden

ispriceoverridden

quotedetail

salesorderdetail

isproductoverridden

isproductoverridden

quotedetail

salesorderdetail

lineitemnumber

lineitemnumber

quotedetail

salesorderdetail

manualdiscountamount

manualdiscountamount

quotedetail

salesorderdetail

priceperunit

priceperunit

quotedetail

salesorderdetail

pricingerrorcode

pricingerrorcode

quotedetail

salesorderdetail

requestdeliveryby

requestdeliveryby

quotedetail

salesorderdetail

salesrepid

salesrepid

quotedetail

salesorderdetail

salesrepiddsc

salesrepiddsc

quotedetail

salesorderdetail

salesrepidname

salesrepidname

quotedetail

salesorderdetail

shipto_addressid

shipto_addressid

quotedetail

salesorderdetail

shipto_city

shipto_city

quotedetail

salesorderdetail

productid

productid

quotedetail

salesorderdetail

productdescription

productdescription

quotedetail

salesorderdetail

productiddsc

productiddsc

quotedetail

salesorderdetail

productidname

productidname

quotedetail

salesorderdetail

quantity

quantity

salesorder

invoice

shipto_city

shipto_city

salesorder

invoice

shippingmethodcode

shippingmethodcode

salesorder

invoice

salesorderid

salesorderid

salesorder

invoice

name

salesorderidname

salesorder

invoice

prioritycode

prioritycode

salesorder

invoice

paymenttermscode

paymenttermscode

salesorder

invoice

pricelevelid

pricelevelid

salesorder

invoice

freightamount

freightamount

salesorder

invoice

name

name

salesorder

invoice

opportunityid

opportunityid

salesorder

invoice

description

description

salesorder

invoice

discountpercentage

discountpercentage

salesorder

invoice

discountamount

discountamount

salesorder

invoice

customeridtype

customeridtype

salesorder

invoice

customeridname

customeridname

salesorder

invoice

customerid

customerid

salesorder

invoice

billto_city

billto_city

salesorder

invoice

billto_line2

billto_line2

salesorder

invoice

billto_line1

billto_line1

salesorder

invoice

billto_fax

billto_fax

salesorder

invoice

billto_country

billto_country

salesorder

invoice

billto_stateorprovince

billto_stateorprovince

salesorder

invoice

billto_postalcode

billto_postalcode

salesorder

invoice

billto_name

billto_name

salesorder

invoice

billto_line3

billto_line3

salesorder

invoice

billto_telephone

billto_telephone

salesorder

invoice

contactid

contactid

salesorder

invoice

accountid

accountid

salesorder

invoice

shipto_country

shipto_country

salesorder

invoice

shipto_fax

shipto_fax

salesorder

invoice

shipto_line1

shipto_line1

salesorder

invoice

shipto_line2

shipto_line2

salesorder

invoice

shipto_line3

shipto_line3

salesorder

invoice

shipto_name

shipto_name

salesorder

invoice

shipto_stateorprovince

shipto_stateorprovince

salesorder

invoice

shipto_postalcode

shipto_postalcode

salesorder

invoice

shipto_telephone

shipto_telephone

salesorder

invoice

totalamountlessfreight

totalamountlessfreight

salesorder

invoice

totalamount

totalamount

salesorder

invoice

transactioncurrencyid

transactioncurrencyid

salesorder

invoice

totaldiscountamount

totaldiscountamount

salesorder

invoice

totallineitemamount

totallineitemamount

salesorder

invoice

totallineitemdiscountamount

totallineitemdiscountamount

salesorder

invoice

totaltax

totaltax

salesorder

invoice

willcall

willcall

salesorder

salesorderdetail

willcall

willcall

salesorder

salesorderdetail

transactioncurrencyid

transactioncurrencyid

salesorder

salesorderdetail

shipto_stateorprovince

shipto_stateorprovince

salesorder

salesorderdetail

shipto_telephone

shipto_telephone

salesorder

salesorderdetail

shipto_name

shipto_name

salesorder

salesorderdetail

shipto_postalcode

shipto_postalcode

salesorder

salesorderdetail

shipto_line2

shipto_line2

salesorder

salesorderdetail

shipto_line3

shipto_line3

salesorder

salesorderdetail

shipto_line1

shipto_line1

salesorder

salesorderdetail

shipto_freighttermscode

shipto_freighttermscode

salesorder

salesorderdetail

shipto_country

shipto_country

salesorder

salesorderdetail

shipto_fax

shipto_fax

salesorder

salesorderdetail

shipto_city

shipto_city

salesorder

salesorderdetail

shipto_contactname

shipto_contactname

salesorder

salesorderdetail

salesorderid

salesorderid

salesorder

salesorderdetail

shipto_addressid

shipto_addressid

salesorderdetail

invoicedetail

shipto_city

shipto_city

salesorderdetail

invoicedetail

salesrepid

salesrepid

salesorderdetail

invoicedetail

salesrepidname

salesrepidname

salesorderdetail

invoicedetail

quantitybackordered

quantitybackordered

salesorderdetail

invoicedetail

quantity

quantity

salesorderdetail

invoicedetail

productidname

productidname

salesorderdetail

invoicedetail

productid

productid

salesorderdetail

invoicedetail

productdescription

productdescription

salesorderdetail

invoicedetail

priceperunit

priceperunit

salesorderdetail

invoicedetail

extendedamount

extendedamount

salesorderdetail

invoicedetail

manualdiscountamount

manualdiscountamount

salesorderdetail

invoicedetail

iscopied

iscopied

salesorderdetail

invoicedetail

ispriceoverridden

ispriceoverridden

salesorderdetail

invoicedetail

isproductoverridden

isproductoverridden

salesorderdetail

invoicedetail

lineitemnumber

lineitemnumber

salesorderdetail

invoicedetail

baseamount

baseamount

salesorderdetail

invoicedetail

description

description

salesorderdetail

invoicedetail

shipto_country

shipto_country

salesorderdetail

invoicedetail

shipto_fax

shipto_fax

salesorderdetail

invoicedetail

shipto_freighttermscode

shipto_freighttermscode

salesorderdetail

invoicedetail

shipto_line1

shipto_line1

salesorderdetail

invoicedetail

shipto_name

shipto_name

salesorderdetail

invoicedetail

shipto_line2

shipto_line2

salesorderdetail

invoicedetail

shipto_line3

shipto_line3

salesorderdetail

invoicedetail

shipto_postalcode

shipto_postalcode

salesorderdetail

invoicedetail

shipto_stateorprovince

shipto_stateorprovince

salesorderdetail

invoicedetail

shipto_telephone

shipto_telephone

salesorderdetail

invoicedetail

tax

tax

salesorderdetail

invoicedetail

transactioncurrencyid

transactioncurrencyid

salesorderdetail

invoicedetail

willcall

willcall

salesorderdetail

invoicedetail

volumediscountamount

volumediscountamount

salesorderdetail

invoicedetail

uomiddsc

uomiddsc

salesorderdetail

invoicedetail

uomidname

uomidname

salesorderdetail

invoicedetail

uomid

uomid

subject

subject

subjectid

parentsubject

subject

subject

title

parentsubjectname

systemuser

msdyn_wallsavedqueryusersettings

systemuserid

msdyn_userid

systemuser

msdyn_wallsavedqueryusersettings

fullname

msdyn_useridname

uomschedule

uom

uomscheduleid

uomscheduleid

See Also

Create and edit entity relationships
Customizable parental entity relationships

© 2016 Microsoft Corporation. All rights reserved. Copyright