Each row of this table indicates that the
TradingPositions in a
TradingPositionContainer are available to customers of
Stores. There the Contract is deployed, subject to any terms and
conditions associated with the Contract.
Column Descriptions:
Name | 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 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> | POLICY_ID | Primary Key |
I0000189 | POLICYNAME+POLICYTYPE_ID+STOREENT_ID | Unique Index |
I0000337 | POLICYTYPE_ID+STOREENT_ID | Non-Unique Index |
I0000697 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_608 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
F_609 | POLICYTYPE_ID | POLICYTYPE | POLICYTYPE_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_1147 | POLICY_ID | SHIPINFO | POLICY_ID | Cascade |
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 |