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

CREATE TABLE [import].[Vehicle_Appointment] (
   [timestamp] [timestamp] NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [Appointment Type] [varchar](10) NOT NULL,
   [Next Appointment Date] [datetime] NOT NULL,
   [Next Appointment at Mileage] [int] NOT NULL,
   [Auto Planned RSP Export] [tinyint] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Vehicle_Appointment$0] PRIMARY KEY CLUSTERED ([VIN], [Appointment Type], [Client_DB])
)


GO