Variant Filter Field, Item Table
Displays the filter that filters by item variant.
If the field contains a variant code, the values in the fields that show quantities are based only on entries with the variant code that is included in the filter.
You can enter a maximum of 10 characters, both numbers and letters. There are certain rules for how these can be combined:
| Meaning | Sample Expression | Included |
|---|---|---|
Equal to |
Blue |
Entries with the Blue variant code |
Interval |
1..5 |
Entries with variant codes 1 through 5 |
Either/or |
Paris|Rome |
Entries with either the Paris or Rome variant code |
Different than |
<>AA |
Entries with all variant codes, except AA |
To see the variant codes in the Item Variant table, choose the field.
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| Negative Adjmt. (LCY) Field, Item Table | Inventory |
| Item Table | Inventory |
| Item Table | Inventory |