WebSphere Commerce database table: BUYSUPMAP

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031204480 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback