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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。