Major OrderCentral table definitions and key fields

Name: Session

  • This table keeps track of session-level data.
  • Ties a session to a user (xctUsers.userID) and customer (Customer.custID) as well as other settings.

Name: xctb_soHeader

  • This is a basket table used to create settings for future creation of the order.
  • This table is a near duplicate of the order header table: soHeader except uses the sessionID as the key.
  • The fields are 1:1 match for what you want to end up in the SL order header.

Name: xctb_basket

  • This is a basket table used for line item settings for an order
  • This table is a near duplicate of the SL table: soLine except uses the sessionID and basketID as the keys.
  • The fields are 1:1 match for what you want to end up in the SL soLine table.

Name: xctUsers

  • This is the main user table for accounts on the OrderCentral website.
  • The username field should be unique.
  • Passwords can be stored plaintext, encrypted one-way or encrypted two-way, depending on requested configuration

Name: xctUserCustomer

  • This table is used to tie webusers to SL customers.
  • Keys: userID (xctUsers.userID), custID (Customer.custID)
  • This table can be used to provide a one-to-many relationship for webusers, configuration change required

Name: xctItems

  • This table is the OrderCentral catalog table. Items must be in this table in order to show up on the website.
  • Main Keys: itemID is usually an SL invtID (inventory.InvtID) invtID this is null if using extensions (product options) otherwise it shoul be a valid SL inventory.invtID or itemXref.alternateID

Name: xctCategory

  • This table handles categorization of data on the website
  • Main keys: categoryID: this is a unique key at each category level. categoryLevel this is the level of categorization. The top level of categories is: 0 parentCategoryID: this is used for all subcategorization levels, default(null) for top level categories

Name: xctItemCategories

  • This table ties items to categories.
  • Items can be in multiple categories
  • Main keys: categoryID (xctCategory.categoryID), categoryLevel (xctCategory.categoryLevel), itemID (xctItems.itemID)