Table 5360 "CRM Customeraddress"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM Customeraddress
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	ParentId	Guid	Parent caption	TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (ParentIdTypeCode = const(account)) “CRM Account”.AccountId else if (ParentIdTypeCode = const(contact)) “CRM Contact”.ContactId)
2	CustomerAddressId	Guid	Address caption
3	AddressNumber	Integer	Address Number caption
4	AddressTypeCode	Option	Address Type caption	OptionCaption: ,Bill To,Ship To,Primary,Other
5	Name	Text[200]	Address Name caption
6	PrimaryContactName	Text[150]	Address Contact caption
7	Line1	Text[250]	Street 1 caption
8	Line2	Text[250]	Street 2 caption
9	Line3	Text[250]	Street 3 caption
10	City	Text[80]	—
11	StateOrProvince	Text[50]	State/Province caption
12	County	Text[50]	—
13	Country	Text[80]	Country/Region caption
14	PostOfficeBox	Text[20]	Post Office Box caption
15	PostalCode	Text[20]	ZIP/Postal Code caption
16	UTCOffset	Integer	UTC Offset caption
17	FreightTermsCode	Option	Freight Terms caption	OptionCaption: ,FOB,No Charge
18	UPSZone	Text[4]	UPS Zone caption
19	Latitude Δ BC28	Decimal	—
20	Telephone1	Text[50]	Main Phone caption
21	Longitude Δ BC28	Decimal	—
23	Telephone2	Text[50]	Phone 2 caption
24	Telephone3	Text[50]	Telephone 3 caption
25	Fax	Text[50]	—
26	VersionNumber	BigInteger	Version Number caption
27	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
28	CreatedOn	DateTime	Created On caption
29	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
30	ModifiedOn	DateTime	Modified On caption
31	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
32	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
33	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
34	OwningUser	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
35	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
36	OverriddenCreatedOn	Date	Record Created On caption
37	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
38	ImportSequenceNumber	Integer	Import Sequence Number caption
39	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
40	OwnerId	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (OwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (OwnerIdType = const(team)) “CRM Team”.TeamId)
41	ParentIdTypeCode	Option	Parent Object Type caption	OptionCaption: ,account,contact
42	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
43	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
44	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
45	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
46	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
47	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
48	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
49	Composite	BLOB	Address caption
50	ShippingMethodCodeEnum	Enum “CDS Shipping Agent Code”	Shipping Method caption	enum Enum 5336 “CDS Shipping Agent Code”

Keys

Key1: CustomerAddressId (clustered)
Key2: Name

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
OwningUser: TableRelation Table 5340 “CRM Systemuser”
ParentId: TableRelation Table 5341 “CRM Account” (conditional)
ParentId: TableRelation Table 5342 “CRM Contact” (conditional)
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”

Referenced by

4 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 5357 “CRM Contract”: BillToAddressName, ServiceAddressName, BillToAddress, ServiceAddress

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Customeraddress"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.