Be.Smart ERP Connector
(EN) Consultant Manual
(EN) Consultant Manual
  • Be.Smart ERP Connector Consultant Manual
  • Abbreviations used
  • Home
  • Purpose of the product
  • Technical solution
    • Data Interface
    • Autodesk Vault
    • Basic types of jobs and their origin
  • Configuration
    • EC configuration (central)
      • Main Card
      • Property Values tab
        • Tab < entity>
    • EC local configuration
    • Logging in
      • Logging to the local station
      • Logging in DI
    • Reverse logging
      • Description of the reverse logging process
    • FLAGs (additional flags in std Vault configuration)
      • List of symptoms
  • Commands and Features in Vault Explorer
    • Attach to already existing purchased item
    • Apply item security to files
    • Create Raw material BOM rows
    • Send to DI (Send to Data interface)
    • Data interface browser
      • Functions
  • Export
    • Item breakdown
      • BOM loading method
      • Transfer MJ
    • Atypical requirements
  • Imports
    • Processing of external requests for transfer to Vault (from version 2019 inclusive)
      • The procedure for processing the Arkance.Import initialization job:
    • PreProcess sample
    • Imports of entities
      • Entity identification by ERP system
      • Import items
      • Importing applications
      • Import folder
      • Importing a change command
      • Import schedules
  • Recommended commissioning procedure
    • DI commissioning
    • Mapping fields
  • Castomization (ec addons)
  • Attachments
    • Job types - complete list
    • Configuration type Global/Workgroup
Powered by GitBook
On this page

Was this helpful?

  1. Imports

PreProcess sample

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author.
-- Create date: 19.1.2018
-- Description: 
--- In pending ERP batches, searches for ITEM lined to FLDR.
--- If ITEM is not found in the selected storage,
--- sets their status to IGNORED
-- =============================================
CREATE PROCEDURE EcIgnoredItemForSpace 
AS
BEGIN
     SET NOCOUNT ON;


     DECLARE @comm_dir BIT = 1;
     DECLARE @assoc_link INT = 30;
     DECLARE @status_pending INT = 0;
     DECLARE @status_ignore INT = 8;


     UPDATE EcENTITY SET comm_status = @status_ignore
     WHERE id IN (
        SELECT ITEM. id FROM EcASSOC AS ASSOC INNER JOIN
                (SELECT id, ent_class_id, name, comm_dir, comm_status FROM EcENTITY AS ENTITY
                  WHERE (comm_dir = @comm_dir) AND (comm_status = @status_pending) AND (ent_class_id = N'ITEM')) AS ITEM
                          ON ASSOC. ent_id_child = ITEM. id LEFT OUTER JOIN
                (SELECT DISTINCT ItemNumber FROM [STORE]. dbo. vw_ItemIteration) AS ITER
                          ON ITEM. name = ITER. ItemNumber COLLATE Czech_CI_AS
         WHERE (ASSOC. ent_id_parent IN (
                     SELECT id FROM EcENTITY AS FLDR
                 WHERE (comm_dir = @comm_dir) AND (comm_status = @status_pending) AND (ent_class_id = N'FLDR')) AND (ITER. ItemNumber IS NULL) AND (ASSOC. assoc_type = @assoc_link)
          )
END
GO
PreviousThe procedure for processing the Arkance.Import initialization job:NextImports of entities

Last updated 11 months ago

Was this helpful?