The invention relates to the technical field of
database system integration, and provides a contract data multi-
system bidirectional synchronization and
field mapping method and device.The contract data multi-
system bidirectional synchronization and
field mapping method comprises the steps that fields of different systems are named and standardized by building and loading a
static field mapping table, and contract main table data in a
source system and extended
data model information of the contract main table data are obtained according to query conditions; performing field name conversion and value formatting on the acquired data according to a
static field mapping table, and performing recursive
processing and
change tracking on a contract signing party sub-table and a money return plan sub-table associated with a contract; identifying field-level and sub-table-level change information by comparing historical versions of the contract data, and generating a structured change
record; and assembling and
synchronizing the converted main table data, the processed sub-table data and the change
record according to a
data structure of the target system. According to the method, the integrated development and long-term maintenance cost of the system can be remarkably reduced, and accurate synchronization of a complex
nested data structure is completely supported.