HansaWorld Invoices

Dimension Table

Dimension	Dimension Hierarchy	Default properties
VAT Code	VAT Code	-
Time	Year / Quarter / Month / Week / Day	-
Customer	Category / Customer	Customer category Customer street Customer city Customer country code Customer longitude Customer latitude Customer person code Customer classification Customer export flag Invoice To Customer Code Invoice To Customer Name First invoice date Customer created date Customer updated date
Invoice	Invoice / Invoice Item	Invoice date Invoice due date Invoice type Invoice currency Invoice customer name Invoice person code Person name Invoice project code Item Variety
Person	Sales Group / Person	-
Currency	Currency	-
Item	Group / Item	Invoice item type Invoice item code Invoice item objects Alternative code Item unit Item group Item classes Item objects
Item Class Levels	Level 1 / Level 2 / Level 3 / Level 4 / Level 5	-
Project (Job)	Class / Project / Project item	-
Location	Group / Location	-

Cube	Level	Measures
Invoice	Record	Invoice amount Discount amount Tax amount Invoice base amount Discount base amount Tax base amount Invoice count Invoice balance Invoice base balance New customer count
Invoice	Item	Item amount FIFO Gross profit Item quantity Item base amount Gross profit base amount Stock FIFO Stock Quantity
Quotation (Shared)	Record	Quotation amount Open Quotation amount Rejected Quotation amount Accepted Quotation amount Quotation base amount Open Quotation base amount Rejected Quotation base amount Accepted Quotation base amount
Sales Order (Shared)	Record	Sales Order amount Sales Order base amount Sales Order Item open amount Sales Order Item open base amount
Stock (Shared)	Record	In stock Stock on order