Skip to main content
All CollectionsManage DataData ImporterData Importer Data Requirements
Data Importer Purchases Activities: What Data do I Need to Provide?

Data Importer Purchases Activities: What Data do I Need to Provide?

Browse through each activity to learn what data is required and how best to fill it

Updated over a week ago

Each activity and calculation method has a number of mandatory and optional fields which are needed to enrich and calculate your emissions data. Click on the relevant activity and calculation method combination to find out:

  • The complete list of fields available within each calculation method

  • What fields are mandatory or optional

  • How we use default values if the data is unavailable

This is an article on data requirements for Purchases activities. For other activities, visit:

Activity Area

Activity

Calculation Method

Purchases

Product & Packaging


Indirect Purchases


Capital Goods



Purchases Quantity-Based

Relevant activities:

  • Product & Packaging

  • Indirect Purchases

  • Capital Goods

Template fields:

Field

Data type

Mandatory or Optional

Default value

Business Unit Name

Picklist (BUs created in AQ app)

Mandatory

-

Business Unit Country

Picklist (Standard AQ values)

Optional

-

Facility Name

Picklist (Facilities created in AQ app)

Optional

-

Reference ID

Text

Optional

-

Purchase Date

Date

Mandatory

-

SKU Name

Text

Mandatory (must be mapped to data)

SKU Description

Text

Optional

-

SKU ID

Text

Optional

-

Purchase Category (Classification Level 1)

Text

Optional

-

Purchase Sub-Category (Classification Level 2)

Text

Optional

-

Purchase Group (Classification Level 3)

Text

Optional

-

Purchase Sub-Group (Classification Level 4)

Text

Optional

-

AQ Goods Service Category

Picklist (AQ Activity Labels)

Mandatory

Purchase Quantity

Number

Mandatory (must be mapped to data)

Purchase Unit

Picklist (Standard AQ values)

Mandatory

Estimated Quantity?

Yes or No

Mandatory

No

Spend Amount

Number

Optional

-

Spend Currency

Picklist (Standard AQ values)

Optional

-

Supplier Name

Text

Optional

-

Supplier Country

Text

Optional

-

Supplier Tax Identification Number

Text

Optional

-


Purchases Spend-Based

Relevant activities:

  • Product & Packaging

  • Indirect Purchases

  • Capital Goods

Template fields:

Field

Data type

Mandatory or Optional

Default value

Business Unit Name

Picklist (BUs created in AQ app)

Mandatory

-

Business Unit Country

Picklist (Standard AQ values)

Optional

-

Facility Name

Picklist (Facilities created in AQ app)

Optional

-

Reference ID

Text

Optional

-

Purchase Date

Date

Mandatory

-

SKU Name

Text

Mandatory

SKU Description

Text

Optional

-

SKU ID

Text

Optional

-

Purchase Category (Classification Level 1)

Text

Optional

-

Purchase Sub-Category (Classification Level 2)

Text

Optional

-

Purchase Group (Classification Level 3)

Text

Optional

-

Purchase Sub-Group (Classification Level 4)

Text

Optional

-

Spend Amount

Number

Mandatory (must be mapped to data)

Spend Currency

Picklist (Standard AQ values)

Mandatory

Estimated Quantity?

Yes or No

Mandatory

No

Supplier Name

Text

Optional

-

Supplier Country

Text

Optional

-

Supplier Tax Identification Number

Text

Optional

-

AQ Goods Service Type

Picklist (AQ Activity Labels)

Mandatory

-

Did this answer your question?