Supplierscontacts

The Contacts resource manages supplier contacts.

Columns


Name	Type	Description
SuppliersSupplierId [KEY]	Long	SuppliersSupplierId of Supplierscontacts
SupplierContactId [KEY]	Long	SupplierContactId of Supplierscontacts
SalutationCode	String	Abbreviation that identifies the honorific title of the supplier contact. A list of accepted values is defined in the lookup type CONTACT_TITLE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
Salutation	String	Honorific title of the supplier contact.
FirstName	String	First name of the supplier contact.
MiddleName	String	Middle name of the supplier contact.
LastName	String	Last name of the supplier contact.
JobTitle	String	Job title of the supplier contact.
AdministrativeContactFlag	Bool	Contains one of the following values: true or false. If true, then the supplier is an administrative contact. If false, then the supplier is not an administrative contact. The default value is false.
PhoneCountryCode	String	Abbreviation that identifies the country for the phone of the supplier contact.
PhoneAreaCode	String	Abbreviation that identifies the area for the phone of the supplier contact.
PhoneNumber	String	Phone for the supplier contact.
PhoneExtension	String	Phone extension for the supplier contact.
MobileCountryCode	String	Abbreviation that identifies the country for the mobile phone of the supplier contact.
MobileAreaCode	String	Abbreviation that identifies the area for the mobile phone of the supplier contact.
MobileNumber	String	Mobile phone number of the supplier contact.
FaxCountryCode	String	Abbreviation that identifies the country for the fax of the supplier contact.
FaxAreaCode	String	Abbreviation that identifies the area for the fax of the supplier contact.
FaxNumber	String	Fax of the supplier contact.
Email	String	Email of the supplier contact.
Status	String	Status of Supplierscontacts
InactiveDate	Date	Date when the supplier contact is no longer active.
PersonProfileId [KEY]	Long	Value that uniquely identifies the person profile.
CreationDate	Datetime	CreationDate of Supplierscontacts
CreatedBy	String	CreatedBy of Supplierscontacts
LastUpdateDate	Datetime	LastUpdateDate of Supplierscontacts
LastUpdatedBy	String	LastUpdatedBy of Supplierscontacts
BilltoBuId	Long	BilltoBuId of Supplierscontacts
BindPurchaseFlag	String	BindPurchaseFlag of Supplierscontacts
BindReqBuId	Long	BindReqBuId of Supplierscontacts
BindSourcingOnlyFlag	String	BindSourcingOnlyFlag of Supplierscontacts
BindSysdate	Date	BindSysdate of Supplierscontacts
Finder	String	Finder of Supplierscontacts
SupplierId	Long	SupplierId of Supplierscontacts

JDBC Driver for Oracle Fusion Cloud Financials

Supplierscontacts

Columns