FND Design Data [Home] [Help]

Table: IC_PHYS_CNT

Product: GMI - Process Manufacturing Inventory
Description: Physical inventory and cycle counts
Implementation/DBA Data: TableGMI.IC_PHYS_CNT
Primary Key: IC_PHYS_CNT_PK
  1. ColumnCYCLE_ID
  2. ColumnCOUNT_NO
  3. ColumnITEM_ID
  4. ColumnWHSE_CODE
  5. ColumnLOT_ID
  6. ColumnLOCATION
Foreign Keys
Table
Foreign Table Foreign Key Column
IC_PHYS_CNT FK Joins to TableGMD_GRADES_B IC_PHYS_CNT.GRADE_CODE
IC_PHYS_CNT FK Joins to TableIC_TEXT_HDR IC_PHYS_CNT.TEXT_CODE
IC_PHYS_CNT FK Joins to TableQC_GRAD_MST IC_PHYS_CNT.GRADE_CODE
IC_PHYS_CNT FK Joins to TableSY_REAS_CDS_B IC_PHYS_CNT.REASON_CODE
IC_PHYS_CNT FK Joins to TableSY_REAS_CDS IC_PHYS_CNT.REASON_CODE