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 |