Techniczny opis integracji z ERP

Opis dotyczy starych instalacji, w których Futuriti Workflow jest instalowany na bazie ERP. Obecne instalacje z użyciem Futuriti Connector nie wprowadzają poniższych modyfikacji na bazę ERP.

Wymagania:

• Konto Windows z uprawnieniami administratora
• Konto Windows musi mieć możliwość uruchomienia zadania w harmonogramie zadań
• Aplikacja komunikuje się po protokole HTTPS
• Użytkownik SQL na którym działa aplikacja powinien posiadać minimum uprawnienia w roli cdnKNF, cdRaport i db_owner.
• tworzy nową bazę o nazwie FuturitiWMS_{nazwa instancji}

Na wybranej bazie systemu ERP wprowadzane są następujące zmiany :

Dodane tabele

• [AlpolShipment].[Accounts]
• [AlpolShipment].[BinaryData]
• [AlpolShipment].[CourierDataDHL]
• [AlpolShipment].[CourierDataDPD_DE]
• [AlpolShipment].[CourierDataDPD_DE_Parcel]
• [AlpolShipment].[CourierDataEuropaczka]
• [AlpolShipment].[CourierDataFedEx]
• [AlpolShipment].[CourierDataFedexInternational]
• [AlpolShipment].[CourierDataFedexInternational_Parcel]
• [AlpolShipment].[CourierDataGLS_CZ]
• [AlpolShipment].[CourierDataGLS_HU]
• [AlpolShipment].[CourierDataGLS_PL]
• [AlpolShipment].[CourierDataGLS_RO]
• [AlpolShipment].[CourierDataGLS_SK]
• [AlpolShipment].[CourierDataGoGlobal]
• [AlpolShipment].[CourierDataInpostPaczkomaty]
• [AlpolShipment].[CourierDataKex]
• [AlpolShipment].[CourierDataMeest]
• [AlpolShipment].[CourierDataMeest_Parcel]
• [AlpolShipment].[CourierDataOlza]
• [AlpolShipment].[CourierDataOmnisell]
• [AlpolShipment].[CourierDataOmnisellAttributes]
• [AlpolShipment].[CourierDataPaczkaWRuchu]
• [AlpolShipment].[CourierDataPocztaPolska]
• [AlpolShipment].[CourierDataSwiatPrzesylek]
• [AlpolShipment].[CourierDataUPS]
• [AlpolShipment].[CourierDataUPS_Parcel]
• [AlpolShipment].[Couriers]
• [AlpolShipment].[CouriersDeliveryTypes]
• [AlpolShipment].[DeliveryTypes]
• [AlpolShipment].[DPDSubParcel]
• [AlpolShipment].[FedExSubParcel]
• [AlpolShipment].[InpostSubParcel]
• [AlpolShipment].[PackageHeader]
• [AlpolShipment].[PocztaPolskaSubParcel]
• [AlpolShipment].[Version]
• [AlpolWF].[Configuration]
• [AlpolWF].[EmailAccounts]
• [AlpolWF].[ExternalEvent]
• [AlpolWF].[ExternalSystem]
• [AlpolWF].[FTPAccounts]
• [AlpolWF].[Holds]
• [AlpolWF].[InternationalData]
• [AlpolWF].[ParameterType]
• [AlpolWF].[PrintDefinitionMap]
• [AlpolWF].[Printings]
• [AlpolWF].[ProcesDefinitionStepActionParameter]
• [AlpolWF].[ProcessAction]
• [AlpolWF].[ProcessActionParameter]
• [AlpolWF].[ProcessDefinition]
• [AlpolWF].[ProcessDefinitionParameter]
• [AlpolWF].[ProcessExecution]
• [AlpolWF].[ProcessExecutionParameters]
• [AlpolWF].[ProcessModule]
• [AlpolWF].[ProcessModuleInstance]
• [AlpolWF].[ProcessSqlLog]
• [AlpolWF].[ProcessStartCondition]
• [AlpolWF].[ProcessStep]
• [AlpolWF].[ProcessStepTransition]
• [AlpolWF].[SystemAction]
• [AlpolWF].[SystemActionTrigger]
• [AlpolWF].[Task]
• [AlpolWF].[Trigger]
• [AlpolWF].[Version]
• [AlpolWF].[WorkerSession]
• [AlpolWF].[WorkerSessionStatus]
• [AlpolWMSIntegrator].[ObjectSynchronization]

Dodane widoki

• [AlpolWF].[Diagnostic_ExternalEventQuery]
• [AlpolWF].[Diagnostic_TaskQuery]
• [AlpolWF].[Diagnostic_TaskQuerySystemError]
• [AlpolWF].[Diagnostic_TaskUnfinished]
• [AlpolWF].[Diagnostic_TaskUnfinishedDetails]
• [AlpolWF].[ExternalEventView]
• [AlpolWF].[ModulView]
• [AlpolWF].[ProcessDefinitionView]
• [AlpolWF].[ProcessStartConditionView]
• [AlpolWF].[ProcessStepTransitionView]
• [AlpolWF].[SystemActionView]
• [AlpolWF].[TaskView]
• [AlpolWF].[TaskViewUnhandledErrors]
• [AlpolWF].[VersionView]

Dodane funkcje

• [AlpolShipment].[GetLabelDataByDocument]
• [AlpolWF].[DecodeBitmask]
• [AlpolWF].[ExternalCourierDetails]
• [AlpolWF].[GetAccountUserNameByDocumentId]
• [AlpolWF].[GetBaseSalesStocks]
• [AlpolWF].[GetBaseWarehouseStocks]
• [AlpolWF].[GetConfigurationValueBoolean]
• [AlpolWF].[GetConfigurationValueInt]
• [AlpolWF].[GetConfigurationValueNumeric]
• [AlpolWF].[GetConfigurationValues]
• [AlpolWF].[GetConfigurationValues2]
• [AlpolWF].[GetConfigurationValues3]
• [AlpolWF].[GetConfigurationValuesByModuleId]
• [AlpolWF].[GetConfigurationValueString]
• [AlpolWF].[GetDocumentByShipmentWaybill]
• [AlpolWF].[GetDocumentByShipmentWaybillERP]
• [AlpolWF].[GetDocumentSerie]
• [AlpolWF].[GetInternationalData]
• [AlpolWF].[GetInternationalData2]
• [AlpolWF].[GetInternationalData3]
• [AlpolWF].[GetItemInternationalData3]
• [AlpolWF].[GetObjectHoldFlag]
• [AlpolWF].[GetSalesDocumentIdByDocumentId]
• [AlpolWF].[GetSalesInvoiceIdByDocumentId]
• [AlpolWF].[GetSalesOrderIdByDocumentId]
• [AlpolWF].[GetSalesOrderIdByFGUID]
• [AlpolWF].[GetSalesOrderWFHeaderByDocumentId]
• [AlpolWF].[GetShippmentDetails]
• [AlpolWF].[GetStockQuantityByDate]
• [AlpolWF].[GetWmsStockByDocumentQuery]
• [AlpolWF].[SplitStringIndex]
• [AlpolWMSIntegrator].[GetDefaultPrinterByDocumentPrint]

Dodane procedury

• [AlpolShipment].[GetAcc_ExternalId_ErpDeliveryName]
• [AlpolShipment].[GetCourierAndDeliveryTypeByErpDeliveryName]
• [AlpolShipment].[GetDocumentAttributes]
• [AlpolShipment].[GetLabelDataByPackageHeaderId]
• [AlpolShipment].[GetLabelFormat]
• [AlpolShipment].[GetPackageDefault]
• [AlpolShipment].[GetPackageHeaderDocument]
• [AlpolShipment].[GetPackageItemsDefault]
• [AlpolShipment].[GetPrinterName]
• [AlpolShipment].[GetReportDataByPrintId]
• [AlpolShipment].[GetSenderData]
• [AlpolShipment].[GetTotalWeight]
• [AlpolShipment].[SetWaybillOnErpDocument]
• [AlpolWF].[AddAttribute]
• [AlpolWF].[AddNewExternalEvent]
• [AlpolWF].[AddProcessError]
• [AlpolWF].[CopyProcessParametersToExecution]
• [AlpolWF].[CreateTaskByProcessExecution]
• [AlpolWF].[DeleteExternalEventsWithRelation]
• [AlpolWF].[Disable_EnableAllTriggers]
• [AlpolWF].[EnableTriggersBySystemActionId]
• [AlpolWF].[ExecuteProcessExternalUserCondition]
• [AlpolWF].[ExecuteProcessStartCondition]
• [AlpolWF].[ExecuteScheduleDateCondition]
• [AlpolWF].[GetExternalEventByTaskId]
• [AlpolWF].[GetOrCreateFGUIDByDocument]
• [AlpolWF].[GetPrintTemplateByDocument]
• [AlpolWF].[GetWmsStockByDocument]
• [AlpolWF].[GoToNextProcessStep]
• [AlpolWF].[RestartTask]
• [AlpolWF].[SetTasksHoldByFGUID]
• [AlpolWF].[SetWaybilOnDocument]
• [AlpolWF].[StartProcessExecution]
• [AlpolWF].[StartProcessExecutionByTaskId]

Dodane triggery

• [AlpolShipment].[PackageHeader].[NewWaybill]
• [AlpolShipment].[PackageHeader].[PackageError]
• [AlpolShipment].[PackageHeader].[ProcessStarter]
• [AlpolWF].[Holds].[AlpolWF_OnHoldDelete]
• [AlpolWF].[Holds].[AlpolWF_OnHoldSave]
• [AlpolWF].[ProcessExecution].[CreateTaskOnNewProcessExecution]
• [AlpolWF].[Printings].[NewPrint]
• [AlpolWF].[Task].[ProcessTaskResponse]
• [AlpolWF].[Task].[SetLastActivity]
• [AlpolWF].[ExternalEvent].[SetLastActivityEvent]
• [AlpolWF].[ExternalEvent].[StartProcessOnExternalAction]

Pozostałe w zależności od rodzaju ERP

• Techniczny opis integracji z Comarch ERP XL
• Techniczny opis integracji z Comarch ERP Optima