Tabel

RUT_VIRKSOMHEDER


Beskrivelse ?

Contains the data associated with RUT units. The central entity in the RUT application.

Størrelse (Antal rækker) ?

6304

Indhold (Kolonner/variable) ?

Navn Indhold
VIRK_ID Unique synthetic id (primary key). Generated from a sequence
RUT_NUMMER Unique identifier generated from a sequence. Format: Rxxxxxxx where x is a single digit
SE_NUMMER SE number
CVR_NUMMER CVR number
CVR_ENHED_01 Boolean (0 or 1) indicating whether this is company registered in the CVR register
NAVN Company name
BRANCHE_ID Foreign key for RUT_BRANCHER
KONTAKT_OPL_ID Foreign key for RUT_KONTAKT_OPLYSNINGER
JOURNAL_NUMMER The related journal number, retrieved from SOES EDSH
SLETTET_01 Boolean (0 or 1) indicating whether this company is logically deleted. If true the company is not included in the output reports.
ALLE_LUKKET_01 Boolean (0 or 1) indicating whether all SOES ESDH cases concerning this company are closed at the time of committing this row. If true, the complete dataset for this company will be updated in the next report.
MOMS_NR_HJEMLAND Foreign tax number
ANDET_VIRK_NR Foreign company id
RETTET_TIDSPUNKT Timestamp for last commit
STATUS_ID Foreign key for RUT_STATUS
RUT_BRUGER The user that performed the last change to the data in the row
VERSION A unique id used by the RUT application.