INF_CV_BANKS
Back to current versionRestore this version

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation