Alias: IVDLN#

The INF_CV_LOCATIONS table is used to import location codes and their attendant data into the software data structures. Locations are user defined codes that uniquely identifies the location to the organization.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
LOCATION_CODEVarchar2(16)CODEY
PARENT_LOCATIONVarchar2(16)CODE
DESCRIPTIONVarchar2(50)DESCRIPTION
LANGUAGE_CODEVarchar2(30)VARCHAR30
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
STATE_PROVINCE_CODEVarchar2(16)CODE
COUNTRY_CODEVarchar2(16)CODE
ZIP_POSTALVarchar2(16)POSTAL CODE
MAIL_ADDRESS_LINE_1Varchar2(50)ADDRESS
MAIL_ADDRESS_LINE_2Varchar2(50)ADDRESS
MAIL_LOCALITYVarchar2(50)ADDRESS
MAIL_STATE_PROVINCE_CODEVarchar2(16)CODE
MAIL_COUNTRY_CODEVarchar2(16)CODE
MAIL_ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTNVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
GEO_CODEVarchar2(16)CODE
BILINGUAL_REGIONVarchar2(30)VARCHAR30
BILINGUAL_LOCATIONVarchar2(4)VARCHAR4
CMA_CODEVarchar2(30)VARCHAR30
INCLUDE_ALL_IN_UENHVarchar2(4)VARCHAR4
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top