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: TableGML.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OP_CUST_MST_OPM_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ID
OP_CUST_MST_OPM_UC1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCO_CODE
ColumnCUST_NO
OF_CUST_MST_OPM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOF_CUST_ID
OP_CUST_MST_OPM_I2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTSORT_NO
ColumnCUST_NO
ColumnCUST_NAME
ColumnDELETE_MARK
ColumnINACTIVE_IND
ColumnCUST_ID
OP_CUST_MST_OPM_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCO_CODE
ColumnOF_BILL_TO_SITE_USE_ID
OP_CUST_MST_OPM_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCO_CODE
ColumnOF_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:

SchemaAPPS
SynonymOP_CUST_MST_OPM