ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9111

Suppliers

The Suppliers resource manages supplier details.

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].[Suppliers] WHERE SupplierId = 10003

Insert

Create a Supplier.

INSERT INTO [Cdata].[Procurement].[Suppliers] (BusinessRelationshipCode,Supplier,TaxOrganizationTypeCode) VALUES ('SPEND_AUTHORIZED', 'Lee Supplies1', 'CORPORATION')

You can also add aggregates with the parent table, using TEMP table and aggregates. Please refer to Invoices.

Update

The Oracle Fusion Cloud Financials API uses SupplierUniqId instead of SupplierId 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].[Suppliers] set YearEstablished=2021 where SupplierUniqId = 454545454;

Note: This does not require any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please use SupplierId instead of SupplierUniqId. You can update the record in the following way:

Update [Cdata].[Procurement].[Suppliers] set YearEstablished=2021 where SupplierUniqId = 454545454 and ParentSupplier='asdw';

Note : Update on aggregates are not allowed by API, use the child tables to add/update/delete aggregates.

Columns

Name Type ReadOnly Description
SupplierId [KEY] Long True

SupplierId

SupplierUniqId [KEY] String True

Use this column's value in insert, update and delete operations, wherever applicable, instead of SupplierId

SupplierPartyId Long False

Value that uniquely identifies the supplier party.

Supplier String False

Name of the supplier.

SupplierNumber String False

Number that identifies the supplier.

AlternateName String False

Alternate name of the supplier.

TaxOrganizationTypeCode String False

Abbreviation that identifies the type of tax organization for the supplier. A list of accepted values is defined in the lookup type POZ_ORGANIZATION_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Tax Organization Type Lookup task.

TaxOrganizationType String False

Type of tax organization for the supplier.

SupplierTypeCode String False

Abbreviation that identifies the type of supplier. A list of accepted values is defined in the lookup type POZ_VENDOR_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Supplier Type Lookup task.

SupplierType String False

Type of supplier.

InactiveDate Date False

Date when the supplier is no longer active.

Status String True

Status

BusinessRelationshipCode String False

Abbreviation that identifies the business relationship between the enterprise and the supplier. A list of accepted values is defined in the lookup type ORA_POZ_BUSINESS_RELATIONSHIP. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.

BusinessRelationship String False

Business relationship between the enterprise and the supplier.

ParentSupplierId Long False

Value that uniquely identifies the parent supplier.

ParentSupplier String False

Name of the parent supplier.

ParentSupplierNumber String True

ParentSupplierNumber

CreationDate Datetime True

CreationDate

CreatedBy String True

CreatedBy

LastUpdateDate Datetime True

LastUpdateDate

LastUpdatedBy String True

LastUpdatedBy

CreationSourceCode String True

CreationSourceCode

CreationSource String True

CreationSource

DataFoxScore Long False

Intelligence score for the supplier provided by Oracle DataFox. This attribute is not currently used.

DataFoxScoringCriteria String False

Contains details about Oracle DataFox scoring criteria.

Alias String False

Alternate internal name for the organization.

DUNSNumber String False

Data Universal Numbering System (DUNS) that identifies the supplier business.

OneTimeSupplierFlag Bool False

Contains one of the following values: true or false. If true, then the supplier is a one-time supplier. If false, then the supplier is not a one-time supplier. The default value is false.

RegistryId String True

RegistryId

CustomerNumber String False

Number that the supplier uses to identify the buying organization.

StandardIndustryClass String False

Classification number that the industry uses.

IndustryCategory String False

Industry category code for the supplier provided by Oracle DataFox intelligence. This attribute is not currently used.

IndustrySubcategory String False

Industry subcategory code for the supplier provided by Oracle DataFox intelligence. This attribute is not currently used.

NationalInsuranceNumber String False

Number that uniquely identifies a supplier who is a person. Some countries use this number to track work, taxation, and government benefits for each person.

NationalInsuranceNumberExistsFlag Bool False

Contains one of the following values: true or false. If true, then a value exists for the National Insurance number. If false, then a value does not exist for the National Insurance number. This attribute is not updatable. The default value is false.

CorporateWebsite String False

Website of the supplier.

YearEstablished Int False

Year when the supplier established themselves.

MissionStatement String False

Mission statement that the supplier uses.

YearIncorporated Int False

Year when the supplier incorporated themselves.

ChiefExecutiveTitle String False

Title of the chief executive officer in the supplier organization.

ChiefExecutiveName String False

Name of the chief executive officer in the supplier organization.

PrincipalTitle String False

Title of the principal officer in the supplier organization.

PrincipalName String False

Name of the principal officer in the supplier organization.

FiscalYearEndMonthCode String False

Abbreviation that identifies the month when the fiscal year ends in the supplier organization. A list of accepted values is defined in the lookup type MONTH. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.

FiscalYearEndMonth String False

Month when the fiscal year ends in the supplier organization.

CurrentFiscalYearPotentialRevenue Decimal False

Potential revenue for the supplier organization in the current fiscal year.

PreferredFunctionalCurrencyCode String False

Abbreviation that identifies the currency that the supplier uses.

PreferredFunctionalCurrency String False

Currency that the supplier uses.

TaxRegistrationCountryCode String False

Abbreviation that identifies the country where the supplier registered themselves for value added tax.

TaxRegistrationCountry String False

Country where the supplier registered themselves for value added tax.

TaxRegistrationNumber String False

Identification number for value added tax that some countries use, such as countries in the European Union.

TaxpayerCountryCode String False

Abbreviation that identifies the country where the supplier organization that is responsible for taxation is located.

TaxpayerCountry String False

Country where the supplier organization that is responsible for taxation resides.

TaxpayerId String False

Value that uniquely identifies the supplier for taxation purposes.

TaxpayerIdExistsFlag Bool False

Contains one of the following values: true or false. If true, then a value exists for the taxpayer identifier. If false, then value does not exist for the taxpayer identifier. This flag is not updatable. The default value is false.

FederalReportableFlag Bool False

Contains one of the following values: true or false. If true, then supplier is reportable to the Internal Revenue Service in the United States for the 1099 tax code. If false, then the supplier is not reportable. The default value is false.

FederalIncomeTaxTypeCode String False

Abbreviation that identifies the type of income tax for a reportable supplier according to the 1099 tax code in the United States.

FederalIncomeTaxType String False

Type of income tax for the supplier.

StateReportableFlag Bool False

Contains one of the following values: true or false. If true, then the supplier is reportable to a state taxing authority in the United States. If false, then the supplier is not reportable. The default value is false.

TaxReportingName String False

Name of tax reporting for a supplier who is reportable for income tax to the Internal Revenue Service in the United States.

NameControl String False

First four characters of the last name of a supplier who is reportable to the Internal Revenue Service in the United States for the 1099 tax code.

VerificationDate Date False

Date when the supplier most recently received the 1099 tax verification.

UseWithholdingTaxFlag Bool False

Contains one of the following values: true or false. If true, then the withholding tax is applicable to the supplier. If false, then withholding tax is not applicable. The default value is false.

WithholdingTaxGroupId Long False

Value that uniquely identifies the tax group in which supplier is classified for withholding the tax.

WithholdingTaxGroup String False

Withholding tax group that the application assigned to the supplier.

BusinessClassificationNotApplicableFlag Bool False

Contains one of the following values: true or false. If true, then no current business classification applies for the supplier. If false, then business classifications do apply. The default value is false.

DataFoxId String False

Value that uniquely identifies a company tracked by Oracle DataFox, which is linked to the supplier. This attribute is not currently used.

DataFoxCompanyName String False

Company name provided by Oracle DataFox intelligence. This attribute is not currently used.

DataFoxLegalName String False

Legal name of the company provided by Oracle DataFox intelligence. This attribute is not currently used.

DataFoxCompanyPrimaryURL String False

Primary URL of the company provided by Oracle DataFox intelligence. This attribute is not currently used.

DataFoxNAICSCode String False

NAICS code provided by Oracle DataFox intelligence. This attribute is not currently used.

DataFoxCountry String False

Country in which the company is present provided by Oracle DataFox intelligence. This attribute is not currently used.

DataFoxEIN String False

Employer identification number provided by Oracle DataFox intelligence. This attribute is not currently used.

DataFoxLastSyncDate Datetime False

Date when the supplier profile was most recently synchronized with Oracle DataFox intelligence. This attribute is not currently used.

OBNEnabledFlag Bool True

OBNEnabledFlag

OnOFACListFlag Bool False

Contains one of the following values: true or false. If true, then the supplier is on the US Government consolidated screening list, which includes, among others, those from the Office of Foreign Assets Control. If false, the supplier isn't on the list. This attribute is not currently used.

OFACSources String False

Contains details about specific lists in the US Government consolidated screening list that the supplier is currently on. The consolidated screening list includes, among others, those from the Office of Foreign Assets Control. This attribute is not currently used.

contacts String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

productsAndServices String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

DFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

globalDFF String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

businessClassifications String False

This column can only be used for Insert. For update and delete, use child table's operations, if applicable.

sites 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

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