POLICY

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:

NameTypeDescription
POLICY_IDBIGINT NOT NULLThe policy ID.
POLICYNAMEVARCHAR (128) NOT NULLThe unique policy name. It is expected that a store contains the following bootstrap policies:
  • MasterCatalog (one per StoreEntity)
  • CreditLine (one per StoreEntity)
POLICYTYPE_IDCHAR (64) NOT NULLThe policy type ID. Foreign key to the POLICYTYPE table.
STOREENT_IDINTEGER NOT NULLThe Store or StoreGroup ID.
PROPERTIESVARCHAR (254)Default name value pairs that can be set to the business policy command. For example: n1=v1&n2=v2.
STARTTIMETIMESTAMPStart date of the policy. If null, the policy starts immediately.
ENDTIMETIMESTAMPEnd date of the policy. If null, no end time.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>POLICY_IDPrimary Key
I0000189POLICYNAME+POLICYTYPE_ID+STOREENT_IDUnique Index
I0000337POLICYTYPE_ID+STOREENT_IDNon-Unique Index
I0000697STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_608STOREENT_IDSTOREENTSTOREENT_IDCascade
F_609POLICYTYPE_IDPOLICYTYPEPOLICYTYPE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1147POLICY_IDSHIPINFOPOLICY_IDCascade
F_536POLICY_IDORDPAYMTHDPOLICY_IDCascade
F_584POLICY_IDPAYSUMMARYPOLICY_IDCascade
F_610POLICY_IDPOLICYCMDPOLICY_IDCascade
F_612POLICY_IDPOLICYDESCPOLICY_IDCascade
F_613POLICY_IDPOLICYTCPOLICY_IDCascade
F_669POLICY_IDREFUNDMTHDPOLICY_IDCascade
F_695POLICY_IDRMAPOLICY_IDCascade