| LICENCE_ID |
Unique identifier for a licence. |
| LICENSEE_ID |
Unique identifier for the company. |
| LICENCE_NAME |
Name of the licence. |
| LICENCE_TYPE |
Type of licence: app = application, exp = exploration, exp&pro = exploration and production, pro = production, rounds = rounds |
| NICK_NAME |
Nick name is often the prospect or the geographical position |
| SECTOR_ID |
Unique identifier for a sector. |
| START_DATE |
Licence issue date |
| END_DATE |
Licence expire date. In case of licence extension the date is written over |
| CREATE_USER_ID |
Id for the user who created this record. |
| CREATE_DATE |
Date and time this record was created. |
| UPDATE_USER_ID |
Id for the user who last updated this record. |
| UPDATE_DATE |
Date and time this record was last updated. |
| LICENSE_STATUS_ID |
Unique identifier for the purpose of a licence |
| LICENSE_PURPOSE_ID |
Unique identifier for the purpose of a Llicence. |
| LICENSE_MATERIAL_ID |
Unique identifier for one kind of material. |