CREATE TABLE [optima].[OP_FZG] ( [Customer Number] [varchar](100) NULL, [Voucher No] [varchar](100) NULL, [Line No Cu] [varchar](100) NULL, [Transaction Status] [varchar](100) NULL, [Due Date] [datetime] NULL, [Bookkeep Date] [datetime] NULL, [State Code] [varchar](100) NULL, [Transact Date] [datetime] NULL, [Handler] [varchar](100) NULL, [Creation Date] [datetime] NULL, [Creation Time 8] [varchar](100) NULL, [Status] [varchar](100) NULL, [Modul] [varchar](100) NULL, [Batch Number] [varchar](100) NULL, [Journal No] [varchar](100) NULL, [Document No] [varchar](100) NULL, [Document Date] [datetime] NULL, [Discount Date] [datetime] NULL, [Dunning Date] [datetime] NULL, [Start Int Date] [datetime] NULL, [Last Int Date] [datetime] NULL, [Pmt Term] [varchar](100) NULL, [Duntimes] [varchar](100) NULL, [Tax Code] [varchar](100) NULL, [Reminder Code] [varchar](100) NULL, [Sum C U] [decimal](28,8) NULL, [Tax C U] [decimal](28,8) NULL, [Cash Discount C U] [decimal](28,8) NULL, [Interest Perc] [decimal](28,8) NULL, [Paid C U] [decimal](28,8) NULL, [Comment Cu] [varchar](100) NULL, [Setoff Acct] [varchar](100) NULL, [Collect Acct] [varchar](100) NULL, [Interest Calc] [varchar](100) NULL, [Int Voucher No] [varchar](100) NULL, [Customer Number2] [varchar](100) NULL, [State Code Cust] [varchar](100) NULL, [Transact Date2] [datetime] NULL, [Handler2] [varchar](100) NULL, [Cust Alt Key] [varchar](100) NULL, [Name] [varchar](100) NULL, [Street Addr] [varchar](100) NULL, [Zipcode] [varchar](100) NULL, [Debit Customer] [varchar](100) NULL, [Title Code] [varchar](100) NULL, [Title] [varchar](100) NULL, [Pmt Term2] [varchar](100) NULL, [Workshop Pricecode] [varchar](100) NULL, [Vat Regno] [varchar](100) NULL, [Salesman] [varchar](100) NULL, [Gross Discount] [varchar](100) NULL, [Delivery Stop Code] [varchar](100) NULL, [Credit Limit] [varchar](100) NULL, [Reminder Code2] [varchar](100) NULL, [Customer Group] [varchar](100) NULL, [Comment 1] [varchar](100) NULL, [Comment 2] [varchar](100) NULL, [Saldo C U Cust] [decimal](28,8) NULL, [Reminder Group] [varchar](100) NULL, [Reminder Date] [datetime] NULL, [Saldo_Beleg] [decimal](28,8) NULL, [Order Number] [varchar](100) NULL, [Debit Account] [varchar](100) NULL, [Status2] [varchar](100) NULL, [Invoice Number] [varchar](100) NULL, [Department] [varchar](100) NULL, [Delivery Account] [varchar](100) NULL, [Salesman2] [varchar](100) NULL, [Invoice Date] [datetime] NULL, [Pmt Term3] [varchar](100) NULL, [Vehicle Sold] [varchar](100) NULL, [Vehicle Sold Sum] [decimal](28,8) NULL, [Department Type Id] [varchar](100) NULL, [Description] [varchar](100) NULL, [Seller Code] [varchar](100) NULL, [Sel Name] [varchar](100) NULL, [Sel Department] [varchar](100) NULL, [Hauptbetrieb] [varchar](100) NULL, [Standort] [varchar](100) NULL, [Kostenstelle] [varchar](100) NULL, [Customer Number_Deliv] [varchar](100) NULL, [Name_Deliv] [varchar](100) NULL, [Heute] [datetime] NULL, [Tage] [varchar](100) NULL, [Staffel] [varchar](100) NULL, [Kunde] [varchar](100) NULL, [Lieferkunde] [varchar](100) NULL, [Datum_Zeichen] [datetime] NULL, [Voucher_Zeichen] [varchar](100) NULL, [Beleg] [varchar](100) NULL ) GO