STORE

Each row of this table represents a store. A store is a store entity.


Column Descriptions:

Name Type Description
STORE_ID INTEGER NOT NULL Generated unique key.
STOREGRP_ID INTEGER NOT NULL The store group for this store.
STORECGRY_ID INTEGER The store category, if any, for this store.
LANGUAGE_ID INTEGER The default language for information displayed to customers shopping in the store. For a list of language components, see the LANGUAGE table.
FFMCENTER_ID INTEGER The default fulfillment center for the store.
STATUS INTEGER NOT NULL DEFAULT 1 The status of the store. Valid values are:

    1
    open

    0
    closed

    -1
    suspended

STORELEVEL CHAR (10) STORELEVEL column is used as a flag to tell if various features are used in the store. The possible values are MC and MOBILE comma separated.

    MC
    The store uses store functions in Management Center.

    MOBILE
    The store has a mobile presence. Enables mapping of user agent to device format using the wc-devices.xml file.

DIRECTORY VARCHAR (254) The base name of the directory in which store-specific Web assets, such as JSP files and property files, are found.
OID CHAR (32) Reserved for IBM internal use.
QUOTEGOODFOR INTEGER DEFAULT 43200 If this many seconds have passed since an Order was prepared and the customer has not committed to pay, the prices and other monetary amounts in the Order may change when OrderProcess is run.
FIELD1 VARCHAR (254) Customizable.
FIELD2 VARCHAR (254) Customizable.
ALLOCATIONGOODFOR INTEGER NOT NULL DEFAULT 43200 When this many seconds have passed since the allocations were made, the ReleaseExpiredAllocations scheduler job can reverse available to promise (ATP) inventory allocations. If 0, ATP inventory allocation is not used by this store, and the INVENTORY table is used instead.
MAXBOOFFSET INTEGER NOT NULL DEFAULT 7776000 The maximum number of seconds that an item can be backordered. If the estimated availability time for a backordered order item exceeds this many seconds into the future, the availability date will automatically be set to this many seconds into the future. Thus, an item cannot be backordered longer than the interval specified here.
REJECTEDORDEXPIRY INTEGER DEFAULT 259200 Orders with payment in declined state longer than this many seconds are candidates for cancellation.
FFMCSELECTIONFLAGS INTEGER NOT NULL DEFAULT 0 Contains bit flags that specify policy used by the default implementation of GetEligibleFulfillmentCenters concerning the selection of a fulfillment center for an order item whose status is:

  • 1 = preferCurrent, give preference to the currently assigned fulfillment center, if any;

  • 2 = noChange, do not change the currently assigned fulfillment center, if any.

BOPMPADFACTOR INTEGER DEFAULT 0 If this store calculates order amounts (such as taxes or shipping charges) differently for different fulfillment centers, the order amount for a previously submitted order might change when fulfillment centers are allocated for backordered order items. This column specifies the percentage amount ("padding factor") by which the order amount presented to the payments subsystem can be increased, if necessary. For example, specify 5 to allow an increase of up to 5 percent.
RTNFFMCTR_ID INTEGER The ID of the fulfillment center used as the default for returning merchandise to the store.
DEFAULTBOOFFSET INTEGER NOT NULL DEFAULT 7776000 When an estimated availability time cannot be determined for a backordered order item, by default, it will be set to this many seconds into the future.
PRICEREFFLAGS INTEGER NOT NULL DEFAULT 0 Contains bit flags that control which trading agreements and offers are searched when prices are refreshed by the default implementation of the GetContractunitPrices task command:

  • 0 = Default. Use trading agreements and offers referenced by order items. The task command fails if the trading agreements or offers cannot be used. The tradingId and offerId are not saved to the ORDITRD and ORDIOFFER tables.

  • 1 = usePreviousOnly. Use trading agreements and offers referenced by the order items. The task command fails if the trading agreements or offers cannot be used. The trading ID and offer ID are saved to the ORDITRD and ORDIOFFER tables.

  • 2 = usePreviousOrSearchAgain. Same as usePreviousOnly. If trading agreements or offers cannot be used, search trading agreements and offers in the ORDIOFFER and ORDITRD tables.

  • 4 = alwaysSearchAgain. Always search for saved trading agreements and offers in the ORDIOFFER and ORDITRD tables.

  • 8 = MergeQtyWithCatentry. Merge quantity of all order items with the same catentryId within an order to get the best price for them. The tradingId and offerId are not saved to the ORDITRD and ORDIOFFER tables.

STORETYPE CHAR (3) Indicates one of the following store types. This indicator is used by a user interface to provide appropriate functions depending on the store type:

  • B2C = Consumer direct

  • BBB = Basic B2B

  • B2B = B2B

  • CHS = Channel hub

  • CPS = Catalog asset store

  • RHS = Consumer direct reseller store

  • BRH = B2B reseller store

  • RPS = Consumer direct reseller storefront asset store

  • BRP = B2B reseller storefront asset store

  • DPS = Distributor asset store

  • DPX = Distributor proxy store

  • SCP = Supplier hub

  • SCS = Supplier catalog asset store

  • SPS = Supplier asset store

  • SHS = Supplier hosted store

  • HCP = Hosting hub

  • PBS = Store directory

  • MHS = Consumer direct hosted store

  • BMH = B2B hosted store

  • MPS = Consumer direct hosted storefront asset store

  • BMP = B2B hosted storefront asset store.

RMAGOODFOR INTEGER DEFAULT 86400 The time period in seconds for which return merchandise authorization (RMA) calculations are valid. If this time period elapses before an RMA is completed, charges or credits and approval will be recalculated.
AVSACCEPTCODES VARCHAR (64) The payments subsystem AVS result codes that the store considers acceptable:

  • 0 = Both street address and postal code match;

  • 1 = Street address matches, but postal code does not;

  • 2 = Postal code matches, but street address does not;

  • 3 = Neither street address nor postal code match;

  • 4 = AVS result not available.

0 is always acceptable, regardless of it appears in this string. All values acceptable for this column are in VARCHAR format, not necessarily single digit numbers. For example, the value 14 means that 0 is acceptable (since 0 is always acceptable), 1 is acceptable, and 4 is acceptable.
For more details about the payments subsystem AVS codes, refer to the payments subsystem documentation.

CRTDBYCNTR_ID BIGINT The contract used to create the store.
LASTUPDATESTATUS TIMESTAMP Indicates the last time the status of the store was updated.
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.
ALLOCATIONOFFSET INTEGER NOT NULL DEFAULT 86400 Amount of time before the requested ship date when inventory allocation should be performed. This time period provides a buffer for the store to reserve the inventory to the order and also allow for enough time to obtain inventory should there be an insufficient amount. See REQUESTEDSHIPDATE in ORDERITEMS.
MAXFOOFFSET INTEGER DEFAULT 7776000 The maximum period of time that can be requested for a future ship date after the date the requested ship date is entered. See REQUESTEDSHIPDATE in ORDERITEMS.
INVENTORYOPFLAG INTEGER NOT NULL DEFAULT 0 Contains bit flags indicating how to perform inventory operations. A value of 1 indicates that the RECEIPT table is updated during shipment confirmation.
BLOCKINGACTIVE SMALLINT DEFAULT 1 Specifies whether the order blocking feature is in use. The order blocking feature can be disabled for this particular store by setting this field to 0. Default is 1.
BLKEXTASYNCH SMALLINT NOT NULL DEFAULT 0 Allows the merchant-extensible code for order blocking to be run asynchronously. This column can be used when a merchant wants to test for blocking conditions by connecting to external systems. To enable this feature, this column must be set to 1. By default, it is turned off (that is, set to 0).
PERSISTENTSESSION SMALLINT

  • 0 = The rememberMe function is disabled for registered customers and guest customers. This is the default value.

  • 1 = The rememberMe function is enabled for registered customers only.

  • 2 = The rememberMe function is enabled for guest customers only.

  • 3= The rememberMe function is enabled for registered customers and guest customers.

ORDERHISTACTIVE CHAR (1) NOT NULL DEFAULT 'Y' Indicates whether order change history tracking is enabled. Default is Y (Yes).
INVENTORYSYSTEM SMALLINT NOT NULL DEFAULT -1 Indicates which inventory system is used:

This setting is used by the inventory component to determine inventory behavior.

UP_DIRECTORY VARCHAR (254) The equivalent value of the DIRECTORY column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> STORE_ID Primary Key
I0000778 FFMCENTER_ID Non-Unique Index
I0000779 STORECGRY_ID Non-Unique Index
I0000780 RTNFFMCTR_ID Non-Unique Index
I0000781 CRTDBYCNTR_ID Non-Unique Index
I0001288 STOREGRP_ID Non-Unique Index
IPF00026 UP_DIRECTORY Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_772 RTNFFMCTR_ID FFMCENTER FFMCENTER_ID Cascade
F_773 STORECGRY_ID STORECGRY STORECGRY_ID Cascade
F_774 STOREGRP_ID STOREGRP STOREGRP_ID Cascade
F_775 STORE_ID STOREENT STOREENT_ID Cascade
F_776 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_777 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_925 CRTDBYCNTR_ID CONTRACT CONTRACT_ID Cascade


Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_1020 STORE_ID RFQTARGET STORE_ID Cascade
F_103 STORE_ID AUTOBIDLOG STORE_ID Cascade
F_113 STORE_ID BID STORE_ID Cascade
F_1144 STORE_ID CTXMGMT STORE_ID Cascade
F_119 STORE_ID BIDLOG STORE_ID Cascade
F_1198 STORE_ID TICKLER STORE_ID Cascade
F_1206 STORE_ID TKLRACTION STORE_ID Cascade
F_1209 STORE_ID TKLRREASON STORE_ID Cascade
F_191 STORE_ID CATENCALCD STORE_ID Cascade
F_211 STORE_ID CATGPCALCD STORE_ID Cascade
F_23 STORE_ID ACCOUNT STORE_ID Cascade
F_258 STORE_ID CPENDORDER STOREENT_ID Cascade
F_308 STORE_ID DISTARRANG WHOLESALESTORE_ID Cascade
F_309 STORE_ID DISTARRANG MERCHANTSTORE_ID Cascade
F_311 STORE_ID ECEOUT STORE_ID Cascade
F_3467 STORE_ID STOREMERCH STORE_ID Cascade
F_3582 STORE_ID INVAVL STORE_ID Cascade
F_3587 STORE_ID INVCNFREL STORE_ID Cascade
F_3600 STORE_ID UPLOADFILE STORE_ID Cascade
F_3605 STORE_ID PX_CDPOOL STORE_ID Cascade
F_393 STORE_ID INVENTORY STORE_ID Cascade
F_403 STORE_ID ITEMFFMCTR STORE_ID Cascade
F_462 STORE_ID MOPICONFIG STORE_ID Cascade
F_578 STORE_ID PAYSTATUS STORE_ID Cascade
F_623 STORE_ID PROFILE STORE_ID Cascade
F_650 STORE_ID RA STORE_ID Cascade
F_661 STORE_ID RECEIPT STORE_ID Cascade
F_677 STORE_ID RFQ STORE_ID Cascade
F_697 STORE_ID RMA STORE_ID Cascade
F_748 STORE_ID SHPARRANGE STORE_ID Cascade
F_784 STORE_ID STORECNTR STORE_ID Cascade
F_786 STORE_ID STOREDEF STORE_ID Cascade
F_802 STORE_ID STOREMBRGP STORE_ID Cascade
F_803 STORE_ID STORETRANS STORE_ID Cascade
F_859 STORE_ID TFTRADENG STORE_ID Cascade
F_911 STORE_ID WTAXINFO STORE_ID Cascade
F_916 STORE_ID STOREREL STORE_ID Cascade
F_917 STORE_ID STOREREL RELATEDSTORE_ID Cascade
F_93 STORE_ID AUCTSTRREL STORE_ID Cascade
F_930 STORE_ID SHPMODCLCD STORE_ID Cascade
F_934 STORE_ID ORDQUOTREL CHILDSTORE_ID Cascade
F_943 STORE_ID MASSOCCECE STORE_ID Cascade
F_944 STORE_ID MASSOCGPGP STORE_ID Cascade
F_945 STORE_ID CATGRPTPC STORE_ID Cascade
F_946 STORE_ID ICMETAFEAT STOREID Cascade
F_947 STORE_ID ICMETAPHOR STOREID Cascade
F_951 STORE_ID QUEUE STORE_ID Cascade
F_970 STORE_ID ICMERTREE STOREID Cascade
F_971 STORE_ID ICKNOWLEDG STOREID Cascade
F_986 STORE_ID FILEUPLOAD STORE_ID Cascade
F_99 STORE_ID AUTOBID STORE_ID Cascade


Related reference
ATP inventory adjustment data model
ATP expected inventory data model
ATP inventory reservations data model
Calculation code data model
Calculation code - indirect attachment data model
Calculation rule data model
Calculation rule - discount data model
Calculation scale data model
Contract data model
Fulfillment data model
Messaging data model
Offers data model
Order management - RMA data model
Order item - allocated data model
Order item - backordered data model
Order release data model
Order trading agreement data model
Receipt data model
Request for Quote (RFQ) data model
Shipping data model
Store data model
User traffic data model
Vendor data model