FND Design Data [Home] [Help]

Table: OP_CNTR_DTL

Product: GML - Process Manufacturing Logistics
Description: Item prices on a contract.
Implementation/DBA Data: TableGML.OP_CNTR_DTL
Primary Key: OP_CNTR_DTL_PK
  1. ColumnPRICE_ID
Primary Key: OP_CNTR_DTL_U1
  1. ColumnCONTRACT_ID
  2. ColumnPRICE_CLASS
  3. ColumnITEM_ID
  4. ColumnQC_GRADE
  5. ColumnWHSE_CODE
  6. ColumnPRICE_UM
  7. ColumnFRTBILL_MTHD
  8. ColumnLINE_NO
Foreign Keys
Table
Foreign Table Foreign Key Column
OP_CNTR_DTL FK Joins to TableGMD_GRADES_B OP_CNTR_DTL.QC_GRADE
OP_CNTR_DTL FK Joins to TableIC_ITEM_MST_B OP_CNTR_DTL.ITEM_ID
OP_CNTR_DTL FK Joins to TableIC_ITEM_MST OP_CNTR_DTL.ITEM_ID
OP_CNTR_DTL FK Joins to TableIC_PRCE_CLS OP_CNTR_DTL.PRICE_CLASS
OP_CNTR_DTL FK Joins to TableOP_CNTR_HDR OP_CNTR_DTL.CONTRACT_ID
OP_CNTR_DTL FK Joins to TableOP_FRGT_MTH OP_CNTR_DTL.FRTBILL_MTHD
OP_CNTR_DTL FK Joins to TableOP_TEXT_HDR OP_CNTR_DTL.TEXT_CODE
OP_CNTR_DTL FK Joins to TableQC_GRAD_MST OP_CNTR_DTL.QC_GRADE
OP_CNTR_DTL FK Joins to TableSY_UOMS_MST OP_CNTR_DTL.PRICE_UM
TableOP_CNTR_BRK FK Joins to OP_CNTR_DTL OP_CNTR_BRK.PRICE_ID