This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Alias: IVPBL#

The INF_CV_BANKS table is used to import banking information into the software data structures. Banks are the financial institutions that the company does business with. Both the company’s bank and the employee’s bank are created here.

Table Columns#

Column name	Data Type / Size	Mand.	Notes
ID	Number(10)		Used internally to define a unique identification for the record. This field would not be loaded.
COUNTRY_CODE	Varchar2(16)	Y
BANK_TRANSIT_CODE	Varchar2(16)	Y
BANK_NAME	Varchar2(50)	Y
EFT_ACCEPTED	Varchar2(4)
ADDRESS_LINE_1	Varchar2(50)
ADDRESS_LINE_2	Varchar2(50)
LOCALITY	Varchar2(50)
STATE_PROVINCE_CODE	Varchar2(16)
ZIP_POSTAL	Varchar2(16)
PHONE_NUMBER	Varchar2(20)
PHONE_EXTENSION	Varchar2(16)
FAX_NUMBER	Varchar2(20)
BANK_MANAGER	Varchar2(50)
ABA_NUMBER	Varchar2(50)
BANK_ACCOUNT	Varchar2(30)
ENTITY_CODE	Varchar2(16)
GL_COMPANY_CODE	Varchar2(16)
GL_ACCOUNT_CODE_CASH	Varchar2(16)
GL_ACCOUNT_CODE_CHECK	Varchar2(16)
GL_ACCOUNT_CODE_DEPOSIT	Varchar2(16)
CURRENCY	Varchar2(30)
PRENOTE_DAYS	Number(5)
STARTING_NUMBER	Number(10)
ENDING_NUMBER	Number(10)
LAST_NUMBER_USED	Number(10)
MANUAL_RANGE	Varchar2(4)
RESTRICTED_RANGE	Varchar2(4)
DESCRIPTION	Varchar2(50)
CREATE_DATE	Date()		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USER	Varchar2(30)		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATE	Date()		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USER	Varchar2(30)		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.