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_INT

Object Details

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

This is the Customer Interface table for data transferred from Oracle Receivables into the OPM customer master table, OP_CUST_MST. The data synchronization program in OPM populates this table with data from the Oracle Receivables customer tables: RA_CUSTOMERS, RA_ADDRESSES_ALL, RA_SITE_USES_ALL, RA_PHONES, RA_CONTACTS, AR_CUSTOMER_PROFILES, RA_TERMS, RA_SALESREPS_ALL, and AP_BANK_ACCOUNTS_ALL. This interface table is one of several used. The other interface table used to transfer Customer data is OP_CUST_CON_INT. Tables in OPM which are then updated from the customer interface tables include: OP_CUST_MST, OP_CUST_CON, OP_CUST_SHP, OP_CUST_ASC and SY_ADDR_MST.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LOWEST_PRICE_IND	NUMBER	(10)		Select lowest price for customer
CUST_ID	NUMBER	(10)	Yes	Customer Surrogate
CO_CODE	VARCHAR2	(4)	Yes	Company for which the customer number is defined. A blank value indicates the customer is defined for all companies.
CUST_NO	VARCHAR2	(80)	Yes	Customer Number
CUSTSORT_NO	VARCHAR2	(16)	Yes	The Customer Number to Sort By.
CUST_NAME	VARCHAR2	(40)	Yes	Customer Name
PHONE_NO	VARCHAR2	(20)	Yes	Customer Phone Number
FAX_NO	VARCHAR2	(20)	Yes	Customer Fax Number
TELEX_NO	VARCHAR2	(20)	Yes	Customer Telex Number
ALTCUST_NO	VARCHAR2	(32)	Yes	Alternate Customer Number
ADDR1	VARCHAR2	(70)	Yes	First line of the address.
ADDR2	VARCHAR2	(70)	Yes	Second line of the address.
ADDR3	VARCHAR2	(70)	Yes	Third line of the address.
ADDR4	VARCHAR2	(70)	Yes	Fourth line of the address.
STATE_CODE	VARCHAR2	(4)	Yes	State.
COUNTRY_CODE	VARCHAR2	(4)	Yes	Country.
POSTAL_CODE	VARCHAR2	(16)	Yes	Postal Code.
MAILADDR1	VARCHAR2	(70)	Yes	Mailing Address Line 1
MAILADDR2	VARCHAR2	(70)	Yes	Mailing Address Line 2
MAILADDR3	VARCHAR2	(70)	Yes	Mailing Address Line 3
MAILADDR4	VARCHAR2	(70)	Yes	Mailing Address Line 4
MAILSTATE_CODE	VARCHAR2	(4)	Yes	State.
MAILCOUNTRY_CODE	VARCHAR2	(4)	Yes	Country.
MAILPOSTAL_CODE	VARCHAR2	(16)	Yes	Postal Code.
TERMS_CODE	VARCHAR2	(4)	Yes	Customer Terms Code
TERMS_VARY	NUMBER	(5)	Yes	0=Don?t allow terms to change; 1=Allow terms to change.
FOB_CODE	VARCHAR2	(4)	Yes	Customer FOB Code.
SLSREP_CODE	VARCHAR2	(8)	Yes	Customer Sales Representative Code.
COMMISSION_CODE	VARCHAR2	(8)	Yes	Customer Commission Code.
BACKORDER_IND	NUMBER	(5)	Yes	0=Don?t allow backorders; 1=Allow backorders.
STMT_IND	NUMBER	(5)	Yes	0=Don?t allow statements; 1=Allow statements.
SVCCHG_IND	NUMBER	(5)	Yes	0=Don?t allow service charges; 1=Allow service charges.
INACTIVE_IND	NUMBER	(5)	Yes	0=Active Customer; 1=Inactive Customer
BILL_IND	NUMBER	(5)	Yes	0=Not a Bill to customer; 1=Bill to customer.
SHIP_IND	NUMBER	(5)	Yes	0=Not a Ship to customer; 1 = Ship to customer.
CUST_TYPE	NUMBER	(5)	Yes	Same as op_cust_mst
SIC_CODE	VARCHAR2	(8)	Yes	SIC Code
FROM_WHSE	VARCHAR2	(4)	Yes	Preferred Warehouse.
TO_WHSE	VARCHAR2	(4)	Yes	Consignment, transfer warehouse in ic_whse_mst.
SPLC_CODE	VARCHAR2	(8)	Yes	Industry Standard Point Location Code.
FRTBILL_MTHD	VARCHAR2	(4)	Yes	Freight Bill Method
CREDIT_LIMIT	NUMBER		Yes	Credit Limit
PRICECUST_ID	NUMBER	(10)	Yes	Price Customer Surrogate for pricing information
CUST_TERRITORY	VARCHAR2	(8)	Yes	Customer territory
CUST_CURRENCY	VARCHAR2	(4)	Yes	Customer Currency
CUST_CLASS	VARCHAR2	(8)	Yes	Customer Class
CUSTTRADE_CLASS	VARCHAR2	(8)	Yes	Customer Trade Class
CUSTGL_CLASS	VARCHAR2	(8)	Yes	Customer GL Class
TAXLOC_CODE	VARCHAR2	(10)	Yes	Customer Tax Location Code
TAXCALC_CODE	VARCHAR2	(4)	Yes	Customer Tax Calculation Code
OPEN_BALANCE	NUMBER		Yes	Customer Open Balance
CREATION_DATE	DATE		Yes	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
LAST_UPDATE_LOGIN	NUMBER	(15)		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
INVALID_IND	NUMBER	(10)	Yes	0=Valid Customer; 1=Invalid Customer
DIRECTION_IND	NUMBER	(10)	Yes	0=Data is coming into GEMMS;1=Data going to Oracle
CUSTPRICE_CLASS	VARCHAR2	(8)	Yes	Customer Price Class
EMAIL_ADDRESS	VARCHAR2	(70)	Yes	Customer Email Address
LOCKBOX_CODE	VARCHAR2	(8)	Yes	Customer Lockbox Code
EDI_FLAG	NUMBER	(5)	Yes	Customer EDI Flag.
USE_PROFILE	NUMBER	(5)	Yes	Same as op_cust_mst
RESTRICT_TO_CUSTITEMS	NUMBER	(5)	Yes	Same as op_cust_mst
SOCONFIRM_IND	NUMBER	(5)	Yes	Same as op_cust_mst
ORA_ADDR4	VARCHAR2	(70)	Yes	Implemented for versions 4.00.03 and later. Used to match with Oracle Financial Integration to table SY_ADDR_MST.
PROVINCE	VARCHAR2	(70)	Yes	Implemented for versions 4.00.03 and later. Used to match with Oracle Financial Integration to table SY_ADDR_MST
COUNTY	VARCHAR2	(70)		Implemented for versions 4.00.03 and later. Used to match with Oracle Financial Integration to table SY_ADDR_MST
MAILORA_ADDR4	VARCHAR2	(70)	Yes	Implemented for versions 4.00.03 and later. Used to match with Oracle Financial Integration to table SY_ADDR_MST
MAILPROVINCE	VARCHAR2	(70)	Yes	Implemented for versions 4.00.03 and later. Used to match with Oracle Financial Integration to table SY_ADDR_MST
MAILCOUNTY	VARCHAR2	(70)	Yes	Implemented for versions 4.00.03 and later. Used to match with Oracle Financial Integration to table SY_ADDR_MST
OF_BILL_TO_ADDRESS_ID	NUMBER		Yes	Surrogate from Oracle Financials identifying the customer address.
OF_SHIP_TO_ADDRESS_ID	NUMBER		Yes	Surrogate from Oracle Financials identifying the customer address.
OF_SHIP_TO_SITE_USE_ID	NUMBER		Yes	Surrogate from Oracle Financials identifying the customer location.
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
OF_CUST_ID	NUMBER		Yes	Surrogate from Oracle Financials identifying the customer.
OF_BILL_TO_SITE_USE_ID	NUMBER		Yes	Surrogate from Oracle Financials identifying the customer location.

Query Text

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


SELECT LOWEST_PRICE_IND
,      CUST_ID
,      CO_CODE
,      CUST_NO
,      CUSTSORT_NO
,      CUST_NAME
,      PHONE_NO
,      FAX_NO
,      TELEX_NO
,      ALTCUST_NO
,      ADDR1
,      ADDR2
,      ADDR3
,      ADDR4
,      STATE_CODE
,      COUNTRY_CODE
,      POSTAL_CODE
,      MAILADDR1
,      MAILADDR2
,      MAILADDR3
,      MAILADDR4
,      MAILSTATE_CODE
,      MAILCOUNTRY_CODE
,      MAILPOSTAL_CODE
,      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
,      OPEN_BALANCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      INVALID_IND
,      DIRECTION_IND
,      CUSTPRICE_CLASS
,      EMAIL_ADDRESS
,      LOCKBOX_CODE
,      EDI_FLAG
,      USE_PROFILE
,      RESTRICT_TO_CUSTITEMS
,      SOCONFIRM_IND
,      ORA_ADDR4
,      PROVINCE
,      COUNTY
,      MAILORA_ADDR4
,      MAILPROVINCE
,      MAILCOUNTY
,      OF_BILL_TO_ADDRESS_ID
,      OF_SHIP_TO_ADDRESS_ID
,      OF_SHIP_TO_SITE_USE_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
,      OF_CUST_ID
,      OF_BILL_TO_SITE_USE_ID
FROM GML.OP_CUST_MST_INT;

Dependencies

[top of page]

GML.OP_CUST_MST_INT does not reference any database object

GML.OP_CUST_MST_INT is referenced by following:

GML: OP_CUST_MST_INT#