DynamicsDocs.com

Diagrams

Table

CRM Customeraddress

Fields |
Keys |
Relations To |
Relations From

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	ParentId	GUID	ExternalName: parentid ExternalType: Lookup Description: Choose the customer's address. TableRelation: IF (ParentIdTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (ParentIdTypeCode=CONST(contact)) "CRM Contact".ContactId;
2	CustomerAddressId	GUID	ExternalName: customeraddressid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the customer address.
3	AddressNumber	Integer	MaxValue: 1000000000 ExternalName: addressnumber ExternalType: Integer Description: Shows the number of the address, to indicate whether the address is the primary, secondary, or other address for the customer.
4	AddressTypeCode	Option	[ ,BillTo,ShipTo,Primary,Other] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: addresstypecode ExternalType: Picklist Description: Select the address type, such as primary or billing.
5	Name	Text200	ExternalName: name ExternalType: String Description: Type a descriptive name for the customer's address, such as Corporate Headquarters.
6	PrimaryContactName	Text150	ExternalName: primarycontactname ExternalType: String Description: Type the name of the primary contact person for the customer's address.
7	Line1	Text250	ExternalName: line1 ExternalType: String Description: Type the first line of the customer's address to help identify the location.
8	Line2	Text250	ExternalName: line2 ExternalType: String Description: Type the second line of the customer's address.
9	Line3	Text250	ExternalName: line3 ExternalType: String Description: Type the third line of the customer's address.
10	City	Text80	ExternalName: city ExternalType: String Description: Type the city for the customer's address to help identify the location.
11	StateOrProvince	Text50	ExternalName: stateorprovince ExternalType: String Description: Type the state or province of the customer's address.
12	County	Text50	ExternalName: county ExternalType: String Description: Type the county for the customer's address.
13	Country	Text80	ExternalName: country ExternalType: String Description: Type the country or region for the customer's address.
14	PostOfficeBox	Text20	ExternalName: postofficebox ExternalType: String Description: Type the post office box number of the customer's address.
15	PostalCode	Text20	ExternalName: postalcode ExternalType: String Description: Type the ZIP Code or postal code for the address.
16	UTCOffset	Integer	MinValue: -1500 MaxValue: 1500 ExternalName: utcoffset ExternalType: Integer Description: Select the time zone for the address.
17	FreightTermsCode	Option	[ ,FOB,NoCharge] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: freighttermscode ExternalType: Picklist Description: Select the freight terms to make sure shipping charges are processed correctly.
18	UPSZone	Text4	ExternalName: upszone ExternalType: String Description: Type the UPS zone of the customer's address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
19	Latitude	Decimal	ExternalName: latitude ExternalType: Double Description: Type the latitude value for the customer's address, for use in mapping and other applications.
20	Telephone1	Text50	ExternalName: telephone1 ExternalType: String Description: Type the primary phone number for the customer's address.
21	Longitude	Decimal	ExternalName: longitude ExternalType: Double Description: Type the longitude value for the customer's address, for use in mapping and other applications.
22	ShippingMethodCode	Option	[ ,Airborne,DHL,FedEx,UPS,PostalMail,FullLoad,WillCall] OptionOrdinalValues: [-1;1;2;3;4;5;6;7] InitValue: [ ] ExternalName: shippingmethodcode ExternalType: Picklist Description: Select a shipping method for deliveries sent to this address.
23	Telephone2	Text50	ExternalName: telephone2 ExternalType: String Description: Type a second phone number for the customer's address.
24	Telephone3	Text50	ExternalName: telephone3 ExternalType: String Description: Type a third phone number for the customer's address.
25	Fax	Text50	ExternalName: fax ExternalType: String Description: Type the fax number associated with the customer's address.
26	VersionNumber	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the customer address.
27	CreatedBy	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
28	CreatedOn	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
29	ModifiedBy	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
30	ModifiedOn	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
31	CreatedByName	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
32	ModifiedByName	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
33	OwningBusinessUnit	GUID	ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read Description: Shows the business unit that the record owner belongs to. TableRelation: "CRM Businessunit".BusinessUnitId
34	OwningUser	GUID	ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who owns the customer address. TableRelation: "CRM Systemuser".SystemUserId
35	TimeZoneRuleVersionNumber	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
36	OverriddenCreatedOn	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
37	UTCConversionTimeZoneCode	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
38	ImportSequenceNumber	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
39	OwnerIdType	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName ExternalAccess: Read
40	OwnerId	GUID	ExternalName: ownerid ExternalType: Owner ExternalAccess: Read Description: Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;
41	ParentIdTypeCode	Option	[ ,account,contact] ExternalName: parentidtypecode ExternalType: EntityName
42	CreatedOnBehalfBy	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
43	CreatedOnBehalfByName	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
44	ModifiedOnBehalfBy	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
45	ModifiedOnBehalfByName	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
46	TransactionCurrencyId	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
47	TransactionCurrencyIdName	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
48	ExchangeRate	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read Description: Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
49	Composite	BLOB [Memo]	ExternalName: composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete address.

Keys

#	Fields
0	CustomerAddressId		Clustered: Yes
1	Name

Table Relations To Other Tables

Field	Related Table	Related Field
ParentId	CRM Account	AccountId	TableRelation: IF (ParentIdTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (ParentIdTypeCode=CONST(contact)) "CRM Contact".ContactId;	1..n
OwningBusinessUnit	CRM Businessunit	BusinessUnitId	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
ParentId	CRM Contact	ContactId	TableRelation: IF (ParentIdTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (ParentIdTypeCode=CONST(contact)) "CRM Contact".ContactId;	1..n
ModifiedOnBehalfBy	CRM Systemuser	SystemUserId	TableRelation: "CRM Systemuser".SystemUserId	1..n
OwnerId	CRM Team	TeamId	TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;	1..n
TransactionCurrencyId	CRM Transactioncurrency	TransactionCurrencyId	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Contract	BillToAddress	TableRelation: "CRM Customeraddress".CustomerAddressId	1..n
CRM Post	RegardingObjectId	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n