ExcelCompanies Table

This can be set up on any database, but when choosing which database to set up on consider:

  • It is easier to use the same database user to access this table as used to access Sage tables
  • If you place it in a Sage company database, remember to back up it's contents in case it is erased during an upgrade.

The fields on the table relate to the entries in the connection box (see Central DB Config Utility).

Below is a schema for creating the table in SQL Server. Data can be entered into this table using the Central DB Config Utility, using SQL, or in SQL Enterprise manager for SQL Server.Excel Companies Table

ExcelCompanies Table Schema

CREATE TABLE [dbo].[ExcelCompanies] (
[Company] [char] (10) NOT NULL ,
[Description] [char] (30) NULL ,
[Server] [char] (20) NULL,
[DBName] [char] (20) NOT NULL,
[UserName] [char] (20) NULL,
[Password] [char] (20) NULL,
[NLDatabase] [char] (20) NULL,
[PLDatabase] [char] (20) NULL,
[PODataBase] [char] (20) NULL,
[STDataBase] [char] (20) NULL,
[PRDataBase] [char] (20) NULL,
[CEDataBase] [char] (20) NULL,
[SLDataBase] [char] (20) NULL
GO
) ON [PRIMARY] CREATE UNIQUE CLUSTERED INDEX [i_Company] ON [dbo].[ExcelCompanies ([Company]) ON [PRIMARY]
GO