C11/System/ARI/SQL/schema/ARI/tables/import.Resource.sql

CREATE TABLE [import].[Resource] (
   [timestamp] [binary](8) NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [Type] [int] NOT NULL,
   [Name] [varchar](50) NOT NULL,
   [Search Name] [varchar](50) NOT NULL,
   [Name 2] [varchar](50) NOT NULL,
   [Address] [varchar](50) NOT NULL,
   [Address 2] [varchar](50) NOT NULL,
   [City] [varchar](30) NOT NULL,
   [Social Security No_] [varchar](30) NOT NULL,
   [Title] [varchar](50) NOT NULL,
   [Education] [varchar](30) NOT NULL,
   [Contract Class] [varchar](30) NOT NULL,
   [Employment Date] [datetime] NOT NULL,
   [Resource Group No_] [varchar](20) NOT NULL,
   [Global Dimension 1 Code] [varchar](20) NOT NULL,
   [Global Dimension 2 Code] [varchar](20) NOT NULL,
   [Unit of Measure Code] [varchar](10) NOT NULL,
   [Direct Unit Cost] [decimal](38,20) NOT NULL,
   [Indirect Cost _] [decimal](38,20) NOT NULL,
   [Unit Cost] [decimal](38,20) NOT NULL,
   [Profit _] [decimal](38,20) NOT NULL,
   [Price_Profit Calculation] [int] NOT NULL,
   [Unit Price] [decimal](38,20) NOT NULL,
   [Vendor No_] [varchar](20) NOT NULL,
   [Last Date Modified] [datetime] NOT NULL,
   [Blocked] [tinyint] NOT NULL,
   [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL,
   [Picture] [image] NULL,
   [Post Code] [varchar](20) NOT NULL,
   [County] [varchar](30) NOT NULL,
   [Automatic Ext_ Texts] [tinyint] NOT NULL,
   [No_ Series] [varchar](10) NOT NULL,
   [Tax Group Code] [varchar](10) NOT NULL,
   [VAT Prod_ Posting Group] [varchar](10) NOT NULL,
   [Country_Region Code] [varchar](10) NOT NULL,
   [IC Partner Purch_ G_L Acc_ No_] [varchar](20) NOT NULL,
   [Address No_] [int] NOT NULL,
   [Date of Update] [datetime] NOT NULL,
   [Time of Update] [datetime] NOT NULL,
   [Updated by User ID] [varchar](50) NOT NULL,
   [Update Company] [varchar](30) NOT NULL,
   [Last Name] [varchar](50) NOT NULL,
   [First Name] [varchar](30) NOT NULL,
   [Title Code] [varchar](10) NOT NULL,
   [Resource Cost Group Code] [varchar](10) NOT NULL,
   [Efficiency _] [decimal](38,20) NOT NULL,
   [Service Advisor No_] [varchar](20) NOT NULL,
   [Employee No_] [varchar](20) NOT NULL,
   [Location Code] [varchar](10) NOT NULL,
   [Price per Day] [decimal](38,20) NOT NULL,
   [Distance Incl_] [int] NOT NULL,
   [Price per Distance] [decimal](38,20) NOT NULL,
   [Amt_ Insurance] [decimal](38,20) NOT NULL,
   [Amt_ Retention] [decimal](38,20) NOT NULL,
   [Amt_ Comprehensive Insurance] [decimal](38,20) NOT NULL,
   [Company Calendar Code] [varchar](10) NOT NULL,
   [Absences In] [int] NOT NULL,
   [Avg_ Hours per Day] [decimal](38,20) NOT NULL,
   [Administrative] [tinyint] NOT NULL,
   [Main Company] [tinyint] NOT NULL,
   [Available from] [datetime] NOT NULL,
   [Available to] [datetime] NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [Pers_ Calendar Templ_ Code] [varchar](20) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Resource$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB])
)

CREATE UNIQUE NONCLUSTERED INDEX [$1] ON [import].[Resource] ([Client_DB], [Search Name], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$2] ON [import].[Resource] ([Client_DB], [Gen_ Prod_ Posting Group], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$3] ON [import].[Resource] ([Client_DB], [Address No_], [No_])

GO