JDBC Driver for Oracle Fusion Cloud Financials

Build 24.0.9062

Suppliers

The Suppliers resource manages supplier details. A supplier is a person or company that the deploying organization uses to procure items or services. You must have the necessary roles and privileges to use this REST resource. For additional details, refer to the Job Roles and Privileges and Status Codes topics.

Columns

Name Type Description
SupplierId [KEY] Long SupplierId of Suppliers
SupplierPartyId Long Value that uniquely identifies the supplier party.
Supplier String Name of the supplier.
SupplierNumber String Number that identifies the supplier.
AlternateName String Alternate name of the supplier.
TaxOrganizationTypeCode String 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 Type of tax organization for the supplier.
SupplierTypeCode String 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 Type of supplier.
InactiveDate Date Date when the supplier is no longer active.
Status String Status of Suppliers
BusinessRelationshipCode String 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 Business relationship between the enterprise and the supplier.
ParentSupplierId Long Value that uniquely identifies the parent supplier.
ParentSupplier String Name of the parent supplier.
ParentSupplierNumber String ParentSupplierNumber of Suppliers
CreationDate Datetime CreationDate of Suppliers
CreatedBy String CreatedBy of Suppliers
LastUpdateDate Datetime LastUpdateDate of Suppliers
LastUpdatedBy String LastUpdatedBy of Suppliers
CreationSourceCode String CreationSourceCode of Suppliers
CreationSource String CreationSource of Suppliers
DataFoxScore Long Intelligence score for the supplier provided by Oracle DataFox. This attribute is not currently used.
DataFoxScoringCriteria String Contains details about Oracle DataFox scoring criteria.
Alias String Alternate internal name for the organization.
DUNSNumber String Data Universal Numbering System (DUNS) that identifies the supplier business.
OneTimeSupplierFlag Bool 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 RegistryId of Suppliers
CustomerNumber String Number that the supplier uses to identify the buying organization.
StandardIndustryClass String Classification number that the industry uses.
IndustryCategory String Industry category code for the supplier provided by Oracle DataFox intelligence. This attribute is not currently used.
IndustrySubcategory String Industry subcategory code for the supplier provided by Oracle DataFox intelligence. This attribute is not currently used.
NationalInsuranceNumber String 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 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 Website of the supplier.
YearEstablished Int Year when the supplier established themselves.
MissionStatement String Mission statement that the supplier uses.
YearIncorporated Int Year when the supplier incorporated themselves.
ChiefExecutiveTitle String Title of the chief executive officer in the supplier organization.
ChiefExecutiveName String Name of the chief executive officer in the supplier organization.
PrincipalTitle String Title of the principal officer in the supplier organization.
PrincipalName String Name of the principal officer in the supplier organization.
FiscalYearEndMonthCode String 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 Month when the fiscal year ends in the supplier organization.
CurrentFiscalYearPotentialRevenue Decimal Potential revenue for the supplier organization in the current fiscal year.
PreferredFunctionalCurrencyCode String Abbreviation that identifies the currency that the supplier uses.
PreferredFunctionalCurrency String Currency that the supplier uses.
TaxRegistrationCountryCode String Abbreviation that identifies the country where the supplier registered themselves for value added tax.
TaxRegistrationCountry String Country where the supplier registered themselves for value added tax.
TaxRegistrationNumber String Identification number for value added tax that some countries use, such as countries in the European Union.
TaxpayerCountryCode String Abbreviation that identifies the country where the supplier organization that is responsible for taxation is located.
TaxpayerCountry String Country where the supplier organization that is responsible for taxation resides.
TaxpayerId String Value that uniquely identifies the supplier for taxation purposes.
TaxpayerIdExistsFlag Bool 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 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 Abbreviation that identifies the type of income tax for a reportable supplier according to the 1099 tax code in the United States.
FederalIncomeTaxType String Type of income tax for the supplier.
StateReportableFlag Bool 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 Name of tax reporting for a supplier who is reportable for income tax to the Internal Revenue Service in the United States.
NameControl String 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 Date when the supplier most recently received the 1099 tax verification.
UseWithholdingTaxFlag Bool 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 Value that uniquely identifies the tax group in which supplier is classified for withholding the tax.
WithholdingTaxGroup String Withholding tax group that the application assigned to the supplier.
BusinessClassificationNotApplicableFlag Bool 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 Value that uniquely identifies a company tracked by Oracle DataFox, which is linked to the supplier. This attribute is not currently used.
DataFoxCompanyName String Company name provided by Oracle DataFox intelligence. This attribute is not currently used.
DataFoxLegalName String Legal name of the company provided by Oracle DataFox intelligence. This attribute is not currently used.
DataFoxCompanyPrimaryURL String Primary URL of the company provided by Oracle DataFox intelligence. This attribute is not currently used.
DataFoxNAICSCode String NAICS code provided by Oracle DataFox intelligence. This attribute is not currently used.
DataFoxCountry String Country in which the company is present provided by Oracle DataFox intelligence. This attribute is not currently used.
DataFoxEIN String Employer identification number provided by Oracle DataFox intelligence. This attribute is not currently used.
DataFoxLastSyncDate Datetime Date when the supplier profile was most recently synchronized with Oracle DataFox intelligence. This attribute is not currently used.
OBNEnabledFlag Bool OBNEnabledFlag of Suppliers
OnOFACListFlag Bool 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 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.
BilltoBuId Long BilltoBuId of Suppliers
BindPurchaseFlag String BindPurchaseFlag of Suppliers
BindReqBuId Long BindReqBuId of Suppliers
BindSourcingOnlyFlag String BindSourcingOnlyFlag of Suppliers
BindSysdate Date BindSysdate of Suppliers
Finder String Finder of Suppliers

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