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_CUST_MST

Product:	GML - Process Manufacturing Logistics
Description:	Customer master.
Implementation/DBA Data:	Not implemented in this database

Primary Key: OP_CUST_MST_PK

CUST_ID

Primary Key: OP_CUST_MST_UC1

CO_CODE
CUST_NO

Foreign Keys

Table	Foreign Table	Foreign Key Column
OP_CUST_MST	GL_CURR_MST	OP_CUST_MST.CUST_CURRENCY
OP_CUST_MST	IC_WHSE_MST	OP_CUST_MST.FROM_WHSE
OP_CUST_MST	IC_WHSE_MST	OP_CUST_MST.TO_WHSE
OP_CUST_MST	OP_CGLD_CLS	OP_CUST_MST.CUSTGL_CLASS
OP_CUST_MST	OP_COMMISSION	OP_CUST_MST.COMMISSION_CODE
OP_CUST_MST	OP_CPRC_CLS	OP_CUST_MST.CUSTPRICE_CLASS
OP_CUST_MST	OP_CTRD_CLS	OP_CUST_MST.CUSTTRADE_CLASS
OP_CUST_MST	OP_CUST_CLS	OP_CUST_MST.CUST_CLASS
OP_CUST_MST	OP_CUST_MST	OP_CUST_MST.PRICECUST_ID
OP_CUST_MST	OP_FOBC_MST	OP_CUST_MST.FOB_CODE
OP_CUST_MST	OP_FRGT_MTH	OP_CUST_MST.FRTBILL_MTHD
OP_CUST_MST	OP_LKBX_MST	OP_CUST_MST.LOCKBOX_CODE
OP_CUST_MST	OP_SLSR_MST	OP_CUST_MST.SLSREP_CODE
OP_CUST_MST	OP_TERM_MST	OP_CUST_MST.TERMS_CODE
OP_CUST_MST	OP_TEXT_HDR	OP_CUST_MST.TEXT_CODE
OP_CUST_MST	SY_ADDR_MST	OP_CUST_MST.ADDR_ID
OP_CUST_MST	SY_ADDR_MST	OP_CUST_MST.MAILADDR_ID
OP_CUST_MST	SY_ORGN_MST_B	OP_CUST_MST.CO_CODE
OP_CUST_MST	SY_ORGN_MST	OP_CUST_MST.CO_CODE
OP_CUST_MST	TX_CALC_MST	OP_CUST_MST.TAXCALC_CODE
OP_CUST_MST	TX_TLOC_CDS	OP_CUST_MST.TAXLOC_CODE
FM_FORM_EFF	OP_CUST_MST	FM_FORM_EFF.CUST_ID
GL_ACCT_MAP	OP_CUST_MST	GL_ACCT_MAP.CUST_ID
OP_ALOT_PRM	OP_CUST_MST	OP_ALOT_PRM.CUST_ID
OP_CHRG_ITM	OP_CUST_MST	OP_CHRG_ITM.CUST_ID
OP_CUST_ASC	OP_CUST_MST	OP_CUST_ASC.CUST_ID
OP_CUST_ASC	OP_CUST_MST	OP_CUST_ASC.ASSOCCUST_ID
OP_CUST_CON	OP_CUST_MST	OP_CUST_CON.CUST_ID
OP_CUST_ITM	OP_CUST_MST	OP_CUST_ITM.CUST_ID
OP_CUST_MST	OP_CUST_MST	OP_CUST_MST.PRICECUST_ID
OP_CUST_SHP	OP_CUST_MST	OP_CUST_SHP.CUST_ID
OP_GNRC_ITM	OP_CUST_MST	OP_GNRC_ITM.CUST_ID
OP_ORDR_DTL	OP_CUST_MST	OP_ORDR_DTL.SHIPCUST_ID
OP_ORDR_DTL	OP_CUST_MST	OP_ORDR_DTL.CONSIGNEE_ID
OP_ORDR_DTL	OP_CUST_MST	OP_ORDR_DTL.ULTIMATE_SHIPCUST_ID
OP_ORDR_DTL	OP_CUST_MST	OP_ORDR_DTL.SOLDTOCUST_ID
OP_ORDR_HDR	OP_CUST_MST	OP_ORDR_HDR.BILLCUST_ID
OP_ORDR_HDR	OP_CUST_MST	OP_ORDR_HDR.SHIPCUST_ID
OP_ORDR_HDR	OP_CUST_MST	OP_ORDR_HDR.ULTIMATE_SHIPCUST_ID
OP_ORDR_HDR	OP_CUST_MST	OP_ORDR_HDR.SOLDTOCUST_ID
OP_ORDR_HDR	OP_CUST_MST	OP_ORDR_HDR.CONSIGNEE_ID
OP_PRCE_EFF	OP_CUST_MST	OP_PRCE_EFF.CUST_ID
OP_PRSL_DTL	OP_CUST_MST	OP_PRSL_DTL.BILLCUST_ID
OP_PRSL_DTL	OP_CUST_MST	OP_PRSL_DTL.SHIPCUST_ID
OP_PRSL_DTL	OP_CUST_MST	OP_PRSL_DTL.CONSIGNEE_ID
OP_PRSL_DTL	OP_CUST_MST	OP_PRSL_DTL.ULTIMATE_SHIPCUST_ID
OP_PRSL_DTL	OP_CUST_MST	OP_PRSL_DTL.SOLDTOCUST_ID
OP_PRSL_HDR	OP_CUST_MST	OP_PRSL_HDR.SHIPCUST_ID
OP_PRSL_HDR	OP_CUST_MST	OP_PRSL_HDR.BILLCUST_ID
OP_PRSL_HDR	OP_CUST_MST	OP_PRSL_HDR.ULTIMATE_SHIPCUST_ID
OP_PRSL_HDR	OP_CUST_MST	OP_PRSL_HDR.SOLDTOCUST_ID
OP_PRSL_HDR	OP_CUST_MST	OP_PRSL_HDR.CONSIGNEE_ID
OP_TXCU_ASC	OP_CUST_MST	OP_TXCU_ASC.CUST_ID
QC_RSLT_MST	OP_CUST_MST	QC_RSLT_MST.CUST_ID
QC_SMPL_MST	OP_CUST_MST	QC_SMPL_MST.CUST_ID
QC_SPEC_MST	OP_CUST_MST	QC_SPEC_MST.CUST_ID