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 | ||
| EFFECTIVE | Date() | EFFECTIVE | ||
| EXPIRY | Date() | EXPIRY | ||
| CHANGE_CODE | Varchar2(16) | CODE | ||
| ENTITY_NAME | Varchar2(50) | VARCHAR50 | Y | |
| LOCATION_CODE | Varchar2(16) | CODE | ||
| INDUSTRY_CODE | Varchar2(16) | CODE | ||
| LEGISLATION | Varchar2(30) | VARCHAR30 | ||
| LANGUAGE_CODE | Varchar2(30) | VARCHAR30 | ||
| CURRENCY | Varchar2(30) | VARCHAR30 | ||
| DUNS_NUMBER | Varchar2(16) | VARCHAR16 | ||
| WEB_ADDRESS | Varchar2(200) | VARCHAR200 | ||
| CREATE_DATE | Date() | DATE | ||
| CREATE_USER | Varchar2(30) | VARCHAR30 | ||
| CHANGE_DATE | Date() | DATE | ||
| CHANGE_USER | Varchar2(30) | VARCHAR30 |
