This table maintains a record of each merge transaction that occurs in the master index application, both through the EDM and from external systems. It also records any unmerges that occur. The differences in data types between Oracle and SQL Server are noted in Table 14. The Oracle type is on the first line, and the SQL Server type is on the second.
Table 14 SBYN_MERGE Table Description
Column Name |
Data Type |
Description |
---|---|---|
VARCHAR2(20) Varchar(20) |
The unique, sequential identification code of merge record. This column cannot be null. |
|
VARCHAR2(20) Varchar(20) |
The EUID of the record that was retained after the merge transaction. This column cannot be null. |
|
VARCHAR2(20) Varchar(20) |
The EUID of the record that was not retained after the merge transaction. |
|
VARCHAR2(20) Varchar(20) |
The transaction number associated with the merge transaction. This column cannot be null. |
|
VARCHAR2(20) Varchar(20) |
The transaction number associated with the unmerge transaction. |