HcmContactsphones

Columns


Name	Type	Description
HcmContactsPersonId [KEY]	Long	HcmContactsPersonId of HcmContactsphones
PhoneId [KEY]	Long	PhoneId of HcmContactsphones
PhoneType	String	Type of phone such as Work, Home, and so on. Valid values are defined in the commonLookupsLOV.
PhoneTypeMeaning	String	PhoneTypeMeaning of HcmContactsphones
LegislationCode	String	Legislation code of the contact's phone.
LegislationName	String	LegislationName of HcmContactsphones
CountryCodeNumber	String	Country code of the contact's phone number. Valid values are defined in the hcmCountriesLov.
AreaCode	String	Area code of the contact's phone number.
PhoneNumber	String	Contact's phone number for various phone types such as Work, Home, and so on.
Extension	String	Extension number for the contact's phone.
FromDate	Date	Date from when the contact's phone number is valid.
ToDate	Date	Date until when the contact's phone number is valid.
CreatedBy	String	CreatedBy of HcmContactsphones
CreationDate	Datetime	CreationDate of HcmContactsphones
LastUpdatedBy	String	LastUpdatedBy of HcmContactsphones
LastUpdateDate	Datetime	LastUpdateDate of HcmContactsphones
PrimaryFlag	Bool	Indicates whether the phone number is the primary phone of the contact.

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