!!!Alias: IVDEN (INF_CV_ENTITIES) \\ Date sensitive details about an entity. !!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]| |