| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PPN_I | PPN |
String | 32 | View | |
| ITEMNMBR | Item Number |
String | 32 | View | |
| CHANGENUMBER_I | Change Number |
Integer | 2 | View | |
| DESCRIPTIN50 | IC_Description |
String | 52 | View | |
| UNIT_I | Unit |
String | 12 | View | |
| ADDCHG_I | Add Chg |
String | 16 | View | |
| DATE1 | Date |
Date | 4 | View | |
| TIME1 | Time |
Time | 4 | View | |
| QUANTITY_I | Quantity |
Currency | 10 | View | |
| OPTPERCENT_I | OPT Percent |
Long Integer | 4 | View | |
| SCRAPPERCENT_I | Scrap Percent |
Long Integer | 4 | View | |
| ALTERNATE_I | Alternate |
Boolean | 2 | View | |
| ALTERNATEPARTFOR_I | Alternate Part For |
String | 32 | View | |
| LEADTIMEOFFSET_I | Lead Time Offset |
Currency | 10 | View | |
| BOMUSERDEF1_I | BOM User Def1 |
String | 32 | View | |
| BOMUSERDEF2_I | BOM User Def2 |
String | 32 | View | |
| BOMSINGLELOT_I | BOM_Single_Lot |
Boolean | 2 | View | |
| BOMENGAPPROVAL_I | BOM_Eng_Approval |
Boolean | 2 | View | |
| WCID_I | WC ID |
String | 12 | View |