Delivery City

City of the delivery address

Delivery City Geo Location

Combination field that can be used on map visualizations. (Delivery City & Deliv­ery Country)

Delivery Country

Country of the delivery address

Delivery County

County of the delivery address

Delivery Geo Location

Combination field that can be used on map visualizations. (Delivery Street, Delivery City & Delivery Country)

Delivery Postal Code

Postal code of the delivery address

Delivery State

State of the delivery address

Delivery Street

Street of the delivery address

Created By

See Created By.

Created Via

See Created Via.

Creation Date

See Creation Date.

Currency ID

See Currency ID.

Customer Order No

Customer order number.

Invoice Status

Invoice Status

Possible values:

"Not yet to invoice", "To invoice", "In process", "Processed"

("Not yet to invoice", "To invoice", "In process", "Processed")

Invoicing Mode

The mode of invoicing.

Possible values: "Order customer", "Invoice customer from order customer", "Delivery address customer", "Free customer", "No invoice".

("Order customer", "Invoice customer from order customer", "Delivery address customer", "Free customer", "No invoice")

Order Date

The order date is the date the customer made the order. This column is linked to the dimension "Date".

Order ID

An ID to identify the order. An order can contain multiple sales orders.

Order Reference

A composed reference to identify an order.

Packing Slip ID

See Packing Slip ID.

Price Category

See Price Category.

Production Base

Possible values:

"Undecided", "Stock", "Production", "Commerce", "Unknown", "Call off con­tract"

Reporting Date

Depending on the state of the column Reporting Status, this value can vary.

In case the status is "Invoiced", the date used is the "Invoice Date".

In case the status is "Shipped", the date used is the "Real Shipment Date".

In case the status is "Picked" or "Ordered", the date used is the "Expected Ship­ment Date".

Reporting Status 

What was the status of the sales order when this record was created.

Possible values:

"Invoiced", "Shipped", "Picked" or "Ordered".

Sales Order ID

See Sales Order ID.

Sales Order Intake Type

This variable identifies the type of sales order.

List of possible values:

"Stock order", "RMA", "Sales order", "Invoice line item", "Call off contract"

"Stock order"

Sales Order Site

This field is only applicable for multi-site databases.

Transport Zone

Transport zone description

Transporter

Transporter

Transporter Keyword

Transporter Keyword

Invoice Price Line Description1

See Invoice Price Line Descrip-tion1.

Invoice Price Line Description2

See Invoice Price Line Descrip-tion2.

Invoice Price Line Keyword

See Invoice Price Line Keyword.

Sales Order Status1

These fields refer to the free sales order statuses. For invoice line items the value is always "Unknown" (Unknown).

---

Sales Order Status10

Shipment Date Confirmed

Confirmed shipment date

Shipment Date Expected

Shipment Date Expected

Shipment Date Original

Original expected shipment date

Shipment Date Real

Real shipment date

Shipment Status

The shipment status.

Possible values:

0: Not applicable

1: Not yet ready to ship

N: Ready to ship

Y: Shipped

Returned

"Ready to ship"