CREATE TABLE [optima].[GuV_8_O21_STK] ( [Acct Nr_ori] [varchar](100) NULL, [Ledger Accts Name] [varchar](100) NULL, [Ledger Accts Name2] [varchar](100) NULL, [Handler] [varchar](100) NULL, [Dept Split] [varchar](100) NULL, [Type Acctt_] [varchar](100) NULL, [Acct No] [varchar](100) NULL, [Bookkeep Date] [datetime] NULL, [Bookkeep Period] [varchar](100) NULL, [Document No] [varchar](100) NULL, [Origin] [varchar](100) NULL, [Status] [varchar](100) NULL, [Debit Amount] [decimal](28,8) NULL, [Credit Amount] [decimal](28,8) NULL, [Debit Quantity] [decimal](28,8) NULL, [Credit Quantity] [decimal](28,8) NULL, [Aa Trtype] [varchar](100) NULL, [Department] [varchar](100) NULL, [Stock] [varchar](100) NULL, [Make Family] [varchar](100) NULL, [Make] [varchar](100) NULL, [Vehicle Type] [varchar](100) NULL, [Model Line] [varchar](100) NULL, [Factory Model] [varchar](100) NULL, [Workshop Model] [varchar](100) NULL, [Product Group] [varchar](100) NULL, [Repair Group] [varchar](100) NULL, [Kit Group] [varchar](100) NULL, [Time Code] [varchar](100) NULL, [Int Voucher No] [varchar](100) NULL, [Balancing Mark] [varchar](100) NULL, [Used Veh Dest Code] [varchar](100) NULL, [Use Of Vehicle] [varchar](100) NULL, [Acct No Next Chart] [varchar](100) NULL, [Reference Ident] [varchar](100) NULL, [Transact Date] [datetime] NULL, [Handler2] [varchar](100) NULL, [Program] [varchar](100) NULL, [Function Code] [varchar](100) NULL, [Modul] [varchar](100) NULL, [Document Key] [varchar](100) NULL, [Comment] [varchar](100) NULL, [Department Type Id] [varchar](100) NULL, [Description] [varchar](100) NULL, [Department Group] [varchar](100) NULL, [Aa Trtype Id] [varchar](100) NULL, [Description2] [varchar](100) NULL, [Own Description] [varchar](100) NULL, [Rechtseinheit] [varchar](100) NULL, [Betrieb] [varchar](100) NULL, [Marke] [varchar](100) NULL, [Mandant] [varchar](100) NULL, [Betrag] [decimal](28,8) NULL, [Text] [varchar](100) NULL, [Acct Nr] [varchar](100) NULL, [Susa] [varchar](100) NULL, [Order Number] [varchar](100) NULL, [Line Number] [varchar](100) NULL, [Inv Time] [decimal](28,8) NULL, [Inv Time Int] [decimal](28,8) NULL, [Make Time Unit] [varchar](100) NULL, [Type Acctt] [varchar](100) NULL ) GO