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

CREATE TABLE [optima].[GuV_8_O21] (
   [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](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](200) 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,
   [Betrag] [decimal](28,8) NULL,
   [Mandant] [varchar](100) NULL,
   [Menge] [varchar](100) NULL,
   [Text] [varchar](200) 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
)


GO