FND Design Data [Home] [Help]

Table: PO_ORDR_DTL

Product: GML - Process Manufacturing Logistics
Description: Purchase order lines.
Implementation/DBA Data: TableGML.PO_ORDR_DTL
Primary Key: PO_ORDR_DTL
  1. ColumnLINE_ID
Primary Key: PO_ORDR_DTL_U1
  1. ColumnPO_ID
  2. ColumnLINE_NO
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_ORDR_DTL FK Joins to TableGMD_GRADES_B PO_ORDR_DTL.QC_GRADE_WANTED
PO_ORDR_DTL FK Joins to TableIC_ITEM_MST_B PO_ORDR_DTL.ITEM_ID
PO_ORDR_DTL FK Joins to TableIC_ITEM_MST PO_ORDR_DTL.ITEM_ID
PO_ORDR_DTL FK Joins to TableIC_PRCH_CLS PO_ORDR_DTL.ICPURCH_CLASS
PO_ORDR_DTL FK Joins to TableIC_WHSE_MST PO_ORDR_DTL.FROM_WHSE
PO_ORDR_DTL FK Joins to TableIC_WHSE_MST PO_ORDR_DTL.TO_WHSE
PO_ORDR_DTL FK Joins to TableOP_FOBC_MST PO_ORDR_DTL.FOB_CODE
PO_ORDR_DTL FK Joins to TableOP_FRGT_MTH PO_ORDR_DTL.FRTBILL_MTHD
PO_ORDR_DTL FK Joins to TableOP_GNRC_ITM PO_ORDR_DTL.GENERIC_ID
PO_ORDR_DTL FK Joins to TableOP_SHIP_MST PO_ORDR_DTL.SHIPPER_CODE
PO_ORDR_DTL FK Joins to TableOP_SHIP_MTH PO_ORDR_DTL.SHIP_MTHD
PO_ORDR_DTL FK Joins to TableOP_TERM_MST PO_ORDR_DTL.TERMS_CODE
PO_ORDR_DTL FK Joins to TablePO_BPOS_DTL PO_ORDR_DTL.BPO_LINE_ID
PO_ORDR_DTL FK Joins to TablePO_ORDR_HDR PO_ORDR_DTL.PO_ID
PO_ORDR_DTL FK Joins to TablePO_TEXT_HDR PO_ORDR_DTL.TEXT_CODE
PO_ORDR_DTL FK Joins to TablePO_VEND_MST PO_ORDR_DTL.SHIPVEND_ID
PO_ORDR_DTL FK Joins to TableQC_GRAD_MST PO_ORDR_DTL.QC_GRADE_WANTED
PO_ORDR_DTL FK Joins to TableSY_ADDR_MST PO_ORDR_DTL.RECVADDR_ID
PO_ORDR_DTL FK Joins to TableSY_REAS_CDS_B PO_ORDR_DTL.POHOLD_CODE
PO_ORDR_DTL FK Joins to TableSY_REAS_CDS_B PO_ORDR_DTL.CANCELLATION_CODE
PO_ORDR_DTL FK Joins to TableSY_REAS_CDS PO_ORDR_DTL.POHOLD_CODE
PO_ORDR_DTL FK Joins to TableSY_REAS_CDS PO_ORDR_DTL.CANCELLATION_CODE
PO_ORDR_DTL FK Joins to TableSY_UOMS_MST PO_ORDR_DTL.ORDER_UM1
PO_ORDR_DTL FK Joins to TableSY_UOMS_MST PO_ORDR_DTL.ORDER_UM2
PO_ORDR_DTL FK Joins to TableSY_UOMS_MST PO_ORDR_DTL.PRICE_UM
TablePO_RECV_DTL FK Joins to PO_ORDR_DTL PO_RECV_DTL.POLINE_ID
TablePO_RELS_SCH FK Joins to PO_ORDR_DTL PO_RELS_SCH.POLINE_ID
TablePO_RTRN_DTL FK Joins to PO_ORDR_DTL PO_RTRN_DTL.POLINE_ID