Enterprise and Elite

[petsco]

Hi

We're a London law firm that uses Thomson Elite as an accounting package, but I think we're going to have to integrate with Enterprise at the Russian office in the near future. Unfortunately we don't know much about it. Does anyone have an English version of the data structure? It seems (from this website) to run on MS SQL - would that be 2005 or 2000? Or either. And has anyone any experience of integrating western accounting packages into Enterprise.

I guess the big question though is enterprise really necessary in Russia? Or is all that is required a word document with the relevant financial information?

thanks


petsco

[Elisy]

Hi,
The integration strategies are different according to 1C:Enterprise version. The last 1C:Enterprise release version is 8.1.

You can choose the following ways to integrate:
1. Interaction using files
Import\export of text files in number of coding, including Unicode
Import\export of DBF files. “1C: Enterprise” includes an internal mechanism of work with external databases in D-Base IV.
Import\export of XML files of free structure. Both step-by-step and DOM models of reading records is supported.
Export of HTML files.
Reading and writing of internal MXL tables.
Export of tables into MS Excel.
Import\export of documents of free formats by means of OLE-server activation of corresponding applications.
2. Interprocess communications
Working as a OLE-client with a free OLE-servers, including work with all kinds of databases which use standard ODBC drivers and other Microsoft technologies of integration on the basis of OLE.
Activation of “1C: Enterprise 8.1” application as a OLE-server from any OLE-client.
Implementation of all kinds of Active-X objects into applications developed on the basis of “1C: Enterprise 8” platform.
3. Internet technologies
Web-services access
Own technology “WEB extension” which allows to generate “thin clients” on the basis of web-interface and web-services MS IIS, ASP.NET, C# assisted (for “1C: Enterprise 8” only)
On-board mechanisms for working with mail protocols pop3\smtp, IMAP.
On-board mechanisms for working with FTP protocol
On-board mechanisms for working with HTTP\HTTPS protocols.
4. Own technology of external components
Allows to connect with free intended program components, executed using a number of languages, in order to provide any extension of functionality (for example, device drivers)

1C:Enterprise supports MS SQL 2000 and 2005. You can choose to use direct DBMS access in some cases. Please note 1C:Enterprise has not static data structure like other ERP systems and it generates structure automatically according to applied solution implementation. For example the following SQL describes one of the 1C:Enterprise documents.
CREATE TABLE [dbo].[_Document135](
[_IDRRef] [binary](16) NOT NULL,
[_Version] [timestamp] NOT NULL,
[_Marked] [binary](1) NOT NULL,
[_Date_Time] [datetime] NOT NULL,
[_NumberPrefix] [datetime] NOT NULL,
[_Number] [nchar](11) COLLATE Cyrillic_General_CI_AS NOT NULL,
[_Posted] [binary](1) NOT NULL,
[_Fld2516RRef] [binary](16) NOT NULL,
[_Fld2517RRef] [binary](16) NOT NULL,
[_Fld2518] [nvarchar](100) COLLATE Cyrillic_General_CI_AS NOT NULL,
[_Fld2519RRef] [binary](16) NOT NULL,
[_Fld2520RRef] [binary](16) NOT NULL,
[_Fld2521] [datetime] NOT NULL,
[_Fld2522RRef] [binary](16) NOT NULL,
[_Fld2523_TYPE] [binary](1) NOT NULL,
[_Fld2523_RTRef] [binary](4) NOT NULL,
[_Fld2523_RRRef] [binary](16) NOT NULL,
[_Fld2524] [ntext] COLLATE Cyrillic_General_CI_AS NOT NULL,
[_Fld2525RRef] [binary](16) NOT NULL,
[_Fld2526] [numeric](10, 0) NOT NULL,
[_Fld2527] [numeric](10, 4) NOT NULL,
[_Fld2528RRef] [binary](16) NOT NULL,
[_Fld2529RRef] [binary](16) NOT NULL,
[_Fld2530] [binary](1) NOT NULL,
[_Fld2531RRef] [binary](16) NOT NULL,
[_Fld2532] [nvarchar](25) COLLATE Cyrillic_General_CI_AS NOT NULL,
[_Fld2533RRef] [binary](16) NOT NULL,
[_Fld2534RRef] [binary](16) NOT NULL,
[_Fld2535] [binary](1) NOT NULL,
[_Fld2536] [binary](1) NOT NULL,
[_Fld2537RRef] [binary](16) NOT NULL,
[_Fld2538_TYPE] [binary](1) NOT NULL,
[_Fld2538_RTRef] [binary](4) NOT NULL,
[_Fld2538_RRRef] [binary](16) NOT NULL,
[_Fld2539] [numeric](5, 2) NOT NULL,
[_Fld2540] [binary](1) NOT NULL,
[_Fld2541_TYPE] [binary](1) NOT NULL,
[_Fld2541_RTRef] [binary](4) NOT NULL,
[_Fld2541_RRRef] [binary](16) NOT NULL,
[_Fld2542RRef] [binary](16) NOT NULL,
[_Fld2543RRef] [binary](16) NOT NULL,
[_Fld2544RRef] [binary](16) NOT NULL,
[_Fld2545] [binary](1) NOT NULL,
[_Fld2546] [binary](1) NOT NULL,
[_Fld2547] [numeric](15, 2) NOT NULL,
[_Fld2548] [numeric](15, 2) NOT NULL,
[_Fld2549RRef] [binary](16) NOT NULL,
[_Fld2550] [binary](1) NOT NULL,
[_Fld2551RRef] [binary](16) NOT NULL,
[_Fld2552] [binary](1) NOT NULL,
[_Fld2553] [binary](1) NOT NULL,
[_Fld2554RRef] [binary](16) NOT NULL,
PRIMARY KEY CLUSTERED
(
[_IDRRef] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

You can choose the experienced integrator from the community of 5300 partners in 570 towns of the former USSR. If you will have some problems to find it please feel free to let us know.

1C:Enterprise is really necessary in Russia. For example it fully implements specific of Russian payroll system with the best support. You can port any western accounting system but with great time and resource consuming.