HcmContactsaddressesaddressesDFF
HcmContactsaddressesaddressesDFF
Columns
Name | Type | Description |
HcmContactsPersonId [KEY] | Long | HcmContactsPersonId of HcmContactsaddressesaddressesDFF |
AddressesAddressId [KEY] | Long | AddressesAddressId of HcmContactsaddressesaddressesDFF |
AddressesEffectiveEndDate [KEY] | Date | AddressesEffectiveEndDate of HcmContactsaddressesaddressesDFF |
AddressesEffectiveStartDate [KEY] | Date | AddressesEffectiveStartDate of HcmContactsaddressesaddressesDFF |
AddressesPersonAddrUsageId [KEY] | Long | AddressesPersonAddrUsageId of HcmContactsaddressesaddressesDFF |
PersonAddrUsageId [KEY] | Long | Descriptive flexfield for contact address. |
EffectiveStartDate [KEY] | Date | Descriptive flexfield for contact address. |
EffectiveEndDate [KEY] | Date | Descriptive flexfield for contact address. |
_FLEX_Context | String | Descriptive flexfield for contact address. |
_FLEX_Context_DisplayValue | String | Context Value |
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 |