load.Belege_Plan.sql 616 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE
  6. OR
  7. ALTER VIEW [load].[Belege_Plan]
  8. AS
  9. SELECT [Entry No],
  10. [Budget Name],
  11. [G L Account No],
  12. [Date],
  13. [Global Dimension 1 Code],
  14. [Global Dimension 2 Code],
  15. [Amount],
  16. [Description],
  17. [Business Unit Code],
  18. [User Id],
  19. [Budget Dimension 1 Code],
  20. [Budget Dimension 2 Code],
  21. [Budget Dimension 3 Code],
  22. [Budget Dimension 4 Code],
  23. [Last Date Modified],
  24. [Dimension Set Id],
  25. [Branch Code],
  26. [Bookkeep Date],
  27. [Hauptbetrieb],
  28. [Betrieb Nr],
  29. [Plan],
  30. [Acct Nr]
  31. FROM [export_csv].[Belege_Plan]
  32. GO
  33. SET QUOTED_IDENTIFIER OFF
  34. GO
  35. SET ANSI_NULLS OFF
  36. GO
  37. GO