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.