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_BANK_REF_DATA

Object Details

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

The AR_CMGT_BANK_REF_DATA table stores information about the banks where a company under credit review has active accounts. This information is supplied by the company under credit review supplies this information to demonstrate its liquidity and ability to meet its credit obligations. Each bank may have multiple accounts and ; current balance information for each account is stored in the AR_CMGT_BANK_REF_ACCTS table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CMGT_BANK_REF_DATA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DATAPOINT_ID
AR_CMGT_BANK_REF_DATA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREDIT_REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DATAPOINT_ID	NUMBER	(15)	Yes	Unique data point identifier for bank reference data pointCcollateral information used in displaying the value of the data in the case folder
CREDIT_REQUEST_ID	NUMBER	(15)	Yes	Identifier of the credit request that initiated the collection of this companys bank information
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)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
BANK_NAME	VARCHAR2	(50)	Yes	Name of the bank where the company under credit review has active accounts
ADDRESS	VARCHAR2	(100)		Bank Aaddress
CITY	VARCHAR2	(60)		City of the bank address
STATE	VARCHAR2	(60)		State of the bank address
POSTAL_CODE	VARCHAR2	(60)		Postal Ccode of the Bbank address
PROVINCE	VARCHAR2	(60)		Province of the Bbank address
COUNTRY	VARCHAR2	(60)		Country of the Bbank address
CONTACT_NAME	VARCHAR2	(50)		Bank contact person for the company under review
PHONE	VARCHAR2	(20)		Phone number of the bank contact person
FAX	VARCHAR2	(20)		Fax number of the bank contact person
EMAIL	VARCHAR2	(240)		Email address of the bank contact person
URL	VARCHAR2	(240)		Website address of the bank
BANK_ROUTING_NUMBER	VARCHAR2	(30)		Routing number of the bank used by 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 bank reference

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
,      BANK_NAME
,      ADDRESS
,      CITY
,      STATE
,      POSTAL_CODE
,      PROVINCE
,      COUNTRY
,      CONTACT_NAME
,      PHONE
,      FAX
,      EMAIL
,      URL
,      BANK_ROUTING_NUMBER
,      CASE_FOLDER_ID
,      NOTES
FROM AR.AR_CMGT_BANK_REF_DATA;

Dependencies

[top of page]

AR.AR_CMGT_BANK_REF_DATA does not reference any database object

AR.AR_CMGT_BANK_REF_DATA is referenced by following:

APPS: AR_CMGT_BANK_REF_DATA