aa_dwh.Module.sql 620 B

12345678910111213141516171819202122232425
  1. CREATE TABLE [aa_dwh].[Module] (
  2. [CLIENT_DB] [varchar](20) NOT NULL,
  3. [System] [varchar](20) NULL,
  4. [F_Belege_SKR51] [bit] NOT NULL
  5. DEFAULT ('0'),
  6. [F_Belege] [bit] NOT NULL
  7. DEFAULT ('0'),
  8. [F_Forderungen] [bit] NOT NULL
  9. DEFAULT ('0'),
  10. [S_Aftersales] [bit] NOT NULL
  11. DEFAULT ('0'),
  12. [S_Offene_Auftraege] [bit] NOT NULL
  13. DEFAULT ('0'),
  14. [V_Bestand] [bit] NOT NULL
  15. DEFAULT ('0'),
  16. [V_Verbindlichkeiten] [bit] NOT NULL
  17. DEFAULT ('0'),
  18. [V_Verkauf] [bit] NOT NULL
  19. DEFAULT ('0')
  20. ,CONSTRAINT [PK_Module] PRIMARY KEY CLUSTERED ([CLIENT_DB])
  21. )
  22. GO