CREATE TABLE [D011-10-1].[DSAHIST_ØS_Indsigt_Posteringer](
  [KASSE] [varchar](3) COLLATE Norwegian_100_CI_AS NULL,
  [BOGFDAT] [datetime2](3) NULL,
  [EKSP] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [BILAG] [varchar](6) COLLATE Norwegian_100_CI_AS NULL,
  [POSTYPE] [varchar](5) COLLATE Norwegian_100_CI_AS NULL,
  [BELOB] [decimal](18,2) NULL,
  [NETBELOB] [decimal](18,2) NULL,
  [DEBKRD] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [KTONR] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [AKTONR] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [INSTNR] [varchar](2) COLLATE Norwegian_100_CI_AS NULL,
  [LEVNR] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [CPRNR] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [DEBNR] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [VALDAT] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [FOPLAAR] [varchar](4) COLLATE Norwegian_100_CI_AS NULL,
  [BETART] [varchar](3) COLLATE Norwegian_100_CI_AS NULL,
  [SOCRKOD] [varchar](2) COLLATE Norwegian_100_CI_AS NULL,
  [SKATKOD] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [DAEKKOD] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [PENSKOD] [varchar](4) COLLATE Norwegian_100_CI_AS NULL,
  [BSKAT] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [OMRNR] [varchar](3) COLLATE Norwegian_100_CI_AS NULL,
  [SAGNR] [varchar](8) COLLATE Norwegian_100_CI_AS NULL,
  [FREMBET] [varchar](2) COLLATE Norwegian_100_CI_AS NULL,
  [POSTEXT] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [BETFORM] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [RETUSRID] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [OPRSTAMP] [varchar](40) COLLATE Norwegian_100_CI_AS NULL,
  [DAEKDTOF] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [DAEKDTOT] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [HKASSE] [varchar](3) COLLATE Norwegian_100_CI_AS NULL,
  [UDBTXT1] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [UDBTXT2] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [UDBTXT3] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [UDBTXT4] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [UDBSTAT] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [UDBFORM] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [UDBDAT] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [UDBTID] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [BETNR] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [TJKOUT] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [TJKUSRID] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [TJKDAT] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [BTYPE] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [BIDENT] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [KATEGORI] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [INSTITUTION] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [DECKTONR] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [ANTAL] [decimal](18,2) NULL,
  [NKSYDART] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [BETKTONR] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [LEVNRTYPE] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [LEVTYPENR] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [PROJEKTNR] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [KTOALIAS] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [EKSTERNTYPE] [varchar](5) COLLATE Norwegian_100_CI_AS NULL,
  [EKSTERNIDENT] [varchar](40) COLLATE Norwegian_100_CI_AS NULL,
  [EINDKLBNR] [varchar](6) COLLATE Norwegian_100_CI_AS NULL,
  [UDBLBNR] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [UDLBET] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [UDLOMK] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [VALUTA] [varchar](3) COLLATE Norwegian_100_CI_AS NULL,
  [VALUTAKURS] [decimal](18,2) NULL,
  [VALUTABELOB] [decimal](18,2) NULL,
  [IBAN] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [BBAN] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [SWIFT] [varchar](30) COLLATE Norwegian_100_CI_AS NULL,
  [BANKKODE] [varchar](30) COLLATE Norwegian_100_CI_AS NULL,
  [BANKNAVN] [varchar](100) COLLATE Norwegian_100_CI_AS NULL,
  [AFDNR] [varchar](10) COLLATE Norwegian_100_CI_AS NULL,
  [BESTILNR] [varchar](12) COLLATE Norwegian_100_CI_AS NULL,
  [ENHEDER] [varchar](17) COLLATE Norwegian_100_CI_AS NULL,
  [ENHEDSPRIS] [decimal](18,2) NULL,
  [EXTVARENR] [varchar](40) COLLATE Norwegian_100_CI_AS NULL,
  [ILMEXTFAKT] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [LINIENR] [varchar](5) COLLATE Norwegian_100_CI_AS NULL,
  [REJSYDARTID] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [RGNAAR] [int] NULL,
  [VARENR] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [VARETEKST] [varchar](100) COLLATE Norwegian_100_CI_AS NULL,
  [UDBTXT] [varchar](300) COLLATE Norwegian_100_CI_AS NULL,
  [KORTART] [varchar](2) COLLATE Norwegian_100_CI_AS NULL,
  [BETALINGSID] [varchar](20) COLLATE Norwegian_100_CI_AS NULL,
  [CDEBITOR] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [SYS_KommuneId] [int] NULL,
  [SYS_BatchDate] [datetime2](3) NULL,
  [SYS_RowID] [bigint] identity(1,1) NOT NULL,
  [SYS_ExtractDate] [datetime2](3) NULL,
  [SYS_SourceFileID] [varchar](80) COLLATE Norwegian_100_CI_AS NULL,
  [SYS_RettelserTidAngivelse] [datetime2](3) NULL,
  [SYS_VersionID] [bigint] NULL,
  [SYS_Checksum] AS (CONVERT([bigint],hashbytes('SHA2_256',concat([KASSE],[BOGFDAT],[EKSP],[BILAG],[POSTYPE],[BELOB],[NETBELOB],[DEBKRD],[KTONR],[AKTONR],[INSTNR],[LEVNR],[CPRNR],[DEBNR],[VALDAT],[FOPLAAR],[BETART],[SOCRKOD],[SKATKOD],[DAEKKOD],[PENSKOD],[BSKAT],[OMRNR],[SAGNR],[FREMBET],[POSTEXT],[BETFORM],[RETUSRID],[OPRSTAMP],[DAEKDTOF],[DAEKDTOT],[HKASSE],[UDBTXT1],[UDBTXT2],[UDBTXT3],[UDBTXT4],[UDBSTAT],[UDBFORM],[UDBDAT],[UDBTID],[BETNR],[TJKOUT],[TJKUSRID],[TJKDAT],[BTYPE],[BIDENT],[KATEGORI],[INSTITUTION],[DECKTONR],[ANTAL],[NKSYDART],[BETKTONR],[LEVNRTYPE],[LEVTYPENR],[PROJEKTNR],[KTOALIAS],[EKSTERNTYPE],[EKSTERNIDENT],[EINDKLBNR],[UDBLBNR],[UDLBET],[UDLOMK],[VALUTA],[VALUTAKURS],[VALUTABELOB],[IBAN],[BBAN],[SWIFT],[BANKKODE],[BANKNAVN],[AFDNR],[BESTILNR],[ENHEDER],[ENHEDSPRIS],[EXTVARENR],[ILMEXTFAKT],[LINIENR],[REJSYDARTID],[RGNAAR],[VARENR],[VARETEKST],[UDBTXT],[KORTART],[BETALINGSID],[CDEBITOR])),0)) PERSISTED,
  [SYS_ExecutionId] [bigint] NULL,
  [SYS_DataDeliveryBatchId_Create] [bigint] NULL
) 
on sys_batch_date_sc(SYS_BatchDate)
GO

CREATE UNIQUE CLUSTERED INDEX [IDX_CL_D011-10-1_DSAHIST_ØS_Indsigt_Posteringer] On [D011-10-1].[DSAHIST_ØS_Indsigt_Posteringer] (SYS_BatchDate, SYS_KommuneId, SYS_RowID) with (data_compression = page, STATISTICS_INCREMENTAL = ON) on sys_batch_date_sc(SYS_BatchDate);
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Regnskabnsoplysninger på posteringsniveua', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'KASSENR.', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'KASSE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BOGF.DATO', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BOGFDAT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'EKSPEDITIONSNR.', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'EKSP';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BILAGSNR.', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BILAG';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'POSTERINGSTYPE', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'POSTYPE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BELØB', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BELOB';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'NETTOBELØB', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'NETBELOB';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'DEBET-KREDIT', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'DEBKRD';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'KONTONUMMER', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'KTONR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'ARKIVKONTONR.', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'AKTONR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'INSTITUTIONSNR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'INSTNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'LEVERANDØR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'LEVNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'PERSONNR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'CPRNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'DEBITORNR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'DEBNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'VALØRDATO', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'VALDAT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'FORFALDS/PÅLIGNINGSÅR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'FOPLAAR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BETALINGSART', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BETART';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'SOCIALREG.KODE', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SOCRKOD';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'SKATTEPLIGTIG KODE', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SKATKOD';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'DÆKKODE', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'DAEKKOD';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'PENSIONSKODE', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'PENSKOD';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'B-SKAT', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BSKAT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'OMRÅDENUMMER', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'OMRNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'SAGSNUMMER', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SAGNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'FREMMED INDBETALER', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'FREMBET';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'POSTERINGSTEKST', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'POSTEXT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BETALINGSFORM', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BETFORM';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BRUGERID', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'RETUSRID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'OPRETTELSESTIDSPUNKT', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'OPRSTAMP';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'DÆKKER PERIODEN FRA', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'DAEKDTOF';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'DÆKKER PERIODEN TIL', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'DAEKDTOT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'HOVEDKASSENR.', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'HKASSE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'UDBETALINGSTEKST 1', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBTXT1';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'UDBETALINGSTEKST 2', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBTXT2';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'UDBETALINGSTEKST 3', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBTXT3';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'UDBETALINGSTEKST 4', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBTXT4';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'STATUSFELT', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBSTAT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BETALINGSFORM', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBFORM';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'UDBETALINGDATO', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBDAT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'UDBETALINGTIDSPUNKT', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBTID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BETALINGSNR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BETNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'POSTERING TJEKKET', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'TJKOUT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'POSTERING TJEKKET AF', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'TJKUSRID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'POSTERING TJEKKET DATO', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'TJKDAT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BILAGSTYPE', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BTYPE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BILAGSIDENTIFIKATION', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BIDENT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'KATEGORI.', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'KATEGORI';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'INSTITUTIONNR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'INSTITUTION';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'DECENTRAL KONTONR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'DECKTONR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'ANTAL', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'ANTAL';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'NEMKONTO YDELSESART', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'NKSYDART';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'NEMKONTO BETALINGSOPL REG.KONTONR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BETKTONR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'HVILKEN TYPE ER LEVERANDØRNR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'LEVNRTYPE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'LEVERANDØRNR AF LEVNRTYPE', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'LEVTYPENR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'PROJEKTNR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'PROJEKTNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Kontoalias', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'KTOALIAS';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Eksternt system', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'EKSTERNTYPE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Identifikation fra ekternt system', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'EKSTERNIDENT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Lobenr i eIndkomsttabel', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'EINDKLBNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Udbetalings lbnr', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBLBNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'UDENLANDSK BETALING', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDLBET';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'UDENLANDSKE OMKOSTNINGER', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDLOMK';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'VALUTA', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'VALUTA';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'VALUTAKURS', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'VALUTAKURS';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'VALUTA BELØB', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'VALUTABELOB';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'IBAN', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'IBAN';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BBAN', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BBAN';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'SWIFT', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SWIFT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BANKKODE', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BANKKODE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'BANKNAVN', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BANKNAVN';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'AFDNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BESTILNR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'ENHEDER';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'ENHEDSPRIS';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'EXTVARENR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'ILMEXTFAKT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'LINIENR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'REJSYDARTID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'REGNSKABSÅR', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'RGNAAR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'VARENR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'VARETEKST';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'UDBTXT';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'KORTART';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'BETALINGSID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'CDEBITOR';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder nummeret på den kommune, som rækken tilhører', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_KommuneId';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder information om, hvilken batch rækken er indlæst i', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_BatchDate';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder et fortløbende nummer, så alle rækker i tabellen har et unikt nummer', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_RowID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder det dato stempel, som kildefilen er markeret med', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_ExtractDate';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder ID for den primære snitflade, hvor data i rækken stammer fra', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_SourceFileID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder den forretningsmæssige tidsangivelse for rækken. Denne bruges hvis data skal slettes med tidsangivelse', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_RettelserTidAngivelse';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder et versionsnummer for den pågældende række', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_VersionID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder cheksum info', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_Checksum';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'SysExecutionId', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_ExecutionId';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'SysDataDeliveryBatchIdCreate', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer', 
@level2type = N'COLUMN', @level2name = N'SYS_DataDeliveryBatchId_Create';
GO

EXEC sys.sp_addextendedproperty 
@name = N'DataArea', 
@value = N'oekonomi', 
@level0type = N'SCHEMA', @level0name = N'D011-10-1', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_ØS_Indsigt_Posteringer';
GO

