STORETPC

The relationship between store entity and trading position container.

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLStore entity id.
TRADEPOSCN_IDBIGINT NOT NULLTrading position container id.
STTPCUSG_IDINTEGER NOT NULLStore TPC usage id.
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>STOREENT_ID+TRADEPOSCN_ID+STTPCUSG_IDPrimary Key
I0001357TRADEPOSCN_IDNon-Unique Index
I0001388STTPCUSG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3642STOREENT_IDSTOREENTSTOREENT_IDCascade
F_3643TRADEPOSCN_IDTRADEPOSCNTRADEPOSCN_IDCascade
F_3675STTPCUSG_IDSTTPCUSGSTTPCUSG_IDCascade