Appendix B - CINCH 18.55

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 1^st for each period).
IRGNLSHDR	Transfer
IRGNLSLINE	Transfer
IRGNLSLINEDTL	Transfer/Remove

Scripts

IRPreview_LongShort.sql

IRDBSizing_LongShort.sql

IRArchive_LongShort.sql