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

CREATE TABLE [import].[Make] (
   [timestamp] [binary](8) NOT NULL,
   [Code] [varchar](20) NOT NULL,
   [Name] [varchar](50) NOT NULL,
   [Consolidation Code] [varchar](10) NOT NULL,
   [Cost Accounting Make No_] [varchar](10) NOT NULL,
   [Map-to IC Dimension Code] [varchar](20) NOT NULL,
   [Map-to IC Dimension Value Code] [varchar](20) NOT NULL,
   [Factory Warranty Customer] [varchar](20) NOT NULL,
   [Vendor No_] [varchar](20) NOT NULL,
   [Serv_ Campaign Nos_] [varchar](10) NOT NULL,
   [Deposit Item Group] [varchar](10) NOT NULL,
   [Deposit Prod_ Posting Group] [varchar](10) NOT NULL,
   [Credit Dep_ Prod_ Post_ Gr_] [varchar](10) NOT NULL,
   [Warranty Inv_ per Service Job] [tinyint] NOT NULL,
   [Lab_ Select: Respect Lab_ Type] [tinyint] NOT NULL,
   [Warranty Submission Nos_] [varchar](10) NOT NULL,
   [Return Parts ID Nos_] [varchar](10) NOT NULL,
   [Warranty Cr_ Memo Account] [varchar](20) NOT NULL,
   [Return Parts ID No_ Assignment] [int] NOT NULL,
   [Warranty - Differential Acc_] [varchar](20) NOT NULL,
   [Fair Deal Cr_ Memo Account] [varchar](20) NOT NULL,
   [Warranty Handling Charge Acc_] [varchar](20) NOT NULL,
   [Warranty VAT Diff_ Account] [varchar](20) NOT NULL,
   [G_L Warranty Application Type] [int] NOT NULL,
   [Warranty Diff_ Posting Type] [int] NOT NULL,
   [Warranty Transfer Method] [int] NOT NULL,
   [Warranty Jrnl_ Name Default] [varchar](10) NOT NULL,
   [Prod Post Grp Handling Charge] [varchar](10) NOT NULL,
   [Cr_ Memo Handling Type] [int] NOT NULL,
   [Closing Tolerance _] [decimal](38,20) NOT NULL,
   [Max_ Closing Tolerance Amount] [decimal](38,20) NOT NULL,
   [Factory Warranty Vendor] [varchar](20) NOT NULL,
   [Credit M Account Foreign Warr_] [varchar](20) NOT NULL,
   [Credit Memo Acc_ Fair Deal Oth] [varchar](20) NOT NULL,
   [Veh_ Purch_ Line Dealer Status] [int] NOT NULL,
   [Acc_ Schedule Export Process] [varchar](20) NOT NULL,
   [Pur_ Doc_ No_ Assignment Type] [int] NOT NULL,
   [Sales Doc_ No_ Assignment Type] [int] NOT NULL,
   [Warranty Export Process] [varchar](20) NOT NULL,
   [Original Part] [tinyint] NOT NULL,
   [Fixed Start Manufacturer No_] [varchar](10) NOT NULL,
   [Fixed End Manufacturer No_] [varchar](10) NOT NULL,
   [Check Option] [tinyint] NOT NULL,
   [Additional Vendor No_] [varchar](20) NOT NULL,
   [Warranty Claim Process] [int] NOT NULL,
   [Serv_ Camp_ Completion Code] [varchar](30) NOT NULL,
   [Service Contract Customer] [varchar](20) NOT NULL,
   [Serv_ Cont_ VAT Bus_ Post_ Gr_] [varchar](10) NOT NULL,
   [Make Logo] [image] NULL,
   [Logo for Vehicles in Stock] [tinyint] NOT NULL,
   [IML Setup] [int] NOT NULL,
   [Assignment Date Target Formula] [varchar](32) NOT NULL,
   [Calc_ Lead Assignment Target] [tinyint] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO