In this manual you may find the field description of: Money Pay in/Collect out cube, Drawer log, Cube on consummation, Modifiers cube, Operations cube, All station sales cube, Payment cards, Total menu item sold cube, Discounts cube, Voids

Money Pay in/Collect out cube

Facts:

Sum– Sum of Collected/Manually counted money in payment currency;

Dimensions:

Currency – Name;

Common Shift–Common Shift Number;

Restaurant–Restaurant Name;

Logic Date–Logic Shift Date;

Open Name–Condition: Open Name;

Reason – Deposit/Collect money Reason;

Cash Server–Cash Server Name;

Type– Deposit Type (deposit in cash drawer, prepayment, prepayment refund etc.);

Month– Operations Performance Month;

DW –Logic Date–week day;

Time–Deposit/Collect Time;

Date–Deposit/Collect Date;

Shift Number–Common Shift Number;

Station–Station Name;

Card Number–Credit Card Number;

Box– Box Number.

Drawer log

Facts:

Box –Box Name.

Dimensions:

Open Time–Opened–time;

Close Time–Printed at–time;

Operation–Performed Operations;

Reason– Open Box Reason;

Employee–Employee Name.

Cube on consummation

Facts:

Sum– The Base Sum for the Consummation;

Percent –Consummation Percent;

Pay Sum – The Pay Sum Amount to Consummator;

Dish –Sold Dishes Quantity;

Price Sum – Price List Sum without Discount and Tax;

 Dimensions:

Month –Operation Performance Month;

DW –Logic Date- week day;

Year–Operation Performance Year;

Restaurant Name–Restaurant Name;

Dish State–Dish State at the cube construction moment;

Code–Object Code;

Consummator Name–Consummator Group Name;

Cash Server–Cash Server Name;

Order Name–Unique Order Name;

Shift Number–Common Shift Number;

Date–Common Shift Logic Date;

Dish-Dish Name

Modifiers cube

Facts:

Pieces Quantity–Sold Modifier Quantity;

Price sum– Modifier Price Sum.

Dimensions:

Modifier – Modifier Name;

Modifier Group– Modifier Group Name;

Common Shift Status –Shift Status;

Category path–Modifier Menu Group;

Restaurant–Restaurant Name;

Cash Server –Cash Server Name;

DW –Logic Date–week day;

Month–Operation Performance Month;

Year–Operation Performance Year;

Order Name- Unique Order Name;

Shift Number–Common Shift Number;

Author – Order Employee Name;

Role –Employee Role Name;

Date- Common Shift Logic Date;

Dish- Dish Name.

Operations cube

Facts:

Number–Operations Number;

Dish Quantity –Modified Dish Quantity;

Order Amount–Modified Order Amount;

Dimensions:

Cash Server–Cash Server Name;

Cash Shift–Cash Shift Number;

Add Dish Time– Add Dish Time to the Order;

Source Table– Source Table Number;

Source Order– Source Order Number;

Date–Logic Shift Date;

DW –Logic Date–week day;

Month– Operation Performance Month;

Year –Operation Performance Year;

Parameter – If operation is with closed receipts, this parameter shows receipt number;

Макет – Макет;

Operation–Performed Operation at the cash drawer;

Time–Operation Time;

Shift Date– Common Shift Logic Date;

Shift Number– Unique Shift Number;

Station– Cash Shift Number;

Order–Order Name;  

Manager–Employee, performing operations;

Access– Employee with the right for the given operation;

Main Waiter– Order Main Waiter;

Table–Table Number;

Table –Table Name;

Common Shift Status –Shift Status.

All station sales cube

Facts:

Amount – Price Amount (amount without discounts and markups);

Basic Amount–Amount in Basic Currency;

Dimensions:

Shift Number Status –Shift Status;

Owner–Card Owner;

Real Date– Sate of printing receipt;

Cash Shift– Common Cash Shift Number;

Close Station– Cash Station Number by receipt close;

Payment-Payment Status;

Ignore in report– Ignore Payment in reports;

Restaurant– Restaurant Name;

Order Category–Order Category Name;

Table–Table Number;

Card Number–Payment Card Number;

Pay Method–payment (cash,cashless);

Cash server–Cash Server Name;

Quarter–Quarter Number;

Month–Performed Payment Month;

DW–Logic Date-week day;

Year–Performed Payment Year;

Date–Logic Date;

Shift Number–Unique Shift Number;

Cashier Code–Unique Cashier Code;

Check Name– Name of the receipt;

Waiter Code– Unique Waiter Code;

Waiter–Waiter Name;

Currency– Payment Currency;

Currency Type–Payment Currency Type.

Payment cards

Facts:

Sum– Price Sum (without discounts/markups);

Check Number- Check Count;

Dimensions:

Card Number– Payment Card Number;

Owner- Owner Name;

Receipt Number–Unique Receipt Number;

Дата – Common Shift Logic Date;

 Shift Number–Common Shift Number;

Pay Method;

Restaurant–Restaurant Name;

Server– Cash Server Name.  

Total menu item sold cube

Facts:

Quantity– Dish Quantity;

Average Price–Dish Average Price;

Amount–Price Amount (without discounts/markups);

Discuont–Discount Amount;

Paid Amount– Payment Amount;

Tax– Tax amount.

Dimensions:

Category– Dish Category;

Dish– Dish Name;

Real Date–Order Close Date;

Combo Dish–Menu Combo Element;

Rate Class–Fiscal Rate;

Waiter– Waiter Name;

Restaurant–Restaurant Name;

DW –Logic Date- week day;

Month– Operation Perform Month;

Year-Operation Perform Date;

Object Kind– Type of the Object (Dish);

Cost–Dish Cost;

Card Number–Owner Card Number;

Order Name–Order number ;

Table–Table Number;

Cash Shift– Common Cash Shift Number;

Sort– Location Order;

Currency Code–Unique Currency Code;

Currency–Currency Name;

Currency Type;

Cash Server– Cash Server Name;

Closure Station– Closure Cash Station Name;

Category Path– Menu Group, including modifier;

Date– Logic Date;

Receipt Status;

Hour– Close Hour;

Receipt Number–Unique Receipt Number;

Shift Number–Common Shift Number;

Order Category;

 (Excl.from Earnings);

Code–Element Code;

Main Waiter–Main Waiter Name 

Discounts cube

Facts:

Amount –Price Amount;

Dimensions:

Waiter– Waiter Name;

Discount–Discount Name;

Type of Defaulters– Defaulters Name;

Common Shift–Common Shift Number;

Restaurant–Restaurant Name;

Mode– Way of discount Mode (manually, automatically);

Not distributed– Not distributed Discount;

Card Number;

Currency– Currency Name;

Currency Type– Currency Type (cash, cashless);

Shift Number– Common Shift Number;

Main Waiter–Order Main Waiter;

Close Station–Close Station Name;

Cash Server–Cash Server Name;

Receipt Number– Unique Receipt Number;

Dish– Dish Number;

Date– Logic Date;

Receipt-Receipt Status.

Voids

Facts:

Quantity– Delete Quantity

Price–Price List Sum;

Amount– Price Amount (without discounts/markups);

Dimensions:

Dish- Dish Name;

Reason – Delete Reason;

Date–Logic Date;

Shift Number–Common Shift Number;

Order–Order Number;

Cash Server–Cash Server Number;

Dish Station–Dish Cash Station;

Station–Cash Station name;

Code–Dish Code;

Waiter–Waiter Name;

Deleted–Employee, deleting dish;

Time–Delete Time;

Delete Date– Logic Deleted Date.