Full expand

Full collapse

BusinessClassification

Jump to

• Fields
• Reference Objects
• Business Views
• Other Properties

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, Plural Label

Business Classification, Supplier Business Classification Details

Qualified Label, Qualified Plural Label

Supplier Business Classification, Supplier Business Classifications

Module

oraProcurementCoreSuppliers

Keys

• $primary: id

Expand all

Collapse all

Fields

* Field can't be null

• certificateNumber (string)

  Certificate that the certifying agency issues for the business classification.

  Label

  Certificate

• classStatus (string)*

  Status of the business classification for the supplier.

  Properties

  • not nullable
• confirmedOn (date)

  Date when the application confirmed the business classification for the supplier.

  Label

  Confirmed On

• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• deletedFlag (boolean)

  Determines whether supplier business classification is active or deleted. If value is Y, business classification has been deleted, else the business classification is active.

• expirationDate (date)

  Date when the certificate that the certifying agency issued for the business classification expires.

  Label

  Expiration Date

• id (int64)*

  Value that uniquely identifies the classification for the supplier business.

  Label

  Business Classification ID

  Properties

  • searchable
  • sortable
  • not nullable
• notes (string)

  Value used to capture any additional information regarding the classification.

  Label

  Notes

• otherCertifyingAgency (string)

  Agency that certifies the business classification for the supplier. This attribute is used when the Manage Certifying Agencies page in the Setup and Maintenance work area doesn't specify the agency you require.

  Label

  Other Certifying Agency

• startDate (date)

  Date when the certificate that the certifying agency issues for the business classification goes into effect.

  Label

  Start Date

• status (string)

  Status of the business classification for the supplier.

  Label

  Status

• subClassificationCode (string)

  Describes the subclassification when a minority owns a business classification.

  Label

  Subclassification

• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

  • sortable
  • not nullable
• timeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • searchable
  • sortable
  • not nullable
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • not nullable

Expand all

Collapse all

Reference Objects

• certifyingAgency (object)

  An institution that certifies the business classification of a supplier. For example, the U.S. Small Business Administration can issue certificates certifying a supplier's small business classification or woman-owned business classification.

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: CertifyingAgency

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  certifyingAgencyId	id

• classification (object)

  Cardinality	Target Object
  One to One	Module: oraCommonAppsInfraObjects Business Object: StandardLookupCode

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  classificationCode	lookupCode

• contact (object)

  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.

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: Contact

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  providedByContactId	id

• supplier (object)

  Cardinality	Target Object
  One to One	Module: oraProcurementCoreSuppliers Business Object: Supplier

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  supplierId	supplierId

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

    Value that uniquely identifies the classification for the supplier business.

    Label

    Business Classification ID

    Properties

    • searchable
    • sortable
    • not nullable
• businessClassificationsExtract**

  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 Classifications

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • certificateNumber (string)

    Certificate that the certifying agency issues for the business classification.

    Label

    Certificate

  • classStatus (string)

    Status of the business classification for the supplier.

    Properties

    • not nullable
  • confirmedOn (date)

    Date when the application confirmed the business classification for the supplier.

    Label

    Confirmed On

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • deletedFlag (boolean)

    Determines whether supplier business classification is active or deleted. If value is Y, business classification has been deleted, else the business classification is active.

  • expirationDate (date)

    Date when the certificate that the certifying agency issued for the business classification expires.

    Label

    Expiration Date

  • id (int64)

    Value that uniquely identifies the classification for the supplier business.

    Label

    Business Classification ID

    Properties

    • searchable
    • sortable
    • not nullable
  • notes (string)

    Value used to capture any additional information regarding the classification.

    Label

    Notes

  • otherCertifyingAgency (string)

    Agency that certifies the business classification for the supplier. This attribute is used when the Manage Certifying Agencies page in the Setup and Maintenance work area doesn't specify the agency you require.

    Label

    Other Certifying Agency

  • startDate (date)

    Date when the certificate that the certifying agency issues for the business classification goes into effect.

    Label

    Start Date

  • status (string)

    Status of the business classification for the supplier.

    Label

    Status

  • subClassificationCode (string)

    Describes the subclassification when a minority owns a business classification.

    Label

    Subclassification

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • certifyingAgency (CertifyingAgency)

    An institution that certifies the business classification of a supplier. For example, the U.S. Small Business Administration can issue certificates certifying a supplier's small business classification or woman-owned business classification.

    Business Object

    CertifyingAgency

    Expand all

    Collapse all

    Fields

    • certifyingAgency (string)

      Agency that certifies the business classification for the supplier.

      Label

      Certifying Agency

      Properties

      • not nullable
    • description (string)

      Description of the agency that certifies the business classification for the supplier.

      Label

      Description

    • endDate (date)

      Date when the certificate that the certifying agency issued for the supplier business classification expires.

      Label

      End Date

    • id (int64)

      Value that uniquely identifies the agency that certifies the business classification for the supplier.

      Label

      Certifying Agency ID

      Properties

      • searchable
      • sortable
      • not nullable

  • classification (StandardLookupCode)

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • contact (Contact)

    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.

    Business Object

    Contact

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the person profile.

      Label

      Person ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • supplier (Supplier)

    Business Object

    Supplier

    Expand all

    Collapse all

    Fields

    • 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

Other Properties

Property	Value
Application Package Name	ora_procurement_core_suppliers
Extensible	No

Back to Top