CRM Customeraddress

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 (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 (CustomerAddressId)	GUID	ExternalName: customeraddressid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the customer address.
3	AddressNumber (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 (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 (Name)	Text200	ExternalName: name ExternalType: String Description: Type a descriptive name for the customer's address, such as Corporate Headquarters.
6	PrimaryContactName (PrimaryContactName)	Text150	ExternalName: primarycontactname ExternalType: String Description: Type the name of the primary contact person for the customer's address.
7	Line1 (Line1)	Text250	ExternalName: line1 ExternalType: String Description: Type the first line of the customer's address to help identify the location.
8	Line2 (Line2)	Text250	ExternalName: line2 ExternalType: String Description: Type the second line of the customer's address.
9	Line3 (Line3)	Text250	ExternalName: line3 ExternalType: String Description: Type the third line of the customer's address.
10	City (City)	Text80	ExternalName: city ExternalType: String Description: Type the city for the customer's address to help identify the location.
11	StateOrProvince (StateOrProvince)	Text50	ExternalName: stateorprovince ExternalType: String Description: Type the state or province of the customer's address.
12	County (County)	Text50	ExternalName: county ExternalType: String Description: Type the county for the customer's address.
13	Country (Country)	Text80	ExternalName: country ExternalType: String Description: Type the country or region for the customer's address.
14	PostOfficeBox (PostOfficeBox)	Text20	ExternalName: postofficebox ExternalType: String Description: Type the post office box number of the customer's address.
15	PostalCode (PostalCode)	Text20	ExternalName: postalcode ExternalType: String Description: Type the ZIP Code or postal code for the address.
16	UTCOffset (UTCOffset)	Integer	MinValue: -1500 MaxValue: 1500 ExternalName: utcoffset ExternalType: Integer Description: Select the time zone for the address.
17	FreightTermsCode (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 (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 (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 (Telephone1)	Text50	ExternalName: telephone1 ExternalType: String Description: Type the primary phone number for the customer's address.
21	Longitude (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 (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 (Telephone2)	Text50	ExternalName: telephone2 ExternalType: String Description: Type a second phone number for the customer's address.
24	Telephone3 (Telephone3)	Text50	ExternalName: telephone3 ExternalType: String Description: Type a third phone number for the customer's address.
25	Fax (Fax)	Text50	ExternalName: fax ExternalType: String Description: Type the fax number associated with the customer's address.
26	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the customer address.
27	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
28	CreatedOn (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 (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
30	ModifiedOn (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 (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
32	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
33	OwningBusinessUnit (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 (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 (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
36	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
37	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
38	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
39	OwnerIdType (OwnerIdType)	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName ExternalAccess: Read
40	OwnerId (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 (ParentIdTypeCode)	Option	[ ,account,contact] ExternalName: parentidtypecode ExternalType: EntityName
42	CreatedOnBehalfBy (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 (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
44	ModifiedOnBehalfBy (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 (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
46	TransactionCurrencyId (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 (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
48	ExchangeRate (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 (Composite)	BLOB [Memo]	ExternalName: composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete address.

Keys

#	Fields
0	CustomerAddressId (CustomerAddressId)		Clustered: Yes
1	Name (Name)

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table	From Field
CRM Contract	BillToAddress (BillToAddress)	TableRelation: "CRM Customeraddress".CustomerAddressId	1..n
CRM Post	RegardingObjectId (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