WebSphere Commerce database table: BUYSUPMAP

This table is used to register the buyer organization using procurement systems with supplier organizations.

Column Descriptions
Column Name Column Type Description
SUPORG_ID BIGINT NOT NULL Supplier Organization reference number.
BUYORGUNIT_ID BIGINT NOT NULL Buyer Organization or Organization Unit reference number.
CATALOG_ID BIGINT NOT NULL Reference number of the root catalog displayed to the buyer organization unit.
PROCPROTCL_ID INTEGER NOT NULL Procurement protocol reference number.
CONTRACT_ID BIGINT Reference number of the contract between the buyer and supplier organizations.
MBRGRP_ID BIGINT NOT NULL Member group to be assigned to the requisitioners registered on the fly.
FIELD1 VARCHAR(64) Customizable.
FIELD2 VARCHAR(64) Customizable.
FIELD3 VARCHAR(64) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235133210 SUPORG_ID+BUYORGUNIT_ID+PROCPROTCL_ID Primary Key
I0000490 BUYORGUNIT_ID Non-Unique Index
I0000491 CATALOG_ID Non-Unique Index
I0000492 CONTRACT_ID Non-Unique Index
I0000493 MBRGRP_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_141 CATALOG_ID CATALOG CATALOG_ID Cascade
F_139 CONTRACT_ID CONTRACT CONTRACT_ID Cascade
F_140 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_142 BUYORGUNIT_ID ORGENTITY ORGENTITY_ID Cascade
F_143 SUPORG_ID ORGENTITY ORGENTITY_ID Cascade
F_138 PROCPROTCL_ID PROCPROTCL PROCPROTCL_ID Cascade
Related reference