C11/System/NAVISION/SQL/schema/NAVISION_BYD/tables/import.Labor.sql

CREATE TABLE [import].[Labor] (
   [timestamp] [timestamp] NOT NULL,
   [Make Code] [varchar](10) NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [Description] [varchar](255) NOT NULL,
   [Search Description] [varchar](255) NOT NULL,
   [Description 2] [varchar](255) NOT NULL,
   [Charging Group] [varchar](20) NOT NULL,
   [Main Group Code] [varchar](10) NOT NULL,
   [Subgroup Code] [varchar](10) NOT NULL,
   [Line Group Code] [varchar](10) NOT NULL,
   [Department Code] [varchar](10) NOT NULL,
   [No Charge] [tinyint] NOT NULL,
   [Fixed Price] [decimal](38,20) NOT NULL,
   [Last Date Modified] [datetime] NOT NULL,
   [Blocked] [tinyint] NOT NULL,
   [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL,
   [No_ Series] [varchar](10) NOT NULL,
   [VAT Prod_ Posting Group] [varchar](10) NOT NULL,
   [Vehicle Appointment Code] [varchar](10) NOT NULL,
   [Update Description] [tinyint] NOT NULL,
   [No Service Surcharge] [tinyint] NOT NULL,
   [Automatic Ext_ Texts] [tinyint] NOT NULL,
   [No Update Charging Group] [tinyint] NOT NULL,
   [Using WIF] [tinyint] NOT NULL,
   [WIF Labor No_] [int] NOT NULL,
   [Fixed Price internal] [decimal](38,20) NOT NULL,
   [Not Accident Free] [tinyint] NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Labor$0] PRIMARY KEY CLUSTERED ([Make Code], [No_], [CLIENT_DB])
)


GO