Appendix B

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 are not affected by Data Archive.

Payable Management
The following CINCH tables are affected during PA – CDA >> Purchasing >> Payables Management archiving transfer/remove process.

Table Name	Company Data Archive Action
IRPMTransCOMP	Transfer/Remove
IRPMPaymentCOMP	Transfer/Remove
IRPMPaymentApplyCOMP	Transfer/Remove (CIN-5470)

Scripts

IRArchive_PM

IRArchive_POP

Purchase Order Processing
The following CINCH tables are affected during PA – CDA >> Purchasing >> Payables Management archiving transfer/remove process.

Table Name	Company Data Archive Action
IRPOPLINECOMP	Transfer/Remove

Scripts

IRArchive_POP

Sales Order Processing
The following CINCH tables are affected during PA – CDA >> Sales >> Sales Order Processing transfer/remove process.

Table Name	Company Data Archive Action
IRCSSOPLINECOMP	Transfer/Remove
IRGNSOPGBApplyHIST	Transfer/Remove
IRASSOPSplitHDR	Transfer/Remove
IRASSOPSplitCOMP	Transfer/Remove
IRASSOPLicenseDTLWH	Transfer/Remove
IRASSOPFarmFieldWORK	Transfer/Remove
IRFSBudgetTrxHIST	Transfer/Remove

Scripts

IRFilter_SOP

IRArchive_SOP

Inventory Control
The following CINCH tables are affected during PA – CDA >> Inventory >> Inventory Control transfer/remove process.

Table Name	Company Data Archive Action
IRIVTRXHISTLINECOMP	Transfer/Remove

Scripts

IRFilter_IV

IRArchive_IV

CINCH/Intellego – Booking
Booking Document Date (DOCDATE) must be less than or equal to the archive cutoff date.

Table Name	Company Data Archive Action
IRASBookingHDRHIST	Transfer/Remove
IRASBookingLINEHIST	Transfer/Remove
IRASBookingFarmFieldLINE	Transfer/Remove

Scripts

IRArchive_Booking

IRPreview_Booking

CINCH/Intellego – Prepay
Prepay date (DATE1 field on table IRASPrepayHDRHIST) must be less than or equal to archive cutoff date.

Table Name	Company Data Archive Action
IRASPrepayHDRHIST	Transfer/Remove
IRASPrepayLINEHIST	Transfer/Remove
IRASPrepayAppliedOPEN	Transfer/Remove

Scripts

IRArchive_Prepay

IRPreview_Prepay

CINCH/Intellego – Branch Transfer
Both the Received Date (IRReceivedDate) and Void Date (IRVoidDate) dates must be less than or equal to archive cutoff date.

Table Name	Company Data Archive Action
IRASBranchTranHDRHIST	Transfer/Remove
IRASBranchTranLINEHIST	Transfer/Remove
IRASBranchTranCompWORK	Transfer/Remove
IRGNTransferFreightWH	Transfer/Remove

Scripts

IRArchive_BranchTransfer

IRPreview_BranchTransfer

CINCH/Intellego – Sales Shipment Invoicing
The Ship Date (IRShipDate) must be less than or equal to archive cutoff date.

Table Name	Company Data Archive Action
IRASShipInvHDRHIST	Transfer/Remove
IRASShipInvLINEHIST	Transfer/Remove
IRASShipInvHDRLicense	Transfer/Remove

Scripts

IRArchive_SalesShipInv

IRPreview_SalesShipInv

CINCH/Intellego – Bulk Transfer
Transfer Date (IRTransferDate) must be less than or equal to archive cutoff date.

Table Name	Company Data Archive Action
IRGNBulkTransferHDRHIST	Transfer/Remove
IRGNBulkTransferDTLHIST	Transfer/Remove
IRGNBulkTransferDiscWH	Transfer/Remove
IRGNBulkTransferDiscRPT	Transfer/Remove
IRGNBulkTransferGrdWH	Transfer/Remove
IRGNBulkTransferGrdRPT	Transfer/Remove
IRGNBulkTransferCmtWH	Transfer/Remove
IRGNTransferFreightWH	Transfer/Remove

Scripts

IRArchive_BulkTransfer

IRPreview_BulkTransfer

IRCSMSTRTableLoad

CINCH/Intellego – Master Tables

Table Name	Company Data Archive Action
IRAGCropYearMSTR	Transfer
IRAGCropZoneMSTR	Transfer
IRAGFarmFieldTransMSTR	Transfer
IRAGFarmMSTR	Transfer
IRAGFieldMSTR	Transfer
IRASABLCustomer	Transfer
IRASABLMSTR	Transfer
IRASABLVendor	Transfer
IRASAGCustClsMSTR	Transfer
IRASAGVendClsMSTR	Transfer
IRASAdvTermsDiscAvailDTL	Transfer
IRASAgWorksBranchMSTR	Transfer
IRASAgWorksItemMSTR	Transfer
IRASAgWorksLocMSTR	Transfer
IRASAgWorksMSTR	Transfer
IRASAgWorksPLMSTR	Transfer
IRASBranchSchdlDTL	Transfer
IRASBranchSchdlSETP	Transfer
IRASBranchTranSETP	Transfer
IRASCDMSItemMSTR	Transfer
IRASCDMSMSTR	Transfer
IRASCostAdjustmentItem	Transfer
IRASCostAdjustmentMSTR	Transfer
IRASCostAdjustmentRate	Transfer
IRASCostAdjustmentRegion	Transfer
IRASCustTaxExemptMSTR	Transfer
IRASECustClsMSTR	Transfer
IRASEItemClsMSTR	Transfer
IRASExportMSTR	Transfer
IRASGreenbookActiveIngrd	Transfer
IRASGreenbookItemMSTR	Transfer
IRASGreenbookMSTR	Transfer
IRASIntegrationExcMSTR	Transfer
IRASLSReportSETP	Transfer
IRASLicenseHolderMSTR	Transfer
IRASLicenseMSTR	Transfer
IRASLicenseTypeMSTR	Transfer
IRASLotAnalysisCrossRef	Transfer
IRASLotAnalysisHDRWORK	Transfer
IRASLotAnalysisIDMSTR	Transfer
IRASLotAnalysisLINEWORK	Transfer
IRASLotAnalysisROPT	Transfer
IRASLotAnalysisSETP	Transfer
IRASLotAnalysisSeqMSTR	Transfer
IRASManufacturerMSTR	Transfer
IRASPrepayClassMSTR	Transfer
IRASPrepayPeriodMSTR	Transfer
IRASPrepaySETP	Transfer
IRASProductHDR	Transfer
IRASProductLINE	Transfer
IRASProductMCPrice	Transfer
IRASProjectionHDR	Transfer
IRASProjectionLINE	Transfer
IRASQuadrantMSTR	Transfer
IRASSalesDiscMSTR	Transfer
IRASSalesMgmtRptOptions	Transfer
IRASSalesReportOptions	Transfer
IRASSalesSETP	Transfer
IRASSalesUserSETP	Transfer
IRASSalespersonCOMP	Transfer
IRASScheduleHDR	Transfer
IRASScheduleLINE	Transfer
IRASShipInvSETP	Transfer
IRASSplitMSTRDTL	Transfer
IRASSplitMSTRHDR	Transfer
IRASSplitMSTRLINE	Transfer
IRASStateRegionMSTR	Transfer
IRASStatementsROPT	Transfer
IRASTerritoryRegionDTL	Transfer
IRASTerritoryRegionMSTR	Transfer
IRASUNCEFACTMSTR	Transfer
IRASUOMMSTR	Transfer
IRASXMLCriteriaMSTR	Transfer
IRASXRefAddressHDR	Transfer
IRASXRefAddressLINE	Transfer
IRASXRefCCHDR	Transfer
IRASXRefCCLINE	Transfer
IRASXRefCCLINEDTL	Transfer
IRASXRefCompanyHDR	Transfer
IRASXRefCompanyLINE	Transfer
IRASXRefCustomerHDR	Transfer
IRASXRefCustomerLINE	Transfer
IRASXRefItemHDR	Transfer
IRASXRefItemLINE	Transfer
IRASXRefItemLINEDTL	Transfer
IRASXRefLocationHDR	Transfer
IRASXRefLocationLINE	Transfer
IRASXRefLocationLINEDTL	Transfer
IRASXRefManMeppelRptType	Transfer
IRASXRefManufacturerHDR	Transfer
IRASXRefManufacturerLINE	Transfer
IRASXRefPayTermsHDR	Transfer
IRASXRefPayTermsLINE	Transfer
IRASXRefSalespersonHDR	Transfer
IRASXRefSalespersonLINE	Transfer
IRASXRefTickerHDR	Transfer
IRASXRefTickerLINE	Transfer
IRASXRefTickerLINEDTL	Transfer
IRASXRefUOMHDR	Transfer
IRASXRefUOMLINE	Transfer
IRASXRefVendorHDR	Transfer
IRASXRefVendorLINE	Transfer
IRASXRefVendorLINEDTL	Transfer
IRCSBranchAccessSETP	Transfer
IRCSBranchItemMSTR	Transfer
IRCSBranchMSTR	Transfer
IRCSCheckBranchSETP	Transfer
IRCSCheckNumberSETP	Transfer
IRCSCurrentRegionBranch	Transfer
IRCSFreightSETP	Transfer
IRCSFuturesSymbolMSTR	Transfer
IRCSHazMatMSTR	Transfer
IRCSNoteMSTR	Transfer
IRCSNumberKeyMSTR	Transfer
IRCSNumbersSETP	Transfer
IRCSReasonCodeMSTR	Transfer
IRCSRegionMSTR	Transfer
IRCSRoleMSTR	Transfer
IRCSSRSReportsROPT	Transfer
IRCSShipMethodCOMP	Transfer
IRCSUDEFListMSTR	Transfer
IRCSUserCOMP	Transfer
IRCSUserCredCOMP	Transfer
IRCSVendor1099MSTR	Transfer
IRFSBillScheduleDetail	Transfer
IRFSBillScheduleMSTR	Transfer
IRFSBudgetBillDetail	Transfer
IRFSBudgetBillMSTR	Transfer
IRFSCustTankBudget	Transfer
IRFSDeliveryDriverMSTR	Transfer
IRFSDeliveryRouteMSTR	Transfer
IRFSDeliveryTruckMSTR	Transfer
IRFSDeliveryTypeMSTR	Transfer
IRFSLocationMSTR	Transfer
IRFSMeterMSTR	Transfer
IRFSTankMSTR	Transfer
IRGNAdvanceSETP	Transfer
IRGNBargeLocMSTR	Transfer
IRGNBargeSETP	Transfer
IRGNBoardOfTradeMSTR	Transfer
IRGNBoardTickerDTL	Transfer
IRGNBoardTickerMSTR	Transfer
IRGNBrokerMSTR	Transfer
IRGNBulkTransferSETP	Transfer
IRGNBulkTransferUserSETP	Transfer
IRGNCommodityGradeDetail	Transfer
IRGNCommodityGradeMSTR	Transfer
IRGNCommodityMSTR	Transfer
IRGNContractPositionHDR	Transfer
IRGNContractPositionLINE	Transfer
IRGNCtrWashKeyMSTR	Transfer
IRGNCustSumSETP	Transfer
IRGNCustSumSETPDTL	Transfer
IRGNDRCCustActTrans	Transfer
IRGNDRCJobSetup	Transfer
IRGNDRCPriceHIST	Transfer
IRGNDRCSETP	Transfer
IRGNDSGrowerMSTR	Transfer
IRGNDeferredCtrKeyMSTR	Transfer
IRGNDeliveryPeriodMSTR	Transfer
IRGNDiscDetailHDR	Transfer
IRGNDiscDetailItems	Transfer
IRGNDiscDetailLINE	Transfer
IRGNDiscSchedComment	Transfer
IRGNDiscScheduleHDR	Transfer
IRGNDiscScheduleItems	Transfer
IRGNDiscScheduleLINE	Transfer
IRGNDispositionMSTR	Transfer
IRGNFOBMSTR	Transfer
IRGNFlowMeterMSTR	Transfer
IRGNFossConstituentSETP	Transfer
IRGNFossGrainSETP	Transfer
IRGNGAC2500GrainSETP	Transfer
IRGNGACDataDetail	Transfer
IRGNGACGrainSETP	Transfer
IRGNGACMSTR	Transfer
IRGNGBStatementRptOPT	Transfer
IRGNGradeAvgRptSETP	Transfer
IRGNGradeDependencyMSTR	Transfer
IRGNGradeFactorMSTR	Transfer
IRGNGradesToGovernMSTR	Transfer
IRGNGrainClassSETP	Transfer
IRGNGrainVendorsLookup	Transfer
IRGNHedgeAccountMSTR	Transfer
IRGNHedgeAcctItemMSTR	Transfer
IRGNItemDispDiscSETP	Transfer
IRGNItemGradeFactorMSTR	Transfer
IRGNLoadKeyMSTR	Transfer
IRGNMainSETP	Transfer
IRGNMarketSiteSETP	Transfer
IRGNMarketZoneMSTR	Transfer
IRGNOptPriceSchHDR	Transfer
IRGNOptPriceSchLINE	Transfer
IRGNPSNumberKeyMSTR	Transfer
IRGNPerten5200GrainSETP	Transfer
IRGNPositionMSTR	Transfer
IRGNPriceScheduleHDR	Transfer
IRGNPriceScheduleLINE	Transfer
IRGNProgCommodityMSTR	Transfer
IRGNProgContractMSTR	Transfer
IRGNProgDispositionMSTR	Transfer
IRGNProgramDetailHDR	Transfer
IRGNProgramDetailLINE	Transfer
IRGNProgramScheduleHDR	Transfer
IRGNProgramScheduleLINE	Transfer
IRGNProjectionHDR	Transfer
IRGNProjectionLINE	Transfer
IRGNPurchCtrSETP	Transfer
IRGNPurchCtrUserSETP	Transfer
IRGNQtyToUseExceptions	Transfer
IRGNQualityClassMSTR	Transfer
IRGNQualitySubClassMSTR	Transfer
IRGNRINGalMSTR	Transfer
IRGNRINMSTR	Transfer
IRGNRINPrintMSTR	Transfer
IRGNSMSMessageMSTR	Transfer
IRGNSOECustomerBalMSTR	Transfer
IRGNSalesCtrPriceSETP	Transfer
IRGNSalesCtrReportDef	Transfer
IRGNSalesPriceIndexSETP	Transfer
IRGNSalesTicketKeyMSTR	Transfer
IRGNScaleMSTR	Transfer
IRGNSiteEmptyCOMP	Transfer
IRGNSplitMSTRHDR	Transfer
IRGNSplitMSTRLINE	Transfer
IRGNSteinliteGrainSETP	Transfer
IRGNSummaryGradeMSTR	Transfer
IRGNTicketAutoApplyDisp	Transfer
IRGNTicketAutoApplyHDR	Transfer
IRGNTicketUserSETP	Transfer
IRGNTradeKeyMSTR	Transfer
IRGNTradeSetup	Transfer
IRGNVehicleDriverMSTR	Transfer
IRGNVehicleMSTR	Transfer
IRGNWarehouseKeyMSTR	Transfer
IRGNWeightsToGovernMSTR	Transfer
IRGNXRefItemClassMSTR	Transfer
IRGNXRefItemSubClassMSTR	Transfer
IRIVHedgeItemDTL	Transfer
IRIVItemCOMP	Transfer
IRIVItemLicenseMSTR	Transfer
IRIVItemQtyCOMP	Transfer
IRIVLocationCOMP	Transfer
IRIVLotMSTR	Transfer
IRIVROPT	Transfer
IRMDSETP	Transfer
IRMDUserInfoSETP	Transfer
IRMFActivityMSTR	Transfer
IRMFMfgSETP	Transfer
IRMFRecipeDTL	Transfer
IRMFRecipeMSTR	Transfer
IRMFWorkCenterMSTR	Transfer
IRPMAddressCOMP	Transfer
IRPMLienholderDTL	Transfer
IRPMVendorCOMP	Transfer
IRRMCreditLimitSETP	Transfer
IRRMCustomerAddressCOMP	Transfer
IRRMCustomerCOMP	Transfer
IRRMCustomerLookupCOMP	Transfer
IRRMCustomerReportOpt	Transfer
IRRMOPENStatementCOMP	Transfer
IRSYLocationCOMP	Transfer
IRSYPaymentTermsCOMP	Transfer
IRSYPaymentTermsDTL	Transfer

Scripts

IRCSMSTRTableLoad

CINCH Customer Documentation

Appendix B

Related content