| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| ECNumber | ECNumber |
String | 16 | View | |
| ITEMNMBR | Item Number |
String | 32 | View | |
| PPN_I | PPN |
String | 32 | View | |
| MANUFACTUREORDER_I | Manufacture Order |
String | 32 | View | |
| SALESORDERNUMBER_I | Sales Order Number |
String | 18 | View | |
| SOPNUMBE | SOP Number |
String | 22 | View | |
| PORDNMBR | Purchase Order Number |
String | 22 | View | |
| ROUTINGNAME_I | RoutingName |
String | 32 | View | |
| USERID | User ID |
String | 16 | View | |
| CHANGEDATE_I | Change Date |
Date | 4 | View | |
| MFGNOTEINDEX_I | MFG Note Index |
Currency | 10 | View |