Table 5360 CRM Customeraddress in 24
- App
- Base Application
- Namespace
- Microsoft.Integration.D365Sales
Versions171819202122232425262728latest
Source29
Fields, 50
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | ParentId | Guid | - | ||||
| 2 | CustomerAddressId | Guid | - | ||||
| 3 | AddressNumber | Integer | - | ||||
| 4 | AddressTypeCode | Option | - | ||||
| 5 | Name | Text[200] | - | ||||
| 6 | PrimaryContactName | Text[150] | - | ||||
| 7 | Line1 | Text[250] | - | ||||
| 8 | Line2 | Text[250] | - | ||||
| 9 | Line3 | Text[250] | - | ||||
| 10 | City | Text[80] | - | ||||
| 11 | StateOrProvince | Text[50] | - | ||||
| 12 | County | Text[50] | - | ||||
| 13 | Country | Text[80] | - | ||||
| 14 | PostOfficeBox | Text[20] | - | ||||
| 15 | PostalCode | Text[20] | - | ||||
| 16 | UTCOffset | Integer | - | ||||
| 17 | FreightTermsCode | Option | - | ||||
| 18 | UPSZone | Text[4] | - | ||||
| 19 | Latitude | Decimal | - | ||||
| 20 | Telephone1 | Text[50] | - | ||||
| 21 | Longitude | Decimal | - | ||||
| 22 | ShippingMethodCode | Option | Removed 19.0 | ||||
| This field is replaced by field 50 ShippingMethodCodeEnum | |||||||
| 23 | Telephone2 | Text[50] | - | ||||
| 24 | Telephone3 | Text[50] | - | ||||
| 25 | Fax | Text[50] | - | ||||
| 26 | VersionNumber | BigInteger | - | ||||
| 27 | CreatedBy | Guid | - | ||||
| 28 | CreatedOn | DateTime | - | ||||
| 29 | ModifiedBy | Guid | - | ||||
| 30 | ModifiedOn | DateTime | - | ||||
| 31 | CreatedByName | Text[200] | - | ||||
| 32 | ModifiedByName | Text[200] | - | ||||
| 33 | OwningBusinessUnit | Guid | - | ||||
| 34 | OwningUser | Guid | - | ||||
| 35 | TimeZoneRuleVersionNumber | Integer | - | ||||
| 36 | OverriddenCreatedOn | Date | - | ||||
| 37 | UTCConversionTimeZoneCode | Integer | - | ||||
| 38 | ImportSequenceNumber | Integer | - | ||||
| 39 | OwnerIdType | Option | - | ||||
| 40 | OwnerId | Guid | - | ||||
| 41 | ParentIdTypeCode | Option | - | ||||
| 42 | CreatedOnBehalfBy | Guid | - | ||||
| 43 | CreatedOnBehalfByName | Text[200] | - | ||||
| 44 | ModifiedOnBehalfBy | Guid | - | ||||
| 45 | ModifiedOnBehalfByName | Text[200] | - | ||||
| 46 | TransactionCurrencyId | Guid | - | ||||
| 47 | TransactionCurrencyIdName | Text[100] | - | ||||
| 48 | ExchangeRate | Decimal | - | ||||
| 49 | Composite | Blob | - | ||||
| 50 | ShippingMethodCodeEnum | Enum CDS Shipping Agent Code | - | ||||
Keys, 2
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | CustomerAddressId | - |
| Key2 | Name | - |