eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: OP_SHIP_MST

Product:	GML - Process Manufacturing Logistics
Description:	Carrier (shipper) codes .
Implementation/DBA Data:	GML.OP_SHIP_MST

Primary Key: OP_SHIP_MST01

OF_SHIPPER_CODE

Primary Key: OP_SHIP_MST_PK

SHIPPER_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
OP_SHIP_MST	OP_TEXT_HDR	OP_SHIP_MST.TEXT_CODE
OP_SHIP_MST	SY_ADDR_MST	OP_SHIP_MST.ADDR_ID
OP_BILL_LAD	OP_SHIP_MST	OP_BILL_LAD.SHIPPER_CODE
OP_CUST_SHP	OP_SHIP_MST	OP_CUST_SHP.SHIPPER_CODE
OP_ORDR_DTL	OP_SHIP_MST	OP_ORDR_DTL.SHIPPER_CODE
OP_ORDR_HDR	OP_SHIP_MST	OP_ORDR_HDR.SHIPPER_CODE
OP_PRSL_DTL	OP_SHIP_MST	OP_PRSL_DTL.SHIPPER_CODE
OP_PRSL_HDR	OP_SHIP_MST	OP_PRSL_HDR.SHIPPER_CODE
OP_RELS_SCH	OP_SHIP_MST	OP_RELS_SCH.SHIPPER_CODE
OP_SHIP_MTH	OP_SHIP_MST	OP_SHIP_MTH.PREFERRED_SHIPPER
PO_BPOS_DTL	OP_SHIP_MST	PO_BPOS_DTL.SHIPPER_CODE
PO_BPOS_HDR	OP_SHIP_MST	PO_BPOS_HDR.SHIPPER_CODE
PO_ORDR_DTL	OP_SHIP_MST	PO_ORDR_DTL.SHIPPER_CODE
PO_ORDR_HDR	OP_SHIP_MST	PO_ORDR_HDR.SHIPPER_CODE
PO_RECV_DTL	OP_SHIP_MST	PO_RECV_DTL.SHIPPER_CODE
PO_RECV_HDR	OP_SHIP_MST	PO_RECV_HDR.SHIPPER_CODE
PO_RELS_SCH	OP_SHIP_MST	PO_RELS_SCH.SHIPPER_CODE
PO_RTRN_HDR	OP_SHIP_MST	PO_RTRN_HDR.SHIPPER_CODE