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. Data tables, relations

Table EcASSOC

entity associantions (eg. BOM, Change Order/Item, …)

field

data type

description

id

bigint not null PK

record number

assoc_type

smallint not null

association type / entity relationship description:

BOM = 0, CoItem = 10, CoFile = 11, Attachment = 20,

LinkParCld = 30, Association = 40, ReverseAssoc = 50, Other = -1

ent_id_parent

bigint not null FK

parent entity – link to EcENTITY.id

ent_id_child

bigint not null FK

child entity – link to EcENTITY.id

qty_occ

int

BOM - number of component occurrences

qty_total

float

BOM - total quantity

position

nvarchar 6

BOM – position (item number)

row_number

nvarchar 6

according to EcASSOC.assoc_type field:

BOM: row number

Attachment: β€œPin” means pinned to a specific file version

Association: 0: Primary, 1: Secondary, 2: Tertiary, 3: StandardComponent,

4: PrimarySub, 5: SecondarySub (AWS.ItemFileLnkTyp Enum)

driven_by_cad

bit

for BOM: 1 = row is driven by CAD component

for Association: 1 = file is driven by Item

PreviousTable EcENTITYNextTable EcLINK