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

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