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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GML.OP_CUST_MST_OPM

Object Details

Object Name:	OP_CUST_MST_OPM
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_CUST_MST_OPM
Subobject Name:
Status:	VALID

This table is the customer master for OPM. All customer information must be entered in Oracle Receivables. A data synchronization program then transfers the information and creates records in this table. There are several fields which are not updated by Oracle Receivables and these may be modified in OPM using the Customer screen. Since information in these fields has no equivalent in Oracle Receivables, the data does not exist in that system. These fields include: CUSTSORT_NO, ALTCUST_NO, TO_WHSE, SPLC_CODE, PRICECUST_NO, CUSTTRADE_CLASS, TEXT_CODE, RESTRICT_TO_CUSTITEMS, LOWEST_PRICE_IND. All other information is taken from similar columns in Oracle Receivables tables.
See the table description for the OPM table OP_CUST_MST_INT for additional information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_CUST_MST_OPM_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUST_ID
OP_CUST_MST_OPM_UC1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CO_CODE CUST_NO
OF_CUST_MST_OPM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OF_CUST_ID
OP_CUST_MST_OPM_I2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTSORT_NO CUST_NO CUST_NAME DELETE_MARK INACTIVE_IND CUST_ID
OP_CUST_MST_OPM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CO_CODE OF_BILL_TO_SITE_USE_ID
OP_CUST_MST_OPM_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CO_CODE OF_SHIP_TO_SITE_USE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUST_ID	NUMBER	(10)	Yes	Surrogate key for customer master record. Surrogate cust_vend in sy_surg_ctl.
CUST_NO	VARCHAR2	(32)	Yes	Unique identifier of a customer.
ADDR_ID	NUMBER	(10)		Pointer to address for customer. Fk to sy_addr_mst. For order entry and shipping, this is the shipping address.
CUSTSORT_NO	VARCHAR2	(16)	Yes	Customer sort number. Used to sort customers for lookups and other purposes. Defaults from customer name. User can override for user-defined sort order.
CUST_NAME	VARCHAR2	(40)	Yes	Customer name
PHONE_NO	VARCHAR2	(20)		Customer phone number.
FAX_NO	VARCHAR2	(20)		Customer fax number.
TELEX_NO	VARCHAR2	(20)		Customer telex number.
ALTCUST_NO	VARCHAR2	(32)		Alternate customer number. Not validated, for customer use.
CO_CODE	VARCHAR2	(4)		Company for which the customer number is defined. A NULL value indicates the customer is defined for all companies.
MAILADDR_ID	NUMBER	(10)		Pointer to sy_addr_mst which holds the mailing address. This address is used for invoicing and billing purposes.
TERMS_CODE	VARCHAR2	(4)		Default payment terms code for customer; fk to op_term_mst.
TERMS_VARY	NUMBER	(5)		Indicates if terms code can vary for this customer on an order. 0 means that the terms code can not be changed on an order; 1 means that the terms code can be changed.
FOB_CODE	VARCHAR2	(4)		Default fob code for this customer; fk to op_fobc_mst.
SLSREP_CODE	VARCHAR2	(8)		Default sales rep for this customer; fk to op_slsr_mst.
COMMISSION_CODE	VARCHAR2	(8)		Default commission code for this customer; fk to op_comm_cds. Indicates commission group.
BACKORDER_IND	NUMBER	(5)	Yes	Indicates if the customer accepts backorders. Value of 0 means that the customer does not accept backorders (i.e., if the entire order qty can not be shipped, then the remaining qty is not backordered). Value of 1 means that the customer
STMT_IND	NUMBER	(5)	Yes	For future use: indicates if the customer is sent a statement. Value of 0 means that the customer is not sent a statement; value of 1 means that the customer is sent a monthly statement.
SVCCHG_IND	NUMBER	(5)	Yes	For future use; indicates if the customer is charged a service charge for overdue payments. Value of 0 means that the customer is not charged a service charge; value of 1 means that the customer is charged a service charge for overdue pay
INACTIVE_IND	NUMBER	(5)	Yes	Indicates whether a customer is active or not. Value of 0 means that the customer is active; a value of 1 means that the customer is inactive. Defaults to 0.
BILL_IND	NUMBER	(5)	Yes	Indicates whether the customer is a bill-to. Value of 0 means that the customer is not a bill-to customer; value of 1 means that the customer is a bill-to customer.
SHIP_IND	NUMBER	(5)	Yes	Indicates whether a customer is a ship-to customer. A value of 0 means that the customer is not a ship-to customer; a value of 1 means that the customer is a ship-to customer.
CUST_TYPE	NUMBER	(5)	Yes	Designates the type of customer. Valid values are: 0 means "normal" customer 1 means consignment customer 2 means transfer/interplant customer.
SIC_CODE	VARCHAR2	(8)		Unvalidated field which can hold the u.s. standard industry code.
FROM_WHSE	VARCHAR2	(4)		Default warehouse where shipments will originate for this customer; fk to ic_whse_mst.
TO_WHSE	VARCHAR2	(4)		Default receiving warehouse for this customer. For use with consignment and transfer customers only. Fk to ic_whse_mst.
SPLC_CODE	VARCHAR2	(16)		Unvalidated field which can contain the standard point location code used in the u.s. for freight and shipping purposes.
FRTBILL_MTHD	VARCHAR2	(4)		Default freight bill method for this customer; fk to op_frgt_mth
CREDIT_LIMIT	NUMBER		Yes	Unvalidated field which can contain a credit limit amount. Will be used as an option for order level credit checking; complete credit checking is available by maintaining credit limits in oracle financials and using the gemms-of a/r integ
PRICECUST_ID	NUMBER	(10)	Yes	Contains the customer id of the customer to be used for customer-specific pricing.
CUST_TERRITORY	VARCHAR2	(8)		Customer territory; unvalidated field.
CUST_CURRENCY	VARCHAR2	(4)		Billing currency of the customer; fk to gl_curr_mst.
CUST_CLASS	VARCHAR2	(8)		Customer class, fk to op_cust_cls.
CUSTTRADE_CLASS	VARCHAR2	(8)		Customer trade class; fk to op_ctrd_cls.
CUSTGL_CLASS	VARCHAR2	(8)		Customer gl class used for gl mapping; fk to op_cgld_cls.
TAXLOC_CODE	VARCHAR2	(10)		Tax location code of customer; fk to tx_tloc_cds.
TAXCALC_CODE	VARCHAR2	(4)		Tax calculation code for customer to specify special tax calculation flags for this customer; fk to tx_calc_mst.
OF_CUST_ID	NUMBER	(10)		Surrogate from Oracle Financials identifying the customer.
OF_SHIP_TO_ADDRESS_ID	NUMBER	(10)		Surrogate from Oracle Financials identifying the customer address.
OF_SHIP_TO_SITE_USE_ID	NUMBER	(10)		Surrogate from Oracle Financials identifying the customer location.
OF_BILL_TO_ADDRESS_ID	NUMBER	(10)		Surrogate from Oracle Financials identifying the customer bill to address.
OF_BILL_TO_SITE_USE_ID	NUMBER	(10)		Surrogate from Oracle Financials identifying the customer bill to site use id.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
OPEN_BALANCE	NUMBER			Contains current open order balance (value of unshipped orders). This amount is updated during order entry and shipping for use in credit checking under oracle financials. Balance is incremented for new open orders and decremented when an
CUSTPRICE_CLASS	VARCHAR2	(8)		Class to group customers for pricing purposes. Used in pricing tables. Fk to op_cprc_cls.
EMAIL_ADDRESS	VARCHAR2	(70)		Freeform text to store email address for customer.
LOCKBOX_CODE	VARCHAR2	(8)		Default lockbox code where customer remits payment. Fk to op_lkbx_mst.
EDI_FLAG	NUMBER	(5)	Yes	For future use; identifies if customer uses edi.
USE_PROFILE	NUMBER	(5)	Yes	Indicates if order profile should be used to create orders for customer. Values are: 0 means that order profile is not used automatically when an order is taken for the customer 1 means that the order profile is automatically copied in wh
RESTRICT_TO_CUSTITEMS	NUMBER	(5)	Yes	Indicates if customer can order items which are not defined in the customer-item table. Value of 1 means that only items defined in the customer-item table can be ordered by this customer. Value of 0 means that any items can be ordered b
SOCONFIRM_IND	NUMBER	(5)	Yes	Indicates if customer requires a sales order confirmation. Value of 0 means that no confirmation is required; value of 1 means that a sales order confirmation must be sent. Indicator will be used in the future.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
LOWEST_PRICE_IND	NUMBER	(5)		Value of 0 (zero) means that normal pricing rules are in effect; value of 1 (one) means that pricing of an order for this customer will select the lowest price from effective pricelists established for this customer.
PO_REQUIRED	NUMBER	(5)		Option which allows bill-to customers to require entry of a PO Number in any sales order created against them. 1 -require a customer PO , 0 or NULL- do not require a customer PO on orders

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUST_ID
,      CUST_NO
,      ADDR_ID
,      CUSTSORT_NO
,      CUST_NAME
,      PHONE_NO
,      FAX_NO
,      TELEX_NO
,      ALTCUST_NO
,      CO_CODE
,      MAILADDR_ID
,      TERMS_CODE
,      TERMS_VARY
,      FOB_CODE
,      SLSREP_CODE
,      COMMISSION_CODE
,      BACKORDER_IND
,      STMT_IND
,      SVCCHG_IND
,      INACTIVE_IND
,      BILL_IND
,      SHIP_IND
,      CUST_TYPE
,      SIC_CODE
,      FROM_WHSE
,      TO_WHSE
,      SPLC_CODE
,      FRTBILL_MTHD
,      CREDIT_LIMIT
,      PRICECUST_ID
,      CUST_TERRITORY
,      CUST_CURRENCY
,      CUST_CLASS
,      CUSTTRADE_CLASS
,      CUSTGL_CLASS
,      TAXLOC_CODE
,      TAXCALC_CODE
,      OF_CUST_ID
,      OF_SHIP_TO_ADDRESS_ID
,      OF_SHIP_TO_SITE_USE_ID
,      OF_BILL_TO_ADDRESS_ID
,      OF_BILL_TO_SITE_USE_ID
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      OPEN_BALANCE
,      CUSTPRICE_CLASS
,      EMAIL_ADDRESS
,      LOCKBOX_CODE
,      EDI_FLAG
,      USE_PROFILE
,      RESTRICT_TO_CUSTITEMS
,      SOCONFIRM_IND
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      LOWEST_PRICE_IND
,      PO_REQUIRED
FROM GML.OP_CUST_MST_OPM;

Dependencies

[top of page]

GML.OP_CUST_MST_OPM does not reference any database object

GML.OP_CUST_MST_OPM is referenced by following:

GML: OP_CUST_MST_OPM#