User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Create a Copy of an Entity or an Entity Group
Transaction SYSETG
SYSETG uses the structure of the database table as defined in the sources and the database content to create a copy of an entity or an entity within a new entity group together with all system and static data owned by the originating entity / entity group.
Second the differentiation of the database table into dynamic and static database table defines whether the data shall be transfered into the newly created entity / entity group.
Excluded from the transfer are the following transient database table:
- SPQ Remote print queue
- SSN Session
- SLG System Log
- EVT Event
- CCA Archived contracts
- SPT System pending entry
- SPR System pending release
- QUE Queue
And excluded from the transfer are accruing data
- ACS - Accruing Sum Records per Account
- ACR - Accruing Control Records
Technically the transfer process is devided into three phases
- based on the selected source entity / entity group all database entries holding a matching entity or entity group are transfered to the target entity / entity group.
- based on links of the transfered entries, all entries which are referred to and which are on a higher entity level than the originating entry are identified and transfered to the target entity / entity group.
- after transfering all relevant data all pointer defined in the transfered entries, which are pointing to entries which are transfered are updated to point to the transfered new entries
To reduce the need to update pointer the pointer pointing to already transfered entries are directly updated when transfering an entry.
This the reason why the transfered table are transfered in a non alphabetic sequence. The software tries to reduce later updates by ordering the table according to the existance of pointer.
When the database holds structural definition issues or the used database holds corrupt entries, it might occur, that entries to get transfered are not identified or pointer in transfered entries are not pointing to existing entries. Such issues might create error messages in the processing log.
If there are errors in the log, the generated entity / entity group most probably is not consistent / complete and might need some more action to repair the database.
Transaction Panels
Copy
Datafields
| Datafield | Description |
|---|---|
| External Key | cf Appendix A, Table ETG field EXTKEY |
| Name | cf Appendix A, Table ETG field NAM |
| External Key | cf Appendix A, Table ETY field EXTKEY |
| Name | cf Appendix A, Table ETY field NAM |
| External Key | cf Appendix A, Table ETG field EXTKEY |
| Name | cf Appendix A, Table ETG field NAM |
| System Base Currency | cf Appendix A, Table ETG field SYSCUR |
| Rate Base Currency | cf Appendix A, Table ETG field RATBASCUR |
| Direction of Rate Logic | cf Appendix A, Table ETG field XRTRATDIR |
| Color for charts | cf Appendix A, Table ETG field COLOR |
| External Key | cf Appendix A, Table ETY field EXTKEY |
| Name | cf Appendix A, Table ETY field NAM |
Table Structure
