HcmContactsemails
HcmContactsemails
Columns
Name | Type | Description |
HcmContactsPersonId [KEY] | Long | HcmContactsPersonId of HcmContactsemails |
EmailAddressId [KEY] | Long | EmailAddressId of HcmContactsemails |
EmailType | String | Type of email such as work, personal, and so on. Valid values are defined in the commonLookupsLOV. |
EmailTypeMeaning | String | EmailTypeMeaning of HcmContactsemails |
EmailAddress | String | Email address of the contact. |
FromDate | Date | Date from when the contact's email address is valid. |
ToDate | Date | Date until when the contact's email address is valid. |
CreatedBy | String | CreatedBy of HcmContactsemails |
CreationDate | Datetime | CreationDate of HcmContactsemails |
LastUpdatedBy | String | LastUpdatedBy of HcmContactsemails |
LastUpdateDate | Datetime | LastUpdateDate of HcmContactsemails |
PrimaryFlag | Bool | Indicates whether the email is the contact's primary email. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
ContactType | String | ContactType |
EmergencyContactFlag | String | EmergencyContactFlag |
PersonId | Long | PersonId |
RelatedPersonId | Long | RelatedPersonId |
RelatedPersonNumber | String | RelatedPersonNumber |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |