FND Design Data [Home] [Help]

Table: PO_VEND_MST

Product: GML - Process Manufacturing Logistics
Description: Vendor master.
Implementation/DBA Data: TableGML.PO_VEND_MST
Primary Key: PO_VEND_MSTI1
  1. ColumnCO_CODE
  2. ColumnVENDOR_NO
Primary Key: PO_VEND_MSTI2
  1. ColumnVENDOR_NO
  2. ColumnVENDSORT_NO
  3. ColumnVENDOR_NAME
  4. ColumnCO_CODE
  5. ColumnINACTIVE_IND
  6. ColumnDELETE_MARK
Primary Key: PO_VEND_MST_PK
  1. ColumnVENDOR_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PO_VEND_MST FK Joins to TableGL_CURR_MST PO_VEND_MST.DEFAULT_CURRENCY
PO_VEND_MST FK Joins to TableOP_FRGT_MTH PO_VEND_MST.FRTBILL_MTHD
PO_VEND_MST FK Joins to TableOP_TERM_MST PO_VEND_MST.TERMS_CODE
PO_VEND_MST FK Joins to TablePO_TEXT_HDR PO_VEND_MST.TEXT_CODE
PO_VEND_MST FK Joins to TablePO_VEND_CLS PO_VEND_MST.VEND_CLASS
PO_VEND_MST FK Joins to TablePO_VGLD_CLS PO_VEND_MST.VENDGL_CLASS
PO_VEND_MST FK Joins to TablePO_VTRD_CLS PO_VEND_MST.VENDTRADE_CLASS
PO_VEND_MST FK Joins to TableSY_ADDR_MST PO_VEND_MST.ADDR_ID
PO_VEND_MST FK Joins to TableSY_ADDR_MST PO_VEND_MST.MAILADDR_ID
PO_VEND_MST FK Joins to TableSY_ORGN_MST_B PO_VEND_MST.CO_CODE
PO_VEND_MST FK Joins to TableSY_ORGN_MST PO_VEND_MST.CO_CODE
TableGL_ACCT_MAP FK Joins to PO_VEND_MST GL_ACCT_MAP.VENDOR_ID
TableIC_LOTS_MST FK Joins to PO_VEND_MST IC_LOTS_MST.SHIPVEND_ID
TableOP_GNRC_ITM FK Joins to PO_VEND_MST OP_GNRC_ITM.VENDOR_ID
TablePO_BPOS_DTL FK Joins to PO_VEND_MST PO_BPOS_DTL.SHIPVEND_ID
TablePO_BPOS_HDR FK Joins to PO_VEND_MST PO_BPOS_HDR.PAYVEND_ID
TablePO_BPOS_HDR FK Joins to PO_VEND_MST PO_BPOS_HDR.SHIPVEND_ID
TablePO_ORDR_DTL FK Joins to PO_VEND_MST PO_ORDR_DTL.SHIPVEND_ID
TablePO_ORDR_HDR FK Joins to PO_VEND_MST PO_ORDR_HDR.PAYVEND_ID
TablePO_ORDR_HDR FK Joins to PO_VEND_MST PO_ORDR_HDR.SHIPVEND_ID
TablePO_RECV_DTL FK Joins to PO_VEND_MST PO_RECV_DTL.SHIPVEND_ID
TablePO_RECV_HDR FK Joins to PO_VEND_MST PO_RECV_HDR.SHIPVEND_ID
TablePO_RECV_HDR FK Joins to PO_VEND_MST PO_RECV_HDR.PAYVEND_ID
TablePO_RTRN_HDR FK Joins to PO_VEND_MST PO_RTRN_HDR.RETURN_VENDOR_ID
TablePO_VEND_ASC FK Joins to PO_VEND_MST PO_VEND_ASC.ASSOCVEND_ID
TablePO_VEND_ASC FK Joins to PO_VEND_MST PO_VEND_ASC.VEND_ID
TablePO_VNIT_MST FK Joins to PO_VEND_MST PO_VNIT_MST.VENDOR_ID
TableQC_RSLT_MST FK Joins to PO_VEND_MST QC_RSLT_MST.VENDOR_ID
TableQC_SMPL_MST FK Joins to PO_VEND_MST QC_SMPL_MST.VENDOR_ID
TableQC_SPEC_MST FK Joins to PO_VEND_MST QC_SPEC_MST.VENDOR_ID