Contents Show
The Price Survey Spreadsheet (Output) is used to export the information from a price survey. It is exported in CSV (comma-separated values) format as an Excel spreadsheet. The system will call a function in the data access layer to retrieve the food items defined for the selected price survey. The Distribution Item ID and Description columns will be populated with the data from the template. The Price column will be blank. Users can then type the prices for each food distribution item in the Price column and save the Excel file for later use. The information can be updated for certain columns and then imported on the Price Survey screen or the Rejected Price Survey screen.
The report is generated by doing clicking the Export button on the Price Survey screen or the Rejected Price Survey screen.
This section describes the data elements that print on the system output. Because of space constraints, the layout may be slightly different and/or all characters may not print within the space allotted.
Origin of Data Element
The value is taken from the Include in Average column of the Create New Price List screen.
Format
It displays as a "Y" when the distribution item is included or as an "N" when the distribution item is not included.
Origin of Data Element
The value is taken from the MaxPrice column of the PeerGroupFoodItem table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the Price column of the Create New Price List screen.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the Description column of the FoodDistributionItem table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the Size column of the RetailItems table.
Format
The value prints as its literal value.
Origin of Data Element
The value is taken from the DistributionItemID column of the FoodDistributionItem table.
Format
The value prints as its literal value.
Origin of Data Element
The value is the unique ID for the retail item from the RetailItems table.
Format
The value prints as its literal value.
The template items are sorted by the description of the food distribution item.
|
Software Version: 2.40.00
