Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 12
Next »
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 | - |
Measures Table
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 |
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 |