| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| AD_Item_Saved | AD Item Saved |
Boolean | 2 | View | |
| ADDSGNAUTH | AD Design Authority |
String | 102 | View | |
| ADBUY | AD Buy |
Boolean | 2 | View | |
| ADREVNMBR | AD Revision Number |
String | 52 | View | |
| ITEMTYPE | Item Type 1. Sales Inventory (For SBM, this type is Stock Item.) |
Integer | 2 | View | |
| AD_ItemExists | AD ItemExists |
Boolean | 2 | View | |
| ADITEMNMBR | AD Item Number |
String | 52 | View | |
| ITMCLSCD | Item Class Code |
String | 12 | View | |
| UOFM | U Of M |
String | 10 | View | |
| UOMSCHDL | U Of M Schedule |
String | 12 | View | |
| ADITEMDESC | AD Item Description |
Text | 2 | View |