Table of Contents

BYOBI Data Dictionary - Buyer & Supplier Status(Your supplier connections)

Abigail Briggs Updated by Abigail Briggs

Understanding Supplier Connections

This guide provides an overview of your organisation's connections with suppliers in the Purchasing Marketplace. It shows which suppliers are connected to your organisation and the purchasing preferences and statuses applied to different product areas.

Supplier connections can be configured at multiple levels, from the entire supplier catalogue down to individual product categories. Each row in the data represents a connection or preference at a particular level.

Understanding the different levels

The data can contain multiple rows for the same supplier, as preferences and statuses can be applied at different levels:

  • Supplier level: Where the Superdomain and Category are both shown as All Products, the status applies to the supplier's entire catalogue.
  • Superdomain level: Where a specific Superdomain is shown and the Category is All Products, the status applies to all products within that Superdomain.
  • Category level: Where both a Superdomain and a specific Category are shown, the status applies only to that particular category within the Superdomain.

Understanding supplier statuses

Each connection will have a status indicating the purchasing preference applied at that level:

  • Selected: The supplier or product area has been selected and is available for purchasing.
  • Deselected: The supplier or product area has been deselected.
  • Preferred: The supplier or product area has been marked as preferred.

Example

A supplier may have the following records:

Superdomain

Category

Status

Meaning

All Products

All Products

Selected

The supplier is selected across their entire catalogue.

IT Equipment

All Products

Deselected

The IT Equipment superdomain has been deselected for this supplier.

Stationery

Pens

Preferred

The Pens category within Stationery has been marked as preferred.

It is important to consider the Superdomain and Category fields together when interpreting a supplier's status. A status may apply to the entire supplier catalogue, a specific product area or an individual category, rather than necessarily applying to the supplier as a whole.

Field Name

Suggested Data Type

Description

__UPDATED_AT

Timestamp

Date and time the record was last updated.

BUYER_BUSINESS_UNIT_ID

Integer / ID

Unique identifier for the buyer's Business Unit.

BUYER_BUSINESS_UNIT_NAME

Text

Name of the buyer's Business Unit.

BUYER_COMPANY_ID

Integer / ID

Unique identifier for the buyer's company or organisation.

BUYER_COMPANY_NAME

Text

Name of the buyer's company or organisation.

BUYER_INTEGRATION_TYPE_CODE

Text

Code identifying the integration type configured for the buyer.

BUYER_INTEGRATION_TYPE_DESCRIPTION

Text

Description of the integration type configured for the buyer.

BUYER_INTEGRATION_TYPE_ID

Integer / ID

Unique identifier for the buyer's integration type.

BUYER_SUPPLIER_STATUS_ID

Integer / ID

Identifier for the status of the relationship between the buyer and supplier.

CATEGORY_ID

Integer / ID

Unique identifier for the category associated with the buyer-supplier relationship.

CATEGORY_NAME

Text

Name of the category associated with the buyer-supplier relationship.

COMPANY_OR_BUSINESS_UNIT

Text

Indicates whether the record relates to a company or a Business Unit.

CUSTOMER_REF

Text

Customer reference used to identify the buyer within the system or an external system.

ORGANISATION_REF

Text

Reference used to identify the organisation.

STATUS_DESCRIPTION

Text

Description of the current status of the buyer-supplier relationship.

SUPERDOMAIN_ID

Integer / ID

Unique identifier for the superdomain associated with the record.

SUPERDOMAIN_NAME

Text

Name of the superdomain associated with the record.

SUPPLIER_COMPANY_NAME

Text

Name of the supplier company.

SUPPLIER_INTEGRATION_TYPE_CODE

Text

Code identifying the integration type configured for the supplier.

SUPPLIER_INTEGRATION_TYPE_DESCRIPTION

Text

Description of the integration type configured for the supplier.

SUPPLIER_INTEGRATION_TYPE_ID

Integer / ID

Unique identifier for the supplier's integration type.

VAT_EXEMPT_TEXT

Text

Text describing the VAT exemption status or applicable VAT exemption information.

How did we do?

BYOBI Data Dictionary - Invoice

BYOBI Data Dictionary - Product & Price