Understanding Summary Attributes
Set up summary attributes to display the most significant details of a blend lot. You can use summary attributes to report and search on blend lots and search on child entity attributes. The system provides 25 summary attributes, 15 of which are numeric and 10 of which are strings.
The following table lists examples of summary attributes and how you can set them up:
Summary Attribute |
Description |
|---|---|
Composition |
You can set up composition to display the most predominant varieties, appellations, and harvest periods and their percentages. You can also display multiple varieties, harvest periods, percentages, and the most predominant grower. |
EUR |
You can set up blend lots to have single or multiple EURs. You can display the largest EUR for the purpose of sorting, searching, and reporting. EURs can be set to the volume, percent, or short code of the largest EUR. |
Ownership |
You can set up blend lots to have single or multiple owners. You can display the largest owner for the purpose of sorting, searching, and reporting. An owner can be set to the volume, percent, or short code of the largest owner. |
Style |
Blend lots can have many styles that are assigned and carry values over the life of the bulk material. Set up styles as a summary attribute for searching, sorting, and managing blend lots. You can display the short code or value of the largest style, second largest style, or smallest style. Additionally, you can display the average, minimum, or maximum value of a group of styles. If you summarize by style, the styles must belong to the same data type. |
Accumulated additives |
Specific accumulated additive values are critical measures for sorting, searching, and organizing blend lots. You can set up summary attributes to display the value for a specific accumulated additive. |
Quality Analysis (QA) Results |
You can set up blend lots to display QA results for test result names. You can set up summary attributes to display the test result, test date, or expiration date. You can set up summary attributes related to QA results as with a string or numeric data type. If you set up this summary attributes related to QA results as numeric, you can use the comparison functionality in the QBE line to filter search results by quality attribute. |
To create summary attributes, you must first generate summary attribute records by using the Create Attributes option on the form menu of the View Summary Attribute Definitions form. After you generate the records, you can provide a detailed definition for each summary attribute.
After you have created a descriptive name and definition for a summary attribute, the system displays the descriptive name whenever summary attributes are used in the system. You can view summary attributes with their descriptive names in the following programs:
Stand alone Barrel Inquiry (P31B03E)
Barrel Inquiry From Inventory Vessel View (P31B03IE)
Instruct Lot Attributes (P31B30)
Wine Lot View (P31B31)
Operation Trace/Track (P31B60)
View End Lots (P31B61)
Inventory by Vessel View (P31B81)
Search for Trial Blend (P31B320)