Products

Name

Description

Data Type

Product id

The internal id of the product. 

String

Item number

The item number of the product as shown in Qarma.

String

Temporary item number

A temporary item number used while the final item number is not yet known. Empty when the product has a final item number.

String

Name

The product name as shown in Qarma.

String

Status

The status of the product, for example Active or Draft.

String

Image url

Link to the product image (if any).

​String

Net weight

The net weight of the product.

Float

Product responsibles

The users and groups responsible for the product

JSON

Material list responsibles

Who is responsible for filling in the material list of the product. supplier is true if the supplier is responsible.

JSON

Tags

The tags applied to the product, separated by commas. Each tag is shown with its full hierarchy, for example HS Code > 44 > 4401 or EUDR Activity > Import.

String

Attachment urls

Links to files attached to the product (if any).

List of links































Order lines

Name

Description

Data Type

Order line id

The unique id of the order line.

String

Order id

The internal id of the order.

String

Order number

The order number as shown in Qarma.

String

Documents not submitted

Number of required documents on the order line that have not been submitted yet.

Integer

Documents rejected

Number of required documents that have been rejected.

Integer

Documents pending approval

Number of required documents that are submitted and waiting for approval.

Integer

Documents approved

Number of required documents that have been approved.

Integer

Documents ignored

Number of required documents that have been marked as ignored.

Integer

Documents total

Total number of required documents on the order line.

Integer

Deadline date

The deadline for submitting the documentation for the order line.

Date

Supplier id

The internal id of the supplier.

String

Supplier number

The supplier number as shown in Qarma.

String

Supplier name

The supplier name as shown in Qarma.

String

Production unit id

The internal id of the production unit.

String

Production unit number

The production unit number as shown in Qarma.

String

Production unit name

The production unit name as shown in Qarma.

String

Quantity

The ordered quantity of the product.

Integer

Product id

The internal id of the product.

String

Country of entry

EUDR: the country where the goods enter the EU market, as a two-letter ISO country code (e.g. DK).

String

Country of activity

EUDR: the country where the activity (import or trade) takes place, as a two-letter ISO country code.

String

Operator name

EUDR: the name of the operator submitting the due diligence statement (DDS).

String

DDS reference number

EUDR: the reference number returned by the EU Information System (TRACES) after the DDS is submitted.

String

DDS verification number

EUDR: the verification number returned by the EU Information System together with the reference number.

String

DDS submitted by

EUDR: the email of the user who submitted the DDS.

String

DDS submission date

EUDR: the date and time the DDS was submitted.

DateTime

DDS submission status

EUDR: the status of the DDS submission, for example available or error_on_submission.

String

Material supply chains

The material supply chains used for the product on this order line.

JSON



Due dates

Name

Description

Data Type

Due date id

The unique id of the due date.

String

Product id

The internal id of the product.

String

Documents not submitted

Number of required documents that have not been submitted yet.

Integer

Documents rejected

Number of required documents that have been rejected.

Integer

Documents pending approval

Number of required documents that are submitted and waiting for approval.

Integer

Documents approved

Number of required documents that have been approved.

Integer

Documents ignored

Number of required documents that have been marked as ignored.

Integer

Documents total

Total number of required documents for the due date.

Integer

Due date

The date by which the documentation must be submitted.

Date

Supplier id

The internal id of the supplier.

String

Supplier number

The supplier number as shown in Qarma.

String

Supplier name

The supplier name as shown in Qarma.

String

Production unit id

The internal id of the production unit.

String

Production unit number

The production unit number as shown in Qarma.

String

Production unit name

The production unit name as shown in Qarma.

String

Material supply 

chains

The material supply chains used for the product. Maps to Material Supply Chain id in the Material supply chains table

JSON



Required documents

Name

Description

Data Type

Order line id

The id of the order line the document is requested for.

String

Due date id

The id of the due date the document is requested for.

String

Scope

What the document covers: Product, Supplier or Material.

String

Status

The status of the document, for example Not submitted, Submitted, Approved or Rejected.

String

Document name

The name of the requested document.

String

Document description

The description of the requested document.

String

Product requirement name

The name of the product requirement that triggered the document.

String

Product requirement description

The description of the product requirement.

String

Material requirement name

For documents with scope Material: the name of the material requirement.

String

Material requirement description

For documents with scope Material: the description of the material requirement.

String

Material Supply Chain id

For documents with scope Material: the id of the material supply chain.

String

Document type

The type of document: File or Plot of land.

String

Harvest start date

For Plot of land documents: the start of the harvest period.

Date

Harvest end date

For Plot of land documents: the end of the harvest period.

Date

Risk assessment results

For Plot of land documents: the result of the automatic deforestation risk check of the plots

JSON

DDS references

EUDR: references to existing due diligence statements (DDS) provided instead of documents.

JSON

Files

The files uploaded for the document.

JSON

Expiration rule

How long the document is valid.

String

Start date

The date the document is valid from.

Date

End date

The date the document expires. Empty if the document does not expire.

Date

Upload responsibles

Who is responsible for uploading the document.

JSON

Approval responsibles

Who is responsible for approving the document.

JSON

Rejection reason

The reason given when the document was rejected.

String

Uploaded date

The date and time the document was uploaded.

DateTime

Uploaded by

The email of the user who uploaded the document.

String

Approved or rejected date

The date and time the document was approved or rejected.

DateTime

Approved or rejected by

The email of the user who approved or rejected the document.

String



Material supply chains


Name

Description

Data Type

Material Supply Chain id

The unique id of the material supply chain.

String

Material name

The name of the material.

String

Material supply chain name

The name of the supply chain, typically linked to the supplier or source.

String

Supplier id

The internal id of the supplier that owns the supply chain.

String

Supplier number

The supplier number as shown in Qarma.

String

Supplier name

The supplier name as shown in Qarma.

String

Production unit id

The internal id of the production unit.

String

Production unit number

The production unit number as shown in Qarma.

String

Production unit name

The production unit name as shown in Qarma.

String

Tags

The tags applied to the supply chain, separated by commas and shown with their full hierarchy, for example FSC Certified > FSC certified, Material origin > Brazil (BR) or Material type > Wood > ….

String

Creation date

The date the material supply chain was created.

Date


If this sounds interesting, don’t hesitate to reach out for a free demo of what we can offer you! If you are already a customer and want to learn more about this, reach out to support@qarmainspect.com or your contact person.