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

CREATE TABLE [import].[Branch_Make] (
   [timestamp] [binary](8) NOT NULL,
   [Branch Code] [varchar](20) NOT NULL,
   [Make Code] [varchar](30) NOT NULL,
   [External Make Flag] [tinyint] NOT NULL,
   [B2B Partner Code] [varchar](30) NOT NULL,
   [Our B2B Partner Code] [varchar](30) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Branch Make$0] PRIMARY KEY CLUSTERED ([Branch Code], [Make Code], [Client_DB])
)


GO