ID |
PK Sequence |
JUR_PERS_ID |
FK to JURIDISK_PERSONER |
FD_SYSTEM_KODE |
Fiskerisystemskilde |
PERSON_JN |
Is this a person or a company. J=this is a person. N or NULL=this is a company |
FIRMA_NAVN |
Company name |
FORNAVN |
First name of person |
EFTERNAVN |
Surname of person |
NATIONALITET |
Ukendt persons nationalitet |
TELEFON |
telephone number (can include country code example +45) |
MOBIL |
mobile telephone number (can contain country code example +45) |
EMAIL |
email address |
FAX |
Fax Number (can contain country code example +45) |
CPR_NR |
Danish CPR Number without '-' |
PAS_NR |
passport number |
ID_KORT_NR |
Identifications card number |
ADRESS1 |
first line of address |
ADRESS2 |
second line of address |
POST_KODE |
addresses post district/post kode/nr (ikke et kode tabel) |
POST_BY |
postal town |
NATION_KODE |
FK to NATIONER |
ROLLE_KODE |
FK to JUR_PERS_UNK_ROLLER |
OPRETTELSESTIDSPUNKT |
Tidspunkt for oprettelse af forekomst i UTC |
OPDATERET_AF |
Initialer for den person der har opdateret rækken. |
OPDATERET_UTC |
Tidspunkt for opdatering i UTC |