Be.Smart ERP Connector
(EN) ERP Connector
(EN) ERP Connector
  • ℹī¸What is ERP Connector?
  • ⚙ī¸System Requirements
  • 🆕What's New
    • Versions 29.2.1.0, 28.7.1.0, 27.13.0.0
    • Versions 29.1.0.0, 28.6.0.0, 27.12.0.0
    • Versions 29.0.0.1 & 28.5.1.1
  • Data Interface - Reference Manual
    • Abbreviations
    • Data interface
    • Data tables, relations
      • Table EcENTITY
      • Table EcASSOC
      • Table EcLINK
      • Table EcLOG
      • Stored procedure EcWriteEntity
    • Exporting data from a Vault
    • Properties / Attributes
    • Associations
    • Links
    • Reading data from data interface
      • Workflow sample
      • Another samples
    • Importing data into a Vault
    • Mandatory EcENTITY table fields
    • Default values
    • LifeCycle States
    • Writing data into data interface
      • Using SQL Stored Procedure
        • Example #1 – insert single EcENTITY record
        • Example #2 – insert two associated EcENTITY records
      • Using SQL syntax
      • Using SQL Management Studio
    • SQL views
    • ERP data displayed dynamically in VE Tab
    • SQL view definition sample:
    • ERP synchronized enums
    • Logging
    • Using thumbnail image data
Powered by GitBook
On this page
  1. Data Interface - Reference Manual
  2. Writing data into data interface

Using SQL Stored Procedure

Stored procedure is provided as a part of the data interface. You should consider using this stored procedure when you need to insert two or more records into the EcENTITY table AND these records have logical association/s.

Name: EcWriteEntity Parameters:

  • @EntName NVARCHAR (100)

  • @BulkID INT = -1 OUT

  • @EntClassID NVARCHAR (10) = 'ITEM'

PreviousWriting data into data interfaceNextExample #1 – insert single EcENTITY record