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:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | CONTRACT_ID | Primary Key |
I0000078 |
NAME+MEMBER_ID+MAJORVERSION+MINORVERSION+ORIGIN | Unique Index |
I0000539 | MEMBER_ID | Non-Unique Index |
I0001510 | FAMILY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_252 | CONTRACT_ID | TRADING | TRADING_ID | Cascade |
F_253 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | 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_785 | CONTRACT_ID | STORECNTR | CONTRACT_ID | Cascade |
F_788 | CONTRACT_ID | STOREDEF | CONTRACT_ID | Cascade |
F_833 | CONTRACT_ID | TDPSCNCNTR | CONTRACT_ID | Cascade |
F_912 | CONTRACT_ID | CNTRSTORE | CONTRACT_ID | Cascade |
F_925 | CONTRACT_ID | STORE | CRTDBYCNTR_ID | Cascade |