This table contains the buyer organization specific profile information of procurement system protocols to support Procurement System integration.
Column Name | Column Type | Column Description |
---|---|---|
CONTRACTPARM | VARCHAR (32) NULL |
The parameter name for identifying the Contract. |
FIELD1 | VARCHAR (32) NULL |
Customizable. |
FIELD2 | VARCHAR (32) NULL |
Customizable. |
FIELD3 | VARCHAR (32) NULL |
Customizable. |
ORGENTITY_ID | BIGINT NOT NULL |
The buyer organization reference number. |
ORGUNITPARM | VARCHAR (32) NOT NULL |
The organization unit parameter name. |
PROCPROTCL_ID | INTEGER NOT NULL |
The Procurement Protocol reference number. |
REQIDPARM | VARCHAR (32) NOT NULL |
The Requisitioner ID parameter name. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035038330 | PROCPROTCL_ID, ORGENTITY_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_615 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | Cascade |
F_616 | PROCPROTCL_ID | PROCPROTCL | PROCPROTCL_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|