Contents Show
The Price List 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 report is generated by clicking the Export button on the Create New Price List 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
This is a blank value.
Format
This is a blank 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
This is a blank value.
Format
This is a blank 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 FoodDistribution table.
Format
The value prints as its literal value.
Origin of Data Element
The value is the unique ID for the retail item.
Format
The value prints as its literal value.
Origin of Data Element
The value is the vendor ID.
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
