Supplier
A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.
Label, Plural Label
Supplier, Suppliers
Qualified Label, Qualified Plural Label
Supplier, Suppliers
Module
oraProcurementCoreSuppliers
Keys
-
$primary: id
-
supplierAltKey: supplierId (default)
Base Business Object
-
Module: oraCxSalesCommonParty
-
Business Object: Organization
Fields
* Field can't be null- alias (object)*
A supplier alias represents the internal name for an organization. For example, the internal name for a supplier Seven Corporation can be Seven Co. or the internal name for a supplier Tall Pharmaceuticals can be Tall Pharma.
Label
Alias
Cardinality Target Object One to One - Module: oraProcurementCoreSuppliers
- Business Object: Alias
Additional Mapping Details
Field in Current Object Field in Target Object id partyId - alternateName (object)*
A supplier alternate name represents the name that a supplier can be alternatively known. For example, a supplier Big Computers can be alternatively known as Big Com, or a supplier Vision Corporation is alternatively known as VC Corporation.
Label
Alternate Name
Cardinality Target Object One to One - Module: oraProcurementCoreSuppliers
- Business Object: AlternateName
Additional Mapping Details
Field in Current Object Field in Target Object id partyId - bcNotApplicableFlag (boolean)
- businessRelationshipCode (enumeration: BusinessRelationship)
Business relationship between the enterprise and the supplier.
Label
Business Relationship
Type
-
Module: oraProcurementCoreSuppliers
-
Enumeration Type: BusinessRelationship
Valid Values
- NONE
- PROSPECTIVE
- SPEND_AUTHORIZED
-
- corporateWebsite (string)
Corporate website of the supplier.
Label
Corporate Web Site
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- not nullable
- creationSource (enumeration: CreationSource)
Source that the application uses to create the supplier. A list of accepted values is defined in the lookup type POZ_CREATION_SOURCE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
Label
Creation Source
Type
-
Module: oraProcurementCoreSuppliers
-
Enumeration Type: CreationSource
Valid Values
- IMPORT
- MANUAL
- REGISTRATION
- REST_SERVICE
- WEB_SERVICE
-
- customerNumber (string)
Number that the supplier uses to identify the buying organization.
Label
Customer Number
- dunsNumber (string)
Data Universal Numbering System (D-U-N-S) that identifies the supplier business.
Label
D-U-N-S Number
Properties
- inherited
- creatable
- searchable
- sortable
- overridable
- updatable
- endDateActive (date)
Date on which the supplier became inactive.
Label
Inactive Date
- federalReportableFlag (boolean)
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 isn't reportable. The default value is false.
Label
Federal reportable
- id (int64)*
The unique identifier of the organization profile.
Label
Organization ID
Properties
- inherited
- searchable
- sortable
- not nullable
- incomeTaxIdFlag (boolean)
Contains one of the following values: true or false. If true, then a value exists for the taxpayer identifier. If false, then value doesn't exist for the taxpayer identifier. This value isn't updatable. The default value is false.
Label
Taxpayer ID Exists
- name (string)*
The name of the organization.
Label
Name
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- overridable
- updatable
- nameControl (string)
First four characters of the last name of a supplier who's reportable to the Internal Revenue Service in the United States for the 1099 tax code.
Label
Name Control
- nationalInsuranceNumberFlag (boolean)
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 doesn't exist for the National Insurance number. This value isn't updatable. The default value is false.
Label
National Insurance Number Exists
- oneTimeFlag (boolean)
Classification number that the industry uses.
Label
One-time supplier
- registryId (string)*
The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.
Label
Registry ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- overridable
- updatable
- sites (object-collection)*
A supplier site contains the details about the terms, controls, and policies that govern how procure to pay transactions are executed between the buying organization and the supplier. You can have multiple sites for a supplier. For example, a purchasing site or a pay site.
Label
Sites
Cardinality Target Object One to many - Module: oraProcurementCoreSuppliers
- Business Object: SupplierSite
Additional Mapping Details
Field in Current Object Field in Target Object supplierId supplierId - spendAuthorizationReviewStatus (string)
Spend authorization review status for the supplier.
Label
Spend Authorization Review Status
- standardIndustryClass (string)
Contains one of the following values: true or false. If true, then the supplier is a one-time supplier. If false, then the supplier isn't a one-time supplier. The default value is false.
Label
SIC
- startDateActive (date)
Date on which the supplier became active
Label
Start Date
- stateReportableFlag (boolean)
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 isn't reportable. The default value is false.
Label
State reportable
- supplierAddresses (object-collection)*
A supplier address represents the location information of a supplier. You can have multiple addresses for a supplier, each with different address purposes. For example, a supplier address with purposes for ordering and remit-to, or a supplier address with purpose a for bidding or RFQ.
Label
Supplier Addresses
Cardinality Target Object One to many - Module: oraProcurementCoreSuppliers
- Business Object: Address
Additional Mapping Details
Field in Current Object Field in Target Object id partyId - supplierId (int64)*
Value that uniquely identifies the supplier.
Label
Supplier ID
Properties
- searchable
- sortable
- not nullable
- supplierNumber (string)*
Number that identifies the supplier.
Label
Supplier Number
Properties
- creatable
- searchable
- sortable
- not nullable
- supplierStatus (enumeration: Status)*
Status of the supplier. Values are ACTIVE or INACTIVE.
Label
Status
Type
-
Module: oraProcurementCoreSuppliers
-
Enumeration Type: Status
Properties
- not nullable
Valid Values
- ACTIVE
- ALL
- INACTIVE
-
- taxOrganizationType (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.
Label
Tax Organization Type
- taxProfile (object)*
A tax profile represents the body of information that relates to a party's transaction tax activities. A tax profile can include main and default information, tax registration, tax exemptions, party fiscal classifications, tax reporting codes, configuration options, and service subscriptions. Third-party tax profiles are for parties with the usage of customer, supplier, and their addresses or sites. For example, a tax profile for supplier Seven Corporation or a tax profile for address San Francisco Office in Seven Corporation.
Label
Tax Profile
Cardinality Target Object One to One - Module: oraProcurementCoreSuppliers
- Business Object: SupplierTaxProfile
Additional Mapping Details
- taxReportingName (string)
Name of tax reporting for a supplier who's reportable for income tax to the Internal Revenue Service in the United States.
Label
Tax Reporting Name
- taxVerificationDate (date)
Date when the supplier most recently received the 1099 tax verification.
Label
Verification Date
- timeCreated (date-time)*
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)*
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- not nullable
- updatedBy (string)*
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- useWithholdingTaxFlag (boolean)
Indicator of whether Allow Withholding Tax is enabled.
Label
Use withholding tax
Reference Objects
- businessClassifications (object-collection)
Supplier certifications that are important to the procurement organization, such as those for supplier diversity programs, are tracked. Some examples of business classifications include Small Business and Veteran-Owned.
Label
Supplier Business Classification Details
Cardinality Target Object One to many - Module: oraProcurementCoreSuppliers
- Business Object: BusinessClassification
Additional Mapping Details
Field in Current Object Field in Target Object supplierId supplierId - contacts (object-collection)
A supplier contact represents a person or representative from the supplier that you can interact or communicate with about the company. For example, Joe Doe and Jane Doe.
Label
Contacts
Cardinality Target Object One to many - Module: oraProcurementCoreSuppliers
- Business Object: Contact
Additional Mapping Details
Field in Current Object Field in Target Object id objectId - federalIncomeTaxType (object)
The 1099 income tax type represents a certain type of nonemployment income tax assigned to a supplier.
Label
Federal Income Tax Type
Cardinality Target Object One to One - Module: oraErpCorePayablesSetup
- Business Object: Payables1099IncomeTaxType
Additional Mapping Details
Field in Current Object Field in Target Object federalIncomeTaxTypeCode incomeTaxType - parentSupplier (object)
A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.
Label
Parent Supplier
Cardinality Target Object One to One - Module: oraProcurementCoreSuppliers
- Business Object: Supplier
Additional Mapping Details
Field in Current Object Field in Target Object parentVendorId supplierId - supplierType (object)
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.
Label
Supplier Type
Cardinality Target Object One to One - Module: oraCommonAppsInfraObjects
- Business Object: StandardLookupCode
Additional Mapping Details
Field in Current Object Field in Target Object supplierTypeCode lookupCode - taxpayerCountry (object)
Country where the supplier organization that's responsible for taxation resides.
Label
Taxpayer Country
Cardinality Target Object One to One - Module: oraCommonAppsInfraObjects
- Business Object: Territory
Additional Mapping Details
Field in Current Object Field in Target Object taxpayerCountryCode territoryCode - withholdingTaxGroup (object)
Shows the tax classification codes which are used to classify taxes into groups for reporting and processing purposes.
Label
Withholding Tax Group
Cardinality Target Object One to One - Module: oraErpCoreTaxSetup
- Business Object: WithholdingTaxClassification
Additional Mapping Details
Field in Current Object Field in Target Object withholdingTaxGroupId taxRateCodeId
REST Resources
| Version | REST Resource Name |
|---|---|
| v1 |
paymentAgentSuppliers |
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- businessRelationshipCode (enumeration: BusinessRelationship)
Business relationship between the enterprise and the supplier.
Label
Business Relationship
Type
-
Module: oraProcurementCoreSuppliers
-
Enumeration Type: BusinessRelationship
Valid Values
- NONE
- PROSPECTIVE
- SPEND_AUTHORIZED
-
- dunsNumber (string)
Data Universal Numbering System (D-U-N-S) that identifies the supplier business.
Label
D-U-N-S Number
Properties
- inherited
- creatable
- searchable
- sortable
- overridable
- updatable
- name (string)
The name of the organization.
Label
Name
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- overridable
- updatable
- registryId (string)
The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.
Label
Registry ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- overridable
- updatable
- supplierId (int64)
Value that uniquely identifies the supplier.
Label
Supplier ID
Properties
- searchable
- sortable
- not nullable
- supplierNumber (string)
Number that identifies the supplier.
Label
Supplier Number
Properties
- creatable
- searchable
- sortable
- not nullable
- supplierStatus (enumeration: Status)
Status of the supplier. Values are ACTIVE or INACTIVE.
Label
Status
Type
-
Module: oraProcurementCoreSuppliers
-
Enumeration Type: Status
Properties
- not nullable
Valid Values
- ACTIVE
- ALL
- INACTIVE
-
- businessRelationshipCode (enumeration: BusinessRelationship)
- supplierListReplica
Data Source
Read-optimized data store
Fields
- businessRelationshipCode (enumeration: BusinessRelationship)
Business relationship between the enterprise and the supplier.
Label
Business Relationship
Type
-
Module: oraProcurementCoreSuppliers
-
Enumeration Type: BusinessRelationship
Valid Values
- NONE
- PROSPECTIVE
- SPEND_AUTHORIZED
-
- id (int64)
The unique identifier of the organization profile.
Label
Organization ID
Properties
- inherited
- searchable
- sortable
- not nullable
- name (string)
The name of the organization.
Label
Name
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- overridable
- updatable
- registryId (string)
The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.
Label
Registry ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- overridable
- updatable
- supplierId (int64)
Value that uniquely identifies the supplier.
Label
Supplier ID
Properties
- searchable
- sortable
- not nullable
- supplierNumber (string)
Number that identifies the supplier.
Label
Supplier Number
Properties
- creatable
- searchable
- sortable
- not nullable
- taxOrganizationType (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.
Label
Tax Organization Type
- businessRelationshipCode (enumeration: BusinessRelationship)
- suppliersExtract**
A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.
Label, Plural Label
Suppliers, Suppliers
Data Source
Read-optimized data store
Fields
- bcNotApplicableFlag (boolean)
- businessRelationshipCode (enumeration: BusinessRelationship)
Business relationship between the enterprise and the supplier.
Label
Business Relationship
Type
-
Module: oraProcurementCoreSuppliers
-
Enumeration Type: BusinessRelationship
Valid Values
- NONE
- PROSPECTIVE
- SPEND_AUTHORIZED
-
- corporateWebsite (string)
Corporate website of the supplier.
Label
Corporate Web Site
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- creationSource (enumeration: CreationSource)
Source that the application uses to create the supplier. A list of accepted values is defined in the lookup type POZ_CREATION_SOURCE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
Label
Creation Source
Type
-
Module: oraProcurementCoreSuppliers
-
Enumeration Type: CreationSource
Valid Values
- IMPORT
- MANUAL
- REGISTRATION
- REST_SERVICE
- WEB_SERVICE
-
- customerNumber (string)
Number that the supplier uses to identify the buying organization.
Label
Customer Number
- dunsNumber (string)
Data Universal Numbering System (D-U-N-S) that identifies the supplier business.
Label
D-U-N-S Number
Properties
- inherited
- creatable
- searchable
- sortable
- overridable
- updatable
- endDateActive (date)
Date on which the supplier became inactive.
Label
Inactive Date
- federalReportableFlag (boolean)
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 isn't reportable. The default value is false.
Label
Federal reportable
- id (int64)
The unique identifier of the organization profile.
Label
Organization ID
Properties
- inherited
- searchable
- sortable
- not nullable
- incomeTaxIdFlag (boolean)
Contains one of the following values: true or false. If true, then a value exists for the taxpayer identifier. If false, then value doesn't exist for the taxpayer identifier. This value isn't updatable. The default value is false.
Label
Taxpayer ID Exists
- name (string)
The name of the organization.
Label
Name
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- overridable
- updatable
- nameControl (string)
First four characters of the last name of a supplier who's reportable to the Internal Revenue Service in the United States for the 1099 tax code.
Label
Name Control
- nationalInsuranceNumberFlag (boolean)
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 doesn't exist for the National Insurance number. This value isn't updatable. The default value is false.
Label
National Insurance Number Exists
- oneTimeFlag (boolean)
Classification number that the industry uses.
Label
One-time supplier
- registryId (string)
The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.
Label
Registry ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- overridable
- updatable
- spendAuthorizationReviewStatus (string)
Spend authorization review status for the supplier.
Label
Spend Authorization Review Status
- standardIndustryClass (string)
Contains one of the following values: true or false. If true, then the supplier is a one-time supplier. If false, then the supplier isn't a one-time supplier. The default value is false.
Label
SIC
- startDateActive (date)
Date on which the supplier became active
Label
Start Date
- stateReportableFlag (boolean)
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 isn't reportable. The default value is false.
Label
State reportable
- supplierId (int64)
Value that uniquely identifies the supplier.
Label
Supplier ID
Properties
- searchable
- sortable
- not nullable
- supplierNumber (string)
Number that identifies the supplier.
Label
Supplier Number
Properties
- creatable
- searchable
- sortable
- not nullable
- taxOrganizationType (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.
Label
Tax Organization Type
- taxReportingName (string)
Name of tax reporting for a supplier who's reportable for income tax to the Internal Revenue Service in the United States.
Label
Tax Reporting Name
- taxVerificationDate (date)
Date when the supplier most recently received the 1099 tax verification.
Label
Verification Date
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- useWithholdingTaxFlag (boolean)
Indicator of whether Allow Withholding Tax is enabled.
Label
Use withholding tax
Reference Object
- alias (Alias)
A supplier alias represents the internal name for an organization. For example, the internal name for a supplier Seven Corporation can be Seven Co. or the internal name for a supplier Tall Pharmaceuticals can be Tall Pharma.
Business Object
AliasFields
- id (int64)
The unique identifier of the name.
Label
Additional Name ID
Properties
- inherited
- searchable
- sortable
- not nullable
- name (string)
Alternate internal name for the organization.
Label
Alias
Properties
- inherited
- creatable
- searchable
- overridable
- updatable
- id (int64)
- alternateName (AlternateName)
A supplier alternate name represents the name that a supplier can be alternatively known. For example, a supplier Big Computers can be alternatively known as Big Com, or a supplier Vision Corporation is alternatively known as VC Corporation.
Business Object
AlternateNameFields
- id (int64)
The unique identifier of the name.
Label
Additional Name ID
Properties
- inherited
- searchable
- sortable
- not nullable
- name (string)
Alternate name of the supplier.
Label
Alternate Name
Properties
- inherited
- creatable
- searchable
- overridable
- updatable
- id (int64)
- federalIncomeTaxType (Payables1099IncomeTaxType)
The 1099 income tax type represents a certain type of nonemployment income tax assigned to a supplier.
Business Object
Payables1099IncomeTaxTypeFields
- incomeTaxType (string)
The type of income tax.
Label
Income Tax Type
Properties
- searchable
- sortable
- not nullable
- incomeTaxType (string)
- parentSupplier (Supplier)
A supplier is a person or company that the deploying organization uses to procure items or services. For example, an office supplies provider or a consulting service provider.
Business Object
SupplierFields
- id (int64)
The unique identifier of the organization profile.
Label
Organization ID
Properties
- inherited
- searchable
- sortable
- not nullable
- supplierId (int64)
Value that uniquely identifies the supplier.
Label
Supplier ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- supplierType (StandardLookupCode)
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.
Business Object
StandardLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- taxProfile (SupplierTaxProfile)
A tax profile represents the body of information that relates to a party's transaction tax activities. A tax profile can include main and default information, tax registration, tax exemptions, party fiscal classifications, tax reporting codes, configuration options, and service subscriptions. Third-party tax profiles are for parties with the usage of customer, supplier, and their addresses or sites. For example, a tax profile for supplier Seven Corporation or a tax profile for address San Francisco Office in Seven Corporation.
Business Object
SupplierTaxProfileFields
- id (int64)
The unique identifier of the party of the tax profile.
Label
Party Tax Profile ID
Properties
- inherited
- searchable
- sortable
- not nullable
- id (int64)
- taxpayerCountry (Territory)
Country where the supplier organization that's responsible for taxation resides.
Business Object
TerritoryFields
- territoryCode (string)
The unique code of the territory.
Label
Territory Code
Properties
- searchable
- sortable
- not nullable
- territoryCode (string)
- withholdingTaxGroup (WithholdingTaxClassification)
Shows the tax classification codes which are used to classify taxes into groups for reporting and processing purposes.
Business Object
WithholdingTaxClassificationFields
- taxRateCodeId (int64)
The unique identifier of the tax rate code.
Label
Tax Rate Code ID
Properties
- searchable
- sortable
- not nullable
- taxRateCodeId (int64)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_procurement_core_suppliers |
| Extensible | Yes |