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 Descriptions
| 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.
|