HcmContactsaddresses
HcmContactsaddresses
Columns
Name | Type | Description |
HcmContactsPersonId [KEY] | Long | HcmContactsPersonId of HcmContactsaddresses |
AddressId [KEY] | Long | Surrogate identifier for the address record. |
EffectiveStartDate [KEY] | Date | Start date of the date-effective changes to the record. |
EffectiveEndDate [KEY] | Date | End date of the date-effective changes to the record. |
AddressLine1 | String | First line of the primary mail address. |
AddressLine2 | String | Second line of the primary mail address. |
AddressLine3 | String | Third line of the primary mail address. |
AddressLine4 | String | Fourth line of the primary mail address. |
TownOrCity | String | Town or city in which the address is located. |
Region1 | String | Primary region in which the address is located. |
Region2 | String | Secondary region within the primary region. |
Region3 | String | Additional secondary region within the primary region. |
Country | String | Country in which the address is located. Valid values are defined in the hcmCountriesLov. |
CountryName | String | CountryName of HcmContactsaddresses |
PostalCode | String | Postal code of the primary mail address. |
LongPostalCode | String | Long postal code of the primary mail address. |
AddlAddressAttribute1 | String | Additional address column used by localizations. |
AddlAddressAttribute2 | String | Additional address column used by localizations. |
AddlAddressAttribute3 | String | Additional address column used by localizations. |
AddlAddressAttribute4 | String | Additional address column used by localizations. |
AddlAddressAttribute5 | String | Additional address column used by localizations. |
Building | String | Building information associated with the address. |
FloorNumber | String | Floor number associated with the building. |
CreatedBy | String | CreatedBy of HcmContactsaddresses |
CreationDate | Datetime | CreationDate of HcmContactsaddresses |
LastUpdatedBy | String | LastUpdatedBy of HcmContactsaddresses |
LastUpdateDate | Datetime | LastUpdateDate of HcmContactsaddresses |
PersonAddrUsageId [KEY] | Long | PersonAddrUsageId of HcmContactsaddresses |
AddressType | String | Type of address. Valid values are defined in the commonLookupsLOV. |
AddressTypeMeaning | String | AddressTypeMeaning of HcmContactsaddresses |
PrimaryFlag | Bool | Indicates whether the address is the primary mailing address. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
ContactType | String | ContactType |
EmergencyContactFlag | String | EmergencyContactFlag |
PersonId | Long | PersonId |
RelatedPersonId | Long | RelatedPersonId |
RelatedPersonNumber | String | RelatedPersonNumber |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |