Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

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.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9111