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.

Tables loaded: P2K_PR_BANK_LOCATIONS

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	Validation: Must be a valid country code defined on P2K_CM_COUNTRIES.
BANK_TRANSIT_CODE	Varchar2(16)	Y
BANK_NAME	Varchar2(50)	Y
EFT_ACCEPTED	Varchar2(4)		Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N”, “NO” or “0”. All other values will translate to True.
ADDRESS_LINE_1	Varchar2(50)
ADDRESS_LINE_2	Varchar2(50)
LOCALITY	Varchar2(50)
STATE_PROVINCE_CODE	Varchar2(16)		Validation: Must be a valid state code or province code, for the COUNTRY_CODE indicated on P2K_CM_STATE_PROVINCES.
ZIP_POSTAL	Varchar2(16)		Validation: Must be formatted in the correct format, for the country indicated
PHONE_NUMBER	Varchar2(20)		Validation: Must be formatted in the correct format, for the country indicated by the physical location. Derivation: Will be derived from the PHONE_NUMBER for the PARENT_LOCATION, if a PARENT_LOCATION has been defined
PHONE_EXTENSION	Varchar2(16)
FAX_NUMBER	Varchar2(20)		Validation: Must be formatted in the correct format, for the country indicated by the physical location.
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.