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

CREATE TABLE [import].[G_L_Account] (
   [timestamp] [binary](8) NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [Name] [varchar](100) NOT NULL,
   [Search Name] [varchar](100) NOT NULL,
   [Account Type] [int] NOT NULL,
   [Global Dimension 1 Code] [varchar](20) NOT NULL,
   [Global Dimension 2 Code] [varchar](20) NOT NULL,
   [Income_Balance] [int] NOT NULL,
   [Debit_Credit] [int] NOT NULL,
   [No_ 2] [varchar](20) NOT NULL,
   [Blocked] [tinyint] NOT NULL,
   [Direct Posting] [tinyint] NOT NULL,
   [Reconciliation Account] [tinyint] NOT NULL,
   [New Page] [tinyint] NOT NULL,
   [No_ of Blank Lines] [int] NOT NULL,
   [Indentation] [int] NOT NULL,
   [Last Date Modified] [datetime] NOT NULL,
   [Totaling] [varchar](250) NOT NULL,
   [Consol_ Translation Method] [int] NOT NULL,
   [Consol_ Debit Acc_] [varchar](20) NOT NULL,
   [Consol_ Credit Acc_] [varchar](20) NOT NULL,
   [Gen_ Posting Type] [int] NOT NULL,
   [Gen_ Bus_ Posting Group] [varchar](10) NOT NULL,
   [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL,
   [Picture] [image] NULL,
   [Automatic Ext_ Texts] [tinyint] NOT NULL,
   [Department Posting] [int] NOT NULL,
   [Make Posting] [int] NOT NULL,
   [Tax Area Code] [varchar](20) NOT NULL,
   [Tax Liable] [tinyint] NOT NULL,
   [Tax Group Code] [varchar](10) NOT NULL,
   [VAT Bus_ Posting Group] [varchar](10) NOT NULL,
   [VAT Prod_ Posting Group] [varchar](10) NOT NULL,
   [Exchange Rate Adjustment] [int] NOT NULL,
   [Default IC Partner G_L Acc_ No] [varchar](20) NOT NULL,
   [Cost Type Code] [varchar](20) NOT NULL,
   [Make Account Code] [varchar](20) NOT NULL,
   [Vehicle Posting] [int] NOT NULL,
   [Book No_ Posting] [int] NOT NULL,
   [Account Group] [int] NOT NULL,
   [G_L Account for Reconciliation] [tinyint] NOT NULL,
   [Recon_ Group Field No_ 1] [int] NOT NULL,
   [Recon_ Group Field No_ 2] [int] NOT NULL,
   [Recon_ Group Field No_ 3] [int] NOT NULL,
   [Recon_ Group Field No_ 4] [int] NOT NULL,
   [Recon_ Group Field No_ 5] [int] NOT NULL,
   [OPP Dim_ for System Entries] [int] NOT NULL,
   [OPP Check Tax Key] [tinyint] NOT NULL,
   [OPP Last Posting at] [datetime] NOT NULL,
   [OPP Acc_ Schedule Name 1] [varchar](10) NOT NULL,
   [OPP Acc_ Schedule Name 2] [varchar](10) NOT NULL,
   [OPP Acc_ Schedule Name 3] [varchar](10) NOT NULL,
   [OPP Acc_ Schedule Line 1] [int] NOT NULL,
   [OPP Acc_ Schedule Line 2] [int] NOT NULL,
   [OPP Acc_ Schedule Line 3] [int] NOT NULL,
   [OPP Account Group 1] [varchar](10) NOT NULL,
   [OPP Account Group 2] [varchar](10) NOT NULL,
   [OPP Account Group 3] [varchar](10) NOT NULL,
   [OPP Account Group 4] [varchar](10) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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

CREATE UNIQUE NONCLUSTERED INDEX [$1] ON [import].[G_L_Account] ([Client_DB], [Search Name], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$10] ON [import].[G_L_Account] ([Client_DB], [OPP Account Group 2], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$11] ON [import].[G_L_Account] ([Client_DB], [OPP Account Group 3], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$12] ON [import].[G_L_Account] ([Client_DB], [OPP Account Group 4], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$2] ON [import].[G_L_Account] ([Client_DB], [Reconciliation Account], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$3] ON [import].[G_L_Account] ([Client_DB], [Gen_ Bus_ Posting Group], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$4] ON [import].[G_L_Account] ([Client_DB], [Gen_ Prod_ Posting Group], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$5] ON [import].[G_L_Account] ([Client_DB], [Account Type], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$8] ON [import].[G_L_Account] ([Client_DB], [Name], [No_])
CREATE UNIQUE NONCLUSTERED INDEX [$9] ON [import].[G_L_Account] ([Client_DB], [OPP Account Group 1], [No_])

GO