ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
namesluginputformuladefinition
2
Additional Receipts AIRadditional_receipts_air{additional_receipts_ticket} / {additional_receipts_units}
3
Additional Receipts AUCadditional_receipts_auc{additional_receipts_cost} / {additional_receipts_units}
4
Additional Receipts AURadditional_receipts_aur{additional_receipts_retail} / {additional_receipts_units}
5
Additional Receipts Costadditional_receipts_cost
6
Additional Receipts IMUadditional_receipts_imu({additional_receipts_ticket} - {additional_receipts_cost}) / {additional_receipts_ticket}Initial Markup for the receipts
7
Additional Receipts Marginadditional_receipts_margin{additional_receipts_retail} - {additional_receipts_cost}
8
Additional Receipts Margin %
additional_receipts_margin_percentage
({additional_receipts_retail} - {additional_receipts_cost}) / {additional_receipts_retail}
9
Additional Receipts Retailadditional_receipts_retail
10
Additional Receipts Ticketadditional_receipts_ticket
11
Additional Receipts Unitsadditional_receipts_units
12
Adjustment AIRadjustment_air{adjustment_ticket} / {adjustment_units}
13
Adjustment AUCadjustment_auc{adjustment_cost} / {adjustment_units}
14
Adjustment AURadjustment_aur{adjustment_retail} / {adjustment_units}
15
Adjustment Costadjustment_costPlease see Adjustment Units
16
Adjustment Cost Rateadjustment_cost_rate{adjustment_cost} / {bop_cost}
17
Adjustment FP Costadjustment_fp_cost
18
Adjustment FP Retailadjustment_fp_retail
19
Adjustment FP Ticketadjustment_fp_ticket
20
Adjustment FP Unitsadjustment_fp_units
21
Adjustment MD Costadjustment_md_cost
22
Adjustment MD Retailadjustment_md_retail
23
Adjustment MD Ticketadjustment_md_ticket
24
Adjustment MD Unitsadjustment_md_units
25
Adjustment Retailadjustment_retailPlease see Adjustment Units
26
Adjustment Retail Rateadjustment_retail_rate{adjustment_retail} / {bop_retail}
27
Adjustment Ticketadjustment_ticketPlease see Adjustment Units
28
Adjustment Ticket Rateadjustment_ticket_rate{adjustment_ticket} / {bop_ticket}
29
Adjustment Unit Rateadjustment_unit_rate{adjustment_units} / {bop_units}
30
Adjustment Unitsadjustment_unitsThis is used to capture unaccounted for deltas between ending inventory and next period's inventory. For actuals, this is automatically calculated by NEXT(BOP) - EOP, to ensure that ending inventory ties into the opening inventory.

For future planning, this can be used to capture non-sale inventory changes, such as accounting for shrink, give-aways, etc.

You can read more about the adjustment metrics here - https://help.toolio.com/en/articles/6503100-adjustment-metrics
31
ATS Costats_cost{bop_cost} + {receipts_cost}
32
ATS Retailats_retail{bop_retail} + {receipts_retail}
33
ATS Ticketats_ticket{bop_ticket} + {receipts_ticket}
34
ATS Unitsats_units{bop_units} + {receipts_units}
35
Average Daily Sales Costavg_daily_sales_costAVERAGE({gross_sales_cost}) / 7.00
36
Average Daily Sales Retailavg_daily_sales_retailAVERAGE({gross_sales_retail}) / 7.00
37
Average Daily Sales Ticketavg_daily_sales_ticket(AVERAGE({gross_sales_retail}) + AVERAGE({markdown}) + AVERAGE({discount})) / 7.00
38
Average Daily Sales Unitsavg_daily_sales_unitsAVERAGE({gross_sales_units}) / 7.00
39
Average Inventory Costaverage_inventory_costAVERAGE({bop_cost})
40
Average Inventory Retailaverage_inventory_retailAVERAGE({bop_retail})
41
Average Inventory Unitsaverage_inventory_unitsAVERAGE({bop_units})
42
Average per Weekaverage_per_weekAVERAGE({gross_sales_units})
43
Bookings Costbookings_cost{booking__total_cost}Topline sales prior to returns. Measured in cost value.
44
Bookings Fill Rate Unitsbookings_fill_rate_units{gross_sales_units} / {bookings_units}Average Unit Cost of Gross Sales
45
Bookings Retailbookings_retail{booking__total_retail}Topline sales prior to returns, but after allowances (i.e. markdowns and discounts). Measured in retail value.
46
Bookings Ticketbookings_ticket{booking__total_ticket}Topline sales prior to returns and allowances (i.e. markdowns and discounts). Measured in ticket value.
47
Bookings Unitsbookings_units{booking__units}Topline sales prior to returns. Measured in units.
48
BOP AIRbop_air{bop_ticket} / {bop_units}
49
BOP AIR FPbop_fp_air{bop_fp_ticket} / {bop_fp_units}
50
BOP AIR MDbop_md_air{bop_md_ticket} / {bop_md_units}
51
BOP AUCbop_auc{bop_cost} / {bop_units}
52
BOP AUC FPbop_fp_auc{bop_fp_cost} / {bop_fp_units}
53
BOP AUC MDbop_md_auc{bop_md_cost} / {bop_md_units}
54
BOP AURbop_aur{bop_retail} / {bop_units}
55
BOP AUR FPbop_fp_aur{bop_fp_retail} / {bop_fp_units}
56
BOP AUR MDbop_md_aur{bop_md_retail} / {bop_md_units}
57
BOP Costbop_cost{inventory__total_cost}
58
BOP Cost FPbop_fp_cost
59
BOP Cost MDbop_md_cost{bop_cost} - {bop_fp_cost}
60
BOP IMUbop_imu({bop_ticket} - {bop_cost}) / {bop_ticket}Initial Markup of the Inventory
61
BOP Marginbop_margin{bop_retail} - {bop_cost}
62
BOP Margin %bop_margin_percentage({bop_retail} - {bop_cost}) / {bop_retail}
63
BOP Retailbop_retail{inventory__total_retail}Beginning of period inventory measured in retail value.
64
BOP Retail FPbop_fp_retail
65
BOP Retail MDbop_md_retail{bop_retail} - {bop_fp_retail}
66
BOP Ticketbop_ticket{inventory__total_ticket}Beginning of period inventory measured at ticket value.
67
BOP Ticket FPbop_fp_ticket
68
BOP Ticket MDbop_md_ticket{bop_ticket} - {bop_fp_ticket}
69
BOP Unitsbop_units{inventory__units}
70
BOP Units FPbop_fp_units
71
BOP Units MDbop_md_units{bop_units} - {bop_fp_units}
72
Choices per Weektotal_choicesCHOICE_DEFINITIONS_CONCATOnly used in Merchandise Plan. It shows the total number of choices that were sold within a week. When aggregated over time, the average per week is taken
73
Comp Gross Sales Retailcomp_gross_sales_retailnew Date('{location__comp_date}') < new Date('{sale__timestamp}') ? {sale__sales_retail} : 0
74
Comp Gross Sales Unitscomp_gross_sales_unitsnew Date('{location__comp_date}') < new Date('{sale__timestamp}') ? {sale__sales_units} : 0
75
Constrained Dependent Costconstrained_dependent_cost
76
Constrained Dependent Retailconstrained_dependent_retail
77
Constrained Dependent Ticketconstrained_dependent_ticket
78
Constrained Dependent Unitsconstrained_dependent_units
79
Constrained Sales Costconstrained_sales_cost{sale__sales_cost}Used in Assortment Plan to show projected sales constrained by available inventory in cost.
80
Constrained Sales Retailconstrained_sales_retail{sale__sales_retail}Used in Assortment Plan to show projected sales constrained by available inventory in retail.
81
Constrained Sales Ticketconstrained_sales_ticketUsed in Assortment Plan to show projected sales constrained by available inventory in ticket.
82
Constrained Sales Unitsconstrained_sales_units{sale__sales_units}Used in Assortment Plan to show projected sales constrained by available inventory in units.
83
Cumulative STcumulative_sell_throughOnly used in Assortment Plan. Shows the Cumulative ST% of the particular choice, in its lifetime. See https://help.toolio.com/en/articles/8826560-receipts-generation-and-reviewing-receipts-plan#h_8f2b0e7192 to learn more.
84
Current Inventorycurrent_inventory_units{inventory__units}
85
Days of Cover Costdays_of_cover_cost{gross_wos_cost} * 7
86
Days of Cover Retaildays_of_cover_retail{gross_wos_retail} * 7
87
Days of Cover Ticketdays_of_cover_ticket{gross_wos_ticket} * 7
88
Days of Cover Unitsdays_of_cover_units{gross_wos_units} * 7
89
Demand Costdemand_costPlease see Demand Units
90
Demand Retaildemand_retailPlease see Demand Units
91
Demand Ticketdemand_ticketPlease see Demand Units
92
Demand Unitsdemand_unitsUsed in Item Plan and curve generations. Shows potential sales that would have happened if the item didn't stockout. This requires a demand configuration in place. You can read more on https://help.toolio.com/en/articles/6868748-demand-metrics
93
Dependent Costdependent_costPlease see Dependent Units
94
Dependent Retaildependent_retailThis is used to capture demand transferrance from one product to another. An example is blank vs. printed tees. Sales Plan on printed tees would appear as Dependant Sales on the blank item, if there is a dependendant demand relationship between the two. Please reach out if you want to learn more.
95
Dependent Ticketdependent_ticketPlease see Dependent Units
96
Dependent Unitsdependent_unitsPlease see Dependent Units
97
Discountdiscount{sale__discount}Discounts are one-time price reductions applied at the point of sale (POS). Employee discounts or special promos for a weekend are some examples of these.
98
Discount %discount_percentage{discount} / {gross_sales_ticket}
99
Effective Safety Stock Unitseffective_safety_stock_units
100
EOP AIReop_air{eop_ticket} / {eop_units}End of period inventory, average initial retail.