CINCH Customer Documentation

Appendix B - CINCH 18.55

Owned by Mike Terning
Last updated: Oct 24, 2022
1 min read

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



✦✦✦

3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2013 - 2024 Cultura Technologies, LLC. All Rights Reserved Worldwide.  Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.