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 |