Number | Description |
---|
1 | All ExceptPercent (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | MCU | Business Unit | Ascending | 2 | WLOTN | Blend Lot Number | Ascending | 3 | HARPER | Harvest Period | Ascending | 4 | VARID | Variety ID | Ascending | 5 | APPID | Appellation ID | Ascending | 6 | CMATYPE | Composition Material Type | Ascending | 7 | SRCETYPE | Source Type | Ascending | 8 | SRCEID | Source Identifier | Ascending |
|
2 | Winery WineLot Variety |
| Element | Alias | Description | Sequence |
---|
1 | MCU | Business Unit | Ascending | 2 | WLOTN | Blend Lot Number | Ascending | 3 | VARID | Variety ID | Ascending |
|
3 | Winery WineLot Vintage |
| Element | Alias | Description | Sequence |
---|
1 | MCU | Business Unit | Ascending | 2 | WLOTN | Blend Lot Number | Ascending | 3 | HARPER | Harvest Period | Ascending |
|
4 | Winery WineLot GeoID +A |
| Element | Alias | Description | Sequence |
---|
1 | MCU | Business Unit | Ascending | 2 | WLOTN | Blend Lot Number | Ascending | 3 | APPID | Appellation ID | Ascending | 4 | VARID | Variety ID | Ascending | 5 | HARPER | Harvest Period | Ascending |
|
5 | Winery WineLot Variety +B |
| Element | Alias | Description | Sequence |
---|
1 | MCU | Business Unit | Ascending | 2 | WLOTN | Blend Lot Number | Ascending | 3 | VARID | Variety ID | Ascending | 4 | HARPER | Harvest Period | Ascending |
|
6 | Appellation |
| Element | Alias | Description | Sequence |
---|
1 | APPID | Appellation ID | Ascending |
|
7 | Variety |
| Element | Alias | Description | Sequence |
---|
1 | VARID | Variety ID | Ascending |
|
8 | Grower |
| Element | Alias | Description | Sequence |
---|
1 | GROWAREA | Growing Area | Ascending |
|
9 | MCU WLOTN BLUID HARPER HARSFX |
| Element | Alias | Description | Sequence |
---|
1 | MCU | Business Unit | Ascending | 2 | WLOTN | Blend Lot Number | Ascending | 3 | BLUID | Block Identifier | Ascending | 4 | HARPER | Harvest Period | Ascending | 5 | HARSFX | Harvest Suffix | Ascending |
|