Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BUYSUPMAP
This table is used to register the buyer organization using procurement systems with supplier organizations.
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 SQL100520030305760 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
_vcc_freeselect_bottom_