Named Calculations
You create a named calculation by combining a rule type, which you select from a preset group of rule types, with the data in selected tables (entities) in the JD Edwards EnterpriseOne Blend Management system from Oracle. Eight entities and five rule types are available to be selected when you are creating a named calculation. Each named calculation contains a name and column title. The system enables additional fields based on the combination of rule type and entity for each named calculation. You select values from two hard-coded user-defined codes (UDCs), 31B/EN for entities and UDC 31B/NC for rule types. The entities UDC (31B/EN) is based on data in the following tables:
Blend Lot Master (F31B31)
Lot Composition (F31B311)
Test Results (F3711)
Lot Style (F31B314)
Lot Owners (F31B315)
Lot EUR (F31B316)
Lot Accumulated Additives (F31B318)
The type of entity that you select determines the rule type that you can select and the information that you can enter for the named calculation. The rule type UDC 31B/NC uses values from fields in the previous list of tables and contains one of the following calculations:
Selected single
Use this calculation to locate a specific field and display the value in that field. For example, locate and display the value in the Material Type field.
Selected numeric
Use this calculation to locate a specific amount or value in a specific numeric field and display a string value, for example, to locate and display the owner with the largest ownership percentage.
Values in this rule type might include largest, second largest, smallest, average, and total.
Selected string
Use this calculation to locate a specific value in a specific alphanumeric field and display a numeric, string, or date value, for example, to locate and display the ownership percentage of an owner.
This calculation can also locate and display a date. For example, it can locate and display the sample date for a particular test result name.
This rule type might include the following values: equal to, not equal to, greater than, greater than or equal to, less than, or less than or equal to.
Value
Use this calculation for totals or a count. For example, locate and display the total cost for a lot or locate and display the total number of owners for a lot.
Values in this rule type might include total or count.
Custom
Use this calculation only when you need a custom function. This calculation type can use all fields, including a custom function field, which is unavailable for all other calculation types.
The entity and rule type that you select determine which fields are available for input and the values that you can select in the fields when creating the named calculation. Additionally, all named calculations contain the Entity Field to Return fields. These rule types contain the following additional fields that you use to build each of the different named calculation types:
Selected numeric calculation
Entity Field to Find
Rule
Where Field
Value To Evaluate
Threshold
Entity Field to Select
Selected string calculation
Rule
Value to Evaluate
Entity Field to Return
Value calculation
Rule
Entity Field to Find
The following tables and lists contain the possible combinations of calculation rules and available fields for each entity. An asterisk (*) indicates that you must enter a value in that field. All other fields contain the value you must select for that field for that particular named calculation.
Selected numeric named calculations for composition use composition data from the F31B311 table, and the value in the Entity Field to Find field must be Percentage.
Rule |
Threshold |
Entity Field to Select |
Entity Field to Select |
Entity Field to Select |
Entity Field to Return |
Entity Field to Return |
Entity Field to Return |
|---|---|---|---|---|---|---|---|
Largest |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Largest |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Largest |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Second Largest |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Largest |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Largest |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Largest |
Leave blank |
Source Identifier |
Leave blank |
Leave blank |
Grower ID |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Source Identifier |
Leave blank |
Leave blank |
Grower ID |
Leave blank |
Leave blank |
Largest |
Leave blank |
Composition Material Type |
Leave blank |
Leave blank |
Composition Material Type |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Composition Material Type |
Leave blank |
Leave blank |
Composition Material Type |
Leave blank |
Leave blank |
Largest |
Leave blank |
Source Type |
Leave blank |
Leave blank |
Source Type |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Source Type |
Leave blank |
Leave blank |
Source Type |
Leave blank |
Leave blank |
Largest |
Leave blank |
Source Identifier |
Leave blank |
Leave blank |
Source Identifier |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Source Identifier |
Leave blank |
Leave blank |
Source Identifier |
Leave blank |
Leave blank |
Largest |
Leave blank |
Grower ID |
Leave blank |
Leave blank |
Grower ID |
Leave blank |
Leave blank |
Second Largest |
Leave blank |
Grower ID |
Leave blank |
Leave blank |
Grower ID |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Leave blank |
Leave blank |
Appellation |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Leave blank |
Appellation |
Code - Variety |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Leave blank |
Code - Variety |
Appellation |
Leave blank |
Largest |
* |
Appellation |
Year - Harvest Period |
Leave blank |
Appellation |
Year - Harvest Period |
Leave blank |
Largest |
* |
Appellation |
Year - Harvest Period |
Leave blank |
Year - Harvest Period |
Appellation |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Appellation |
Code - Variety |
Year - Harvest Period |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Appellation |
Year - Harvest Period |
Code - Variety |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Code - Variety |
Appellation |
Year - Harvest Period |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Code - Variety |
Year - Harvest Period |
Appellation |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Year - Harvest Period |
Appellation |
Code - Variety |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Year - Harvest Period |
Code - Variety |
Appellation |
Largest |
* |
Appellation |
Code - Variety |
Leave blank |
Appellation |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Year - Harvest Period |
Leave blank |
Appellation |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Year - Harvest Period |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Appellation |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Code - Variety |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Year - Harvest Period |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Appellation |
Code - Variety |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Code - Variety |
Appellation |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Appellation |
Year - Harvest Period |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Year - Harvest Period |
Appellation |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Code - Variety |
Year - Harvest Period |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Year - Harvest Period |
Code - Variety |
Leave blank |
Largest |
* |
Appellation |
Leave blank |
Leave blank |
Percentage |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Leave blank |
Percentage |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Year - Harvest Period |
Leave blank |
Percentage |
Leave blank |
Leave blank |
Largest |
* |
Appellation |
Code - Variety |
Year - Harvest Period |
Percentage |
Leave blank |
Leave blank |
Largest |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Percentage |
Leave blank |
Leave blank |
Largest |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Percentage |
Leave blank |
Leave blank |
Largest |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Percentage |
Leave blank |
Leave blank |
Selected string named calculations for composition use composition data from the F31B311 table, and the value in the Entity Field to Return field must be Percentage.
Entity Field to Find |
Entity Field to Find |
Entity Field to Find |
Rule |
Value to Evaluate |
Value to Evaluate |
Value to Evaluate |
|---|---|---|---|---|---|---|
Code - Variety |
Leave blank |
Leave blank |
Equal To |
* |
Leave blank |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Equal To |
* |
Leave blank |
Leave blank |
Appellation |
Leave blank |
Leave blank |
Equal To |
* |
Leave blank |
Leave blank |
Appellation |
Code - Variety |
Leave blank |
Equal To |
* |
* |
Leave blank |
Appellation |
Year - Harvest Period |
Leave blank |
Equal To |
* |
* |
Leave blank |
Appellation |
Code - Variety |
Year - Harvest Period |
Equal To |
* |
* |
* |
Code - Variety |
Year - Harvest Period |
Leave blank |
Equal To |
* |
* |
Leave blank |
Composition Material Type |
Leave blank |
Leave blank |
Equal To |
* |
Leave blank |
Leave blank |
Source Type |
Leave blank |
Leave blank |
Equal To |
* |
Leave blank |
Leave blank |
Source Identifier |
Leave blank |
Leave blank |
Equal To |
* |
Leave blank |
Leave blank |
Grower ID |
Leave blank |
Leave blank |
Equal To |
* |
Leave blank |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Greater Than |
* |
Leave blank |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Greater Than or Equal To |
* |
Leave blank |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Less Than |
* |
Leave blank |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Less Than or Equal To |
* |
Leave blank |
Leave blank |
Code - Variety |
Leave blank |
Leave blank |
Not Equal To |
* |
Leave blank |
Leave blank |
Year - Harvest Period |
Leave blank |
Leave blank |
Not Equal To |
* |
Leave blank |
Leave blank |
Code - Variety |
Year - Harvest Period |
Leave blank |
Not Equal To |
* |
* |
Leave blank |
Composition Material Type |
Leave blank |
Leave blank |
Not Equal To |
* |
Leave blank |
Leave blank |
Source Type |
Leave blank |
Leave blank |
Not Equal To |
* |
Leave blank |
Leave blank |
Source Identifier |
Leave blank |
Leave blank |
Not Equal To |
* |
Leave blank |
Leave blank |
Grower ID |
Leave blank |
Leave blank |
Not Equal To |
* |
Leave blank |
Leave blank |
Selected string named calculations for costs use cost data from the Blend Lot Costs table (F31B31C), and the value in the Entity Field to Find field must be Cost Component.
Rule |
Value to Evaluate |
Entity Field to Find |
|---|---|---|
Equal To |
* |
Amount - Unit Cost |
Equal To |
* |
Unit Cost |
Value cost named calculations use cost data from the F31B31C table, and the value in the Entity Field to Find field must be cost component.
Rule |
Entity Field to Find |
|---|---|
Total |
Amount - Unit Cost |
Selected string named calculations for QA use QA results data from the Test Results table (F3711). Enter the following values in the following fields:
Entity Field to Find: Test Result Name
Rule: Equal To
Value to Evaluate: *
Entity Field to Return
Test Value
From Result Value
Result Expiration Date
Test ID
Date Tested
You can set named calculations for QA results to return numeric values as well. To obtain numeric calculation results, the following conditions must be met:
If you want to display a numeric value for the test value, you must select the Numeric option for the test definition. The system does not check this setting until the return value is actually calculated
If you want to display a numeric value for the From result value, you must select the Numeric option for the test result name. The system checks this setting when you create the named calculation.
Selected numeric named calculations for style use style data from the Lot Style table (F31B314), and the value in the Entity Field to Find field must be Unit - Style Value.
Rule |
Where Field |
Value to Evaluate |
Entity Field to Return |
|---|---|---|---|
Largest |
Style category code 1 |
UDC 31B/T1 |
Code - Style Item |
Second Largest |
Style category code 1 |
UDC 31B/T1 |
Code - Style Item |
Smallest |
Style category code 1 |
UDC 31B/T1 |
Code - Style Item |
Largest |
Style category code 1 |
UDC 31B/T1 |
Unit - Style Value |
Second Largest |
Style category code 1 |
UDC 31B/T1 |
Unit - Style Value |
Smallest |
Style category code 1 |
UDC 31B/T1 |
Unit - Style Value |
Average |
Style category code 1 |
UDC 31B/T1 |
Unit - Style Value |
Total |
Style category code 1 |
UDC 31B/T1 |
Unit - Style Value |
Largest |
Style category code 2 |
UDC 31B/T2 |
Code - Style Item |
Second Largest |
Style category code 2 |
UDC 31B/T2 |
Code - Style Item |
Smallest |
Style category code 2 |
UDC 31B/T2 |
Code - Style Item |
Largest |
Style category code 2 |
UDC 31B/T2 |
Unit - Style Value |
Second Largest |
Style category code 2 |
UDC 31B/T2 |
Unit - Style Value |
Smallest |
Style category code 2 |
UDC 31B/T2 |
Unit - Style Value |
Average |
Style category code 2 |
UDC 31B/T2 |
Unit - Style Value |
Total |
Style category code 2 |
UDC 31B/T2 |
Unit - Style Value |
Selected string named calculations for style use style data from the F31B314 table, and the value in the Entity Field to Find field must be Code - Style Item.
Rule |
Value to Evaluate |
Entity Field to Return |
|---|---|---|
Equal To |
* |
Unit - Style Value |
Not Equal To |
* |
Unit - Style Value |
Selected numeric named calculations for owners use owner data from the Lot Owners table (F31B315), and the value in the Rule field must be Largest.
Entity Field to Find |
Entity Field to Return |
|---|---|
Blend Lot Quantity |
Owner Short Code |
Percentage |
Owner Short Code |
Blend Lot Quantity |
Blend Lot Quantity |
Percentage |
Percentage |
Selected string named calculations for owners use owner data from the Lot Owners table (F31B315), and the value in the Entity Field to Find field must be Owner Short Code.
Rule |
Value to Evaluate |
Entity Field to Return |
|---|---|---|
Equal To |
* |
Blend Lot Quantity |
Equal To |
* |
Percentage |
Not Equal To |
* |
Blend Lot Quantity |
Not Equal To |
* |
Percentage |
Selected numeric named calculations for EUR use EUR data from the Lot EUR table (F31B316), and the value in the Rule field must be Largest.
Entity Field to Find |
Entity Field to Return |
|---|---|
Blend Lot Quantity |
EUR Short Code |
Percentage |
EUR Short Code |
Blend Lot Quantity |
Blend Lot Quantity |
Percentage |
Percentage |
Selected string named calculations for EUR use EUR data from the F31B316 table, and the value in the Entity Field to Find field must be EUR Short Code.
Rule |
Value to Evaluate |
Entity Field to Return |
|---|---|---|
Equal To |
* |
Blend Lot Quantity |
Equal To |
* |
Percentage |
Not Equal To |
* |
Blend Lot Quantity |
Not Equal To |
* |
Percentage |
Value EUR named calculations use EUR data from the F31B316 table. Enter the following values in the following fields:
Entity Field to Find: EUR Code
Rule: Count
Entity Field to Return: Total Number of EURs
Selected string named calculation for accumulated additives uses accumulated additives data from the Lot Accumulated Additives table (F31B318). Enter the following values in the following fields:
Entity Field to Find: Short Item Number
Rule: Equal To
Value to Evaluate: *
Entity Field to Return:
Active Additive Quantity
Additive Quantity in Lot UOM
Selected single named calculations for lot headers use lot master data from the Blend Lot Master table (F31B31). Enter the following values in the Entity Field to Return field:
Instructed Attribute 1 through 12
Summary Attribute 1 through 25
Wine Status Short Code
Blend Lot Status
Material Type Code