Skip to content
English
  • There are no suggestions because the search field is empty.

Definitions of Stock measures

List of definitions for Stock measures found in the Stock Module of the Master Template cube

Fact Field Name Definition
Stock Transaction Type Breaks down all Stock Movements - sourced directly from AP21
Stock Movement Units The Sum of all Stock Transaction Types equates to the total Stock Movements both In and Out which is used to calculate the Closing Stock on Hand.  
Stock Movement Cost The Sum of all Stock Transaction Types equates to the total Stock Movements both In and Out which is used to calculate the Closing Stock on Hand.  
Stock Movement Retail $ The Sum of all Stock Transaction Types equates to the total Stock Movements both In and Out which is used to calculate the Closing Stock on Hand.  
Stock CSOH Units Closing Stock on Hand: Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock CSOH Cost Closing Stock on Hand: Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock CSOH Retail $ Closing Stock on Hand: Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock CSOH Retail Incl GST $ Closing Stock on Hand: Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock CSOH Orig Retail $ Closing Stock on Hand: Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock CSOH Orig Retail Incl GST $ Closing Stock on Hand: Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock In Transit Units Goods In Transit refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.
Stock In Transit Cost Goods In Transit refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.
Stock In Transit Retail $ Goods In Transit refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.
Stock In Transit Retail Incl GST $ Goods In Transit refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.
Stock In Transit Orig Retail $ Goods In Transit refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.
Stock In Transit Orig Retail Incl GST $ Goods In Transit refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.
Stock CSOH Excl In Transit Units Closing Stock on Hand: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock CSOH Excl In Transit Cost Closing Stock on Hand: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock CSOH Excl In Transit Retail $ Closing Stock on Hand: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock CSOH Excl In Transit Retail Incl GST$ Closing Stock on Hand: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock Curr RRP Incl GST Current RRP Incl GST: under the Stock module, this is an historical view of the Current RRP incl GST for a product against the calendar, providing a view of any changes to the current RRP by calendar period down to the date. If there is no CSOH for that calendar period, the field will be blank.
Stock Orig RRP Incl GST Original RRP Incl GST: under the Stock module, this is an historical view of the Original RRP incl GST for a product against the calendar, providing a view of any changes to the Original RRP by calendar period down to the date. If there is no CSOH for that calendar period, the field will be blank.
Stock Stock Markdown Units The total Opening Stock on Hand units on the date that a Permanent Price Change has been applied to a Product or group of Products
Stock Stock Markdown Retail $ The Sum of the Total change in Stock value at Retail $ from the previous Current RRP to the new Current RRP * Opening Stock on hand on the day a Permanent Price Change has been applied to a Product or group of Products. 
Stock CSOH GP Gross Profit Value of the Closing Stock on Hand i.e. the difference between the Retail value and the Cost value of the stock
Stock CSOH GP % Gross Profit Value (or CSOH GP) as a % of the Closing Stock on Hand at Retail $ to show the Stock profit value at the selected calendar time
Stock # SKUs with CSOH Count of the number of SKU's (defined by Style / Colour / Size) with a Closing Stock on Hand Quantity
Stock # Options with CSOH Count of the number of Options (defined by Style / Colour) with a Closing Stock on Hand Quantity
Stock # Styles with CSOH Count of the number of Styles with a Closing Stock on Hand Quantity
Stock # Stores with CSOH Count of the number of Locations with a Closing Stock on Hand Quantity. Used against the Product to show how many stores in stock of a particular Product level selected - can show against Style, Option or SKU
Stock OSOH Units Opening Stock on Hand; The Stock on hand for the start of the time period selected which also equates to the Closing Stock on Hand for the previous relative calendar period selected. E.g. OSOH week = CSOH for the previous week. Includes in Transit unless stated otherwise.  
Stock OSOH Cost Opening Stock on Hand; The Stock on hand for the start of the time period selected which also equates to the Closing Stock on Hand for the previous relative calendar period selected. E.g. OSOH week = CSOH for the previous week. Includes in Transit unless stated otherwise.  
Stock OSOH Retail $ Opening Stock on Hand; The Stock on hand for the start of the time period selected which also equates to the Closing Stock on Hand for the previous relative calendar period selected. E.g. OSOH week = CSOH for the previous week. Includes in Transit unless stated otherwise.  
Stock Full Price CSOH Units CSOH for all Full Price Stock, defined as stock with no Permanent Markdown applied to the product.  
Stock Markdown CSOH Units CSOH for all Markdown Stock, defined as stock which has had a Permanent Markdown applied to the product.  
Stock Full Price Store CSOH Units CSOH in Stores (excluding locations defined as warehouse) for all Full Price Stock, defined as stock with no Permanent Markdown applied to the product.  
Stock Markdown Store CSOH Units CSOH in Stores (excluding locations defined as warehouse) for all Markdown Stock, defined as stock which has had a Permanent Markdown applied to the product.  
Stock Full Price CSOH Retail $ CSOH for all Full Price Stock, defined as stock with no Permanent Markdown applied to the product.  
Stock Markdown CSOH Retail $ CSOH for all Markdown Stock, defined as stock which has had a Permanent Markdown applied to the product.  
Stock Full Price Store CSOH Retail $ CSOH in Stores (excluding locations defined as warehouse) for all Full Price Stock, defined as stock with no Permanent Markdown applied to the product.  
Stock Markdown Store CSOH Retail $ CSOH in Stores (excluding locations defined as warehouse) for all Markdown Stock, defined as stock which has had a Permanent Markdown applied to the product.  
Stock Full Price CSOH Cost CSOH for all Full Price Stock, defined as stock with no Permanent Markdown applied to the product.  
Stock Markdown CSOH Cost CSOH for all Markdown Stock, defined as stock which has had a Permanent Markdown applied to the product.  
Stock Full Price Store CSOH Cost CSOH in Stores (excluding locations defined as warehouse) for all Full Price Stock, defined as stock with no Permanent Markdown applied to the product.  
Stock Markdown Store CSOH Cost CSOH in Stores (excluding locations defined as warehouse) for all Markdown Stock, defined as stock which has had a Permanent Markdown applied to the product.  
Stock Store CSOH Units Closing Stock on Hand In Stores (excludes locations defined as Warehouse): Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock Store CSOH Cost Closing Stock on Hand In Stores (excludes locations defined as Warehouse): Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock Store CSOH Retail $ Closing Stock on Hand In Stores (excludes locations defined as Warehouse): Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock Store In Transit Units Goods In Transit to Store locations only: refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.  
Stock Store In Transit Cost Goods In Transit to Store locations only: refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.  
Stock Store In Transit Retail $ Goods In Transit to Store locations only: refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.  
Stock Store CSOH Excl In Transit Units Closing Stock on Hand in Store Locations only: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock Store CSOH Excl In Transit Cost Closing Stock on Hand in Store Locations only: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock Store CSOH Excl In Transit Retail $ Closing Stock on Hand in Store Locations only: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock Warehouse CSOH Units Closing Stock on Hand In Warehouse Locations (excludes locations defined as Stores): Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock Warehouse CSOH Cost Closing Stock on Hand In Warehouse Locations (excludes locations defined as Stores): Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock Warehouse CSOH Retail $ Closing Stock on Hand In Warehouse Locations (excludes locations defined as Stores): Stock on Hand shows stock physically at a location as well as In Transit stock as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube. In Transit stock shows against the receiving location.  
Stock Warehouse In Transit Units Goods In Transit to Warehouse locations only: refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.  
Stock Warehouse In Transit Cost Goods In Transit to Warehouse locations only: refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.  
Stock Warehouse In Transit Retail $ Goods In Transit to Warehouse locations only: refers to the stock that has been shipped (picked and packed and shipped) from one location and is on it's way (or In Transit) to another. It shows against the receiving Location.  
Stock Warehouse CSOH Excl In Transit Units Closing Stock on Hand in Warehouse Locations only: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock Warehouse CSOH Excl In Transit Cost Closing Stock on Hand in Warehouse Locations only: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock Warehouse CSOH Excl In Transit Retail $ Closing Stock on Hand in Warehouse Locations only: Stock on Hand shows stock physically at a location excluding any In Transit stock, as at the selected calendar or relative time period. Stock on hand also includes layby stock. If no calendar is selected, then data is as at the most recent overnight update to the cube.  
Stock Opening Balance Units Opening Balance is a Stock Transaction Type used in Accounting to represent the starting Stock Value for the calendar period in review.  
Stock Opening Balance Cost Opening Balance is a Stock Transaction Type used in Accounting to represent the starting Stock Value for the calendar period in review.  
Stock Opening Balance Retail $ Opening Balance is a Stock Transaction Type used in Accounting to represent the starting Stock Value for the calendar period in review.  
Stock Received Units Received is a Stock Transaction Type used in Accounting to represent the Intake Stock Value, Received in to the business, for the calendar period in review.  
Stock Received Cost Received is a Stock Transaction Type used in Accounting to represent the Intake Stock Value, Received in to the business, for the calendar period in review.  
Stock Received Retail $ Received is a Stock Transaction Type used in Accounting to represent the Intake Stock Value, Received in to the business, for the calendar period in review.  
Stock Stock Writeoff Units Stock Writeoffs is a Stock Transaction Type used in Accounting to represent the Stock Value that has been written off or wiped from the books, for the calendar period in review.  
Stock Stock Writeoff Cost Stock Writeoffs is a Stock Transaction Type used in Accounting to represent the Stock Value that has been written off or wiped from the books, for the calendar period in review.  
Stock Stock Writeoff Retail $ Stock Writeoffs is a Stock Transaction Type used in Accounting to represent the Stock Value that has been written off or wiped from the books, for the calendar period in review.  
Stock Stocktake Units Stocktake is a Stock Transaction Type used in Accounting to represent a Stock discrepancy as a result of a stocktake. This value has had to be added or deducted from the books as a result of the stocktake discrepancy, for the calendar period in review.  
Stock Stocktake Cost Stocktake is a Stock Transaction Type used in Accounting to represent a Stock discrepancy as a result of a stocktake. This value has had to be added or deducted from the books as a result of the stocktake discrepancy, for the calendar period in review.  
Stock Stocktake Retail $ Stocktake is a Stock Transaction Type used in Accounting to represent a Stock discrepancy as a result of a stocktake. This value has had to be added or deducted from the books as a result of the stocktake discrepancy, for the calendar period in review.  
Stock Stock Sales Units Stock Sales is a Stock Transaction Type used in Accounting to represent a value of Stock which has been Sold, for the calendar period in review.  
Stock Stock Sales Cost Stock Sales is a Stock Transaction Type used in Accounting to represent a value of Stock which has been Sold, for the calendar period in review.  
Stock Stock Sales Retail $ Stock Sales is a Stock Transaction Type used in Accounting to represent a value of Stock which has been Sold, for the calendar period in review.  
Stock Transfer In Units Transfer In is a Stock Transaction Type used in Accounting to represent the total Stock which has been Transferred In to the business or Locations for the calendar period in review.  
Stock Transfer In Cost Transfer In is a Stock Transaction Type used in Accounting to represent the total Stock which has been Transferred In to the business or Locations for the calendar period in review.  
Stock Transfer In Retail $ Transfer In is a Stock Transaction Type used in Accounting to represent the total Stock which has been Transferred In to the business or Locations for the calendar period in review.  
Stock Transfer Out Units Transfer Out is a Stock Transaction Type used in Accounting to represent the total Stock which has been Transferred Out to the business or Locations for the calendar period in review.  
Stock Transfer Out Cost Transfer Out is a Stock Transaction Type used in Accounting to represent the total Stock which has been Transferred Out to the business or Locations for the calendar period in review.  
Stock Transfer Out Retail $ Transfer Out is a Stock Transaction Type used in Accounting to represent the total Stock which has been Transferred Out to the business or Locations for the calendar period in review.  
Stock In Transit Movement Units In Transit Movement is a Stock Transaction Type used in Accounting to represent the total Stock which Is currently In Transit between Locations for the calendar period in review.  
Stock In Transit Movement Cost In Transit Movement is a Stock Transaction Type used in Accounting to represent the total Stock which Is currently In Transit between Locations for the calendar period in review.  
Stock In Transit Movement Retail $ In Transit Movement is a Stock Transaction Type used in Accounting to represent the total Stock which Is currently In Transit between Locations for the calendar period in review.  
Stock Other Stock Units Other Stock is a Stock Transaction Type used in Accounting to represent the total Other Stock Movements not covered by any of the other listed Transaction Types for the calendar period in review.  
Stock Other Stock Cost Other Stock is a Stock Transaction Type used in Accounting to represent the total Other Stock Movements not covered by any of the other listed Transaction Types for the calendar period in review.  
Stock Other Stock Retail $ Other Stock is a Stock Transaction Type used in Accounting to represent the total Other Stock Movements not covered by any of the other listed Transaction Types for the calendar period in review.  
Stock Committed CSOH % Units Store Closing Stock on hand as a % of the Total Closing Stock on Hand - the amount of stock committed to a Locations including In Transit Stock.  
Stock Committed CSOH % Cost Store Closing Stock on hand as a % of the Total Closing Stock on Hand - the amount of stock committed to a Locations including In Transit Stock.  
Stock Committed CSOH % Retail $ Store Closing Stock on hand as a % of the Total Closing Stock on Hand - the amount of stock committed to a Locations including In Transit Stock.