Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

Item_Inv

  • Last UpdatedDec 18, 2018
  • 1 minute read
  • Add "sublot_no" (string40, nullable) before "grade_cd" to store the sublot of the item stored here.

  • Change "grade_cd" and "status_cd" from non-nullable to nullable so these fields of the lot or sublot tables will be usable as defaults.

  • Add inhibit-delete foreign key from "item_id" and "lot_no" to lot, and from "item_id" , "lot_no", and "sublot_no" to sublot.

  • Add inhibit-delete foreign keys from "grade_cd" to item_grade, and from "status_cd" to item_state.

TitleResults for “How to create a CRG?”Also Available in