Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
ITEMNMBR | Item Number |
String | 32 | View | |
ITEMSTATUS_I | Item Status |
Integer | 2 | View | |
BOMTYPE_I | BOM Type |
Integer | 2 | View | |
MAKEBUYCODE_I | Make/Buy_Code |
Integer | 2 | View | |
ITEMDESIGNAUTHORIT_I | Item Design Authority |
String | 102 | View | |
EFFECTIVEDATE_I | Effective Date0 |
Date | 4 | View | |
REVISIONLEVEL_I | Revision Level |
String | 52 | View | |
CHANGEDATE_I | Change Date |
Date | 4 | View | |
USERID | User ID |
String | 16 | View | |
DWGNUM_I | DWG # |
String | 32 | View | |
DWGSIZE_I | DWG Size |
String | 4 | View | |
ABCCODE_I | ABC_Code |
Integer | 2 | View | |
FLOORSTOCK_I | Floor Stock |
Boolean | 2 | View | |
ITEMUSEUP_I | Item Use Up? |
Boolean | 2 | View | |
CALCMRP_I | Calc MRP |
Boolean | 2 | View | |
QAQCNEEDED_I | QA/QC Needed |
Boolean | 2 | View | |
MINIMUMISSUE_I | Minimum Issue |
Currency | 10 | View | |
IVCARRYINGCOST_I | IV Carrying Cost |
Currency | 10 | View | |
IVSETUPCOST_I | IV Setup Cost |
Currency | 10 | View | |
AVERAGEORDQTY_I | Average ORD QTY |
Currency | 10 | View | |
SHRINKAGEPERCENT_I | Shrinkage% |
Long Integer | 4 | View | |
DESTTESTINGREQD_I | Destructive Testing Required |
Boolean | 2 | View | |
ALTERNATE_I | Alternate |
Boolean | 2 | View | |
SHIPPINGUOFM_I | Shipping U Of M |
Integer | 2 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
MFGNOTEINDEX_I | MFG Note Index |
Currency | 10 | View | |
ITEMFULFILLMETHOD | Item Fulfillment Method |
Integer | 2 | View | |
LLC | LLC |
Long Integer | 4 | View | |
RUNNUMBER | MRP_Run_Number |
Long Integer | 4 | View | |
FG_STD_QTY_I | FG Standard Quantity |
Currency | 10 | View | |
QASTDATE | QA Start Date |
Date | 4 | View | |
QAENDDATE | QA End Date |
Date | 4 | View | |
DAYTOEXP | Days To Expire |
Integer | 2 | View | |
INCL_EXP_TO_ENG | Include In Export To Engineering |
Boolean | 2 | View | |
ISCHANGD | IsChanged |
Boolean | 2 | View |