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

TABLE: AR.RA_CUSTOMERS_INTERFACE_ALL

Object Details
Object Name: RA_CUSTOMERS_INTERFACE_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.RA_CUSTOMERS_INTERFACE_ALL
Subobject Name:
Status: VALID


The RA_CUSTOMERS_INTERFACE_ALL table is one of the Customer Interface tables that Oracle Receivables uses to import customer, address, customer profiles, and site use information. Receivables uses this customer information to create records in the RA_CUSTOMERS, RA_ADDRESSES_ALL, RA_CUSTOMER_RELATIONSHIPS_ALL, and RA_SITE_USES_ALL tables. Receivables deletes all information from this table after your customer data is successfully imported. For more information about customer conversion, see the Oracle Trading Community Architecture Reference Guide.
.
Customer Interface uses INTERFACE_STATUS column is used by Customer Interface to store any error messages that apply to the interface record.
.
The REQUEST_ID column stores the request ID of the last concurrent request that you submitted to run customer interface.
.
The INSERT_UPDATE_FLAG column stores I if you are inserting a new row or U if you are updating an existing record.
.
The VALIDATED_FLAG column stores Y or N to indicate if this record was validated.
.
Please refer to the Oracle Trading Community Architecture Reference Guide for more detailed information on Open Interface table columns, including import validation and destination columns.
.
The primary keys for this table are ORIG_SYSTEM_CUSTOMER_REF, ORIG_SYSTEM_ADDRESS_REF, and SITE_USE_CODE.
Scope: public
Product: HZ
Lifecycle: active
Display Name: Customer
Category: BUSINESS_ENTITY HZ_CUSTOMER_ACCOUNT
Category: BUSINESS_ENTITY HZ_PARTY
Category: BUSINESS_ENTITY HZ_PERSON
Category: BUSINESS_ENTITY HZ_ORGANIZATION
Category: BUSINESS_ENTITY HZ_ADDRESS

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RA_CUSTOMERS_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnORIG_SYSTEM_CUSTOMER_REF
RA_CUSTOMERS_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnORIG_SYSTEM_ADDRESS_REF
RA_CUSTOMERS_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCUSTOMER_NUMBER
RA_CUSTOMERS_INTERFACE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnORIG_SYSTEM_PARTY_REF
RA_CUSTOMERS_INTERFACE_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARTY_NUMBER
RA_CUSTOMERS_INTERFACE_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARTY_SITE_NUMBER
Columns
Name Datatype Length Mandatory Comments
ORIG_SYSTEM_CUSTOMER_REF VARCHAR2 (240) Yes Unique customer identifier from foreign system
SITE_USE_CODE VARCHAR2 (30)
Revenue Accounting lookup code for SITE_USE_CODE
ORIG_SYSTEM_ADDRESS_REF VARCHAR2 (240)
Unique address identifier from foreign system
INTERFACE_STATUS VARCHAR2 (240)
Error codes for rejected records
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
INSERT_UPDATE_FLAG VARCHAR2 (1) Yes I for inserts, or U for updates
VALIDATED_FLAG VARCHAR2 (1)
Y or N indicates whether record has already been validated
CUSTOMER_NAME VARCHAR2 (360) Yes Customer name
CUSTOMER_NUMBER VARCHAR2 (30)
Customer number
CUSTOMER_STATUS VARCHAR2 (1)
Customer status flag. Lookup code for CODE_STATUS
CUSTOMER_TYPE VARCHAR2 (25)
Lookup code for CUSTOMER_TYPE
ORIG_SYSTEM_PARENT_REF VARCHAR2 (240)
Related customer's unique identifier from foreign system
PRIMARY_SITE_USE_FLAG VARCHAR2 (1)
Y or N indicates whether site is primary for this address
LOCATION VARCHAR2 (40)
Site use number
ADDRESS1 VARCHAR2 (240)
Address first line
ADDRESS2 VARCHAR2 (240)
Address second line
ADDRESS3 VARCHAR2 (240)
Address third line
ADDRESS4 VARCHAR2 (240)
Address fourth line
CITY VARCHAR2 (60)
Address city
STATE VARCHAR2 (60)
Address state
PROVINCE VARCHAR2 (60)
Address province
COUNTY VARCHAR2 (60)
Address county
POSTAL_CODE VARCHAR2 (60)
Address postal code
COUNTRY VARCHAR2 (60)
Address country
CUSTOMER_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Customer Descriptive Flexfield category
CUSTOMER_ATTRIBUTE1 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE2 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE3 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE4 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE5 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE6 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE7 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE8 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE9 VARCHAR2 (150)
Customer Descriptive Flexfield value
ADDRESS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Address Descriptive Flexfield category
ADDRESS_ATTRIBUTE1 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE2 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE3 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE4 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE5 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE6 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE7 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE8 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE9 VARCHAR2 (150)
Address Descriptive Flexfield value
SITE_USE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Site Use Descriptive Flexfield category
SITE_USE_ATTRIBUTE1 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE2 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE3 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE4 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE5 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE6 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE7 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE8 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE9 VARCHAR2 (150)
Site Use Descriptive Flexfield value
ADDRESS_KEY VARCHAR2 (50)
Not currently used
CUSTOMER_CATEGORY_CODE VARCHAR2 (30)
Lookup code for customer category
CUSTOMER_CLASS_CODE VARCHAR2 (30)
Customer class lookup assigned to the customer
CUSTOMER_KEY VARCHAR2 (50)
Not currently used
CUST_TAX_CODE VARCHAR2 (50)
Tax code assigned to customer or business purpose
CUST_TAX_EXEMPT_NUM VARCHAR2 (30)
Tax exempt identification number
CUST_TAX_REFERENCE VARCHAR2 (50)
Customer's tax registration number
DEMAND_CLASS_CODE VARCHAR2 (30)
Lookup code
LOCATION_CCID NUMBER (15)
This column is used by customer interface and should be left null
CUST_SHIP_VIA_CODE VARCHAR2 (30)
The name of the preferred ship method.
SITE_USE_TAX_CODE VARCHAR2 (50)
Tax code assigned to a site
SITE_USE_TAX_EXEMPT_NUM VARCHAR2 (30)
Tax exempt identification number for a site
SITE_USE_TAX_REFERENCE VARCHAR2 (50)
Tax registration number for a site
WARNING_TEXT VARCHAR2 (240)
Not currently used
CUSTOMER_ATTRIBUTE10 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE11 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE12 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE13 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE14 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE15 VARCHAR2 (150)
Customer Descriptive Flexfield value
ADDRESS_ATTRIBUTE10 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE11 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE12 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE13 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE14 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE15 VARCHAR2 (150)
Address Descriptive Flexfield value
SITE_USE_ATTRIBUTE10 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE11 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE12 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE13 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE14 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE15 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE16 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE17 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE18 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE19 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE20 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE21 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE22 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE23 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE24 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_USE_ATTRIBUTE25 VARCHAR2 (150)
Site Use Descriptive Flexfield value
SITE_SHIP_VIA_CODE VARCHAR2 (30)
Freight Carrier assigned to site
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
MESSAGE_TEXT VARCHAR2 (240)
Stores warning message text
BILL_TO_ORIG_ADDRESS_REF VARCHAR2 (240)
This column is the original system's reference to another address record whose bill to site will be linked to the ship to site for this address
JGZZ_FISCAL_CODE VARCHAR2 (20)
This column is used as the fiscal code for certain European countries
LANGUAGE VARCHAR2 (30)
Base language
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
URL VARCHAR2 (240)
Customers home page address on World Wide Web
ORG_ID NUMBER (15)
Organization identifier
CUSTOMER_PROSPECT_CODE VARCHAR2 (30)
Indicates whether a business or company is a customer or a prospect
CUSTOMER_NAME_PHONETIC VARCHAR2 (320)
The customer's alternate name
ADDRESS_LINES_PHONETIC VARCHAR2 (560)
An alternate name for the customer's address
TRANSLATED_CUSTOMER_NAME VARCHAR2 (50)
Translated customer name
TERRITORY VARCHAR2 (30)
Territory associated with this customer record
GL_ID_REC NUMBER (15)
Code combination ID for the receivable account
GL_ID_REV NUMBER (15)
Code combination ID for the revenue account
GL_ID_TAX NUMBER (15)
Code combination ID for the tax account
GL_ID_FREIGHT NUMBER (15)
Code combination ID for the freight account
GL_ID_CLEARING NUMBER (15)
Code combination ID for the clearing account
GL_ID_UNBILLED NUMBER (15)
Code combination ID for the unbilled account
GL_ID_UNEARNED NUMBER (15)
Code combination ID for the earned account
PERSON_FLAG VARCHAR2 (1)
Flag to distinguish between PERSON and
PERSON_FIRST_NAME VARCHAR2 (150)
First name of the Person
PERSON_LAST_NAME VARCHAR2 (150)
Last name of the Person
GDF_ADDRESS_ATTR_CAT VARCHAR2 (30)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_ADDRESS_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality related to addresses
GDF_SITE_USE_ATTR_CAT VARCHAR2 (30)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GDF_SITE_USE_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality related to site uses
GL_ID_UNPAID_REC NUMBER (15)
Code combination ID for the unpaid bills receivable account
GL_ID_REMITTANCE NUMBER (15)
Code combination ID standard remitted bills receivable account
GL_ID_FACTOR NUMBER (15)
Code combination ID for the factored (without recourse) bills receivable account
ORIG_SYSTEM_PARTY_REF VARCHAR2 (240)
Unique party identifier from foreign system
PARTY_NUMBER VARCHAR2 (30)
Unique identification number for this party
PARTY_SITE_NUMBER VARCHAR2 (30)
Party site number
ADDRESS_CATEGORY_CODE VARCHAR2 (30)
Address category code
ADDRESS_ATTRIBUTE16 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE17 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE18 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE19 VARCHAR2 (150)
Address Descriptive Flexfield value
ADDRESS_ATTRIBUTE20 VARCHAR2 (150)
Address Descriptive Flexfield value
CUSTOMER_ATTRIBUTE16 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE17 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE18 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE19 VARCHAR2 (150)
Customer Descriptive Flexfield value
CUSTOMER_ATTRIBUTE20 VARCHAR2 (150)
Customer Descriptive Flexfield value
Query Text

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


SELECT ORIG_SYSTEM_CUSTOMER_REF
,      SITE_USE_CODE
,      ORIG_SYSTEM_ADDRESS_REF
,      INTERFACE_STATUS
,      REQUEST_ID
,      INSERT_UPDATE_FLAG
,      VALIDATED_FLAG
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_STATUS
,      CUSTOMER_TYPE
,      ORIG_SYSTEM_PARENT_REF
,      PRIMARY_SITE_USE_FLAG
,      LOCATION
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      POSTAL_CODE
,      COUNTRY
,      CUSTOMER_ATTRIBUTE_CATEGORY
,      CUSTOMER_ATTRIBUTE1
,      CUSTOMER_ATTRIBUTE2
,      CUSTOMER_ATTRIBUTE3
,      CUSTOMER_ATTRIBUTE4
,      CUSTOMER_ATTRIBUTE5
,      CUSTOMER_ATTRIBUTE6
,      CUSTOMER_ATTRIBUTE7
,      CUSTOMER_ATTRIBUTE8
,      CUSTOMER_ATTRIBUTE9
,      ADDRESS_ATTRIBUTE_CATEGORY
,      ADDRESS_ATTRIBUTE1
,      ADDRESS_ATTRIBUTE2
,      ADDRESS_ATTRIBUTE3
,      ADDRESS_ATTRIBUTE4
,      ADDRESS_ATTRIBUTE5
,      ADDRESS_ATTRIBUTE6
,      ADDRESS_ATTRIBUTE7
,      ADDRESS_ATTRIBUTE8
,      ADDRESS_ATTRIBUTE9
,      SITE_USE_ATTRIBUTE_CATEGORY
,      SITE_USE_ATTRIBUTE1
,      SITE_USE_ATTRIBUTE2
,      SITE_USE_ATTRIBUTE3
,      SITE_USE_ATTRIBUTE4
,      SITE_USE_ATTRIBUTE5
,      SITE_USE_ATTRIBUTE6
,      SITE_USE_ATTRIBUTE7
,      SITE_USE_ATTRIBUTE8
,      SITE_USE_ATTRIBUTE9
,      ADDRESS_KEY
,      CUSTOMER_CATEGORY_CODE
,      CUSTOMER_CLASS_CODE
,      CUSTOMER_KEY
,      CUST_TAX_CODE
,      CUST_TAX_EXEMPT_NUM
,      CUST_TAX_REFERENCE
,      DEMAND_CLASS_CODE
,      LOCATION_CCID
,      CUST_SHIP_VIA_CODE
,      SITE_USE_TAX_CODE
,      SITE_USE_TAX_EXEMPT_NUM
,      SITE_USE_TAX_REFERENCE
,      WARNING_TEXT
,      CUSTOMER_ATTRIBUTE10
,      CUSTOMER_ATTRIBUTE11
,      CUSTOMER_ATTRIBUTE12
,      CUSTOMER_ATTRIBUTE13
,      CUSTOMER_ATTRIBUTE14
,      CUSTOMER_ATTRIBUTE15
,      ADDRESS_ATTRIBUTE10
,      ADDRESS_ATTRIBUTE11
,      ADDRESS_ATTRIBUTE12
,      ADDRESS_ATTRIBUTE13
,      ADDRESS_ATTRIBUTE14
,      ADDRESS_ATTRIBUTE15
,      SITE_USE_ATTRIBUTE10
,      SITE_USE_ATTRIBUTE11
,      SITE_USE_ATTRIBUTE12
,      SITE_USE_ATTRIBUTE13
,      SITE_USE_ATTRIBUTE14
,      SITE_USE_ATTRIBUTE15
,      SITE_USE_ATTRIBUTE16
,      SITE_USE_ATTRIBUTE17
,      SITE_USE_ATTRIBUTE18
,      SITE_USE_ATTRIBUTE19
,      SITE_USE_ATTRIBUTE20
,      SITE_USE_ATTRIBUTE21
,      SITE_USE_ATTRIBUTE22
,      SITE_USE_ATTRIBUTE23
,      SITE_USE_ATTRIBUTE24
,      SITE_USE_ATTRIBUTE25
,      SITE_SHIP_VIA_CODE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      MESSAGE_TEXT
,      BILL_TO_ORIG_ADDRESS_REF
,      JGZZ_FISCAL_CODE
,      LANGUAGE
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      URL
,      ORG_ID
,      CUSTOMER_PROSPECT_CODE
,      CUSTOMER_NAME_PHONETIC
,      ADDRESS_LINES_PHONETIC
,      TRANSLATED_CUSTOMER_NAME
,      TERRITORY
,      GL_ID_REC
,      GL_ID_REV
,      GL_ID_TAX
,      GL_ID_FREIGHT
,      GL_ID_CLEARING
,      GL_ID_UNBILLED
,      GL_ID_UNEARNED
,      PERSON_FLAG
,      PERSON_FIRST_NAME
,      PERSON_LAST_NAME
,      GDF_ADDRESS_ATTR_CAT
,      GDF_ADDRESS_ATTRIBUTE1
,      GDF_ADDRESS_ATTRIBUTE2
,      GDF_ADDRESS_ATTRIBUTE3
,      GDF_ADDRESS_ATTRIBUTE4
,      GDF_ADDRESS_ATTRIBUTE5
,      GDF_ADDRESS_ATTRIBUTE6
,      GDF_ADDRESS_ATTRIBUTE7
,      GDF_ADDRESS_ATTRIBUTE8
,      GDF_ADDRESS_ATTRIBUTE9
,      GDF_ADDRESS_ATTRIBUTE10
,      GDF_ADDRESS_ATTRIBUTE11
,      GDF_ADDRESS_ATTRIBUTE12
,      GDF_ADDRESS_ATTRIBUTE13
,      GDF_ADDRESS_ATTRIBUTE14
,      GDF_ADDRESS_ATTRIBUTE15
,      GDF_ADDRESS_ATTRIBUTE16
,      GDF_ADDRESS_ATTRIBUTE17
,      GDF_ADDRESS_ATTRIBUTE18
,      GDF_ADDRESS_ATTRIBUTE19
,      GDF_ADDRESS_ATTRIBUTE20
,      GDF_SITE_USE_ATTR_CAT
,      GDF_SITE_USE_ATTRIBUTE1
,      GDF_SITE_USE_ATTRIBUTE2
,      GDF_SITE_USE_ATTRIBUTE3
,      GDF_SITE_USE_ATTRIBUTE4
,      GDF_SITE_USE_ATTRIBUTE5
,      GDF_SITE_USE_ATTRIBUTE6
,      GDF_SITE_USE_ATTRIBUTE7
,      GDF_SITE_USE_ATTRIBUTE8
,      GDF_SITE_USE_ATTRIBUTE9
,      GDF_SITE_USE_ATTRIBUTE10
,      GDF_SITE_USE_ATTRIBUTE11
,      GDF_SITE_USE_ATTRIBUTE12
,      GDF_SITE_USE_ATTRIBUTE13
,      GDF_SITE_USE_ATTRIBUTE14
,      GDF_SITE_USE_ATTRIBUTE15
,      GDF_SITE_USE_ATTRIBUTE16
,      GDF_SITE_USE_ATTRIBUTE17
,      GDF_SITE_USE_ATTRIBUTE18
,      GDF_SITE_USE_ATTRIBUTE19
,      GDF_SITE_USE_ATTRIBUTE20
,      GL_ID_UNPAID_REC
,      GL_ID_REMITTANCE
,      GL_ID_FACTOR
,      ORIG_SYSTEM_PARTY_REF
,      PARTY_NUMBER
,      PARTY_SITE_NUMBER
,      ADDRESS_CATEGORY_CODE
,      ADDRESS_ATTRIBUTE16
,      ADDRESS_ATTRIBUTE17
,      ADDRESS_ATTRIBUTE18
,      ADDRESS_ATTRIBUTE19
,      ADDRESS_ATTRIBUTE20
,      CUSTOMER_ATTRIBUTE16
,      CUSTOMER_ATTRIBUTE17
,      CUSTOMER_ATTRIBUTE18
,      CUSTOMER_ATTRIBUTE19
,      CUSTOMER_ATTRIBUTE20
FROM AR.RA_CUSTOMERS_INTERFACE_ALL;

Dependencies

[top of page]

AR.RA_CUSTOMERS_INTERFACE_ALL does not reference any database object

AR.RA_CUSTOMERS_INTERFACE_ALL is referenced by following:

SchemaAPPS
TriggerJL_BR_AR_BEF_DEL_CUST_INT
SynonymRA_CUSTOMERS_INTERFACE
SynonymRA_CUSTOMERS_INTERFACE_ALL