This table is used to register the buyer organization using procurement systems with supplier organizations.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.