Each row of this table indicates that the TradingPositions in a TradingPositionContainer are available to customers of Stores where the Contract is deployed, subject to any terms and conditions associated with the Contract.
Column Description(s):
Column Name | Column Type | Description |
POLICY_ID |
BIGINT NOT NULL |
The policy ID. |
POLICYNAME |
VARCHAR(128) NOT NULL |
The unique policy name. It is expected that a store contains the following bootstrap policies:
- MasterCatalog (one per StoreEntity)
- CreditLine (one per StoreEntity)
|
POLICYTYPE_ID |
CHAR(64) NOT NULL |
The policy type ID. Foreign key to the POLICYTYPE table. |
STOREENT_ID |
INTEGER NOT NULL |
The Store or StoreGroup ID. |
PROPERTIES |
VARCHAR(254) |
Default name value pairs that can be set to the business policy command. For example: n1=v1&n2=v2. |
STARTTIME |
TIMESTAMP |
Start date of the policy. If null, the policy starts immediately. |
ENDTIME |
TIMESTAMP |
End date of the policy. If null, no end time. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000189 |
POLICYNAME+POLICYTYPE_ID+STOREENT_ID |
Unique Index |
SQL050212031256450 |
POLICY_ID |
Primary Key |
I0000337 |
POLICYTYPE_ID+STOREENT_ID |
Non-Unique Index |
I0000697 |
STOREENT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_609 |
POLICYTYPE_ID |
POLICYTYPE |
POLICYTYPE_ID |
Cascade |
F_608 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_536 |
POLICY_ID |
ORDPAYMTHD |
POLICY_ID |
Cascade |
F_584 |
POLICY_ID |
PAYSUMMARY |
POLICY_ID |
Cascade |
F_610 |
POLICY_ID |
POLICYCMD |
POLICY_ID |
Cascade |
F_612 |
POLICY_ID |
POLICYDESC |
POLICY_ID |
Cascade |
F_613 |
POLICY_ID |
POLICYTC |
POLICY_ID |
Cascade |
F_669 |
POLICY_ID |
REFUNDMTHD |
POLICY_ID |
Cascade |
F_695 |
POLICY_ID |
RMA |
POLICY_ID |
Cascade |
F_1147 |
POLICY_ID |
SHIPINFO |
POLICY_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.