The following lists indicate the CINCH tables affected during the archive process.
Company Data Archive Action Legend:
- Transfer: Data is only copied to the 'Archive' company from the 'Live' company.
- Transfer/Remove: Data can be both copied to the 'Archive' company from the 'Live' Company and removed from the 'Live' company.
- Tables not listed below are not affected by Data Archive.
CINCH/Intellego – Process Manufacturing
The following CINCH tables are affected during PA – CDA >> Additional Products >> CINCH/Intellego – ProcessMFG archiving transfer/remove process.
Table Name |
Company Data Archive Action |
Module: Manufacturing |
Validation: DOCDATE |
IRMFMfgHDRHIST |
Transfer/Remove |
IRMFMfgLINEHIST |
Transfer/Remove |
Scripts |
IRPreview_ProcessMFG.sql |
IRDBSizing_ProcessMFG.sql |
IRArchive_ProcessMFG.sql |
CINCH/Intellego – Long Short
The following CINCH tables are affected during PA – CDA >> Additional Products >> CINCH/Intellego – Long Short archiving transfer/remove process.
Table Name |
Company Data Archive Action |
Module: Long Short |
Validation: IRRcnclDate |
IRGNLSRcnclHDRHIST |
Transfer/Remove |
IRGNLSRcnclInvAdjHIST |
Transfer/Remove |
IRGNLSRcnclPCHIST |
Transfer/Remove |
IRGNLSRcnclSCHIST |
Transfer/Remove |
IRGNLSRcnclTradeHIST |
Transfer/Remove |
|
Validation: IRPositionYear & IRPositionPeriod (By default the date is considered as 1st for each period). |
IRGNLSHDR |
Transfer |
IRGNLSLINE |
Transfer |
IRGNLSLINEDTL |
Transfer/Remove |
Scripts |
IRPreview_LongShort.sql |
IRDBSizing_LongShort.sql |
IRArchive_LongShort.sql |
