Supplierscontacts
Supplierscontacts
Table Specific Information
Select
The 本製品 uses the Oracle Fusion Cloud Financials API to process some of the filters having queryable=true in metadata. The 本製品 processes other filters within the 本製品.
For example, the following query is processed server side:
SELECT * FROM [Cdata].[Procurement].[Supplierscontacts] WHERE SupplierContactId = 10003
Insert
You need to provide SuppliersUniqId, instead of SuppliersSupplierId , to insert the record.
Create a Suppliercontacts. SuppliersUniqId is used to uniquely identify the Supplier.
INSERT INTO [Cdata].[Procurement].[Supplierscontacts] (SuppliersUniqId,Salutation,FirstName,LastName,AdministrativeContactFlag,MobileCountryCode,MobileAreaCode,MobileNumber) VALUES ('300000051066029','Mr.','Test1','Test2',true,'1','650','555-2234')
Update
The Oracle Fusion Cloud Financials API uses SuppliersUniqId instead of SuppliersSupplierId and SupplierContactUniqId instead of SupplierContactId as a path parameter in the URL to update the record.
If you want to update a record directly using the id (without any other filter), you can update the record in the following way:
Update [Cdata].[Procurement].[Supplierscontacts] set PhoneNumber='66565' where SuppliersUniqId = 454545454 and SupplierContactUniqId=454;
Note: This does not require any extra GET request to retrieve the UniqId. You need to provide all the UniqIds.
Alternatively, if you want to apply any other filter. Please use SuppliersSupplierId instead of SuppliersUniqId and SupplierContactId instead of SupplierContactUniqId. You can update the record in the following way:
Update [Cdata].[Procurement].[Supplierscontacts] set PhoneNumber='66565' where SuppliersSupplierId = 454545454
Note : Update on aggregates are not allowed by API, use the child tables to add/update/delete aggregates.
Columns
Name | Type | ReadOnly | Description |
SuppliersSupplierId [KEY] | Long | True |
SuppliersSupplierId of Supplierscontacts |
SuppliersUniqId [KEY] | String | True |
Use this column's value for insert, update and delete operations, wherever applicable, instead of suppliersSupplierId. |
SupplierContactId [KEY] | Long | True |
SupplierContactId of Supplierscontacts |
SupplierContactUniqId [KEY] | String | True |
Use this column's value in insert, update and delete operations, wherever applicable, instead of SupplierContactId |
SalutationCode | String | False |
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 | False |
Honorific title of the supplier contact. |
FirstName | String | False |
First name of the supplier contact. |
MiddleName | String | False |
Middle name of the supplier contact. |
LastName | String | False |
Last name of the supplier contact. |
JobTitle | String | False |
Job title of the supplier contact. |
AdministrativeContactFlag | Bool | False |
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 | False |
Abbreviation that identifies the country for the phone of the supplier contact. |
PhoneAreaCode | String | False |
Abbreviation that identifies the area for the phone of the supplier contact. |
PhoneNumber | String | False |
Phone for the supplier contact. |
PhoneExtension | String | False |
Phone extension for the supplier contact. |
MobileCountryCode | String | False |
Abbreviation that identifies the country for the mobile phone of the supplier contact. |
MobileAreaCode | String | False |
Abbreviation that identifies the area for the mobile phone of the supplier contact. |
MobileNumber | String | False |
Mobile phone number of the supplier contact. |
FaxCountryCode | String | False |
Abbreviation that identifies the country for the fax of the supplier contact. |
FaxAreaCode | String | False |
Abbreviation that identifies the area for the fax of the supplier contact. |
FaxNumber | String | False |
Fax of the supplier contact. |
String | False |
Email of the supplier contact. | |
Status | String | True |
Status of Supplierscontacts |
InactiveDate | Date | False |
Date when the supplier contact is no longer active. |
PersonProfileId [KEY] | Long | False |
Value that uniquely identifies the person profile. |
CreationDate | Datetime | True |
CreationDate of Supplierscontacts |
CreatedBy | String | True |
CreatedBy of Supplierscontacts |
LastUpdateDate | Datetime | True |
LastUpdateDate of Supplierscontacts |
LastUpdatedBy | String | True |
LastUpdatedBy of Supplierscontacts |
DFF | String | False |
This column can only be used for Insert. For update and delete, use child table's operations, if applicable. |
addresses | String | False |
This column can only be used for Insert. For update and delete, use child table's operations, if applicable. |
BilltoBuId | Long | True |
billtobuid |
BindPurchaseFlag | String | True |
bindpurchaseflag |
BindReqBuId | Long | True |
bindreqbuid |
BindSourcingOnlyFlag | String | True |
bindsourcingonlyflag |
BindSysdate | Date | True |
bindsysdate |
Finder | String | True |
finder |
SupplierId | Long | True |
supplierid |
CUReferenceNumber | Int | False |
Maps the child aggregates with Parent tables. |