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.AR_CMGT_TRADE_REF_DATA

Object Details

Object Name:	AR_CMGT_TRADE_REF_DATA
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_CMGT_TRADE_REF_DATA
Subobject Name:
Status:	VALID

The AR_CMGT_TRADE_REF_DATA table stores information about the a company's credit and trade relationships of a company under credit review with other creditors. The A company's credit relationships with other trade organizations may be a predictor of the its general creditworthiness of the company and its ability to pay debts owed to you.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CMGT_TRADE_REF_DATA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DATAPOINT_ID
AR_CMGT_TRADE_REF_DATA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREDIT_REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DATAPOINT_ID	NUMBER	(15)	Yes	Unique identifier of the bank trade reference data point. to which the bank accounts belong.
CREDIT_REQUEST_ID	NUMBER	(15)	Yes	Identifier of the credit request that initiated the collection of this companys trade reference informationCredit request identifier for which bank account information is reported for the company under credit review.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
COUNTRY	VARCHAR2	(60)		Country of the address for the Ttrade Rreference supplied for the company under credit review.
TAX_NUMBER	VARCHAR2	(50)		Tax Identification number for the trade Rreference
REFERENCE_NAME	VARCHAR2	(50)		Name of the company with whom the company under credit review has a trade relationship
CONTACT_NAME	VARCHAR2	(50)		Name of the person who supplied the Ttrade Rreference information for the company under credit review
ADDRESS	VARCHAR2	(100)		Address of the trade Rreference address
PHONE_NUMBER	VARCHAR2	(20)		Pnone number of the trade Rreference person
CITY	VARCHAR2	(60)		City of the trade Rreference address
FAX_NUMBER	VARCHAR2	(20)		Fax number of the trade Rreference
STATE	VARCHAR2	(60)		State of the the trade reference address
EMAIL	VARCHAR2	(240)		e-amil of the Ttrade Rreference person
POSTAL_CODE	VARCHAR2	(60)		Postal code of the Ttrade Rreference address
PROVINCE	VARCHAR2	(60)		Province of the Ttrade Rreference
URL	VARCHAR2	(240)		URL of the Ttrade Rreference
REPORT_DATE	DATE			Receipt date of the Ttrade Rreference information
LAST_TRANSACTION_DATE	DATE			Date of the last transaction between the Ttrade Rreference and the company under credit review
NUMBERS_OF_YEARS_IN_TRADE	NUMBER	(4)		Number of years that the Ttrade Rreference and the company under credit review have been transacting
PAYMENT_TERMS	VARCHAR2	(30)		Standard payment terms between the trade reference and for the company under credit review for the Trade Reference
CREDIT_LIMIT	NUMBER			Total amount of credit extended by the Ttrade Rreference to the company under credit review
CURRENCY	VARCHAR2	(30)		Currency of the credit extended by the Ttrade Rreference
AMOUNT_OWED	NUMBER			Amount owed to the Ttrade Rreference by the company under credit review.
CREDIT_BALANCE	NUMBER			Amount of credit available to the company by the Ttrade Rreference for new purchases.
PAST_DUE_AMOUNT	NUMBER			Past due balance owed to the Ttrade Rreference by the company under credit review.
INTERNAL_TRADE_RATING	VARCHAR2	(15)		Trade Rreference assessment of the creditworthiness of the company under credit review
CASE_FOLDER_ID	NUMBER	(15)		Identifier of the case folder. Foreign key to the AR_CMGT_CASE_FOLDERS table.
NOTES	VARCHAR2	(2000)		Free-form text area to provide additional information gathered from the the trade Rreference

Query Text

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


SELECT DATAPOINT_ID
,      CREDIT_REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COUNTRY
,      TAX_NUMBER
,      REFERENCE_NAME
,      CONTACT_NAME
,      ADDRESS
,      PHONE_NUMBER
,      CITY
,      FAX_NUMBER
,      STATE
,      EMAIL
,      POSTAL_CODE
,      PROVINCE
,      URL
,      REPORT_DATE
,      LAST_TRANSACTION_DATE
,      NUMBERS_OF_YEARS_IN_TRADE
,      PAYMENT_TERMS
,      CREDIT_LIMIT
,      CURRENCY
,      AMOUNT_OWED
,      CREDIT_BALANCE
,      PAST_DUE_AMOUNT
,      INTERNAL_TRADE_RATING
,      CASE_FOLDER_ID
,      NOTES
FROM AR.AR_CMGT_TRADE_REF_DATA;

Dependencies

[top of page]

AR.AR_CMGT_TRADE_REF_DATA does not reference any database object

AR.AR_CMGT_TRADE_REF_DATA is referenced by following:

AR: AR_CMGT_TRADE_REF_DATA#