1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071 |
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_NULLS ON
- GO
- CREATE
- OR
- ALTER VIEW [load].[Belege]
- AS
- SELECT [No],
- [Name],
- [Account Type],
- [Income Balance],
- [Last Date Modified],
- [Entry No],
- [G L Account No],
- [Posting Date],
- [Document Type],
- [Document No],
- [Description],
- [Bal Account No],
- [Department Code],
- [Make Code],
- [User Id],
- [Source Code],
- [Quantity],
- [Reason Code],
- [Gen Posting Type],
- [Gen Bus Posting Group],
- [Gen Prod Posting Group],
- [Bal Account Type],
- [Transaction No],
- [Document Date],
- [External Document No],
- [Source Type],
- [Source No],
- [No Series],
- [Branch Code],
- [Main Area],
- [Vin],
- [Book No],
- [Veh Source Code],
- [Reposted],
- [Corrected],
- [Correction To Curr No],
- [Reposting To Curr No],
- [Code],
- [Name_1],
- [Bookkeep Date],
- [Betrieb],
- [Acct Nr],
- [Betrag],
- [Amount_1],
- [Text],
- [Hauptbetrieb],
- [Marke]
- FROM [export_csv].[Belege]
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- SET ANSI_NULLS OFF
- GO
- GO
|