| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| ITEMNMBR | Item Number |
String | 32 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CUSTITEMNMBR | Customer Item Number |
String | 32 | View | |
| CUSTITEMDESC | Customer Item Description |
String | 52 | View | |
| CUSTITEMSHORNAME | Customer Item Short Name |
String | 16 | View | |
| CUSTITEMGENERICDESC | Customer Item Generic Description |
String | 12 | View | |
| USERDEF1 | User Defined 1 |
String | 22 | View | |
| USERDEF2 | User Defined 2 |
String | 22 | View | |
| USRDEF03 | User Defined 3 |
String | 22 | View | |
| USRDEF04 | User Defined 4 |
String | 22 | View | |
| USRDEF05 | User Defined 5 |
String | 22 | View | |
| USERDEFKEY1 | User Defined Key1 |
String | 52 | View | |
| USERDEFKEY2 | User Defined Key2 |
String | 52 | View | |
| USERDEFKEY3 | User Defined Key3 |
String | 52 | View | |
| USERDEFKEY4 | User Defined Key4 |
String | 52 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View |