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

CREATE TABLE [optima].[OP_AS] (
   [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] [varchar](100) 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,
   [Summe  (Saldo_Beleg) Nr 2] [decimal](28,8) NULL,
   [Summe  (Saldo_Beleg) Nr 1] [decimal](28,8) NULL,
   [Order Number] [varchar](100) NULL,
   [Status2] [varchar](100) NULL,
   [Debit Account] [varchar](100) NULL,
   [Invoice Number] [varchar](100) NULL,
   [Delivery Account] [varchar](100) NULL,
   [Department] [varchar](100) NULL,
   [Invoice Date] [datetime] NULL,
   [Orders Grossvalue] [decimal](28,8) NULL,
   [Salesman2] [varchar](100) 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