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

Mandatory EcENTITY table fields

  • bulk_id

for ITEM entity type import it is strongly recommended to keep one bulk_id for each item structure

i.e. when importing purchased items, unique bulk_id should be assigned to every single item

  • ent_class_id

for example ‘ITEM’

  • guid

only for ent_class_id = ‘CUSTENT’ - ie. only for Custom Object entity, refers the type of CustomObject; ask CAD Studio consultant to provide this string value

  • name

for example Vault Item number, Vault File name, Vault ECO number, Vault Folder name, …

  • comm_dir

1 for import into Vault

  • comm_status 0 for pending

PreviousImporting data into a VaultNextDefault values