C11/System/OPTIMA/SQL/schema/GC/tables/optima.GuV_8_O21_SKR.sql

CREATE TABLE [optima].[GuV_8_O21_SKR] (
   [Acct Nr] [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](255) NULL,
   [Int Voucher No] [varchar](255) NULL,
   [Balancing Mark] [varchar](100) NULL,
   [Used Veh Dest Code] [varchar](100) NULL,
   [Use Of Vehicle] [varchar](255) NULL,
   [Acct No Next Chart] [varchar](100) NULL,
   [Reference Ident] [varchar](100) NULL,
   [Transact Date] [varchar](100) 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](500) NULL,
   [Department Type Id] [varchar](100) NULL,
   [Description_Department] [varchar](500) NULL,
   [Department Group] [varchar](100) NULL,
   [Aa Trtype Id] [varchar](100) NULL,
   [Description] [varchar](500) NULL,
   [Own Description] [varchar](100) NULL,
   [Rechtseinheit] [varchar](100) NULL,
   [Betrieb] [varchar](100) NULL,
   [Marke] [varchar](100) NULL,
   [Betrag] [decimal](28,8) NULL,
   [Mandant] [varchar](100) NULL,
   [Menge] [varchar](100) NULL,
   [Text] [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,
   [Site] [varchar](100) NULL,
   [KST] [varchar](255) NULL,
   [Model Line_vpp5q] [varchar](100) NULL,
   [Mod Lin Specify_vpp5q] [varchar](100) NULL,
   [Kostenträger_mit_Bez_] [varchar](100) NULL,
   [Kostenträger] [varchar](100) NULL,
   [Customer Number] [varchar](100) NULL,
   [Customer Group] [varchar](100) NULL,
   [Absatzkanal] [varchar](100) NULL,
   [GuV_Bilanz] [varchar](100) NULL,
   [Susa2] [varchar](100) NULL,
   [Ebene31] [varchar](100) NULL,
   [Marke für Kostenträger] [varchar](100) NULL,
   [Kostenträger_mit_Bez] [varchar](100) NULL,
   [ACCT_Detail] [varchar](100) NULL,
   [Buchungen ohne Marke] [varchar](100) NULL,
   [Buchungen ohne KST] [varchar](100) NULL,
   [Buchungen ohne Absatzkanal] [varchar](100) NULL,
   [Destination] [varchar](100) NULL
)


GO