STOREENT

Each row of this table represents a StoreEntity. A StoreEntity is an abstract superclass that can represent either a Store or a StoreGroup.

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLGenerated unique key.
MEMBER_IDBIGINT NOT NULLThe owner of the StoreEntity.
TYPECHAR (1) NOT NULLThe kind of StoreEntity this row represents. Valid values are as follows: G = StoreGroup S = Store
SETCCURRCHAR (3)The default currency for a StoreEntity that will be used by a customer who has not specified a preferred currency. This is a currency code as per ISO 4217 standards. If the currency code is NULL for a Store, the default currency is obtained from its StoreGroup. See also the STORELANG table.
IDENTIFIERVARCHAR (254) NOT NULLA string that, together with MEMBER_ID, uniquely identifies the StoreEntity.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if the StoreEntity has been marked for deletion: 0 = No, 1 = Yes.
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_IDPrimary Key
I0000240IDENTIFIER+MEMBER_IDUnique Index
I0000787MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_789SETCCURRSETCURRSETCCURRCascade
F_790MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1015STOREENT_IDMSGARCHIVESTOREENT_IDCascade
F_1025STOREENT_IDMSGSTORESTOREENT_IDCascade
F_1036STOREENT_IDEMLBOUNCEDSTOREENT_IDCascade
F_1039STOREENT_IDEMLSTRPLCYSTOREENT_IDCascade
F_1042STOREENT_IDPX_GROUPSTOREENT_IDCascade
F_1043STOREENT_IDPX_POLICYSTOREENT_IDCascade
F_1048STOREENT_IDPX_PROMOTIONSTOREENT_IDCascade
F_1053STOREENT_IDPX_COUPONSTOREENT_IDCascade
F_1056STOREENT_IDPX_USAGESTOREENT_IDCascade
F_1081STOREENT_IDPX_TEMPLATESTOREENT_IDCascade
F_1088STOREENT_IDORDRELEASESTOREENT_IDCascade
F_1102STOREENT_IDATCHTGTSTOREENT_IDCascade
F_1107STOREENT_IDATCHASTSTOREENT_IDCascade
F_1232STOREENT_IDPRCORSNSTOREENT_IDCascade
F_128STOREENT_IDBROADCASTSTOREENT_IDCascade
F_1500STOREENT_IDEXPERIMENTSTOREENT_IDCascade
F_152STOREENT_IDCALCODESTOREENT_IDCascade
F_164STOREENT_IDCALMETHODSTOREENT_IDCascade
F_177STOREENT_IDCALSCALESTOREENT_IDCascade
F_182STOREENT_IDCAMPAIGNSTOREENT_IDCascade
F_233STOREENT_IDCHARGETYPESTOREENT_IDCascade
F_236STOREENT_IDCHKCMDSTOREENT_IDCascade
F_243STOREENT_IDCMDREGSTOREENT_IDCascade
F_249STOREENT_IDCOLLATERALSTOREENT_IDCascade
F_265STOREENT_IDCPPMNSTOREENT_IDCascade
F_286STOREENT_IDCURCONVERTSTOREENT_IDCascade
F_289STOREENT_IDCURCVLISTSTOREENT_IDCascade
F_293STOREENT_IDCURFORMATSTOREENT_IDCascade
F_296STOREENT_IDCURLISTSTOREENT_IDCascade
F_299STOREENT_IDDISPCGPRELSTOREENT_IDCascade
F_304STOREENT_IDDISPENTRELSTOREENT_IDCascade
F_313STOREENT_IDEMSPOTSTOREENT_IDCascade
F_325STOREENT_IDFLOWADMINSTOREENT_IDCascade
F_3504STOREENT_IDATTRDICTSTOREENT_IDCascade
F_3511STOREENT_IDATTRDICTGRPSTOREENT_IDCascade
F_3553STOREENT_IDATTRSTOREENT_IDCascade
F_3555STOREENT_IDATTRVALSTOREENT_IDCascade
F_3614STOREENT_IDWALLETSTOREENT_IDCascade
F_3618STOREENT_IDINSRULESTOREENT_IDCascade
F_3630STOREENT_IDPRICERULESTOREENT_IDCascade
F_3632STOREENT_IDPRELETEMPLATESTOREENT_IDCascade
F_3636STOREENT_IDPREQUATIONSTOREENT_IDCascade
F_3637STOREENT_IDPRCONSTANTSTOREENT_IDCascade
F_3642STOREENT_IDSTORETPCSTOREENT_IDCascade
F_3650STOREENT_IDSUBSCRIPTIONSTOREENT_IDCascade
F_3654STOREENT_IDSUBSCRTEMPLATESTOREENT_IDCascade
F_3663STOREENT_IDCATFILTERSTOREENT_IDCascade
F_3678STOREENT_IDCMFEEDLOGSTOREENT_IDCascade
F_3686STOREENT_IDSRCHTERMASSOCSTOREENT_IDCascade
F_3697STOREENT_IDSEOPAGEDEFSTOREENT_IDCascade
F_3703STOREENT_IDSEOPAGEDEFSUBPARAMSTOREENT_IDCascade
F_3705STOREENT_IDSEOURLKEYWORDSTOREENT_IDCascade
F_3711STOREENT_IDSEOTOKENUSGTYPESTOREENT_IDCascade
F_3715STOREENT_IDSTOREDEFCATSTOREENT_IDCascade
F_3716STOREENT_IDSTORECONFSTOREENT_IDCascade
F_3718STOREENT_IDSTOREPLTYPESSTOREENT_IDCascade
F_3720STOREENT_IDPAGELAYOUTSTOREENT_IDCascade
F_3724STOREENT_IDCATOVRGRPSTOREENT_IDCascade
F_3725STOREENT_IDSTORECATOVRGRPSTOREENT_IDCascade
F_3727STOREENT_IDFOLDERSTOREENT_IDNo Action
F_3728STOREENT_IDFOLDERITEMSTOREENT_IDCascade
F_3730STOREENT_IDGEONODESTOREENT_IDCascade
F_3731STOREENT_IDSTLOCSTOREENT_IDCascade
F_3734STOREENT_IDFACETCATGRPSTOREENT_IDCascade
F_3746STOREENT_IDPLWIDGETDEFSTOREENT_IDCascade
F_3750STOREENT_IDPLSTOREWIDGETSTOREENT_IDCascade
F_3759STOREENT_IDPLPAGESTOREENT_IDCascade
F_3763STOREENT_IDSRCHPROPRELVSTOREENT_IDCascade
F_3765STOREENT_IDPREVIEWTOKENSTOREENT_IDCascade
F_3776STOREENT_IDCEDISPCTXSTOREENT_IDCascade
F_3780STOREENT_IDCEDYNDISPCTXSTOREENT_IDCascade
F_381STOREENT_IDIITEMSTOREENT_IDCascade
F_385STOREENT_IDINITIATIVESTOREENT_IDCascade
F_388STOREENT_IDINVADJCODESTOREENT_IDCascade
F_409STOREENT_IDJURSTSTOREENT_IDCascade
F_412STOREENT_IDJURSTGROUPSTOREENT_IDCascade
F_415STOREENT_IDLANGPAIRSTOREENT_IDCascade
F_420STOREENT_IDLMEVENTMAPSTOREENT_IDCascade
F_421STOREENT_IDLMSERVERSTOREENT_IDCascade
F_439STOREENT_IDMBRATTRVALSTOREENT_IDCascade
F_478STOREENT_IDONLOGSTOREENT_IDCascade
F_480STOREENT_IDONQUEUESTOREENT_IDCascade
F_507STOREENT_IDORDERITEMSSTOREENT_IDCascade
F_517STOREENT_IDORDERSSTOREENT_IDCascade
F_577STOREENT_IDPAYMTHDSUPSTOREENT_IDCascade
F_581STOREENT_IDPAYSUMMARYSTOREENT_IDCascade
F_608STOREENT_IDPOLICYSTOREENT_IDCascade
F_636STOREENT_IDPVCMDLSPECSTOREENT_IDCascade
F_645STOREENT_IDQTYFORMATSTOREENT_IDCascade
F_721STOREENT_IDRTNDNYRSNSTOREENT_IDCascade
F_722STOREENT_IDRTNDSPCODESTOREENT_IDCascade
F_728STOREENT_IDRTNREASONSTOREENT_IDCascade
F_736STOREENT_IDSCHCMDSTOREENT_IDCascade
F_737STOREENT_IDSCHCONFIGSTOREENT_IDCascade
F_745STOREENT_IDSHIPMODESTOREENT_IDCascade
F_765STOREENT_IDSTENCALUSGSTOREENT_IDCascade
F_775STOREENT_IDSTORESTORE_IDCascade
F_779STOREENT_IDSTORECATSTOREENT_IDCascade
F_780STOREENT_IDSTORECENTSTOREENT_IDCascade
F_782STOREENT_IDSTORECGRPSTOREENT_IDCascade
F_794STOREENT_IDSTOREENTDSSTOREENT_IDCascade
F_795STOREENT_IDSTOREGRPSTOREGRP_IDCascade
F_796STOREENT_IDSTOREITEMSTOREENT_IDCascade
F_799STOREENT_IDSTORELANGSTOREENT_IDCascade
F_805STOREENT_IDSTORITMFFCSTOREENT_IDCascade
F_816STOREENT_IDTAXCGRYSTOREENT_IDCascade
F_885STOREENT_IDTXCDCLASSSTOREENT_IDCascade
F_901STOREENT_IDVENDORSTOREENT_IDCascade
F_926STOREENT_IDREPDLVRYSTOREENT_IDCascade
F_956STOREENT_IDINTVSCHEDSTOREENT_IDCascade
F_958STOREENT_IDEMLPROMOSTOREENT_IDCascade
F_965STOREENT_IDEMLCFGSTOREENT_IDCascade
F_967STOREENT_IDEMLUSRRECVSTOREENT_IDCascade
F_973STOREENT_IDEMLMSGSTOREENT_IDCascade
R_3447STOREENT_IDSTQOTCFGSTOREENT_IDCascade
R_3448STOREENT_IDSTORBLKRSNSTOREENT_IDCascade
R_3450STOREENT_IDORDCHGRSNSTOREENT_IDCascade