POZ_SUPP_BANK_ACCT

Details

Schema: FUSION
Object owner: POZ
Object type: TABLE
Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
POZ_SUPP_BANK_ACCT_REQS_PK	BANK_ACCOUNT_REQUEST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BANK_ACCOUNT_REQUEST_ID	NUMBER		18	Yes	Account request identifier for supplier profile change management.
ASSOCIATED_ENTITY	VARCHAR2	25			Entity associated with this bank account - values are 'SUPPLIER', 'SITE' or 'ADDRESS'
SUPP_REQUEST_ID	NUMBER		18	Yes	This field is the unique identifier for a supplier request
EXT_BANK_ACCOUNT_ID	NUMBER		18		External bank account identifier
CHANGE_REQ_ROW_TYPE	VARCHAR2	30		Yes	Type of the request. This could either be 'CHANGE' or 'SNAPSHOT' or 'NEW'
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
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.
TEMP_EXT_BANK_ACCT_ID	NUMBER		18		Temp external bank account identifier which is a foreign key to IBY_TEMP_EXT_BANK_ACCTS
START_DATE	DATE				The start date of bank account assignment.
END_DATE	DATE				The end date of bank account assignment.
PRIMARY_FLAG	VARCHAR2	1			Primary account indicator
PARTY_SITE_ID	NUMBER		18		Identifier of the address/party site this bank account request is for. This will be null for Supplier level bank accounts.
VENDOR_SITE_ID	NUMBER		18		Identifier of the vendor site this bank account request is for. This will be null for Supplier and address level bank accounts.
REPLACE_BANK_ACCOUNT_FLAG	VARCHAR2	1			When end dating the assignment of a bank account with the current supplier at certain level, specify whether the installments and invoices associated with this account be updated with an alternate bank account.
ASSIGN_TO_PENDING_INSTALL_FLAG	VARCHAR2	1			At the time of creating new bank account number, user can specify the created bank account as the bank account for other installment and invoice
ASSOCIATED_BANK_ACCT_FLAG	VARCHAR2	1			Indicates that the bank account has been added from 'Search and Select' popup

Foreign Keys

Table	Foreign Table	Foreign Key Column
POZ_SUPP_BANK_ACCT_REQUESTS	poz_supp_requests	SUPP_REQUEST_ID
POZ_SUPP_BANK_ACCT_REQUESTS	iby_ext_bank_accounts	EXT_BANK_ACCOUNT_ID
POZ_SUPP_BANK_ACCT_REQUESTS	hz_party_sites	PARTY_SITE_ID
POZ_SUPP_BANK_ACCT_REQUESTS	poz_supplier_sites_all_m	VENDOR_SITE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_SUPP_BANK_ACCT_REQS_N1	Non Unique	Default	SUPP_REQUEST_ID
POZ_SUPP_BANK_ACCT_REQS_U1	Unique	Default	BANK_ACCOUNT_REQUEST_ID