HansaWorld core measures and dimensions

Time

Transactional Record date.

Week Day

Days of the week.

Hour

Hour-of-day from Transactional Record timestamps.

Customer

Customer for the Transactional Record.

Person

User/employee associated with Transactional Record.

Unit

Measurement unit used for items such as kg, meters, cm, liters, etc.

Currency

Currency used in the Transactional Record.

Item

Related items (INVc). Usually listed in Transactional Record rows. Record level measures don’t work with this dimension.

VAT Code

VAT/Tax code (VATCodeBlock).

Account

Nominal Ledger account (AccVc).

Country

Country field from Contact/Customer card that is associated with Transactional Record.

Route

Delivery/visit route (DelRouteVc).

Project (Job)

Projects/Job (PRVc).

Location

Warehouse, store, or site (LocationVc).

Supplier

Supplier for purchase documents.

Record Status

Transactional Record status that shows if the “OK” checkbox was checked (OKed, not-OKed).

Invoice

Shows specific invoices and can be expanded to show the invoice items.

Invoice Type

Invoice types (Normal, Cash, Credit, Downpayment, Normal Special Sales, Credit Special Sales).

Unpaid invoice periods

Age range for outstanding/unpaid invoices (e.g., 0, 1–15, 16–30, 31–45, 46-60, 166+ days) based on due dates and payment status. The period ranges can be changed in import settings.

Activity Class

Activity classification (Class/Type).

Activity

Individual activity (ActVc)

Delivery

Deliveries document(SHVc) and can be expanded to show the Delivery items.

Transaction

Transactional Record (TRVc)

Transaction Status

Transaction status (OKed, Invalid, Simulation)

Simulation Status

Simulation status (Active, Invalid, Transferred)

Goods Receipt

Goods Receipt document (PUVc) and can be expanded to show the Goods Receipt items.

POS

Sales terminal/register transaction (IVCashVc) and can be expanded to show the POS items.

POS Machine

Individual sales terminal/register.

Purchase Invoice

Shows specific purchase invoices and can be expanded to show the purchase invoice items.

Purchase Order

Shows specific purchase order and can be expanded to show the purchase order items.

Quotation

Shows specific quotation and can be expanded to show the quotation items.

Sales Order

Shows specific sales order and can be expanded to show the sales order items.

Stock Depreciation

Shows specific stock depreciation and can be expanded to show the stock depreciation items.

Stock Movement

Shows specific stock movement and can be expanded to show the stock movement items.

Invoice

Invoice date

Invoice type

Customer code

Customer name

Person code

Project code

Sales group code

Due date

Currency

Currency rate

Invoice to Customer Code

Invoice to Customer Name

Invoice transaction time

URL

Invoice Item

Invoice item type

Item code

Objects

Item Varieties

Activity

Persons

From date

To date

Creation date

Todo

Calendar

Customer

Project code

Item code

Objects

UUID

OK flag

URL

Delivery

Delivery date

Sales Order number

Customer code

Customer name

Person code

Objects

Region

Location code

OK flag

UUID

URL

Delivery Item

Item Varieties

Item code

Objects

Serial number

Transactions

Transaction number

Created date

Transaction type

Created by

Comment

UUID

URL

Transaction Item

Account code

Objects

Goods Receipt

Supplier code

Supplier

Goods receipt date

Goods receipt class

Currency

Currency rate

Objects

Comment

OK flag

UUID

URL

Goods Receipt Item

GR item type

Item code

Objects

Item Varieties

Serial Nr.

Comment

Project (Job)

Customer

Currency

Terminated

Project manager code

Person code

Sales group code

Start date

End date

Finished date

UUID

URL

POS

POS date

Machine code

Customer code

Customer name

Persons code

OK flag

Currency

Objects

Currency rate

Invoice address 1

Invoice address 2

Invoice address 3

Invoice address 4

Invoice address 5

Base rate 1

Base rate 2

Location code

VAT included

POS transaction time

UUID

URL

POS Item

POS invoice item type

Item code

Objects

Item Varieties

Location code

VAT code

Invalid

Purchase Invoice

Purchase Invoice date

Purchase Invoice type

Purchase Invoice supplier code

Purchase Invoice supplier name

Purchase Invoice person code

Purchase Invoice sales group code

Purchase Invoice due date

Purchase Invoice currency

Purchase Invoice currency rate

OK flag

Purchase Invoice supplier invoice number

Purchase Invoice supplier address 1

Purchase Invoice supplier address 2

Purchase Invoice supplier address 3

Purchase Invoice supplier address 4

Purchase Invoice supplier address 5

Purchase Invoice supplier country

Purchase Invoice purchase order number

UUID

URL

Purchase Invoice Item

Purchase Invoice item type

Purchase Invoice item code

Purchase Invoice objects

Purchase Invoice Item Varieties

Purchase Invoice account number

Purchase Invoice project Code

Purchase Order

Purchase Order date

Purchase Order class

Planned ship date

Supplier code

Supplier name

Person code

Sales group code

Project code

Currency

Objects

Closed

OK flag

Currency rate

Invoice address 1

Invoice address 2

Invoice address 3

Invoice address 4

Invoice address 5

Delivery address 1

Delivery address 2

Delivery address 3

Delivery address 4

Delivery address 5

UUID

URL

Purchase Order Item

Item code

Objects

Item Varieties

Quotation

Quotation date

Decision date

Customer code

Customer name

Person code

Sales group code

Project code

Currency

UUID

URL

Quotation Item

Item code

Quotation item type

Objects

Item Varieties

Sales Order

Sales Order date

Sales Order class

Planned ship date

Customer code

Customer name

Person code

Sales group code

Project code

Currency

Objects

Closed

OK flag

Currency rate

Invoice address 1

Invoice address 2

Invoice address 3

Invoice address 4

Invoice address 5

Invoice country

Delivery address 1

Delivery address 2

Delivery address 3

Delivery address 4

Delivery address 5

Delivery country

UUID

URL

Sales Order Item

Item code

Objects

Item Varieties

Location

Calssification

UUID

URL

Stock Depreciation

GR item type

Item code

Objects

Item Varieties

Serial Nr.

Invoice amount

Invoice (IVVc) total amount in original document currency, from invoice documents.

Invoice base amount

Invoice (IVVc) total amount converted to company main base currency.

Invoice balance

Current outstanding (unpaid) invoice balance in original document currency from balances (ARVc) register.

Invoice base balance

Outstanding invoice balance converted to company main base currency from balances (ARVc) register.

Discount amount

Total discount sum in original document currency from invoice (IVVc).

Discount base amount

Total discount sum converted to company main base currency from invoice (IVVc).

Tax amount

Total VAT/Tax amount in original document currency on invoices (IVVc).

Tax base amount

VAT/Tax row amount converted to company main base currency on invoices (IVVc).

Invoice count

Count of invoice (IVVc) records.

Invoice row count

Count of Invoice (IVVc) record rows.

Unique invoice customers count

Number of distinct customers with at least one Invoice (IVVc) in report context.

Item amount

Invoice (IVVc) rows Item sum in original document currency.

Item base amount

Invoice (IVVc) rows Item sum in company main base currency. Used as primary measure for Turnover, Revenue, Sales, etc.

Item quantity

Invoice (IVVc) rows Item quantity.

Total weight

Invoice total weight from sold items.

Gross Profit

Invoice (IVVc) rows Item gross profit in company main base currency.

Gross Profit Base Amount

Invoice (IVVc) rows Item gross profit in company main base currency. Used as primary measure for Margin, Profit, GP, etc.

Activity duration

Total duration of CRM activities (ActVc)(e.g., calls, meetings, tasks)

Activity count

Activities count (ActVc).

Activity OKed duration

Duration of activities (ActVc) marked as confirmed/approved ("OKed").

Activity OKed count

Count of activities (ActVc) marked as confirmed/approved ("OKed").

Activity Not OKed duration

Duration of activities (ActVc) not yet confirmed/approved.

Activity Not OKed count

Count of activities (ActVc) not yet confirmed/approved.

Unique CRM customer count

Number of distinct customers with at least one Activity (ActVc) in report context.

Delivery count

Deliveries count (SHVc).

Total Shipped Quantity

Total shipped item quantity (SHVc).

Total Weight

Total weight of shipped items (SHVc).

Total Volume

Total volume of shipped items (SHVc).

Unique Delivery customers count

Number of distinct customers with at least one Delivery (SHVc) in report context.

Shipped Quantity

Delivery (SHVc) rows Item quantity.

Item Row Count

Number of item rows in Delivery (SHVc)

Item base amount

Delivery (SHVc) rows Item sum in company main base currency. Used as primary measure for Turnover, Revenue, Sales, etc.

Ordered Quantity

Quantity from Sales orders (ORVc).

Credit amount

The total numeric value of all financial transactions (TRVc) recorded on the right side of the general ledger for a given period and account.

Debit amount

The total numeric value of all financial transactions (TRVc) recorded on the left side of the general ledger for a given period and account

Balance

The monetary net worth, value, or cumulative standing of a specific financial (TRVc) account at a given point in time or over a defined period.

Initial Budget

The baseline financial (TRVc) projection or forecast set for an account, department (Tag/Object), or project at the start of the planning period.

Revised Budget

Updated financial (TRVc) projection or forecast set for an account, department (Tag/Object), or project at the start of the planning period.

Transaction count

Number of Transactions (TRVc)

Total Goods Receipts count

Number of goods receipt(PUVc) documents matching the selected context.

OK Goods Receipt count

Count of Goods Receipts (PUVc) marked as confirmed/approved ("OKed").

Not OK Goods Receipt count

Count of Goods Receipts (PUVc) not marked as confirmed/approved ("Not OKed").

Unique goods receipt supplier count

Number of distinct supplier with at least one Goods Receipt (PUVc) in report context.

Quantity

Goods receipt (PUVc) rows item quantity

Total cost

The full value of the received (PUVc) inventory items, calculated in the primary transaction currency (or converted directly to the home currency / Base Currency 1 depending on ERP system setup). It represents the absolute unit price multiplied by quantity, plus any distributed land costs such as freight, customs, or handling fees.

Total base cost

The value of the received (PUVc) inventory items converted into Base Currency 2 (the secondary base currency configured in the HansaWorld System module).

Project budget amount

Project (TBBUVc) total amount in original document currency, from job costing documents.

Project budget base amount

Project (TBBUVc) total amount converted to company main base currency.

Project count

Count of Projects (TBBUVc).

Unique job costing customer count

Number of distinct customer with at least one Project (TBBUVc) in report context.

Item budget amount

Budgeted value for individual Project (TBBUVc) item in original currency.

Item budget base amount

Budgeted value for individual Project (TBBUVc) item converted to company main base currency.

Item budget quantity

Project (TBBUVc) rows item quantity

Budget Gross profit

Project (TBBUVc) rows Item gross profit in company main base currency.

Budget Gross profit base amount

Project (TBBUVc) rows Item gross profit in company main base currency.

Budget discount amount

Total discount sum in original Project (TBBUVc) document.

Budget discount base amount

Total discount sum converted to company main base currency from Projects (TBBUVc).

Item budget count

Number of Project (TBBUVc) budget items.

POS count

Count of POS transaction (IVCashVc).

POS amount

Total POS (IVCashVc) transaction amount in original POS currency.

POS discount amount

Total discount sum in original POS (IVCashVc) document currency.

POS tax amount

Total POS (IVCashVc) transaction tax amount in original POS currency.

POS base amount

POS (IVCashVc) total amount converted to company main base currency.

POS discount base amount

Total discount sum converted to company main base currency from POS (IVCashVc).

POS tax base amount

Total POS (IVCashVc) transaction tax amount converted to company base currency.

Unique POS customers count

Number of distinct customer with at least one POS (IVCashVc) in report context.

POS item amount

POS (IVCashVc) rows Item sum in company main base currency. Used as primary measure for Turnover, Revenue, Sales, etc.

POS item quantity

POS (IVCashVc) rows Item quantity.

POS item base amount

POS (IVCashVc) rows Item sum converted to company main base currency.

POS gross profit

POS (IVCashVc) rows Item gross profit in company main base currency.

POS gross profit base amount

POS (IVCashVc) rows Item gross profit in company main base currency.

POS row count

Count of POS (IVCashVc) record rows.

Purchase Invoice amount

Purchase Invoice (VIVc) total amount in original document currency, from invoice documents.

Purchase Invoice base amount

Purchase Invoice (VIVc) total amount converted to company main base currency.

Purchase Invoice balance

Current outstanding (unpaid) purchase invoice balance in original document currency from balances (ARVc) register.

Purchase Invoice base balance

Outstanding purchase invoice balance converted to company main base currency from balances (ARVc) register.

Purchase Invoice tax amount

Total VAT/Tax amount in original document currency on purchase invoices (VIVc).

Purchase Invoice tax base amount

VAT/Tax row amount converted to company main base currency on purchase invoices (VIVc).

Purchase Invoice row count

Count of purchase invoice (VIVc) record rows.

Unique purchase invoice suppliers count

Number of distinct suppliers with at least one purchase invoice (VIVc) in report context.

Purchase Invoice Item amount

Purchase invoice (VIVc) rows Item sum in original document currency.

Purchase Invoice item base amount

Purchase invoice (VIVc) rows Item sum in company main base currency. Used as primary measure for Turnover, Revenue, Sales, etc.

Purchase Invoice item quantity

Purchase invoice (VIVc) rows Item quantity.

Purchase Order amount

Purchase Order (POVc) total amount in original document currency, from invoice documents.

Purchase Order base amount

Purchase Order (POVc) total amount converted to company main base currency.

Tax amount

Total VAT/Tax amount in original document currency on purchase orders (POVc).

Tax base amount

VAT/Tax row amount converted to company main base currency on purchase orders (POVc).

Discount amount

Total discount sum in original Purchase Order (POVc) document currency.

Discount base amount

Total discount sum converted to company main base currency from Purchase Order (POVc).

Purchase Order count

Count of Purchase Order transaction (POVc).

Unique purchase order suppliers count

Number of distinct suppliers with at least one purchase order (POVc) in report context.

Item amount

Purchase order (POVc) rows Item sum in original document currency.

Item base amount

Purchase Order (POVc) rows Item sum in company main base currency. Used as primary measure for Turnover, Revenue, Sales, etc.

Item quantity

Purchase Order (POVc) rows Item quantity.

Open amount

Purchase Order (POVc) amount of the remaining, unfulfilled portion of the order.

Open base amount

Purchase Order (POVc) total open amount converted to company main base currency.

Open quantity

Purchase Order (POVc) quantity of the remaining, unfulfilled portion of the order.

Quotation amount

Quotation (QTVc) total amount in original document currency, from invoice documents.

Quotation base amount

Quotation (QTVc) total amount converted to company main base currency.

Open Quotation amount

Open Quotation (QTVc) total amount in original document currency, from invoice documents.

Open Quotation base amount

Open Quotation (QTVc) total amount converted to company main base currency.

Rejected Quotation amount

Rejected Quotation (QTVc) total amount in original document currency, from invoice documents.

Rejected Quotation base amount

Rejected Quotation (QTVc) total amount converted to company main base currency.

Accepted Quotation amount

Accepted Quotation (QTVc) total amount in original document currency, from invoice documents.

Accepted Quotation base amount

Accepted Quotation (QTVc) total amount converted to company main base currency.

Tax amount

Total VAT/Tax amount in original document currency on Quotation (QTVc).

Tax base amount

VAT/Tax row amount converted to company main base currency on Quotation (QTVc).

Probability

The estimated probability to win Quotation (QTVc)

Discount amount

Total discount sum in original Quotation (QTVc) document currency.

Discount base amount

Total discount sum converted to company main base currency from Quotation (QTVc).

Quotation count

Count of Quotation (QTVc).

Open Quotation count

Count of Open Quotation (QTVc).

Rejected Quotation count

Count of Rejected Quotation (QTVc).

Accepted Quotation count

Count of Accepted Quotation (QTVc).

Unique quotation customer count

Number of distinct customers with at least one Quotation (QTVc) in report context.

Item amount

Quotation (QTVc) rows Item sum in original document currency.

Item base amount

Quotation (QTVc) rows Item sum in company main base currency. Used as primary measure for Turnover, Revenue, Sales, etc.

Item quantity

Quotation (QTVc) rows Item quantity.

Gross profit

Total discount sum in original document currency from Quotation (QTVc).

Gross profit base amount

Total discount sum converted to company main base currency from Quotation (QTVc).

Sales Order amount

Sales Order (ORVc) total amount in original document currency, from invoice documents.

Sales Order base amount

Sales Order (ORVc) total amount converted to company main base currency.

Tax amount

Total VAT/Tax amount in original document currency on sales orders (ORVc).

Tax base amount

VAT/Tax row amount converted to company main base currency on sales orders (ORVc).

Discount amount

Total discount sum in original Sales Order (ORVc) document currency.

Discount base amount

Total discount sum converted to company main base currency from Sales Order (ORVc).

Sales Order count

Count of Sales Order transaction (ORVc).

Sales Order open gross profit

Total discount sum in original document currency from Open Sales Order (ORVc).

Sales Order open gross profit base amount

Total discount sum converted to company main base currency from Open Sales Order (ORVc).

Unique sales order customer count

Number of distinct customers with at least one sales order (ORVc) in report context.

Not invoiced quantity

Sales Orders (ORVc) item quantity that have not yet been invoiced.

Not invoiced gross profit amount

Total discount sum in original document currency from Open Sales Order (ORVc) that have not yet been invoiced.

Not invoiced gross profit base amount

Total discount sum converted to company main base currency from Open Sales Order (ORVc) that have not yet been invoiced.

Item amount

Sales order (ORVc) rows Item sum in original document currency.

Item base amount

Sales Order (ORVc) rows Item sum in company main base currency. Used as primary measure for Turnover, Revenue, Sales, etc.

Item quantity

Sales Order (ORVc) rows Item quantity.

Gross profit

Total discount sum in original document currency from Sales Order (ORVc).

Gross profit base amount

Total discount sum converted to company main base currency from Sales Order (ORVc).

Open amount

Sales Order (ORVc) amount of the remaining, unfulfilled portion of the order.

Open base amount

Sales Order (ORVc) total open amount converted to company main base currency.

Open quantity

Sales Order (ORVc) quantity of the remaining, unfulfilled portion of the order.

In stock

Quantity of an item (ItemStatusVc) currently held in stock

On order

Quantity of an item (ItemStatusVc) that has been ordered (e.g., from suppliers) but not yet received.

On delivery

Quantity of an item (ItemStatusVc) that is out for delivery or in transit.

In stock WA value

The weighted-average value of the stock item (ItemStatusVc) currently held.

On open Purchase Orders

Quantity of an item (ItemStatusVc) on purchase orders that are still open (unreceived)

On OKed open Purchase Orders

Quantity of an item (ItemStatusVc) approved on purchase orders that are still open (unreceived)

Stock In

Quantities of stock items (ItemHistVc) received during the selected Time period.

Stock Out

Quantities of stock items (ItemHistVc) issued during the selected Time period.

Non-Stock In

Quantities of stock items (ItemHistVc) received during the selected Time period but not tracked as stock.

Non-Stock Out

Quantities of stock items (ItemHistVc) issued during the selected Time period but not tracked as stock.

Total Cost In

Amount of stock items (ItemHistVc) received during the selected Time period.

Total Cost Out

Amount of stock items (ItemHistVc) issued during the selected Time period.

Total Non-Stock Cost In

Amount of stock items (ItemHistVc) received during the selected Time period but not tracked as stock.

Total Non-Stock Cost Out

Amount of stock items (ItemHistVc) issued during the selected Time period but not tracked as stock.

Stock Depreciation count

Count of Stock Depreciation transaction (SDVc).

OK Stock Depreciation count

Count of approved Stock Depreciation transaction (SDVc).

Not OK Stock Depreciation count

Count of not approved Stock Depreciation transaction (SDVc).

FIFO

Stock Depreciation transaction value (SDVc).

Quantity

Item quantity in Stock Depreciation transaction (SDVc).