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

CREATE TABLE [import].[Branch_Description] (
   [timestamp] [binary](8) NOT NULL,
   [Code] [varchar](10) NOT NULL,
   [Description] [varchar](50) NOT NULL,
   [Branch ID] [varchar](10) NOT NULL,
   [Consolidation Code] [varchar](10) NOT NULL,
   [Main Location Code] [varchar](10) NOT NULL,
   [Update Labor Clocking In Order] [int] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO