ETL_DWH_ARI/schema/GC_TRANSIT_ARI/tables/import.Model_Master.sql

CREATE TABLE [import].[Model_Master] (
   [timestamp] [timestamp] NOT NULL,
   [No_] [nvarchar](20) NOT NULL,
   [Make Code] [nvarchar](20) NOT NULL,
   [Description] [nvarchar](50) NOT NULL,
   [Inventory Posting Group] [nvarchar](10) NOT NULL,
   [Gen_ Prod_ Posting Group] [nvarchar](10) NOT NULL,
   [Vehicle Category Code] [nvarchar](10) NOT NULL,
   [Engine Code] [nvarchar](10) NOT NULL,
   [Model Code] [nvarchar](20) NOT NULL,
   [Power (kW)] [int] NOT NULL,
   [Power (hp)] [int] NOT NULL,
   [Market Segment Code] [nvarchar](10) NOT NULL,
   [No_ of Doors] [int] NOT NULL,
   [Labor Type] [nvarchar](30) NOT NULL
)


GO