BYOBI Data Dictionary - Purchase Orders & Order Lines

Abigail Briggs Updated by Abigail Briggs

This guides aims to provide an understanding of the Purchase Orders data set available via the Purchasing BYOBI solution. This solution is agnostic of any third-party reporting tool.

The Purchase orders data is made up of two data tables

  • Purchase Orders: this table includes all of your organisations Purchase Orders. The data is header level, it does not include line level
  • Order Items: this table includes the line level details of every Purchase order

Purchase Orders

Every purchase order raised in Purchase is stored in this table. The order stored in the table is added at the time of order creation.

Field Name

Data Type

Description

PURCHASE_ORDER_ID

NUMBER 

Primary key of the Purchase Orders table

PURCHASE_ORDER_DATE

TIMESTAMP 

Purchase Order Date

PURCHASE_ORDER_NUMBER

VARCHAR 

Customer Purchase Order referene number

SENT_TO_SUPPLIER_DATE

TIMESTAMP 

Date purchase order is issued to supplier

LAST_UPDATED_TIME

TIMESTAMP 

SALES_ORDER_REFERENCE_ID

NUMBER 

SUPPLIER_ID

NUMBER 

The unique ID of the Supplier (Generated by Purchasing)

REQUESTOR ID

NUMBER 

The unique ID of the user

BILLING_ADDRESS_ID

NUMBER 

Unique identifier for the billing address associated with the order. This is a foreign key that links to the primary key in the Billing Address table, where full address details are stored.

SHIPPING_ADDRESS_ID

NUMBER

Unique identifier for the shipping address associated with the order. This is a foreign key that links to the primary key in the Shipping Address table, where full address details are stored.

BUYER_COMPANY_ID

NUMBER

Unique identifier for the buying organisation associated with the order. This field serves as a primary reference key for the organisation in the system. Although end users will typically only see data for their own organisation, this ID is used to link orders to the correct buyer in the database.

OWNER_USER_ID

 

 

LAST_UPDATED_BY

 

 

REQUESTOR NAME

VARCHAR 

Name of the user who requested the order

SUPPLIER_NAME

VARCHAR 

Purchasings name of the supplier. Stored at the time of order placed

BUYER_COMPANY_NAME

VARCHAR 

Company or Business Unit of where the requestor was assigned to at the time of placing the order

ORDER_STATUS

VARCHAR 

Status of the order

INVOICE_STATUS

VARCHAR 

TBC

IN_PROGRESS_FLAG

VARCHAR 

TBC

REQUESTOR_PHONE_NUMBER

VARCHAR 

Phone number on the Purchase Order

REQUESTOR_EMAIL

VARCHAR 

Email 

ORDER_ATTENTION_NAME

VARCHAR 

Attention name on the Purchase Order 

BUYER_HEADER_TEXT

VARCHAR 

This text is configured in Purchasing and applied to every order 

BUYER_FOOTER_TEXT

VARCHAR 

This text is configured in Purchasing and applied to every order 

BUYER_FINAL_TEXT

VARCHAR 

This text is configured in Purchasing and applied to every order 

BUYER_VAT_NUMBER

VARCHAR 

The VAT number is configured in Purchasing and applied to every order 

SUPPLIER_EXTERNAL_ID

VARCHAR 

Buyers Finance/ERP ID for the Supplier

SUPPLIER_COMMENTS

VARCHAR 

Comments added by the supplier

UPDATED_AT

TIMESTAMP 

Purchase Order Items

Every purchase order raised in Purchase is stored in this table with the associated line items that are added to the order. The order lines stored in the table is added at the time of order creation. For example the part number, unit price etc are added in this table. If you did want to view live catalogue data, you can link us the part number with the items table in BYOBI. (Items table is a future data set).

Field name

Data Type

Description

ORDER_ITEM_ID

VARCHAR

Primary key for the order line 

PURCHASE_ORDER_ID

VARCHAR

This field is a foreign key that links each order item to its parent purchase order in the Purchase Orders table (Purchase Order ID).

SALES_ORDER_REFERENCE_ID

VARCHAR

PURCHASE_ORDER_NUMBER

VARCHAR

Customer Purchase order reference number

BUYER_COMPANY_ID

VARCHAR

Unique ID of the Buyer organisation in Purchasing

PURCHASE_ORDER_DATE

TIMESTAMP

Purchase order date

SUPPLIER_ID

VARCHAR

Purchasing Supplier ID

SUPPLIER_NAME

VARCHAR

Purchasings name of the supplier. Stored at the time of order placed

REQUESTOR_NAME

VARCHAR

Purchasing unique ID for each user

PART_NUMBER

VARCHAR

Part number on the order (Suppliers part number or added by the requestor for free text orders)

MANUFACTURER_PART_NUMBER

VARCHAR

Suppliers manufacturer part number

ORDER_LINE_DESCRIPTION

VARCHAR

Description

VENDOR_PART_NUMBER

VARCHAR

Suppliers manufacturer part number

MANUFACTURER_NAME

VARCHAR

Suppliers manufacturer name

ITEM_CATEGORY_NAME

VARCHAR

Purchasing Category Name

ITEM_SUPERDOMAIN_NAME

VARCHAR

Purchasing superdomain name

ITEM_UNSPSC_CODE

VARCHAR

UNSPSC code

ORDERED_QUANTITY

VARCHAR

DELIVERED_QUANTITY

VARCHAR

Quantity delivered (will only be applicable where the supplier has marked the order as shipped in the supplier portal)

PURCHASE_PRICE

VARCHAR

The price on the order to the supplier

SELLING_PRICE

VARCHAR

The selling price of the item at the time of purchase

LIST_PRICE

VARCHAR

The list price of the item at the time of the purchase 

SALES_TAX_AMOUNTS

VARCHAR

Tax amount

SALES_TAX_PERCENTAGES

VARCHAR

Tax percentage

PRICE_UNIT

VARCHAR

Unit

UNIT_OF_MEASURE

VARCHAR

Unit of measure (EA, Pack etc)

ORDER_STATUS

VARCHAR

Status of order line

TAX_CODE

VARCHAR

CREATED_BY

VARCHAR

Name of requestor

REQUESTOR_ID

VARCHAR

Unique ID of the requestor. Foreign key to the users data table

SELLER_USER_ID

VARCHAR

CREATED_BY_USER_ID

VARCHAR

USER_CURRENCY_ID

VARCHAR

PRICE_CURRENCY_ID

VARCHAR

EXPECTED_DELIVERY_DATE

VARCHAR

ORDER_COMMENTS

VARCHAR

Header level comments added by the requestor on the order

BUYER_ORDER_LINE_COMMENTS

VARCHAR

Line level comments added by the requestor on the order

SUPPLIER_COMMENTS

VARCHAR

Comments added by the supplier

ATTENTION_TO

VARCHAR

RFQ_ITEM_ID

VARCHAR

CATALOGUE_ITEM_ID

VARCHAR

Unique key for the suppliers item in the catalogue. Foreign key to the Catalogue Items data table

OLIGO_ITEM_ID

VARCHAR

Unique key for the Oligo created by the user. Foreign key to the Oligos data table

EXTERNAL_LINE_NUMBER

VARCHAR

Line number provided by customer finance system for Purchase order 

ITEM_CATEGORY

VARCHAR

Catalogue or Off Catalogue

LINE_TYPE_ID

VARCHAR

LINE_TYPE_DESCRIPTION

VARCHAR

Line type description (Catalogue, Free Format, Punchout, Oligo or eServices)

LINE_TAX_ID

VARCHAR

LINE_TOTAL_AMOUNT

VARCHAR

Total amount on line

SUPPLIER_FILE_PATH

VARCHAR

File path of attachment added by a supplier

IS_RFQ_MUST_ORDER_ALL

VARCHAR

IS_PRICE_CHANGED

VARCHAR

ERROR_REFERENCE_ID

VARCHAR

BASKET_ID

VARCHAR

UPDATED_AT

TIMESTAMP

How did we do?

Contact