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

CREATE TABLE [import].[Location] (
   [timestamp] [binary](8) NOT NULL,
   [Code] [varchar](10) NOT NULL,
   [Name] [varchar](50) NOT NULL,
   [Use As In-Transit] [tinyint] NOT NULL,
   [Book Nos_] [varchar](10) NOT NULL,
   [Department Code] [varchar](20) NOT NULL,
   [Ship-to Address Code] [varchar](10) NOT NULL,
   [Internal Customer] [varchar](20) NOT NULL,
   [Bank Code] [varchar](10) NOT NULL,
   [Requisition Method Code] [varchar](10) NOT NULL,
   [Branch Code] [varchar](10) NOT NULL,
   [Associated Location Filter] [varchar](250) NOT NULL,
   [Shelf_Bin Default] [int] NOT NULL,
   [Disable Alternat_ Parts Search] [tinyint] NOT NULL,
   [Auto Req_ Wksh_ Name] [varchar](10) NOT NULL,
   [Shipment Proposal Name] [varchar](20) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO