Hansaworld Quotations

Dimension Table

Dimension	Dimension Hierarchy	Default properties
Time	Year / Quarter / Month / Week / Day
Customer	Category / Customer	Customer created date Customer updated date
Person	Sales Group / Person
Currency	Currency
Item	Group / Item	Alternative code
Project (Job)	Class / Project / Project item
Location	Group / Location
Quotation Status	Quotation Status
Quotation	Quotation Class / Quotation / Quotation item	Quotation date Decision date Quotation currency Quotation project Item Variety

Cube	Level	Measures
Quotations	Record	Quotation amount Open Quotation amount Rejected Quotation amount Accepted Quotation amount Discount amount Tax amount Quotation base amount Open Quotation base amount Rejected Quotation base amount Accepted Quotation base amount Discount base amount Tax base amount Probability Quotation count Open Quotation count Rejected Quotation count Accepted Quotation count
Quotations	Item	Item amount Item quantity Item base amount Discount amount Discount base amount Gross profit Gross profit base amount
Invoices	Record
Invoices	Item
Sales Orders	Record
Sales Orders	Item
Stock	Record