BUYSUPMAP

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

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	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

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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