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

CREATE TABLE [import].[Vehicle_Customer] (
   [timestamp] [timestamp] NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [Type] [int] NOT NULL,
   [Customer No_] [varchar](20) NOT NULL,
   [Beginning of Contract] [datetime] NOT NULL,
   [Expiration of Contract] [datetime] NOT NULL,
   [Warranty Add-On Contract No_] [varchar](20) NOT NULL,
   [Contact Person] [varchar](10) NOT NULL,
   [Prospect No_] [varchar](20) NOT NULL,
   [Distance Kilometer] [int] NOT NULL,
   [Distance Miles] [int] NOT NULL,
   [PPL Interface] [tinyint] NOT NULL,
   [SA2 Interface] [tinyint] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO