D
D
Dmitry Krapivin2017-09-25 19:23:35
Database
Dmitry Krapivin, 2017-09-25 19:23:35

1c how to implement a distributed database and "data merging" in it during the exchange?

Precondition:
There is a subsidiary organization Branch No. 1, the remainder of which has the nomenclature Tractor K-700 with serial number 567
and Tractor K-700 with serial number 888. Moreover, for each technique, data on its mileage as of the current date, carried out TO-1 and. d.
In the database, the head of the organization has data on the specified tractors and data on the balance
In branch No. 2, the database does not contain data on the nomenclature Tractor K-700 with serial number 567
and Tractor K-700 with serial number 888.
Scenario:
1. The head organization creates Document on acceptance and transfer from Branch No. 1 and Branch No. 2 to the technician. Indicates what the K-700 Tractor should transmit. without specifying a specific nomenclature. Writes a document. The document goes to Branch #1 and Branch #2.
2. After some time, in fact , Branch No. 2 received the Tractor K-700 with serial number 888 from Branch No. 1.
2. Branch No. 2 creates in the system a new nomenclature Tractor K-700 with serial number 888 in its database. Creates an Incoming document. The remainder of Branch No. 2 from this moment is Tractor K-700 with serial number 888.
3. Data on receipt from Branch No. 2 are sent to the parent organization.
4. After some time, Branch No. 1 creates an Expense document in the system, where it indicates that the K-700 Tractor with serial number 888 has gone to Branch No. 2. This data is sent to the parent organization.
So, in the parent organization, there are two nomenclature Tractor K-700 with serial number 888 with different SUiD (ID)!
Dear colleagues, please tell me how such problems are solved in 1s? Maybe there are already some solutions to such problems in practice? In theory, the system should probably somehow compare two different nomenclatures according to some criteria and merge (merge) into one. And if the system cannot compare according to some criteria? What to do? Help and advise please.
The database is distributed.
1c0e1880f53b410199e6d59749c56501.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin, 2017-09-26
@kiru

there are two nomenclature Tractor K-700 with serial number 888 with different SUiD (ID)!

Give a common denominator.
Yes, there are "Plans of exchanges" + "Data conversion" (the most popular ones) with their help you can organize data migration.
v8.1c.ru/overview/Term_000000315.htm

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question