Alias: IVDEN#

The INF_CV_ENTITIES table is used to import entity codes and their attendant data into the software data structures. The Entity Code is a user-defined code that uniquely identifies the entity. It is often an abbreviation of the name or initials, or an acronym by which the organization refers to itself.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
GL_COMPANY_CODEVarchar2(16)CODE
PARENT_ENTITYVarchar2(16)CODE
STANDINGVarchar2(30)VARCHAR30
EFFECTIVEDate()EFFECTIVE
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
ENTITY_NAMEVarchar2(50)VARCHAR50Y
LOCATION_CODEVarchar2(16)CODE
INDUSTRY_CODEVarchar2(16)CODE
LEGISLATIONVarchar2(30)VARCHAR30
LANGUAGE_CODEVarchar2(30)VARCHAR30
CURRENCYVarchar2(30)VARCHAR30
DUNS_NUMBERVarchar2(16)VARCHAR16
WEB_ADDRESSVarchar2(200)VARCHAR200
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30