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 – 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 |