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 |