FND Design Data [Home] [Help]

Table: OP_CUST_SHP

Product: GML - Process Manufacturing Logistics
Description: Preferred shippers (carriers) and ship methods for customers.
Implementation/DBA Data: TableGML.OP_CUST_SHP
Primary Key: OP_CUST_SHP_PK
  1. ColumnCUSTSHIP_ID
Primary Key: OP_CUST_SHP_U1
  1. ColumnCUST_ID
  2. ColumnWHSE_CODE
  3. ColumnICSHIP_CLASS
  4. ColumnSHIP_MTHD
  5. ColumnSHIPPER_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
OP_CUST_SHP FK Joins to TableOP_TEXT_HDR OP_CUST_SHP.TEXT_CODE
OP_CUST_SHP FK Joins to TableIC_SHIP_CLS OP_CUST_SHP.ICSHIP_CLASS
OP_CUST_SHP FK Joins to TableIC_WHSE_MST OP_CUST_SHP.WHSE_CODE
OP_CUST_SHP FK Joins to TableOP_CUST_MST OP_CUST_SHP.CUST_ID
OP_CUST_SHP FK Joins to TableOP_SHIP_MST OP_CUST_SHP.SHIPPER_CODE
OP_CUST_SHP FK Joins to TableOP_SHIP_MTH OP_CUST_SHP.SHIP_MTHD