load.Belege.sql 943 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE
  6. OR
  7. ALTER VIEW [load].[Belege]
  8. AS
  9. SELECT [No],
  10. [Name],
  11. [Account Type],
  12. [Income Balance],
  13. [Last Date Modified],
  14. [Entry No],
  15. [G L Account No],
  16. [Posting Date],
  17. [Document Type],
  18. [Document No],
  19. [Description],
  20. [Bal Account No],
  21. [Department Code],
  22. [Make Code],
  23. [User Id],
  24. [Source Code],
  25. [Quantity],
  26. [Reason Code],
  27. [Gen Posting Type],
  28. [Gen Bus Posting Group],
  29. [Gen Prod Posting Group],
  30. [Bal Account Type],
  31. [Transaction No],
  32. [Document Date],
  33. [External Document No],
  34. [Source Type],
  35. [Source No],
  36. [No Series],
  37. [Branch Code],
  38. [Main Area],
  39. [Vin],
  40. [Book No],
  41. [Veh Source Code],
  42. [Reposted],
  43. [Corrected],
  44. [Correction To Curr No],
  45. [Reposting To Curr No],
  46. [Code],
  47. [Name_1],
  48. [Bookkeep Date],
  49. [Betrieb],
  50. [Acct Nr],
  51. [Betrag],
  52. [Amount_1],
  53. [Text],
  54. [Hauptbetrieb],
  55. [Marke]
  56. FROM [export_csv].[Belege]
  57. GO
  58. SET QUOTED_IDENTIFIER OFF
  59. GO
  60. SET ANSI_NULLS OFF
  61. GO
  62. GO