HcmContactsphones
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. |
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 |