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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034847390 | SUPORG_ID, BUYORGUNIT_ID, PROCPROTCL_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|