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: TableGML.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: TablespaceAPPS_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:

SchemaAPPS
SynonymOP_CUST_MST_INT