Alias: IVPBL#

(INF_CV_BANKS)
Bank Locations

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
COUNTRY_CODEVarchar2(16)CODEY
BANK_TRANSIT_CODEVarchar2(16)CODEY
BANK_NAMEVarchar2(50)VARCHAR50Y
EFT_ACCEPTEDVarchar2(4)VARCHAR4
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
STATE_PROVINCE_CODEVarchar2(16)CODE
ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
BANK_MANAGERVarchar2(50)VARCHAR50
ABA_NUMBERVarchar2(50)VARCHAR50
BANK_ACCOUNTVarchar2(30)VARCHAR30
ENTITY_CODEVarchar2(16)CODE
GL_COMPANY_CODEVarchar2(16)CODE
GL_ACCOUNT_CODE_CASHVarchar2(16)CODE
GL_ACCOUNT_CODE_CHECKVarchar2(16)CODE
GL_ACCOUNT_CODE_DEPOSITVarchar2(16)CODE
CURRENCYVarchar2(30)VARCHAR30
PRENOTE_DAYSNumber(5)NUMBER5
STARTING_NUMBERNumber(10)NUMBER10
ENDING_NUMBERNumber(10)NUMBER10
LAST_NUMBER_USEDNumber(10)NUMBER10
MANUAL_RANGEVarchar2(4)VARCHAR4
RESTRICTED_RANGEVarchar2(4)VARCHAR4
DESCRIPTIONVarchar2(50)DESCRIPTION
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30