FND Design Data [Home] [Help]

Table: OP_PRSL_DTL

Product: GML - Process Manufacturing Logistics
Description: Order profile lines and blanket sales order lines.
Implementation/DBA Data: TableGML.OP_PRSL_DTL
Primary Key: OP_PRSL_DTLI1
  1. ColumnPRESALES_ORD_ID
  2. ColumnPRESALES_ORDLINE_NO
Primary Key: OP_PRSL_DTL_PK
  1. ColumnPRESALES_ORDLINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OP_PRSL_DTL FK Joins to TableGL_CURR_MST OP_PRSL_DTL.BILLING_CURRENCY
OP_PRSL_DTL FK Joins to TableGMD_GRADES_B OP_PRSL_DTL.QC_GRADE_WANTED
OP_PRSL_DTL FK Joins to TableIC_ITEM_MST_B OP_PRSL_DTL.ITEM_ID
OP_PRSL_DTL FK Joins to TableIC_ITEM_MST OP_PRSL_DTL.ITEM_ID
OP_PRSL_DTL FK Joins to TableIC_WHSE_MST OP_PRSL_DTL.FROM_WHSE
OP_PRSL_DTL FK Joins to TableOP_COMMISSION OP_PRSL_DTL.COMMISSION_CODE
OP_PRSL_DTL FK Joins to TableOP_CUST_CON OP_PRSL_DTL.CONTACT_ID
OP_PRSL_DTL FK Joins to TableOP_CUST_MST OP_PRSL_DTL.BILLCUST_ID
OP_PRSL_DTL FK Joins to TableOP_CUST_MST OP_PRSL_DTL.SHIPCUST_ID
OP_PRSL_DTL FK Joins to TableOP_CUST_MST OP_PRSL_DTL.CONSIGNEE_ID
OP_PRSL_DTL FK Joins to TableOP_CUST_MST OP_PRSL_DTL.ULTIMATE_SHIPCUST_ID
OP_PRSL_DTL FK Joins to TableOP_CUST_MST OP_PRSL_DTL.SOLDTOCUST_ID
OP_PRSL_DTL FK Joins to TableOP_FRGT_MTH OP_PRSL_DTL.FRTBILL_MTHD
OP_PRSL_DTL FK Joins to TableOP_GNRC_ITM OP_PRSL_DTL.GENERIC_ID
OP_PRSL_DTL FK Joins to TableOP_HOLD_CDS OP_PRSL_DTL.HOLDREAS_CODE
OP_PRSL_DTL FK Joins to TableOP_LKBX_MST OP_PRSL_DTL.REMIT_TO_LOCKBOX
OP_PRSL_DTL FK Joins to TableOP_PKGD_ITM OP_PRSL_DTL.SALESPKG_ID
OP_PRSL_DTL FK Joins to TableOP_PORT_MST OP_PRSL_DTL.EMBARKATION_PORT
OP_PRSL_DTL FK Joins to TableOP_PORT_MST OP_PRSL_DTL.DEBARKATION_PORT
OP_PRSL_DTL FK Joins to TableOP_PRSL_HDR OP_PRSL_DTL.PRESALES_ORD_ID
OP_PRSL_DTL FK Joins to TableOP_SHIP_MST OP_PRSL_DTL.SHIPPER_CODE
OP_PRSL_DTL FK Joins to TableOP_SHIP_MTH OP_PRSL_DTL.SHIP_MTHD
OP_PRSL_DTL FK Joins to TableOP_SLSR_MST OP_PRSL_DTL.SLSREP_CODE
OP_PRSL_DTL FK Joins to TableOP_TERM_MST OP_PRSL_DTL.TERMS_CODE
OP_PRSL_DTL FK Joins to TableOP_TEXT_HDR OP_PRSL_DTL.TEXT_CODE
OP_PRSL_DTL FK Joins to TableQC_GRAD_MST OP_PRSL_DTL.QC_GRADE_WANTED
OP_PRSL_DTL FK Joins to TableSY_ADDR_MST OP_PRSL_DTL.SHIPADDR_ID
OP_PRSL_DTL FK Joins to TableSY_UOMS_MST OP_PRSL_DTL.ORDER_UM1
OP_PRSL_DTL FK Joins to TableSY_UOMS_MST OP_PRSL_DTL.ORDER_UM2
TableOP_ORDR_DTL FK Joins to OP_PRSL_DTL OP_ORDR_DTL.PRESALES_ORDLINE_ID
TableOP_PRSL_CHG FK Joins to OP_PRSL_DTL OP_PRSL_CHG.PRESALES_ORDLINE_ID
TableOP_RELS_SCH FK Joins to OP_PRSL_DTL OP_RELS_SCH.PRESALES_ORDLINE_ID