CINCH Customer Documentation
Appendix B CINCH 18.54
- Mike Terning
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.
CINCH/Intellego – Inbound Grain
The following CINCH tables are affected during PA – CDA >> Additional Products >> CINCH/Intellego – Inbound Grain archiving transfer/remove process.
Table Name | Company Data Archive Action |
Module: Assembly | Validation: IRAssemblyDate and IRStatus in (0,6,8,9) |
IRGNAssemblyHDRWORK | Transfer/Remove |
IRGNAssemblyDiscWORK | Transfer/Remove |
IRGNAssemblyGradeWORK | Transfer/Remove |
IRGNAssemblyCommentWH | Transfer/Remove |
IRGNAssemblyApplyTRXHIST | Transfer/Remove |
IRGNAssemblyGrdFactorRPT | Transfer/Remove |
IRGNAssemblyInvoiceDtl | Transfer/Remove |
IRGNAssemblyMoveHIST | Transfer/Remove |
IRGNAssemblyTransferHIST | Transfer/Remove |
IRGNAssemblyTrfPrgDTL | Transfer/Remove |
IRGNITUnitTrainInWH | Transfer/Remove |
IRGNProgramDetailWORK | Transfer/Remove |
IRGNUnitTrainInWH | Transfer/Remove |
Module: Advances | Validation: DOCDATE and IRADVAMT = IRAppliedAmount |
IRGNAdvanceHIST | Transfer/Remove |
IRGNAdvanceLHDTL | Transfer/Remove |
Module: Advances Settlement | Validation: IRSettlementDate |
IRGNAdvanceSettledHIST | Transfer/Remove |
IRGNAdvanceLHDTL | Transfer/Remove |
Module: Inbound In Transit Scale Tickets | Validation: IRTicketDate and IRGNTicketDetailWORK's IRStatus > 6 via the IRGNITTicket_Filter |
IRGNITTktScaleHIST | Transfer/Remove |
IRGNITTktDetailHIST | Transfer/Remove |
IRGNITTktOwnerHIST | Transfer/Remove |
IRGNITTktGradeHIST | Transfer/Remove |
IRGNITTktDscntHIST | Transfer/Remove |
IRGNITTktFreightHIST | Transfer/Remove |
IRGNITTktDtlPrcHIST | Transfer/Remove |
IRGNITTktGradeFactorRPT | Transfer/Remove |
IRGNITTktDetailAdjRPT | Transfer/Remove |
Module: Inbound Scale Tickets | Validation: IRTicketDate and IRGNTicketDetailWORK's IRStatus > 6 via the IRGNITTicket_Filter |
IRGNTicketScaleWORK | Transfer/Remove |
IRGNTicketOwnerWORK | Transfer/Remove |
IRGNTicketDetailWORK | Transfer/Remove |
IRGNTktDetailPriceWORK | Transfer/Remove |
IRGNTicketDiscountWORK | Transfer/Remove |
IRGNTicketGradeWORK | Transfer/Remove |
IRGNTicketFreightWORK | Transfer/Remove |
IRGNTicketPostWORK | Transfer/Remove |
IRGNTicketSealDetailWH | Transfer/Remove |
IRGNTicketSpotPriceWORK | Transfer/Remove |
IRGNTicketMoveHIST | Transfer/Remove |
IRGNTicketMovePriceHIST | Transfer/Remove |
IRGNTicketMoveToHIST | Transfer/Remove |
Module: Purchase Loads | Validation: ORDRDATE |
IRGNPurchLoadHIST | Transfer/Remove |
IRGNPurchLoadDtlWH | Transfer/Remove |
IRGNPurchLoadFreightHIST | Transfer/Remove |
IRGNPurchLOCommentWORK | Transfer/Remove |
Module: Purchase Contracts | Validation: IRStatusDate and IRStatus > 6 |
IRGNPurchCtrWORK | Transfer/Remove |
IRGNPurchCtrDeliveryWORK | Transfer/Remove |
IRGNPurchCtrPriceWORK | Transfer/Remove |
IRGNPurchCtrPosDTL | Transfer/Remove |
IRGNPurchCtrPartners | Transfer/Remove |
IRGNPurchCtrPostWORK | Transfer/Remove |
IRGNPurchCtrReconDTLHIST | Transfer/Remove |
IRGNPurchCtrSupDist | Transfer/Remove |
IRGNPurchCtrSupDtl | Transfer/Remove |
IRGNPCCommentWORKHIST | Transfer/Remove |
IRGNPCDComentWORKHIST | Transfer/Remove |
IRGNPCPCommentWORKHIST | Transfer/Remove |
IRGNPurchCtrAmend | Transfer/Remove |
IRGNPurchCtrAmendFee | Transfer/Remove |
IRGNPurchCtrAmendLog | Transfer/Remove |
IRGNPurchCtrVER | Transfer/Remove |
IRGNPurchCtrDeliveryVER | Transfer/Remove |
IRGNPurchCtrPriceVER | Transfer/Remove |
IRGNPurchCtrNoteVER | Transfer/Remove |
IRGNPurchCtrPartnersVER | Transfer/Remove |
IRGNPurchCtrPosVER | Transfer/Remove |
IRGNPurchCtrRollLOG | Transfer/Remove |
IRGNPCACommentWHVer | Transfer/Remove |
IRGNPCDACommentWHVer | Transfer/Remove |
IRGNPCNoteMSTR | Transfer/Remove |
IRGNPCPACommentWHVer | Transfer/Remove |
IRGNPurchCtrReconDTLHIST | Transfer/Remove |
IRGNContractPorgramWORK | Transfer/Remove |
Module: Settlements | Validation: IRSettlementDate |
IRGNSettlementHDRHIST | Transfer/Remove |
IRGNSettlementLINEHIST | Transfer/Remove |
IRGNSettlementSplitWH | Transfer/Remove |
IRGNSettlementLHDTL | Transfer/Remove |
IRGNSettlementDist | Transfer/Remove |
IRGNSettlementVoidHDR | Transfer/Remove |
IRGNSettlementVoidLINE | Transfer/Remove |
IRGNSettlementDistVOID | Transfer/Remove |
IRGNSettlementAdvWORKHIS | Transfer/Remove |
Scripts |
IRArchive_InboundGrain.sql |
IRPreview_InboundGrain.sql |
IRDBSizing_InboundGrain.sql |
CINCH/Intellego – Outbound Grain
The following CINCH tables are affected during PA – CDA >> Additional Products >> CINCH/Intellego – Outbound Grain archiving transfer/remove process.
Table Name | Company Data Archive Action |
Module: (Sales) Load Orders | Validation: ORDRDATE |
IRGNLoadHIST | Transfer/Remove |
IRGNLoadFreightHIST | Transfer/Remove |
IRGNLoadGradeFactorRPT | Transfer/Remove |
IRGNLoadDtlAdjRPT | Transfer/Remove |
IRGNLoadDELETE | Transfer/Remove |
IRGNLOCommentWORK | Transfer/Remove |
Module: Shipments | Validation: IRShipDate |
IRGNLoadShipmentHIST | Transfer/Remove |
IRGNLoadShipmentHISTCOMP | Transfer/Remove |
IRGNLoadShipmentDtlWH | Transfer/Remove |
IRGNLoadShipmentGrdWH | Transfer/Remove |
IRGNLoadShipmentDiscWH | Transfer/Remove |
IRGNLoadShipmentFrtWH | Transfer/Remove |
IRGNLoadShipmentPrgWH | Transfer/Remove |
IRGNLoadShipmentRPT | Transfer/Remove |
IRGNLoadShipmentLots | Transfer/Remove |
Module: Sales Contracts | Validation: IRStatusDate and IRStatus>3 |
IRGNSalesCtrWORK | Transfer/Remove |
IRGNSalesCtrDeliveryWORK | Transfer/Remove |
IRGNSalesCtrPriceWORK | Transfer/Remove |
IRGNSalesCtrHIDTL | Transfer/Remove |
IRGNSalesCtrPosDTL | Transfer/Remove |
IRGNSalesCtrDelSubs | Transfer/Remove |
IRGNSalesCtrDelSubsPrice | Transfer/Remove |
IRGNSCUnderfillDetail | Transfer/Remove |
IRGNSCCommentWORKHIST | Transfer/Remove |
IRGNSCDCommentWORKHIST | Transfer/Remove |
IRGNSCDPCommentWORKHIST | Transfer/Remove |
IRGNSalesCtrAmend | Transfer/Remove |
IRGNSalesCtrAmendLog | Transfer/Remove |
IRGNSalesCtrAmendFee | Transfer/Remove |
IRGNSalesCtrVER | Transfer/Remove |
IRGNSalesCtrDeliveryVER | Transfer/Remove |
IRGNSalesCtrDelSubsVER | Transfer/Remove |
IRGNSalesCtrPriceVER | Transfer/Remove |
IRGNSalesCtrDelSubsPrVER | Transfer/Remove |
IRGNUnitTrainOutWH | Transfer/Remove |
IRGNContractProgramWORK | Transfer/Remove |
Scripts |
IRArchive_OutboundGrain.sql |
IRPreview_OutboundGrain.sql |
IRDBSizing_OutboundGrain.sql |
CINCH/Intellego – Futures
The following CINCH tables are affected during PA – CDA >> Additional Products >> CINCH/Intellego – Futures archiving transfer/remove process.
Table Name | Company Data Archive Action |
Module: Futures | Validation: IRTradeDate and IRClosedFlag = 1 |
IRGNTradeLINEOPEN | Transfer/Remove |
IRGNTradeDistOPEN | Transfer/Remove |
IRGNTradeLinePosDTL | Transfer/Remove |
IRGNTradeApplyOPEN | Transfer/Remove |
IRGNTradeHIDTL | Transfer/Remove |
IRGNTradeComment | Transfer/Remove |
Scripts |
IRArchive_Futues.sql |
IRPreview_Futures.sql |
IRDBSizing_Futures.sql |
CINCH/Intellego – Barge
The following CINCH tables are affected during PA – CDA >> Additional Products >> CINCH/Intellego – Barge archiving transfer/remove process.
Table Name | Company Data Archive Action |
Module: Barge | Validation: IRUnloadDate |
IRGNBargeHDRHIST | Transfer/Remove |
IRGNBargeLINEHIST | Transfer/Remove |
IRGNBargeGradeHIST | Transfer/Remove |
Scripts |
IRArchive_Barge.sql |
IRPreview_Barge.sql |
IRDBSizing_Barge.sql |
CINCH/Intellego – DPR
The following CINCH tables are affected during PA – CDA >> Additional Products >> CINCH/Intellego – DPR archiving transfer/remove process.
Table Name | Company Data Archive Action |
Module: DPR | Validation: IRDPRDate |
IRGNDPRDateMSTR | Transfer/Remove |
IRGNDPRBalanceMSTR | Transfer/Remove |
IRGNDPRWRBalMSTR | Transfer/Remove |
IRGNDPRWRCOHIST | Transfer/Remove |
IRGNDPRWRHIST | Transfer/Remove |
IRGNDPRStorageBalMSTR | Transfer/Remove |
IRGNDPRGBHIST | Transfer/Remove |
IRGNDPRAdjustmentHIST | Transfer/Remove |
IRGNDPRInvAdjHIST | Transfer/Remove |
IRGNDPRSOEHIST | Transfer/Remove |
IRGNDPRSOEInTransitHIST | Transfer/Remove |
IRGNDPRDeferredHIST | Transfer/Remove |
IRGNDPRPaidHIST | Transfer/Remove |
IRGNDPRInTransitHIST | Transfer/Remove |
IRGNDPROutboundHIST | Transfer/Remove |
IRGNDPRSOEAdjHIST | Transfer/Remove |
IRGNDPRUnpricedHIST | Transfer/Remove |
IRGNDPRUnpricedAdjHIST | Transfer/Remove |
IRGNDPRPricedHIST | Transfer/Remove |
IRGNDPRPricedAdjHIST | Transfer/Remove |
IRGNDPRStorageHIST | Transfer/Remove |
IRGNDPRStorageAdjHIST | Transfer/Remove |
IRGNDPRITTktHIST | Transfer/Remove |
Scripts |
IRArchive_DPR.sql |
IRPreview_DPR.sql |
IRDBSizing_DPR.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.