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 | ||
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 |