Each row of this table represents a Contract. A Contract is part of a Store, and represents terms and conditions that may be associated with OrderItems, such as prices, minimum quantities, and who can use the Contract.
Column Name | Column Type | Description |
---|---|---|
CONTRACT_ID | BIGINT NOT NULL | Unique identifier for a contract. Foreign key to TRADING_ID in the TRADING database table. |
MAJORVERSION | INTEGER NOT NULL DEFAULT 1 | Major version number of the Contract. |
MINORVERSION | INTEGER NOT NULL DEFAULT 0 | Minor version number of the Contract. |
NAME | VARCHAR(200) NOT NULL | Uniquely identifies a version of a Contract of a particular origin for a particular owner. |
MEMBER_ID | BIGINT NOT NULL | Owner of the Contract. |
ORIGIN | INTEGER NOT NULL DEFAULT 0 | Indicates why the Contract was created: 0 = manual 1 = imported 2 = RFQ 3 = exchange 4 = auction 5 = 2-party negotiation 6 = deployment |
STATE | INTEGER NOT NULL DEFAULT 0 | Indicates the contract state: 0 = draft 1 = pending approval 2 = approved 3 = active 4 = rejected 5 = canceled 6 = closed 7 = suspended -1 = deployment in progress -2 = deployment failed |
USAGE | INTEGER NOT NULL DEFAULT 0 | Indicates how the contract will be used: 0 = default 1 = organization buyer 2 = reseller 3 = special bid 4 = referral 5 = supplier 6 = delegation grid |
MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates if this Contract has been marked for deletion: 0 = No 1 = Yes and this Contract has been marked for deletion |
COMMENTS | VARCHAR(4000) | A comment associated with the Contract. |
TIMECREATED | TIMESTAMP | The time the Contract was created. |
TIMEUPDATED | TIMESTAMP | The time the Contract was most recently updated. |
TIMEAPPROVED | TIMESTAMP | The time the Contract was approved. |
TIMEACTIVATED | TIMESTAMP | The time the Contract was activated. |
TIMEDEPLOYED | TIMESTAMP | The time the Contract was deployed. |
FAMILY_ID | BIGINT | The contract belongs to this family of contracts with the same name, owner, and origin. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000078 | NAME+MEMBER_ID+MAJORVERSION+MINORVERSION+ORIGIN | Unique Index |
SQL050212031216060 | CONTRACT_ID | Primary Key |
I0000539 | MEMBER_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_253 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
F_252 | CONTRACT_ID | TRADING | TRADING_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_139 | CONTRACT_ID | BUYSUPMAP | CONTRACT_ID | Cascade |
F_188 | CONTRACT_ID | CATCNTR | CONTRACT_ID | Cascade |
F_246 | CONTRACT_ID | CNTRDISPLY | CONTRACT_ID | Cascade |
F_912 | CONTRACT_ID | CNTRSTORE | CONTRACT_ID | Cascade |
F_925 | CRTDBYCNTR_ID | STORE | CONTRACT_ID | Cascade |
F_785 | CONTRACT_ID | STORECNTR | CONTRACT_ID | Cascade |
F_788 | CONTRACT_ID | STOREDEF | CONTRACT_ID | Cascade |
F_833 | CONTRACT_ID | TDPSCNCNTR | CONTRACT_ID | Cascade |