!!!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 name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[ENTITY_CODE]|Varchar2(16)|[CODE]|Y| |[GL_COMPANY_CODE]|Varchar2(16)|[CODE]| | |[PARENT_ENTITY]|Varchar2(16)|[CODE]| | |[STANDING]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[EFFECTIVE]|Date()|[EFFECTIVE]| | |[EXPIRY]|Date()|[EXPIRY]| | |[CHANGE_CODE]|Varchar2(16)|[CODE]| | |[ENTITY_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y| |[LOCATION_CODE]|Varchar2(16)|[CODE]| | |[INDUSTRY_CODE]|Varchar2(16)|[CODE]| | |[LEGISLATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[LANGUAGE_CODE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CURRENCY]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[DUNS_NUMBER]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[WEB_ADDRESS]|Varchar2(200)|[VARCHAR200|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |