Table Information for the Manage Parts Screen

Changes to the Manage Parts screen update the ITEM and PART tables.

Information for standard parts is also stored in and/or pulled from the following tables:

  • ABC_CLASSIF
  • ALT_PART
  • BOM_CONFIG
  • BUYER
  • COMM
  • DOC_TYPE
  • DOCUMENT
  • EQUIP
  • GENL_LAB_CAT
  • INVT, INVT_ABBRV_CD, INVT_PROJ, INVT_WHSE_LOC
  • ITEM_CST, ITEM_LT, ITEM_PRODUCT, ITEM_SETTINGS, ITEM_TEXT, ITEM_UDEF, ITEM_UM, ITEM_VEND
  • MANUF
  • MFG_BOM
  • MO_HDR, MO_RQMT
  • MRP_SETTINGS_CORP
  • OPERATION, OPERATION_EQUIP, OPERATION_LAB, OPERATION_NOTES, OPERATION_RATES, OPERATION_TEXT
  • ORG
  • PART_DOCUMENT, PART_PREF_TYPE, PART_PROJ
  • PLANNER
  • PO_LN
  • PROD_CLASSIF, PROD_TYPE
  • PROJ_EDIT, PROJ_SUBST_PART, PROV_PART
  • RECPT_LN
  • ROUTING_CONFIG, ROUTING_HDR, ROUTING_LN, ROUTING_LN_DOC, ROUTING_LN_EQUIP, ROUTING_LN_LAB, ROUTING_LN_NOTES, ROUTING_LN_TEXT
  • RQ_LN
  • RU_LAB_CLASSIF, RU_PROC_TYPE, RU_SETTINGS
  • S_ITEM_CST_TYPE
  • S_LOC_TYPE
  • S_LT_TYPE
  • S_ORD_POLICY_TYPE
  • S_PART_TYPE
  • S_PLAN_TYPE
  • S_STATUS_TYPE
  • S_WHERE_USED
  • SERIAL_LOT
  • SKILL
  • SO_LN
  • STD_TEXT
  • SUBST_PART
  • TEXT_WHERE_USED
  • UDEF_LBL
  • UM
  • VEND
  • WC_ALTERNATES, WC_CAP_RATES, WC_EQUIP, WC_LAB
  • WHSE, WHSE_LOC
  • WORKCENTER