C11/System/ARI/SQL/schema/GC_TRANSIT_ARI/tables/import.Vehicle.sql

CREATE TABLE [import].[Vehicle] (
   [timestamp] [binary](8) NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [Vehicle Status] [int] NOT NULL,
   [Model] [varchar](50) NOT NULL,
   [Model No_] [varchar](30) NOT NULL,
   [Location Code] [varchar](10) NOT NULL,
   [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL,
   [VAT Prod_ Posting Group] [varchar](10) NOT NULL,
   [Make Code] [varchar](20) NOT NULL,
   [Customer No_] [varchar](20) NOT NULL,
   [Initial Registration] [datetime] NOT NULL,
   [Dealer Status] [varchar](10) NOT NULL,
   [Old Vehicle Status] [int] NOT NULL,
   [Old Customer No_] [varchar](20) NOT NULL,
   [Purchase Receipt Date] [datetime] NOT NULL,
   [Inventory Posting Group] [varchar](10) NOT NULL,
   [Current Book No_] [varchar](20) NOT NULL,
   [Date of Sale] [datetime] NOT NULL,
   [Current Price Sticker] [int] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO