Database Table: BUYSUPMAP

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

Column Name Column Type Column Description
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.
CONTRACT_ID BIGINT
NULL
Reference number of the contract between the buyer and supplier organizations.
FIELD1 VARCHAR (64)
NULL
Customizable.
FIELD2 VARCHAR (64)
NULL
Customizable.
FIELD3 VARCHAR (64)
NULL
Customizable.
MBRGRP_ID BIGINT
NOT NULL
Member group to be assigned to the requisitioners registered on the fly.
PROCPROTCL_ID INTEGER
NOT NULL
Procurement protocol reference number.
SUPORG_ID BIGINT
NOT NULL
Supplier Organization reference number.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034847390 SUPORG_ID, BUYORGUNIT_ID, PROCPROTCL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_138 PROCPROTCL_ID PROCPROTCL PROCPROTCL_ID Cascade
F_139 CONTRACT_ID CONTRACT CONTRACT_ID Cascade
F_140 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_141 CATALOG_ID CATALOG CATALOG_ID Cascade
F_142 BUYORGUNIT_ID ORGENTITY ORGENTITY_ID Cascade
F_143 SUPORG_ID ORGENTITY ORGENTITY_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable