CREATE TABLE [import].[Arbeitswertposten] (
   [timestamp] [binary](8) NOT NULL,
   [Lfd_ Nr_] [int] NOT NULL,
   [Lagerortcode] [varchar](10) NOT NULL,
   [Belegnr_] [varchar](20) NOT NULL,
   [Buchungsdatum] [datetime] NOT NULL,
   [Arbeitswertnr_] [varchar](20) NOT NULL,
   [Markencode] [varchar](10) NOT NULL,
   [Verrechnungsgruppennr_] [varchar](20) NOT NULL,
   [Beschreibung] [varchar](100) NOT NULL,
   [Arbeitstypcode] [varchar](10) NOT NULL,
   [Einheitencode] [varchar](10) NOT NULL,
   [Menge] [decimal](38,20) NOT NULL,
   [EK-Preis] [decimal](38,20) NOT NULL,
   [Einstandspreis] [decimal](38,20) NOT NULL,
   [Einstandsbetrag] [decimal](38,20) NOT NULL,
   [VK-Preis] [decimal](38,20) NOT NULL,
   [Verkaufsbetrag] [decimal](38,20) NOT NULL,
   [Kostenstellencode] [varchar](10) NOT NULL,
   [Menge pro Stunde] [decimal](38,20) NOT NULL,
   [Menge (Stunde)] [decimal](38,20) NOT NULL,
   [Benutzer ID] [varchar](20) NOT NULL,
   [Herkunftscode] [varchar](10) NOT NULL,
   [Fakturierbar] [tinyint] NOT NULL,
   [Buch_-Blatt Name] [varchar](10) NOT NULL,
   [Ursachencode] [varchar](10) NOT NULL,
   [Geschäftsbuchungsgruppe] [varchar](20) NOT NULL,
   [Produktbuchungsgruppe] [varchar](20) NOT NULL,
   [Belegdatum] [datetime] NOT NULL,
   [Externe Belegnummer] [varchar](30) NOT NULL,
   [Nummernserie] [varchar](10) NOT NULL,
   [Hauptgruppencode] [varchar](10) NOT NULL,
   [Untergruppencode] [varchar](10) NOT NULL,
   [Positionsgruppencode] [varchar](10) NOT NULL,
   [Verk_ an Deb_-Nr_] [varchar](20) NOT NULL,
   [Rech_ an Deb_-Nr_] [varchar](20) NOT NULL,
   [Fahrgestellnummer] [varchar](20) NOT NULL,
   [Fahrzeugtyp] [varchar](50) NOT NULL,
   [Paketnr_] [varchar](20) NOT NULL,
   [Paketversionsnr_] [int] NOT NULL,
   [Vorgabezeit] [decimal](38,20) NOT NULL,
   [Ist-Zeit] [decimal](38,20) NOT NULL,
   [Postenart] [int] NOT NULL,
   [Vorgabezeitart] [int] NOT NULL,
   [Werkstattauftragsnr_] [varchar](20) NOT NULL,
   [Werkstattauftragszeilennr_] [int] NOT NULL,
   [Belegtyp] [int] NOT NULL,
   [Vorgabezeit (Stunde)] [decimal](38,20) NOT NULL,
   [Filialcode] [varchar](10) NOT NULL,
   [Client_DB] [varchar](50) NOT NULL
)


GO