Be.Smart ERP Connector
(EN) ERP Connector
(EN) ERP Connector
  • â„šī¸What is ERP Connector?
  • âš™ī¸System Requirements
  • 🔑Installation & Activation Guide
  • 🆕What's New
    • Versions 30.1.0.6, 29.3.0.5, 28.8.0.5 & 27.14.0.5
    • Versions 30.0.0.3, 29.2.1.2, 28.7.3.3 & 27.13.0.5
    • Versions 28.7.1.1, 27.13.0.1
    • 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

Was this helpful?

  1. Data Interface - Reference Manual
  2. Data interface
  3. Data tables, relations

Table EcLINK

links to entities in Vault client, to files in shared folders

field

data type

description

id

bigint not null PK

record number

ent_id

bigint not null FK

link to EcENTITY.id

link_type

smallint not null

link type: see value list under this table

vault

nvarchar 20

Vault name (link to full Vault client only)

object_type

nvarchar 20

Vault entity type (link to full Vault client only)

object_name

nvarchar (max)

entity name OR http link OR full file name

link_type values: FullClientCompose = 1, FullClientAcrContents = 2, FullClientHttpRequest = 3, FullClientComposePublishedFile = 4, FullClientAcrContentsPublishedFile = 5, FullClientHttpRequestPublishedFile = 6,

ThinClientMaster = 10, ThinClientRev = 11, ThinClientMasterPublishedFile = 12, ThinClientRevPublishedFile = 13,

FfnNative = 20, FfnVisualization = 21, FfnThumbnail = 22, FfnPublished = 30, VaultFullName = 40,

Other = 0, PendingPublication = -2

PreviousTable EcASSOCNextTable EcLOG

Last updated 2 years ago

Was this helpful?