BUYSUPMAP

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

Column Descriptions:

NameTypeDescription
SUPORG_IDBIGINT NOT NULLSupplier Organization reference number.
BUYORGUNIT_IDBIGINT NOT NULLBuyer Organization or Organization Unit reference number.
CATALOG_IDBIGINT NOT NULLReference number of the root catalog displayed to the buyer organization unit.
PROCPROTCL_IDINTEGER NOT NULLProcurement protocol reference number.
CONTRACT_IDBIGINTReference number of the contract between the buyer and supplier organizations.
MBRGRP_IDBIGINT NOT NULLMember group to be assigned to the requisitioners registered on the fly.
FIELD1VARCHAR (64)Customizable.
FIELD2VARCHAR (64)Customizable.
FIELD3VARCHAR (64)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SUPORG_ID+BUYORGUNIT_ID+PROCPROTCL_IDPrimary Key
I0000490BUYORGUNIT_IDNon-Unique Index
I0000491CATALOG_IDNon-Unique Index
I0000492CONTRACT_IDNon-Unique Index
I0000493MBRGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_138PROCPROTCL_IDPROCPROTCLPROCPROTCL_IDCascade
F_139CONTRACT_IDCONTRACTCONTRACT_IDCascade
F_140MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_141CATALOG_IDCATALOGCATALOG_IDCascade
F_142BUYORGUNIT_IDORGENTITYORGENTITY_IDCascade
F_143SUPORG_IDORGENTITYORGENTITY_IDCascade