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: AR.RA_CUSTOMERS_INTERFACE_ALL

Object Details

Object Name:	RA_CUSTOMERS_INTERFACE_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.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:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_CUSTOMERS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYSTEM_CUSTOMER_REF
RA_CUSTOMERS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYSTEM_ADDRESS_REF
RA_CUSTOMERS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	CUSTOMER_NUMBER
RA_CUSTOMERS_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYSTEM_PARTY_REF
RA_CUSTOMERS_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARTY_NUMBER
RA_CUSTOMERS_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARTY_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
CUST_TAX_HEADER_LEVEL_FLAG	VARCHAR2	(1)		Indicates if an item is a tax header or a line item. Y for records that are headers for tax purposes, N for records that are lines.
CUST_TAX_ROUNDING_CODE	VARCHAR2	(30)		Rounding rule code to be used for rounding taxes of this regime. Possible values are UP, DOWN and NEAREST. Rounding rule is the method to use to round off taxes to the minimum accountable unit.
SITE_USE_TAX_HEADER_LEVEL_FLAG	VARCHAR2	(1)		Indicates if an item is a tax header or a line item at Site Use Level. Y for records that are headers for tax purposes, N for records that are lines.
SITE_USE_TAX_ROUNDING_CODE	VARCHAR2	(30)		Rounding rule code to be used for rounding taxes of this regime. Possible values are UP, DOWN and NEAREST. Rounding rule is the method to use to round off taxes to the minimum accountable unit.
SITE_USE_TAX_CLASSIFICATION	VARCHAR2	(30)		Default tax classification code for this party site. System defaults a tax classification code to the transaction line according to the tax setup.
FISCAL_CLASS_CATEGORY	VARCHAR2	(30)		Party Fiscal Classification type for this party. TCA class category associated to use with this party fiscal classification type.
FISCAL_CLASS_CODE	VARCHAR2	(30)		Party Fiscal Classification code for this party. These are the TCA class category codes associated to use with this party fiscal classification type.
CUST_FEDERAL_ENTITY_TYPE	VARCHAR2	(30)		Identifies the type of entity involved in transactions with the reporting entity: other Federal entities or non-Federal entities such as private/local/state/tribal/foreign governments or exceptions for other non-Federal partners. 'Code' is being stored.
CUST_TRADING_PARTNER_AGENCY_ID	VARCHAR2	(3)		The ID which Identifies the other Federal agency involved in transactions with the reporting entity. Is used in conjunction with a Federal Entity type of 'Federal' .
CUST_DUNS_EXTENSION	VARCHAR2	(4)		A 4 character extension to DUNS number, used to identify registrants and is limited to different CCR (Central Contractor Registration) records for the same registrant at the same physical location. For example, a registrant could have two records for themselves at the same physical location to identify two separate bank accounts.
CUST_ADVANCE_PAYMENT_INDICATOR	VARCHAR2	(30)		This is the indicator for Advance payment.

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
,      CUST_TAX_HEADER_LEVEL_FLAG
,      CUST_TAX_ROUNDING_CODE
,      SITE_USE_TAX_HEADER_LEVEL_FLAG
,      SITE_USE_TAX_ROUNDING_CODE
,      SITE_USE_TAX_CLASSIFICATION
,      FISCAL_CLASS_CATEGORY
,      FISCAL_CLASS_CODE
,      CUST_FEDERAL_ENTITY_TYPE
,      CUST_TRADING_PARTNER_AGENCY_ID
,      CUST_DUNS_EXTENSION
,      CUST_ADVANCE_PAYMENT_INDICATOR
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:

AR: RA_CUSTOMERS_INTERFACE_ALL#