Personality Knowledgebase 5.05
HighLine
Wiki
G’day (anonymous guest)
User Preferences
Log in
Register a new user!
For full search, hit enter...
Recent Searches
INF_CV_BANKS
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.3 mins, 78 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
6
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVPBL
#
(INF_CV_BANKS)
Bank Locations
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
COUNTRY_CODE
Varchar2(16)
CODE
Y
BANK_TRANSIT_CODE
Varchar2(16)
CODE
Y
BANK_NAME
Varchar2(50)
VARCHAR50
Y
EFT_ACCEPTED
Varchar2(4)
VARCHAR4
ADDRESS_LINE_1
Varchar2(50)
ADDRESS
ADDRESS_LINE_2
Varchar2(50)
ADDRESS
LOCALITY
Varchar2(50)
ADDRESS
STATE_PROVINCE_CODE
Varchar2(16)
CODE
ZIP_POSTAL
Varchar2(16)
POSTAL CODE
PHONE_NUMBER
Varchar2(20)
TELEPHONE
PHONE_EXTENSION
Varchar2(16)
VARCHAR16
FAX_NUMBER
Varchar2(20)
TELEPHONE
BANK_MANAGER
Varchar2(50)
VARCHAR50
ABA_NUMBER
Varchar2(50)
VARCHAR50
BANK_ACCOUNT
Varchar2(30)
VARCHAR30
ENTITY_CODE
Varchar2(16)
CODE
GL_COMPANY_CODE
Varchar2(16)
CODE
GL_ACCOUNT_CODE_CASH
Varchar2(16)
CODE
GL_ACCOUNT_CODE_CHECK
Varchar2(16)
CODE
GL_ACCOUNT_CODE_DEPOSIT
Varchar2(16)
CODE
CURRENCY
Varchar2(30)
VARCHAR30
PRENOTE_DAYS
Number(5)
NUMBER5
STARTING_NUMBER
Number(10)
NUMBER10
ENDING_NUMBER
Number(10)
NUMBER10
LAST_NUMBER_USED
Number(10)
NUMBER10
MANUAL_RANGE
Varchar2(4)
VARCHAR4
RESTRICTED_RANGE
Varchar2(4)
VARCHAR4
DESCRIPTION
Varchar2(50)
DESCRIPTION
CREATE_DATE
Date()
DATE
CREATE_USER
Varchar2(30)
VARCHAR30
CHANGE_DATE
Date()
DATE
CHANGE_USER
Varchar2(30)
VARCHAR30
Hello, 10.86.0.2
Index
Recent Updates
Wiki Formatting
Search Help