CE_INDEX_BANKS

This table contains bank information.

Details

• Schema: FUSION

• Object owner: CE

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CE_INDEX_BANKS_PK	BANK_PARTY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
BANK_PARTY_ID	NUMBER		18	Yes	Identifier of the bank.	Active
BANK_NAME	VARCHAR2	360		Yes	Name of the bank.	Active
BANK_NAME_ALT	VARCHAR2	360			Alternate name of the bank.	Active
BANK_NUMBER	VARCHAR2	30			Numerical value assigned to the bank.	Active
BANK_PARTY_NUMBER	VARCHAR2	30		Yes	Numerical value assigned to the bank party.
HOME_COUNTRY_CODE	VARCHAR2	2			Country of the bank.
START_DATE	DATE			Yes	First date that the bank is active.	Active
END_DATE	DATE				Last date that the bank is active.	Active
BANK_INSTITUTION_TYPE	VARCHAR2	30		Yes	Institution type of the bank. For example, bank and clearing house.	Active
TAXPAYER_ID_NUMBER	VARCHAR2	20			Bank identifier assigned by a tax authority.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ce_bank_branch_identifiers	ce_index_banks	BANK_OR_BRANCH_ID
ce_payment_instruments	ce_index_banks	BANK_ID
iby_vcard_programs_b	ce_index_banks	VCARD_PROGRAM_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CE_INDEX_BANKS_N1	Non Unique	Default	BANK_NAME
CE_INDEX_BANKS_N2	Non Unique	Default	UPPER("BANK_NAME")
CE_INDEX_BANKS_N3	Non Unique	Default	BANK_NUMBER
CE_INDEX_BANKS_N4	Non Unique	Default	HOME_COUNTRY_CODE, BANK_NAME
CE_INDEX_BANKS_N5	Non Unique	Default	BANK_PARTY_NUMBER
CE_INDEX_BANKS_N6	Non Unique	Default	BANK_INSTITUTION_TYPE
CE_INDEX_BANKS_N7	Non Unique	Default	REQUEST_ID
CE_INDEX_BANKS_U1	Unique	Default	BANK_PARTY_ID