Database schema changes from version 5.1 to version 5.5

This topic describes the database schema changes between WebSphere Commerce 5.1 and WebSphere Commerce 5.5. The changes are grouped into the following sections:

Tables added since version 5.1

ACACGPDESC
This table stores locale specific display information for the ACACTGRP table. The Administration Console GUI displays the locale specific display names from this table.
ACACTACTGP
This table captures the association between access control actions and action groups.
ACACTDESC
This table stores locale specific display information for the actions stored in the ACACTION table.
ACACTGRP
This table stores all the access control action groups. An action group can contain one or more actions. The association between actions and action groups is captured in the ACACTACTGP table.
ACACTION
This table is a master list of all the actions in the system. Typically the actions map to the controller commands and views in the system. This table stores all the actions that can be performed on the resources in the system.
ACATTR
This table is a master list of the attributes based on which some resources can be grouped. These attributes can be used to form implicit groups of resources.
ACATTRDESC
This table stores locale specific display information corresponding to the ACATTR table.
ACCLOGMAIN
This table contains information about access violation. Entries are created only if a violation has occurred. There will only be one entry per request. Detailed information is stored in the ACCLOGSUB table.
ACCLOGSUB
This table contains detailed information of the request causing access violation. The entries are linked to the ACCLOGMAIN table.
ACCOUNT
ACORGPOL
This table enables an organization to be exempted from one or more of the template policies. This table is deprecated and is provided for backward compatibility only.
ACPLGPDESC
This table stores locale specific information for the ACPOLGRP table.
ACPLGPSUBS
This table stores the association between access control policy groups and organizational entities. An organizational entity that is associated with a policy group is said to subscribe to that policy group. The access control policies belonging to that policy group will apply to that organization. An organization can subscribe to multiple policy groups and the same policy group can be subscribed to by multiple organizations.
ACPOLDESC
This table stores locale specific information for the ACPOLICY table.
ACPOLGPPOL
This table stores the association between access control policy groups and access control policies. An access control policy that belongs to a policy group will be applied to all the organizations that subscribe to that policy group.
ACPOLGRP
This table stores all the access control policy groups in the system. Each a row in this table represents a policy group.
ACPOLICY
This table stores all the access control policies in the system. Each policy is a row in the policy table. Every policy refers to an action group, a member group, a resource group and optionally a relationship.
ACPOLSUBGP
Reserved for IBM internal use.
ACRELATION
This table is a master list of all the relations that exist in the system. These relationships are between resources that are protected and the members in the system.
ACRELDESC
This table stores locale specific information about relationships.
ACRELGRP
This table is a master list of all the relationship groups that exist in the system. These relationship groups are between resources that are protected and the users in the system.
ACRESACT
This table captures the relationship between resources and actions. Given a resource, we can find out the associated actions from this table.
ACRESATREL
This table stores the attributes for a given resource on which it can be implicitly grouped. The metadata information about attributes is used in the GUI for defining resource groups and also for generating the SQL for prefiltering.
ACRESCGRY
This table stores all the resource categories in the system and the metadata information about them. The metadata includes information about the table and columns that store the resources belonging to this resource category.
ACRESGPDES
This table stores locale specific display information for the ACRESGRP table.
ACRESGPRES
This table associates resource groups with resource categories (or the classes of resources). You can use this table to group various resources in a group based on their class names.
ACRESGRP
This table stores all the resource groups in the system. The conditions column stores an XML document containing the constraints and attribute value pairs used for grouping the resources.
ACRESMEMRL
This table stores resource-member relationships for resources of the type of different resource categories. A combination of all the columns other than ACRESMEMRL_ID should be unique.
ACRESPRIM
This table stores the primary resource column names for a resource. A given resource can have more than one primary column.
ACRESREL
This table stores the relationship between resources. Given a resource, you can find out the possible relationships that it can have and also the table and the columns in which various relationships are stored.
ACRLGPDESC
This table stores locale specific information about relationship groups.
ACRSCGDES
This table stores locale specific display names for the resource categories.
APPLY_INIT
This table holds the mining model apply results. The mining model is applied to information pertaining to initiatives.
APPLY_MEMBER
The table contains the output from WebSphere Commerce Analyzer after applying the mining model to members and running the WebSphere Commerce Analyzer sample closed-loop script.
APPLY_RESULT
This table contains the result of a mining apply for contracts or accounts.
APRVSTATUS
This table stores approval requests and their status and contains multiple rows for each action awaiting approval, with one row for every potential approver. Each entry is unique per approver, entity tuplet. The FlowTypeId indicates which type of entityId is pending approval.
ATTACHMENT
This table contains information about Attachments. An Attachment is a supporting document for a trading document. For example, it can be a specification of a product, or a price list spreadsheet.
ATTACHUSG
The Attachment usage table.
AUCPAYINFO
Reserved for IBM internal use.
BASEITEM
BaseItems represent a general family of goods with a common name and description. BaseItems are used exclusively for fulfillment. Each CatalogEntry that represents a Product in the catalog has a corresponding BaseItem for fulfillment purposes.
BASEITMDSC
Each row of this table contains language-dependent information for a BaseItem.
BKORDALLOC
Each row contains information about the quantity required for this backordered order item and the amount of available inventory allocated to this item.
BKORDITEM
Each row contains the expected ship date of a backordered OrderItem.
BUYERPO
Each row of this table represents a Purchase Order Number that the Buyer organization of the Account has defined or used for Trading with the Seller organization. The number is only unique within the Account.
BUYERPOTYP
The Buyer Purchase Order Type table. This table defines the different types of Buyer Purchase Order for the Site.
BUYSUPMAP
This table is used to register the buyer organization using procurement systems with supplier organizations.
BUYSUPSEC
Reserved for IBM internal use.
BZSRVCFG
This table contains rule server configuration data. Each row represents a rule server.
BZSVCCFG
This table contains rule service configuration data. Each row represents a rule service configuration, including to which rule server the service belongs.
BZSVCSTA
This table indicates the last-known status of a rule service. Each row represents status reported by an application clone for a rule service.
CACHEIVL
This table records changes to product or category information in the database. It can be populated by user-defined database triggers.
CALCODEMGP
The CalculationCodeQualifyMethod can use the rows of this table to restrict use of a CalculationCode to members of certain MemberGroups.
CATCLSFCOD
This table contains the assignment of classification codes to CatalogEntries.
CATCONFINF
This table holds additional information for CatalogEntries that represent Configurable Products. This information may be required by an external configurator to configure this CatalogEntry.
CATGRPPS
This table relates CatalogGroups to ProductSets. Every CatalogEntry under the Catalog sub-tree for this CatalogGroup is a member of the specified ProductSet.
CATGRPTPC
This table relates master catalogs with trading position containers. Each catalog entry belonging to the indicated master catalog must have a standard price offer supplied for the specified trading position container.
CATPRDREL
Reserved for IBM internal use.
CHARGETYPE
Charge or credit applied against a transaction which is not for product. Examples include expedite fees, customization fees, and restocking fees.
CHKARRANG
This table associates the defined store commands (SCHCMD) with the defined check commands (CHKCMD).
CHKCMD
The check commands that can be used by a store to determine whether the scheduled job needs execution. This is for the Scheduler menu in the Administration Console.
CHRGTYPDSC
This table contains the language-dependent descriptions of the Charge Type.
CLASIFCODE
This table contains all possible product classification codes under different classification domains (such as UNSPSC, SPSC, and so on) that can be assigned to CatalogEntries.
CLSFCODEDS
This table contains the language specific information of product classification code.
CNTRDISPLY
This table contains display information for a Contract.
CNTRNAME
This table contains name information for a Contract. The Contract name is used to force serialization on contract management.
CNTRSTORE
This table contains Store information for a Contract. The data is used to persist XML data needed by a contract to create a Store.
COLLABWS
This table stores collaborative workspace information.
CPEMAILMAP
This table stores the mapping of the coupon ID to the e-mail IDs of guest customers to which specific coupon IDs persisted by them were sent.
CPITMAP
This table stores all the items from the given (completed) order that were applicable to the selected coupon set.
CPOFFER
This table contains the promotions that are available to be shown to customers in their offer list.
CPPMN
This table gives the details of what a promotion is, and reference to its purchase, validity, and discount conditions.
CPPMNACC
This table stores the number of times coupons have been accepted from the coupon promotion by the guest customer identified by the e-mail ID. It also stores the number of times the customer has redeemed coupons from this promotion.
CPPMNCAT
This table contains the purchase conditions for a category-level promotion. If the purchase condition type in CPPMN table was C, then this table is used to find out all the items that are required for this coupon to be redeemed. There can be more than one category condition for a given promotion. All the purchase conditions for a coupon are combined using the AND operator.
CPPMNDESC
This table contains the language specific description of the promotion.
CPPMNDISC
This table contains the discount conditions for a promotion. Every coupon has exactly one calculation code.
CPPMNORD
This table contains the minimum purchase amount in the shopping cart for this coupon to be applicable to.
CPPMNPROD
This table contains the purchase conditions for a promotion. If the purchase condition type in CPPMN table was "P", then this table is used to find out all the items that are required for this Coupon to be redeemed.
CPPMNVAL
Reserved for IBM internal use.
CPWALLET
This table contains the coupons that the user has accepted.
CREDITLINE
Each row of this table represents a credit line the account holder (buyer organization) has with the seller organization. This credit line is associated with a specific business account.
CWMEMBER
This table stores collaborative workspace member information.
DISTARRANG
Each row of this table represents a DistributionArrangement, enabling a Store to sell its own inventory.
EMLCFG
This table stores the configuration of e-mail activity accounts. Each store can have one inbound (POP3) and one outbound (SMTP) server configured.
EMLGRPREL
This table stores the relationship between an e-mail activity and its assigned member group (customer profile).
EMLMSG
This table stores e-mail message templates. Each row corresponds to an e-mail message template which can be used within an e-mail activity.
EMLPROMO
This table stores e-mail activities. Each row corresponds to an e-mail activity which is sent to a given customer profile.
EMLRCPTS
This table records the recipients of an e-mail activity.
EMLRPTEVTS
This table records e-mail events for each recipient of a particular e-mail activity. If a row does not exist for a recipient of an e-mail activity, the user has not yet caused an event.
EMLUSRRECV
This table stores user preference of whether to receive e-mail or not.
EMSPOT
This table contains registered e-Marketing Spots.
FILEUPLOAD
This table contains the information of uploaded files.
FLCOMPOSE
Reserved for IBM internal use.
FLDOMNDESC
Reserved for IBM internal use.
FLINSTANCE
Reserved for IBM internal use.
FLOW
Reserved for IBM internal use.
FLOWADMIN
Reserved for IBM internal use.
FLOWDESC
Reserved for IBM internal use.
FLOWDOMAIN
Reserved for IBM internal use.
FLOWTYPE
Reserved for IBM internal use.
FLSTATEDCT
Reserved for IBM internal use.
FLSTATEGP
Reserved for IBM internal use.
FLSTATEREL
Reserved for IBM internal use.
FLSTDCTDSC
Reserved for IBM internal use.
FLSTGPDSC
Reserved for IBM internal use.
FLTRANSDSC
Reserved for IBM internal use.
FLTRANSITN
Reserved for IBM internal use.
FLTYPEDESC
Reserved for IBM internal use.
HISTOATTR
Reserved for IBM internal use.
HISTOFREQ
Reserved for IBM internal use.
HISTONVP
Reserved for IBM internal use.
INTVSCHED
This table describes the scheduling of initiatives onto e-Marketing Spots.
INVADJCODE
Each row of this table defines an InventoryAdjustmentCode for a Store, or the Stores in a StoreGroup. Each code represents a reason for an InventoryAdjustment, such as broken, lost, or found.
INVADJDESC
Each row of this table contains language-dependent information about an InventoryAdjustmentCode.
INVADJUST
This table records adjustments made to inventory.
INVOICE
This table stores the invoice XML generated for the order release. An order release is represented by a row in the ORDRELEASE table.
INVRESERVE
Each row contains information about existing inventory that has been reserved for such purposes as auctions. This reserved inventory is not available for customer orders until the reservation is reversed.
INVRSRVDSC
Each row contains language-specific descriptions for the types of inventory reservations that the user has defined.
INVRSRVTYP
Each row contains user-defined reservation types that can be used when reserving inventory.
ITEMFFMCTR
Each rows contains information about reserved quantities, amount on backorder, and amount allocated to backorders for items owned by a store at a fulfillment center.
ITEMSPC
Information about specified items. A specified item is a product with values for all its attributes. A specified item could correspond to a 2L bottle of milk, with 2% fat content. A specified item is the customer view of what the merchant sells.
ITEMTYPE
Each row of this table represents a type of BaseItem.
ITEMVERSN
Each row of this table represents an ItemVersion for a BaseItem. An ItemVersion expires when its expiration date is in the past. Each BaseItem must only have a single ItemVersion defined.
LMEVENTMAP
LikeMinds event information. This information is also stored in the LikeMinds server database.
LMSERVER
This table holds the LikeMinds server information.
LPOPURAMT
This table is used to keep track of Purchase Amounts by Purchase Order number and by Orders. Entries are created only for Orders against Limited Purchase Order (PO) numbers.
MANIFEST
One record exists for each manifest (shipment confirmation) produced for an order release. If a release is packaged in two boxes there will be two rows in the manifest table.
MBRATTR
This table contains an attribute definition dictionary for members.
MBRATTRVAL
This table stores the values of attributes which are defined in the MBRATTR table for members.
MBRGRPCOND
This table stores the conditions for an implicit memberGroup.
MBRGRPDESC
This table contains locale specific information for the entries in the MBRGRP table.
MBRREL
This table stores membership hierarchy relationships among users and orgEntities. Note that memberGroup is not part of the membership hierarchy.
MBRROLE
This table stores role assignment for members. Each member can play one or more roles in the WebSphere Commerce system. When a member is assigned a role, the orgEntity for which the member plays that role can also be specified.
MLTIME
This table is used by the MassLoader component as register of current timestamp.
MSGARCHIVE
This table stores sent messages (if ARCHIVEMSG = "1" is set for the message profile). The stored messages can be resent using the integrated GUI in the Administration Console.
NOTIFY
Reserved for IBM internal use.
NUMBRUSG
Each row defines a NumberUsage object. Numbers such as quantities and monetary amounts can be rounded and formatted differently depending on their associated NumberUsage objects. The CurrencyManager and QuantityManager cache this information.
NUMBRUSGDS
Each row of this table contains language-dependent information for a NumberUsage. This table defines a usage of either a currency format or a quantity format. See also the NUMBRUSG table.
OICOMPLIST
Each rows contains information about the components of a configured OrderItem.
OPERATOR
This table is used to define operators.
OPERATRDSC
This table holds the language-dependent information related to an operator.
ORCPMAP
This table stores information about the electronic coupons that were used with the given (completed) Order.
ORDCALCD
Each row of this table indicates to the CalculationCodeCombineMethod that a CalculationCode is directly attached to all OrderItems in an Order whose directCalculationCodeAttachment flag in ORDERITEMS.PREPAREFLAGS is 1.
ORDCHNLTYP
Reserved for IBM internal use.
ORDERMGP
This table is used to track the customer profiles to which an Order is associated.
ORDIMEEXTN
This table contains procurement system specific OrderItem information.
ORDIOFFER
Each row of this table indicates an Offer that was searched to obtain the price for an OrderItem. These rows are created by the OrderItemAdd and OrderItemUpdate commands.
ORDIPROF
Reserved for IBM internal use.
ORDITRD
Each row of this table indicates a TradingAgreement that was searched to obtain the price for an OrderItem. These rows are created by the OrderItemAdd and OrderItemUpdate commands.
ORDMEEXTN
This table contains procurement system specific order information.
ORDPICKHST
Details of the how inventory was picked from the receipt level when available inventory is allocated to an OrderItem.
ORDQUOTREL
Each row of this table represents a relationship between a parent Order and a child Order.
ORDRELEASE
Each row in this table represents an OrderRelease. An OrderRelease is a grouping of all OrderItems in an Order that are to be shipped to the same address using the same shipping mode from the same FulfillmentCenter at the same time.
ORDSHIPHST
Each row contains information about inventory that has been released for fulfillment of an OrderItem.
ORGCODE
This table contains the unique identification of an OrgEntity under different identification systems or domains. This can be used to identify buyer organizations and supplier organizations to each other in procurement systems.
OUTPUTQ
Reserved for IBM internal use.
OUTPUTQDSC
Reserved for IBM internal use.
PARTICIPNT
This table stores information about a participant for a TradingAgreement.
PARTROLE
This table stores role information about a participant for a TradingAgreement.
PARTROLEDS
This table stores descriptions for the role a participant plays a TradingAgreement.
PATTRDESC
This table contains personalization Attribute descriptions.
PATTRIBUTE
This is the personalization Attribute supported by the site.
PATTRPROD
The relationship table between the PATTRIBUTE and CATENTRY tables.
PATTRVALUE
The personalization Attribute Value table. This table holds the values associated with personalization attributes.
PAYSUMMARY
Each row of this table stores a payment summary XML that could be sent to an external accounting system. The summary is by Store, Account, and payment policy.
PICKBATCH
This table contains pick batch information. A pick batch groups together order releases for their processing as a unit at a FulfillmentCenter (picking inventory for OrderItems, packing them into boxes, and shipping to customer through selected carrier).
PLCYACCDSC
This table holds language-dependent information related to an account policy.
PLCYACCLCK
This table contains the account lockout policies for WebSphere Commerce stores.
PLCYACCT
This table stores the account policies.
PLCYLCKDSC
This table holds language-dependent information related to an account lockout policy.
PLCYPASSWD
This table stores password policies.
PLCYPWDDSC
This table holds language-dependent information related to a password policy.
PLCYTYCMIF
This table stores command interface relationship information for a business policy.
PLCYTYPDSC
This table describes the type of business policy for a policy.
POLICY
Each row in this table represents a business policy.
POLICYCMD
This table stores command relationship information for a business policy.
POLICYDESC
This table stores descriptions for a business policy.
POLICYTC
This table stores information about which business policy is referenced by a specific term or condition.
POLICYTYPE
This table stores information about the type of business policy for a policy.
PRATRSTATR
Reserved for IBM internal use.
PRCEOFFPRD
Reserved for IBM internal use.
PRCOFFRPRC
Reserved for IBM internal use.
PRDATRAVAL
Reserved for IBM internal use.
PROCBUYPRF
This table contains the buyer organization specific profile information of procurement system protocols to support Procurement System integration.
PROCMSGVW
This table contains the view names used to compose the response message sent to procurement systems. Response message composition can be customized (per buyer, per protocol) using this table.
PROCPROTCL
Each row of this table represents a procurement system protocol and its version number. For example, cXML, OCI, OBI, and so on.
PROCSYS
Each row of this table represents a Procurement System. Examples of Procurement systems are Ariba, Oracle, CommerceOne, and so on.
PRODATR
Reserved for IBM internal use.
PRODSETDSC
This table holds the language-dependent information related to ProductSets.
PRODUCTSET
This table holds the definition of a ProductSet. The actual representation of the ProductSet is held in the PRSETCEREL table.
PRSETCEREL
This table holds the expanded (published) form of a ProductSet.
PSETADJMNT
This table stores information on product set adjustments and shows which product set is referenced by a term and condition for a business policy.
PURCHASELT
This table stores information on stipulations or limitations on how much a customer can purchase based on a Contract.
QTYUNITMAP
Each row of this table maps a QuantityUnit (defined in the QTYUNIT table) to a unit of measurement code defined in an external standard.
QUEUE
This table contains customer care queue records in each store.
QUEUECSR
This table contains customer care queue assignment records for Customer Service Representatives.
QUEUEDESC
This table contains Customer Care Queue display information according to languages.
RA
Records general information about inventory expected from a vendor. "RA" stands for Replenishment Advisement. However, the term "Expected Inventory Record" is used to mean the same thing.
RABACKALLO
Each row contains information about how backorders are allocated against expected inventory.
RADETAIL
This table contains detailed information about items on an expected inventory record.
RCPTAVAIL
Defines which DistributionArrangements have access to received inventory.
RECEIPT
Each row contains information about each receipt of an item at a FulfillmentCenter.
REFKEYS
The table represents a foreign relationship between tables that does not already exist in the database.
REFUNDMTHD
Reserved for IBM internal use.
REPDLVRY
This table represents how each store wants the automated commerce reports to be delivered.
RFQ
This table holds the basic RFQ data.
RFQCATEGRY
This table holds categories created in each RFQ.
RFQPROD
RFQ Request and Product relationship table. This table stores information about the products requested in an RFQ.
RFQRSP
RFQ Response table. This table stores the basic RFQ response information.
RFQRSPEVAL
This table holds all the response product evaluations for the RFQ.
RFQRSPPARL
This table holds the relationship of the personalized attributes in the RFQ and the response.
RFQRSPPROD
RFQ response and product relationship table. This table stores the products included in a specific RFQ Response.
RFQRSPTCRL
The relationship between one specified RFQ term or condition, and an RFQ Response to this term or condition.
RFQTARGET
This table holds the target stores for RFQ.
RICHATTR
This summary table relates Attribute CatalogEntries to AttrValue CatalogEntries. It contains pre-computed results based on the data existing in the underlying ATTRIBUTE and ATTRVALUE tables.
RICHATTRCG
This summary table relates Attribute CatalogEntries to AttrValue CatalogEntries for each CatalogGroup. It contains pre-computed results based on the data existing in the underlying ATTRIBUTE and ATTRVALUE tables.
RLDISCOUNT
Reserved for IBM internal use.
RMA
This table is a container for return merchandise authorizations (RMAs).
RMAAUTHLOG
This table is a log of when each return merchandise authorization (RMA) was authorized. A single RMA may appear multiple times if changes were made and the RMA was re-authorized.
RMACHARGE
This table stores charges or credits, applied to a return merchandise authorization (RMA), which are not for sellable products or services. This can be applicable to the entire RMA or to a specific RMA item, such as restocking fees or shipping credits.
RMAIADJCRD
This table stores return merchandise authorization (RMA) item adjustment credits. These are the portion of an order item adjustment that is to be refunded to the buyer.
RMAIDNYRSN
A joint table which specifies reasons for denying a return merchandise authorization (RMA) item.
RMAITEM
This table stores item information for a return or credit for a return merchandise authorization (RMA).
RMAITEMCMP
This table describes the smallest unit of inventory items involved in a return merchandise authorization (RMA).
RMATAX
This table stores return merchandise authorization (RMA) tax credits.
ROLE
This table stores the roles defined in WebSphere Commerce. Once a role is created, you cannot change the name or description of a role using a graphical user interface tool.
ROLEDESC
This table stores locale specific information for the ROLE table.
RTNDNYDESC
This table stores the language-dependent descriptions of the reasons for denying return merchandise authorizations (RMAs).
RTNDNYRSN
This table stores denial reasons for return merchandise authorization (RMA) items. These are the reasons for which an RMA item was not automatically approved by the system.
RTNDSPCODE
This table stores return disposition codes to describe how a received item is disposed.
RTNDSPDESC
This table stores the language-dependent description of a return disposition code.
RTNRCPTDSP
This table describes how a returned item has been disposed.
RTNREASON
This table stores the reason for customer dissatisfaction with a product.
RTNRECEIPT
This table stores the receipt record that indicates that a returned item, from a return merchandise authorization (RMAA), has been received and specifies information about the received items.
RTNRSNDESC
This table stores the language-dependent description of the return reason codes.
SCHACTIVE
The list containing what job will need to be run and the time when the job should execute.
SCHCMD
The URL commands that can be used as a scheduled job by a store. This is for the scheduler menu in the Administration Console.
SCHERRORLOG
This table contains the exception information when a job fails to execute successfully.
SEGMENTATION
This table holds each segmentation run's output. A segmentation is made up of several segments (clusters) defined by attributes (data columns) which are then grouped into several value bins.
SEGMENTATION_REF
Reference table for language-specific translation of each model (SEGMENTATION row) used in the datamining segmentation run.
SHPARJURGP
Each row of this table indicates that a ShippingArrangement applies to all OrderItems whose shipping addresses match a ShippingJurisdictionGroup. Refer to SHPARRANGE.FLAGS.
SHPMODCLCD
Reserved for IBM internal use.
SMTPHOST
This table maintains a list of SMTP servers where WebSphere Commerce has successfully connected to in the past. Any entries in this table should represent a valid SMTP server name and port pair.
STCGRYDESC
This table contains language-dependent information about a StoreCategory.
STDPRICE
This summary table defines standard (offer) price for each CatalogEntry. It contains pre-computed results based on the data existing in the underlying OFFER, OFFERPRICE and TRADEPOSCN tables
STGUINDTAB
This is the configuration table to check for a unique index conflict.
STORECNTR
Each row of this table indicates that a Contract is deployed in a Store.
STOREITEM
Each row of this table contains attributes that affect how a particular Store allocates inventory for the specified items of a particular BaseItem. If there is no row for the Store, then the row for its StoreGroup is used.
STOREREL
This table contains the relationships between stores.
STORITMFFC
Each row of this table contains information about a BaseItem for a particular Store (or all the Stores in a StoreGroup) and FulfillmentCenter.
STRELTYP
This table contains the store relationship types.
STRELTYPDS
This table contains the store relationship type descriptions.
TCATTR
This table stores information about the terms and conditions attributes specified within a contract. This table stores the XML data required by a term and condition.
TCDESC
This table stores descriptions for terms and conditions for a contract.
TCPITMAP
This table stores all the items from the shopping cart that are applicable to the current coupon for the Coupon Decision Support system.
TCSUBTYPDS
Each row in this table contains a description for a sub-type of terms and conditions.
TCSUBTYPE
Each row in this table contains information about the implementation of a terms and conditions sub-type.
TCTYPE
This table contains the types of terms and conditions.
TERMCOND
This table contains terms and conditions used in trading agreements (business accounts, contracts, RFQs). To see how columns are used by different terms and conditions, refer to TERMCOND column mapping in the online help.
TFALGOPOL
Reserved for IBM internal use.
TFALGOREG
Reserved for IBM internal use.
TFALGOTYPE
Reserved for IBM internal use.
TFALGPOLDS
Reserved for IBM internal use.
TFALGTYPDS
Reserved for IBM internal use.
TFALREGDSC
Reserved for IBM internal use.
TFDOMAIN
Reserved for IBM internal use.
TFDOMDSC
Reserved for IBM internal use.
TFEXTENG
Reserved for IBM internal use.
TFSBDOMAIN
Reserved for IBM internal use.
TFSBDOMDSC
Reserved for IBM internal use.
TFTRADENG
Reserved for IBM internal use.
TFTRENGDSC
Reserved for IBM internal use.
TMPBOLIST
Reserved for IBM internal use.
TMPCMPLIST
Reserved for IBM internal use.
TMPFFCLIST
Reserved for IBM internal use.
TMPPROCID
Reserved for IBM internal use.
TMPRADTL
Reserved for IBM internal use.
TMPRCTLIST
Reserved for IBM internal use.
TORCPMAP
This table stores information about the coupons that are applicable on the current shopping cart while the decision support system is running.
TRADING
Each row in this table represents a TradingAgreement.
TRDATTACH
This table stores information about the trading to attachment relationship for a TradingAgreement.
TRDDEPAMT
This table is used to keep track of deposited amounts by TradingAgreements, by Orders or OrderItems.
TRDDESC
The trading agreement description table.
TRDPSCNXML
This table is used to store the XML document for a given trading position container.
TRDPURAMT
This table is used to keep track of Purchase Amounts by Trading Agreements, by Orders or OrderItems. Entries are created only for Trading Agreement with Right-to-Buy by Amount or Obligation-to-Buy by Amount Terms and Conditions.
TRDREFAMT
This table is used to keep track of Refund Amounts by Trading Agreements, by Orders and by RMA ID. Entries are created only for Trading Agreement with Right-to-Buy by Amount or Obligation-to-Buy by Amount Terms and Conditions.
TRDTYPE
This table stores information about the type of trading for a TradingAgreement.
TRDTYPEDSC
This table stores a description for TradingAgreement types in multiple languages.
VENDOR
Each row defines a Vendor who has a relationship with a Store, or all the Stores in a StoreGroup, generally to provide inventory.
VENDORDESC
Language-specific information about Vendors.
VERSIONSPC
Each row defines the relationship between a product version and a specified item.
WCSDICTNRY
Reserved for IBM internal use.
WCSDTNRYDS
This is a description table to the WCSDICTNRY table.

Tables containing new columns

ACACGPDESC
  • ACACTGRP_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
ACACTACTGP
  • ACACTGRP_ID
  • ACACTION_ID
  • FIELD1
ACACTDESC
  • ACACTION_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
ACACTGRP
  • ACACTGRP_ID
  • FIELD1
  • GROUPNAME
  • MEMBER_ID
ACACTION
  • ACACTION_ID
  • ACTION
ACATTR
  • ACATTR_ID
  • ATTRNAME
  • DATATYPE
  • FIELD1
ACATTRDESC
  • ACATTR_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
ACCLOGMAIN
  • ACCLOGMAIN_ID
  • HOSTNAME
  • STOREENT_ID
  • THREADID
  • USERS_ID
ACCLOGSUB
  • ACCLOGMAIN_ID
  • ACCLOGSUB_ID
  • ACTION
  • LOGTIME
  • RESOURCES
  • RESULT
  • USERS_ID
ACCOUNT
  • ACCOUNT_ID
  • COMMENTS
  • CURRENCY
  • DEFAULTCONTRACT
  • MARKFORDELETE
  • MEMBER_ID
  • NAME
  • STATE
  • STORE_ID
  • TIMEACTIVATED
  • TIMEAPPROVED
  • TIMECREATED
  • TIMEUPDATED
ACORGPOL
  • ACPOLICY_ID
  • MEMBER_ID
ACPLGPDESC
  • ACPOLGRP_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
ACPLGPSUBS
  • ACPOLGRP_ID
  • ORGENTITY_ID
ACPOLDESC
  • ACPOLICY_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
ACPOLGPPOL
  • ACPOLGRP_ID
  • ACPOLICY_ID
ACPOLGRP
  • ACPOLGRP_ID
  • MEMBER_ID
  • NAME
ACPOLICY
  • ACACTGRP_ID
  • ACPOLICY_ID
  • ACRELATION_ID
  • ACRELGRP_ID
  • ACRESGRP_ID
  • FIELD1
  • MBRGRP_ID
  • MEMBER_ID
  • POLICYNAME
  • POLICYTYPE
ACPOLSUBGP
  • CHILD_ID
  • PARENT_ID
ACRELATION
  • ACRELATION_ID
  • RELATIONNAME
ACRELDESC
  • ACRELATION_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
ACRELGRP
  • ACRELGRP_ID
  • CONDITIONS
  • DESCRIPTION
  • FIELD1
  • GRPNAME
  • MEMBER_ID
ACRESACT
  • ACACTION_ID
  • ACRESCGRY_ID
ACRESATREL
  • ACATTR_ID
  • ACRESCGRY_ID
  • ATTRCOLNAME
  • ATTRTBLNAME
  • FIELD1
  • RESKEYCOLNAME
ACRESCGRY
  • ACRESCGRY_ID
  • FIELD1
  • RESCLASSNAME
  • RESJOINKEY
  • RESKEYOWNCOL
  • RESOWNERCOL
  • RESOWNERTABLE
  • RESPRIMARYTABLE
ACRESGPDES
  • ACRESGRP_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
ACRESGPRES
  • ACRESCGRY_ID
  • ACRESGRP_ID
  • FIELD1
ACRESGRP
  • ACRESGRP_ID
  • CONDITIONS
  • DESCRIPTION
  • FIELD1
  • FIELD2
  • GRPNAME
  • MEMBER_ID
ACRESMEMRL
  • ACRELATION_ID
  • ACRESCGRY_ID
  • ACRESMEMRL_ID
  • MEMBER_ID
  • RESOURCEID
ACRESPRIM
  • ACRESCGRY_ID
  • FIELD1
  • RESPRIMARYCOL
ACRESREL
  • ACRELATION_ID
  • ACRESCGRY_ID
  • FIELD1
  • RESJOINCOL
  • RESOURCETYPE
  • RESRELCOL
  • RESRELKEYCOL
  • RESRELMEMCOL
  • RESRELTABLE
ACRLGPDESC
  • ACRELGRP_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
ACRSCGDES
  • ACRESCGRY_ID
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
APPLY_INIT
  • CONFIDENCE
  • INITIATIVE_ID
  • LAST_UPDATED
  • LAST_UPDATED_ID
  • SCORE
  • SCORE2
  • SEGMENTATION_ID
  • SEGMENT_INDEX
  • SEGMENT_INDEX2
APPLY_MEMBER
  • CONFIDENCE
  • LAST_UPDATED
  • LAST_UPDATED_ID
  • MEMBER_ID
  • SCORE
  • SCORE2
  • SEGMENTATION_ID
  • SEGMENT_INDEX
  • SEGMENT_INDEX2
  • SUB_ID
  • TYPE_ID
APPLY_RESULT
  • CONFIDENCE
  • LAST_UPDATED
  • LAST_UPDATED_ID
  • RESULT_ID
  • SCORE
  • SCORE2
  • SEGMENTATION_ID
  • SEGMENT_INDEX
  • SEGMENT_INDEX2
  • TYPE_ID
APRVSTATUS
  • ACTIONTIME
  • APPROVER_ID
  • APRVSTATUS_ID
  • COMMENTS
  • ENTITY_ID
  • FLOWTYPE_ID
  • FLOW_ID
  • FLSTATEDCT_ID
  • MBRGRP_ID
  • STATUS
  • SUBMITTER_ID
  • SUBMITTIME
ATTACHMENT
  • ATTACHMENTURL
  • ATTACHMENT_ID
  • ATTACHUSG_ID
  • CONTENT
  • CREATEMETHOD
  • DESCRIPTION
  • FILENAME
  • FILESIZE
  • IMAGE1
  • IMAGE2
  • MARKFORDELETE
  • MEMBER_ID
  • MIMETYPE
  • MIMETYPEENCODING
  • RESERVED
  • TIMECREATED
  • TIMEUPDATED
ATTACHUSG
  • ATTACHUSG_ID
ATTRIBUTE
  • GROUPNAME
  • MULTITYPE
  • NOTEINFO
  • QTYUNIT_ID
  • USAGE
ATTRVALUE
  • ATTACHMENT_ID
  • OPERATOR_ID
  • QTYUNIT_ID
AUCPAYINFO
  • AUCPAYINFO_ID
  • BANKINFO
  • BILLADDR
  • CAUSE
  • CAUSEID
  • COMMENTS
  • CREATETIME
  • DESCR
  • DEVICE
  • ENCRYPT
  • EXPDATE
  • FIELD1
  • FIELD2
  • MEMBER_ID
  • NAME
  • PAYMETHOD
  • STATUS
AUCTION
  • AUCMODE
  • AUCPAYINFO_ID
  • DURLENGTH
  • INVRSRVID
  • PRICELIMIT
  • QUANTLIMIT
AUCTIONLOG
  • AUCMODE
  • AUCPAYINFO_ID
  • DURLENGTH
  • INVRSRVID
  • PRICELIMIT
  • QUANTLIMIT
AUCTVIEW
  • AUCMODE
  • AUCPAYINFO_ID
  • DURLENGTH
  • INVRSRVID
  • PRICELIMIT
  • QUANTLIMIT
AUTOBID
  • AUCPAYINFO_ID
AUTOBIDLOG
  • AUCPAYINFO_ID
BASEITEM
  • BASEITEM_ID
  • ITEMTYPE_ID
  • LASTUPDATE
  • MARKFORDELETE
  • MEMBER_ID
  • PARTNUMBER
  • QUANTITYMEASURE
  • QUANTITYMULTIPLE
BASEITMDSC
  • BASEITEM_ID
  • LANGUAGE_ID
  • LASTUPDATE
  • LONGDESCRIPTION
  • SHORTDESCRIPTION
BID
  • AUCPAYINFO_ID
  • BIDMODE
  • INITPRICE
  • LIMITPRICE
BIDLOG
  • AUCPAYINFO_ID
  • BIDMODE
  • INITPRICE
  • LIMITPRICE
BIDPAYMENT
  • AUCPAYINFO_ID
BKORDALLOC
  • BKORDNUM
  • ITEMSPC_ID
  • LASTUPDATE
  • ORDERITEMS_ID
  • QTYALLOCATED
  • QTYAVAILABLE
  • QTYNEEDED
BKORDITEM
  • DATEEXPECTED
  • LASTUPDATE
  • ORDERITEMS_ID
BUSPROF
  • REQUISITIONERID
BUYERPO
  • ACCOUNT_ID
  • AMOUNT
  • BUYERPOTYP_ID
  • BUYERPO_ID
  • PONUMBER
  • SETCCURR
  • STATE
BUYERPOTYP
  • BUYERPOTYP_ID
BUYSUPMAP
  • BUYORGUNIT_ID
  • CATALOG_ID
  • CONTRACT_ID
  • FIELD1
  • FIELD2
  • FIELD3
  • MBRGRP_ID
  • PROCPROTCL_ID
  • SUPORG_ID
BUYSUPSEC
  • AUTHLEVEL
  • BUYERLOGONID
  • BUYERLOGONPASSWORD
  • BUYORG_ID
  • EXPIRYDATE
  • FIELD1
  • FIELD2
  • FIELD3
  • STATUS
  • SUPLOGONID
  • SUPLOGONIDTYPE
  • SUPLOGONPASSWORD
  • SUPORG_ID
BZSRVCFG
  • BZSRVCFG_ID
  • ENABLED
  • SERVERNAME
BZSVCCFG
  • AGENTS
  • BZSRVCFG_ID
  • BZSVCCFG_ID
  • ENABLED
  • LASTUPDATE
  • PROJECTPATH
  • SERVICENAME
  • SESSIONTIMEOUT
  • STOREENT_ID
BZSVCSTA
  • BZSVCCFG_ID
  • CLONE_ID
  • STATUSCODE
CACHEIVL
  • DATAID
  • INSERTTIME
  • TEMPLATE
CALCODE
  • DESCRIPTION
  • DISPLAYLEVEL
  • ENDDATE
  • FLAGS
  • PRECEDENCE
  • STARTDATE
CALCODEMGP
  • CALCODE_ID
  • MBRGRP_ID
CALRANGE
  • MARKFORDELETE
CAMPAIGN
  • STATUS
  • TYPE
CATALOG
  • TPCLEVEL
CATCLSFCOD
  • CATENTRY_ID
  • CODE
  • DOMAIN
CATCONFINF
  • CATENTRY_ID
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
  • FIELD5
  • REFERENCE
  • URL
CATENTDESC
  • KEYWORD
CATENTRY
  • BASEITEM_ID
  • ENDDATE
  • ITEMSPC_ID
  • STARTDATE
  • STATE
CATGPENREL
  • LASTUPDATE
CATGRPATTR
  • SEQUENCE
CATGRPDESC
  • KEYWORD
  • NOTE
CATGRPPS
  • CATALOG_ID
  • CATGROUP_ID
  • PRODUCTSET_ID
  • USAGE
CATGRPREL
  • CATALOG_ID_LINK
  • LASTUPDATE
CATGRPTPC
  • CATALOG_ID
  • CATGROUP_ID
  • STORE_ID
  • TRADEPOSCN_ID
CATPRDREL
  • CATALOG_ID
  • CATENTRY_ID
  • CATGROUP_ID
  • IDENTIFIER
  • LASTUPDATE
  • MEMBER_ID
  • PARTNUMBER
  • RULE
  • SEQUENCE
CATTOGRP
  • LASTUPDATE
  • SEQUENCE
CHARGETYPE
  • CHARGETYPE_ID
  • CODE
  • DISPLAYAGGREGATED
  • MARKFORDELETE
  • STOREENT_ID
CHKARRANG
  • CHKCMD_ID
  • SCHCMD_ID
CHKCMD
  • CHKCMD_ID
  • DISPLAYNAME
  • INTERFACENAME
  • STOREENT_ID
CHRGTYPDSC
  • CHARGETYPE_ID
  • DESCRIPTION
  • LANGUAGE_ID
CLASIFCODE
  • CLASIFCODE_ID
  • CODE
  • DOMAIN
  • PARENTCODE
CLEANCONF
  • OBJECTNAME
  • SEQUENCE
  • STATEMENT
  • STATEMENTTYPE
CLSFCODEDS
  • CLASIFCODE_ID
  • DESCRIPTION
  • LANGUAGE_ID
CNTRDISPLY
  • CNTRDISPLY_ID
  • CONTRACT_ID
  • DEVICEFMT_ID
  • DISPLAYPAGENAME
  • PARTROLE_ID
CNTRNAME
  • MEMBER_ID
  • NAME
  • ORIGIN
CNTRSTORE
  • CONTRACT_ID
  • STOREXML
COLLABWS
  • ACCOUNT_ID
  • COLLABWS_ID
  • CREATORLOGONID
  • DESCRIPTION
  • NAME
  • PROCID
  • PROCTYPE
  • TEMPLATE
  • TIMECREATED
CONTRACT
  • COMMENTS
  • MAJORVERSION
  • MARKFORDELETE
  • MINORVERSION
  • ORIGIN
  • TIMEACTIVATED
  • TIMEAPPROVED
  • TIMECREATED
  • TIMEDEPLOYED
  • TIMEUPDATED
  • USAGE
CPEMAILMAP
  • CPWALLET_ID
  • SHOPPEREMAILID
CPITMAP
  • CPWALLET_ID
  • DISCAMT
  • ORDERITEMS_ID
CPOFFER
  • CPPMN_ID
  • FIELD1
  • FIRSTTIMESEEN
  • STATE
  • USERS_ID
CPPMN
  • CPPMNDESC
  • CPPMNNAME
  • CPPMNVAL_ID
  • CPPMN_ID
  • CREATIONTIME
  • EARLYBIRDLIMIT
  • ENDDATE
  • FIELD1
  • INITIATIVE_ID
  • NUMACPALLOWED
  • NUMOFFERED
  • NUMSEENALLOWED
  • NUMUSEALLOWED
  • PROMODISPTYPE
  • PURCHASECONDTYPE
  • SETCCURR
  • STARTDATE
  • STATUS
  • STOREENT_ID
  • TOTALNUMOFFER
CPPMNACC
  • CPPMN_ID
  • NUMACCEPTED
  • NUMREDEEMED
  • SHOPPEREMAILID
CPPMNCAT
  • CATALOG_ID
  • CATGROUP_ID
  • CPPMN_ID
  • MAXQTY
  • MAXVALUE
  • MINQTY
  • MINVALUE
  • QTYMEASURE
CPPMNDESC
  • CPPMN_ID
  • FULLIMAGEPATH
  • LANGUAGE_ID
  • LONGDESC
  • SHORTDESC
  • THUMBNAILPATH
CPPMNDISC
  • CALCODE_ID
  • CPPMNDISC_ID
  • CPPMN_ID
CPPMNORD
  • CPPMN_ID
  • ORDERMAX
  • ORDERMIN
CPPMNPROD
  • CATENTRY_ID
  • CPPMN_ID
  • QTYMEASURE
  • QUANTITY
CPPMNVAL
  • CPPMNVAL_ID
  • DAY
  • ENDTIME
  • FIELD1
  • MONTH
  • STARTTIME
  • VALIDITYTYPE
  • WEEK
CPWALLET
  • ACCEPTFROMTYPE
  • CPPMN_ID
  • CPWALLET_ID
  • FIELD1
  • NUMUSE
  • STATE
  • TIMEACCEPT
  • USERS_ID
CREDITLINE
  • ACCOUNT_ID
  • CREDITLIMIT
  • CREDITLINE_ID
  • DECIMALFIELD1
  • DECIMALFIELD2
  • SETCCURR
  • STATE
  • TIMECREATED
  • TIMEUPDATED
CURFMTDESC
  • NUMBRUSG_ID
CURFORMAT
  • MINAPPROVEAMOUNT
  • NUMBRUSG_ID
CWMEMBER
  • COLLABWS_ID
  • LOGONID
  • ROLE
DISPCGPREL
  • LANGUAGE_ID
DISPENTREL
  • LANGUAGE_ID
DISTARRANG
  • BASEITEM_ID
  • DISTARRANG_ID
  • ENDDATE
  • FIELD1
  • FIELD2
  • FIELD3
  • LASTUPDATE
  • MERCHANTSTORE_ID
  • PICKINGMETHOD
  • STARTDATE
  • WHOLESALESTORE_ID
EMLCFG
  • ACCOUNT
  • ADDRESS
  • DESCRIPTION
  • EMLCFG_ID
  • EMLSERVER
  • HOST
  • NAME
  • PASSWORD
  • PORT
  • STOREENT_ID
  • TIME
  • TYPE
EMLGRPREL
  • EMLPROMO_ID
  • MBRGRP_ID
EMLMSG
  • DESCRIPTION
  • EMLMSG_ID
  • JSPPATH
  • NAME
  • PROPERTYFILE
  • STOREENT_ID
EMLPROMO
  • DESCRIPTION
  • EMLMSG_ID
  • EMLPROMO_ID
  • MODDATE
  • MODIFIEDBY
  • NAME
  • SCCJOBREFNUM
  • STATUS
  • STOREENT_ID
EMLRCPTS
  • COUNT
  • EMLPROMO_ID
  • RECIPIENTS
EMLRPTEVTS
  • BOUNCED
  • CLICKED
  • EMLPROMO_ID
  • OPENED
  • USERS_ID
EMLUSRRECV
  • RECEIVEEML
  • STOREENT_ID
  • USERS_ID
EMSPOT
  • DEFAULTRULE
  • DESCRIPTION
  • EMSPOT_ID
  • LASTUPDATE
  • LASTUPDATEDBY
  • NAME
  • STOREENT_ID
  • SUPPORTEDTYPES
FFMCENTER
  • DEFAULTSHIPOFFSET
  • EXTFFMSTORENUM
  • INVENTORYOPFLAGS
  • MARKFORDELETE
FILEUPLOAD
  • FILEENCODING
  • FILENAME
  • FILEPATH
  • FILESIZE
  • FILETYPE
  • FILEUPLOAD_ID
  • HOSTNAME
  • MEMBER_ID
  • SCCJOBREFNUM
  • STATUS
  • STORE_ID
  • UPLOADTIME
  • VERSION
FLCOMPOSE
  • COMPOSITEFLOW_ID
  • SEQUENCE
  • SINGLEFLOW_ID
FLDOMNDESC
  • DESCRIPTION
  • FLOWDOMAIN_ID
  • LANGUAGE_ID
  • LONGDESCRIPTION
FLINSTANCE
  • CURRSTAGEINDEX
  • CURSTATEIDENTIFIER
  • ENTITY_ID
  • FLOWCONTEXT
  • FLOWSTAGES
  • FLOWTYPE_ID
  • FLOW_ID
  • LASTUPDATETIME
FLOW
  • ATTRIBUTE
  • COMPOSITEFLOW
  • FLOWTYPE_ID
  • FLOW_ID
  • IDENTIFIER
  • PRIORITY
FLOWADMIN
  • FLOWADMIN_ID
  • FLOW_ID
  • ORGENTITY_ID
  • STOREENT_ID
FLOWDESC
  • DESCRIPTION
  • FLOW_ID
  • LANGUAGE_ID
  • LONGDESCRIPTION
FLOWDOMAIN
  • FLOWDOMAIN_ID
  • IDENTIFIER
  • PRIORITY
FLOWTYPE
  • ATTRIBUTE
  • BIZFLOWBEANCLASS
  • FLOWDOMAIN_ID
  • FLOWTYPE_ID
  • IDENTIFIER
  • PRIORITY
  • VIEWNAME
FLSTATEDCT
  • APPROVERMBRGRPNAME
  • FLOWTYPE_ID
  • FLSTATEDCT_ID
  • FLSTATEGP_ID
  • IDENTIFIER
  • STATENAME
  • STATETYPE
FLSTATEGP
  • FLOWTYPE_ID
  • FLSTATEGP_ID
  • IDENTIFIER
  • MANDATORYSTATEGP
FLSTATEREL
  • ENTRYACTNINTERFACE
  • EXITACTNINTERFACE
  • FLOW_ID
  • FLSTATEDCT_ID
  • RESPONSEVIEWNAME
FLSTDCTDSC
  • DESCRIPTION
  • FLSTATEDCT_ID
  • LANGUAGE_ID
FLSTGPDSC
  • DESCRIPTION
  • FLSTATEGP_ID
  • LANGUAGE_ID
FLTRANSDSC
  • EVENTDESC
  • FLTRANSITN_ID
  • LANGUAGE_ID
  • TRANSITIONDESC
FLTRANSITN
  • ACCESSCTRLGUARD
  • ACTIONINTERFACE
  • APPROVAL
  • BUSINESSLOGICGUARD
  • EVENTIDENTIFIER
  • FLOW_ID
  • FLTRANSITN_ID
  • PRIORITY
  • RESPONSEVIEWNAME
  • SOURCESTATE_ID
  • SPAWNFLWTYPE_ID
  • SPAWNTYPE
  • TARGETSTATE_ID
FLTYPEDESC
  • DESCRIPTION
  • FLOWTYPE_ID
  • LANGUAGE_ID
  • LONGDESCRIPTION
HISTOATTR
  • ATTRIBUTEID
  • BUCKETCOUNT
  • HISTOID
  • HISTOTYPE
  • MAXVALUE
  • MINVALUE
  • RANGEARR
HISTOFREQ
  • FREQ
  • HISTOID
  • HISTOTYPE
  • SEQNUM
HISTONVP
  • FIELDNAME
  • FIELDVALUE
  • HISTOID
  • HISTOTYPE
INITIATIVE
  • CAMPAIGN_ID
  • RESULTTYPE
  • RULE
  • SELLTYPE
  • STATUS
  • TYPE
INTVSCHED
  • EMSPOT_ID
  • ENDDATE
  • INITIATIVE_ID
  • INTVSCHED_ID
  • PRIORITY
  • STARTDATE
  • STOREENT_ID
INVADJCODE
  • ADJUSTCODE
  • INVADJCODE_ID
  • LASTUPDATE
  • MARKFORDELETE
  • STOREENT_ID
INVADJDESC
  • DESCRIPTION
  • INVADJCODE_ID
  • LANGUAGE_ID
  • LASTUPDATE
INVADJUST
  • ADJUSTMENTCOMMENT
  • ADJUSTMENTDATE
  • INVADJCODE_ID
  • INVADJUSTNUM
  • INVADJUST_ID
  • LASTUPDATE
  • QUANTITY
  • RECEIPT_ID
INVOICE
  • INVOICEXML
  • INVOICE_ID
  • ORDERS_ID
  • ORDRELEASENUM
  • STATUS
  • TIMECREATED
INVRESERVE
  • DESCRIPTION
  • EXPIRATION
  • FFMCENTER_ID
  • INVRESERVE_ID
  • INVRSRVTYP_ID
  • ITEMSPC_ID
  • LASTUPDATE
  • QUANTITY
  • STORE_ID
INVRSRVDSC
  • DESCRIPTION
  • INVRSRVTYP_ID
  • LANGUAGE_ID
  • NAME
INVRSRVTYP
  • INVRSRVTYP_ID
ITEMFFMCTR
  • FFMCENTER_ID
  • ITEMSPC_ID
  • LASTUPDATE
  • QTYALLOCBACKORDER
  • QTYBACKORDERED
  • QTYRESERVED
  • RESTOCKTIME
  • STORE_ID
ITEMSPC
  • BASEITEM_ID
  • DISCONTINUED
  • ITEMSPC_ID
  • LASTUPDATE
  • MARKFORDELETE
  • MEMBER_ID
  • PARTNUMBER
ITEMTYPE
  • DESCRIPTION
  • ITEMTYPE_ID
  • OID
ITEMVERSN
  • BASEITEM_ID
  • EXPIRATIONDATE
  • ITEMVERSN_ID
  • LASTUPDATE
  • VERSIONNAME
JURST
  • MARKFORDELETE
JURSTGROUP
  • MARKFORDELETE
LANGUAGE
  • MIMECHARSET
LMEVENTMAP
  • EXTEVENTDESC
  • EXTEVENTNAME
  • LMEVENTMAP_ID
  • LMSETNAME
  • LMTXTYPEID
  • STOREENT_ID
LMSERVER
  • HOSTNAME
  • LMENGINENAME
  • LMENGINETYPE
  • LMSERVER_ID
  • LMSETNAME
  • PORT
  • STOREENT_ID
LPOPURAMT
  • AMOUNT
  • BUYERPO_ID
  • ORDERS_ID
  • SETCCURR
MANIFEST
  • DATESHIPPED
  • FIELD1
  • LASTUPDATE
  • MANIFESTSTATUS
  • MANIFEST_ID
  • ORDERS_ID
  • ORDRELEASENUM
  • PACKAGEID
  • PICKUPRECORDID
  • SETCCURR
  • SHIPMODE_ID
  • SHIPPINGCOSTS
  • TRACKINGID
  • WEIGHT
  • WEIGHTMEASURE
MASSOCCECE
  • DATE1
  • STORE_ID
MASSOCGPGP
  • DATE1
  • STORE_ID
MBRATTR
  • ATTRTYPE_ID
  • DESCRIPTION
  • MBRATTR_ID
  • NAME
MBRATTRVAL
  • ATTRTYPE_ID
  • DATETIMEVALUE
  • FLOATVALUE
  • INTEGERVALUE
  • MBRATTRVAL_ID
  • MBRATTR_ID
  • MEMBER_ID
  • STOREENT_ID
  • STRINGVALUE
MBRGRP
  • LASTUPDATE
  • LASTUPDATEDBY
MBRGRPCOND
  • CONDITIONS
  • FIELD1
  • FIELD2
  • MBRGRP_ID
MBRGRPDESC
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
  • MBRGRP_ID
MBRGRPMBR
  • EXCLUDE
MBRGRPTYPE
  • PROPERTIES
MBRREL
  • ANCESTOR_ID
  • DESCENDANT_ID
  • SEQUENCE
MBRROLE
  • MEMBER_ID
  • ORGENTITY_ID
  • ROLE_ID
MEMBER
  • STATE
MLTIME
  • INSTANCEID
  • MLTIMESTAMP
MSGARCHIVE
  • MESSAGE
  • MESSAGEINDEX
  • MSGARCHIVE_ID
  • STOREENT_ID
  • TRANSPORT_ID
MSGSTORE
  • EXPIRY
  • STOREENT_ID
  • TRANSPORT_ID
NOTIFY
  • MSGTYPE_ID
  • NOTIFICATIONID
  • NOTIFY_ID
  • TRANSPORTATTNAME
  • TRANSPORTATTVALUE
  • TRANSPORT_ID
NUMBRUSG
  • CODE
  • NUMBRUSG_ID
NUMBRUSGDS
  • DESCRIPTION
  • LANGUAGE_ID
  • NUMBRUSG_ID
OICOMPLIST
  • CATALOGQUANTITY
  • CATENTRY_ID
  • CONFIGURATIONID
  • CURRENCY
  • INVENTORYQUANTITY
  • ITEMSPC_ID
  • OICOMPLIST_ID
  • ORDERITEMS_ID
  • REQUIRED
  • SUPPLIERDATA
  • SUPPLIERPARTNUMBER
  • UNITPRICE
OPERATOR
  • OPERATOR
  • OPERATORTYPE
  • OPERATOR_ID
OPERATRDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • OPERATOR_ID
ORCPMAP
  • CPWALLET_ID
  • ORDERS_ID
ORDADJUST
  • DISPLAYLEVEL
ORDCALCD
  • CALCODE_ID
  • CALFLAGS
  • CALPARMAMT
  • CALPARMTYPE
  • ORDCALCD_ID
  • ORDERS_ID
ORDCHNLTYP
  • LASTUPDATE
  • NAME
  • ORDCHNLTYP_ID
  • PAYMENTTRANSTYPE
ORDERITEMS
  • ALLOCADDRESS_ID
  • ALLOCATIONGROUP
  • ALLOCFFMC_ID
  • ALLOCQUANTITY
  • AVAILQUANTITY
  • CONFIGURATIONID
  • CORRELATIONGROUP
  • ESTAVAILTIME
  • FULFILLMENTSTATUS
  • INVENTORYSTATUS
  • ITEMSPC_ID
  • LASTALLOCUPDATE
  • LINEITEMTYPE
  • NEEDEDQUANTITY
  • ORDRELEASENUM
  • OUTPUTQ_ID
  • PROMISEDAVAILTIME
  • SHIPPINGOFFSET
  • SUPPLIERDATA
  • SUPPLIERPARTNUMBER
  • TERMCOND_ID
  • TIMERELEASED
  • TIMESHIPPED
  • TRADING_ID
ORDERMGP
  • MBRGRP_ID
  • ORDERS_ID
ORDERS
  • COMMENTS
  • NOTIFICATIONID
  • ORDCHNLTYP_ID
  • ORGENTITY_ID
  • PROVIDERORDERNUM
  • SHIPASCOMPLETE
ORDICALCD
  • CALFLAGS
  • CALPARMAMT
  • CALPARMTYPE
  • ORDICALCD_ID
ORDIMEEXTN
  • COMMENTS1
  • COMMENTS2
  • FIELD1
  • FIELD2
  • FIELD3
  • ORDERITEMS_ID
  • REQUESTEDSHIPTIME
  • SHIPASCOMPLETE
ORDIOFFER
  • OFFER_ID
  • ORDERITEMS_ID
ORDIPROF
  • ORDERITEMS_ID
  • PROFILENAME
ORDISTAT
  • ORDSTAT_ID
  • SUPPLIERDATA
ORDITRD
  • ORDERITEMS_ID
  • TRADING_ID
ORDMEEXTN
  • BUYERORDERID
  • COMMENTS1
  • COMMENTS2
  • FIELD1
  • FIELD2
  • FIELD3
  • ORDERS_ID
  • ORDERTYPE
  • PAYLOADID
  • REQUESTEDSHIPTIME
  • REQUESTEDTIME
ORDPAYMTHD
  • ACCOUNT_ID
  • ACTUALAMOUNT
  • BIGINTFIELD1
  • BIGINTFIELD2
  • BIGINTFIELD3
  • BUYERPO_ID
  • CHARGEAMOUNT
  • CHARGEAMTCURR
  • CHARGETIME
  • CREDITLINE_ID
  • DECIMALFIELD1
  • DECIMALFIELD2
  • DECIMALFIELD3
  • PAYSUMMARY_ID
  • POLICY_ID
  • REFUNDNUMBER
  • RMA_ID
  • STATUS
  • STRINGFIELD1
  • STRINGFIELD2
  • STRINGFIELD3
  • STRINGFIELD4
  • TRADING_ID
  • XMLDATA
ORDPICKHST
  • DATEPICKED
  • LASTUPDATE
  • ORDERITEMS_ID
  • ORDERPICKINGTYPE
  • ORDPICKHSTNUM
  • QTYPICKED
  • RECEIPT_ID
  • VERSIONSPC_ID
ORDQUOTREL
  • CHILDSTORE_ID
  • CHILD_ID
  • DISPLAYSEQUENCE
  • FLAGS
  • ORDQUOTREL_ID
  • PARENT_ID
  • RELTYPE
  • TIMEOUTTIME
  • TRADING_ID
ORDRELEASE
  • CAPTUREDATE
  • CUSTOMERCONFIRM
  • EXTORDNUM
  • EXTREF
  • FFMACKNOWLEDGEMENT
  • FIELD1
  • FIELD2
  • FIELD3
  • LASTUPDATE
  • ORDERS_ID
  • ORDRELEASENUM
  • PACKSLIPXML
  • PICKBATCH_ID
  • STATUS
  • TIMEPLACED
ORDSHIPHST
  • DATESHIPPED
  • LASTUPDATE
  • ORDERITEMS_ID
  • ORDSHIPHSTNUM
  • QTYRETURNED
  • QTYSHIPPED
  • RECEIPT_ID
  • VERSIONSPC_ID
ORDSTAT
  • OSCODE
ORDTAX
  • LASTUPDATE
ORGCODE
  • CODE
  • CODETYPE
  • ORGCODE_ID
  • ORGENTITY_ID
ORGENTITY
  • STATUS
OUTPUTQ
  • LASTUPDATE
  • NAME
  • OUTPUTQTYPE
  • OUTPUTQ_ID
OUTPUTQDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • LASTUPDATE
  • OUTPUTQ_ID
PARTICIPNT
  • INFORMATION
  • MEMBER_ID
  • PARTICIPNT_ID
  • PARTROLE_ID
  • TERMCOND_ID
  • TIMECREATED
  • TIMEUPDATED
  • TRADING_ID
PARTROLE
  • PARTROLE_ID
PARTROLEDS
  • DESCRIPTION
  • LANGUAGE_ID
  • PARTROLE_ID
PATTRDESC
  • DESCRIPTION
  • LANGUAGE_ID
  • PATTRIBUTE_ID
PATTRIBUTE
  • ACCESSBEANNAME
  • ATTRTYPE_ID
  • ENCRYPTFLAG
  • NAME
  • PATTRIBUTE_ID
  • SEQUENCE
PATTRPROD
  • CATENTRY_ID
  • PATTRIBUTE_ID
PATTRVALUE
  • ATTACHMENT_ID
  • ATTRTYPE_ID
  • BIGINTVALUE
  • CHANGEABLE
  • CORRELATIONGROUP
  • DATEVALUE
  • ENCRYPTFLAG
  • FLOATVALUE
  • INTEGERVALUE
  • MANDATORY
  • OPERATOR_ID
  • ORDERITEMS_ID
  • PATTRIBUTE_ID
  • PATTRVALUE_ID
  • QTYUNIT_ID
  • RFQPROD_ID
  • RFQRSPPROD_ID
  • SEQUENCE
  • STRINGVALUE
  • TERMCOND_ID
PAYSUMMARY
  • ACCOUNT_ID
  • CREDITLINE_ID
  • PAYSUMMARYXML
  • PAYSUMMARY_ID
  • PERIODENDTIME
  • PERIODSTARTTIME
  • POLICY_ID
  • SETCCURR
  • STATUS
  • STOREENT_ID
  • TOTALCHARGE
PICKBATCH
  • DATE1
  • DATE2
  • FFMCENTER_ID
  • FIELD1
  • FIELD2
  • FIELD3
  • LASTUPDATE
  • MEMBER_ID
  • PICKBATCH_ID
  • PICKSLIPXML
PLCYACCDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • PLCYACCT_ID
PLCYACCLCK
  • LOCKOUTTHRESHOLD
  • PLCYACCLCK_ID
  • WAITTIME
PLCYACCT
  • PLCYACCLCK_ID
  • PLCYACCT_ID
  • PLCYPASSWD_ID
PLCYLCKDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • PLCYACCLCK_ID
PLCYPASSWD
  • MATCHUSERID
  • MAXCONSECUTIVETYPE
  • MAXINSTANCES
  • MAXLIFETIME
  • MINALPHABETIC
  • MINNUMERIC
  • MINPASSWDLENGTH
  • PLCYPASSWD_ID
  • REUSEPASSWORD
PLCYPWDDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • PLCYPASSWD_ID
PLCYTYCMIF
  • BUSINESSCMDIF
  • POLICYTYPE_ID
PLCYTYPDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • POLICYTYPE_ID
POLICY
  • ENDTIME
  • POLICYNAME
  • POLICYTYPE_ID
  • POLICY_ID
  • PROPERTIES
  • STARTTIME
  • STOREENT_ID
POLICYCMD
  • BUSINESSCMDCLASS
  • POLICY_ID
  • PROPERTIES
POLICYDESC
  • DESCRIPTION
  • LANGUAGE_ID
  • LONGDESCRIPTION
  • POLICY_ID
  • TIMECREATED
  • TIMEUPDATED
POLICYTC
  • POLICY_ID
  • TERMCOND_ID
POLICYTYPE
  • POLICYTYPE_ID
PRATRSTATR
  • ATTR_ID
  • ATTR_NAME
  • ATTR_PARTNUMBER
  • ATTR_PRODUCT_ID
  • LANG_ID
  • TYPE_ID
PRCEOFFPRD
  • ID
  • PARTNUMBER
PRCOFFRPRC
  • COMPAREPRICE
  • CURRENCY
  • ID
  • PRICE
PRDATRAVAL
  • ATTRIBUTE_ID
  • ATTRTYPE_ID
  • ATTRVALUE_ID
  • CATENTRY_ID
  • FIELD1
  • FIELD2
  • FIELD3
  • FLOATVALUE
  • IMAGE1
  • IMAGE2
  • INTEGERVALUE
  • LANGUAGE_ID
  • NAME
  • OID
  • PARTNUMBER
  • SEQUENCE
  • STRINGVALUE
PROCBUYPRF
  • CONTRACTPARM
  • FIELD1
  • FIELD2
  • FIELD3
  • ORGENTITY_ID
  • ORGUNITPARM
  • PROCPROTCL_ID
  • REQIDPARM
PROCMSGVW
  • ERRORVIEW
  • MSGNAME
  • ORGENTITY_ID
  • PROCPROTCL_ID
  • VIEWNAME
PROCPROTCL
  • AUTHTYPE
  • CLASSIFDOMAIN
  • FIELD1
  • FIELD2
  • FIELD3
  • PROCPROTCLCOMMENT
  • PROCPROTCL_ID
  • PROCSYSNAME
  • PROTOCOLNAME
  • TWOSTEPMODE
  • UOMSTANDARD
  • VERSION
PROCSYS
  • FIELD1
  • FIELD2
  • PROCSYSNAME
PRODATR
  • ATTRIBUTE_ID
  • ATTRTYPE_ID
  • ATTRVALUE_ID
  • ATTR_NAME
  • ATTR_PARTNUMBER
  • ATTR_PRODUCT_ID
  • CATENTRY_ID
  • FIELD1
  • FIELD2
  • FIELD3
  • FLOATVALUE
  • IMAGE1
  • IMAGE2
  • INTEGERVALUE
  • LANGUAGE_ID
  • NAME
  • OID
  • PARTNUMBER
  • SEQUENCE
  • STRINGVALUE
PRODSETDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • PRODUCTSET_ID
PRODUCTSET
  • MARKFORDELETE
  • MEMBER_ID
  • NAME
  • PRODUCTSET_ID
  • PUBLISHTIME
  • STATIC
  • XMLDEFINITION
PROFILE
  • ARCHIVEMSG
PRSETCEREL
  • CATENTRY_ID
  • PRODUCTSET_ID
PSETADJMNT
  • ADJUSTMENT
  • PRECEDENCE
  • PRODUCTSET_ID
  • TERMCOND_ID
  • TYPE
PURCHASELT
  • CATENTRY_ID
  • CURRENCY
  • CURRENTAMOUNT
  • CURRENTQUANTITY
  • LIMITTYPE
  • MAXAMOUNT
  • MAXQUANTITY
  • MINAMOUNT
  • MINQUANTITY
  • PURCHASELT_ID
  • TERMCOND_ID
  • TRADEPOSCN_ID
PVCBINDING
  • PVCBINDING_ID
PVCBUFFER
  • PARAMETERS2K
PVCDEVMDL
  • DEVMDLNAME
QTYFMTDESC
  • NUMBRUSG_ID
QTYFORMAT
  • NUMBRUSG_ID
QTYUNITMAP
  • FIELD1
  • QTYUNIT_ID
  • UOMCODE
  • UOMSTANDARD
QUEUE
  • ALLCSR
  • NAME
  • QUEUE_ID
  • STORE_ID
QUEUECSR
  • CSR_ID
  • QUEUE_ID
QUEUEDESC
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
  • QUEUE_ID
RA
  • CREATETIME
  • DATECLOSED
  • EXTERNALID
  • LASTUPDATE
  • MARKFORDELETE
  • OPENINDICATOR
  • ORDERDATE
  • RA_ID
  • STORE_ID
  • VENDOR_ID
RABACKALLO
  • ITEMSPC_ID
  • LASTUPDATE
  • ORDERITEMS_ID
  • QTYALLOCATED
  • RABACKALLONUM
  • RADETAIL_ID
RADETAIL
  • EXPECTEDDATE
  • FFMCENTER_ID
  • ITEMSPC_ID
  • LASTUPDATE
  • MARKFORDELETE
  • QTYALLOCATED
  • QTYORDERED
  • QTYRECEIVED
  • QTYREMAINING
  • RADETAILCOMMENT
  • RADETAIL_ID
  • RA_ID
RCPTAVAIL
  • DISTARRANG_ID
  • LASTUPDATE
  • PRECEDENCE
  • RCPTAVAIL_ID
  • RECEIPT_ID
RECEIPT
  • COMMENT1
  • COMMENT2
  • COST
  • CREATETIME
  • FFMCENTER_ID
  • LASTUPDATE
  • QTYINKITS
  • QTYINPROCESS
  • QTYONHAND
  • QTYRECEIVED
  • RADETAIL_ID
  • RECEIPTDATE
  • RECEIPTTYPE
  • RECEIPT_ID
  • RTNRCPTDSP_ID
  • SETCCURR
  • STORE_ID
  • VENDOR_ID
  • VERSIONSPC_ID
REFKEYS
  • FKCOLUMN_NAME
  • FKTABLE_NAME
  • TABLENAME
REFUNDMTHD
  • ACCOUNT_ID
  • CREDITLINE_ID
  • ORDERS_ID
  • PAYSUMMARY_ID
  • POLICY_ID
  • REFUNDAMOUNT
  • RETURNXML
  • RMA_ID
  • SETCCURR
  • TIMECREATED
  • TRADING_ID
REPDLVRY
  • FISCALYEAR
  • FORMAT
  • FREQUENCY
  • STOREENT_ID
RFQ
  • ACCESSTYPE
  • ACTIVATETIME
  • CANCELTIME
  • CLOSETIME
  • COMPLETETIME
  • CREATETIME
  • DURATION
  • ENDRESULT
  • ENDTIME
  • MAJORVERSION
  • MARKFORDELETE
  • MEMBER_ID
  • MINORVERSION
  • NAME
  • NEXTOFFID
  • NEXTOFFTYPE
  • NUMRESPONSES
  • PREVOFFID
  • PREVOFFTYPE
  • RFQ_ID
  • ROUND
  • RULETYPE
  • STAGE
  • STARTTIME
  • STATE
  • STORE_ID
  • TFTRADENG_ID
  • TRACKNUMBER
  • UPDATETIME
  • VERSIONFLAGS
RFQCATEGRY
  • NAME
  • RFQCATEGRY_ID
  • RFQ_ID
RFQPROD
  • CATENTRY_ID
  • CHANGEABLE
  • CURRENCY
  • PRICE
  • QTYUNIT_ID
  • QUANTITY
  • RFQCATEGRY_ID
  • RFQPRODNAME
  • RFQPROD_ID
  • RFQ_ID
RFQRSP
  • ACCEPTACTION
  • CANCELTIME
  • CREATETIME
  • DESCRIPTION
  • MAJORVERSION
  • MARKFORDELETE
  • MEMBER_ID
  • MINORVERSION
  • NAME
  • PREVRSP
  • REJECTREASON
  • REMARKS
  • RFQRSP_ID
  • RFQ_ID
  • STATE
  • STORE_ID
  • TFTRADENG_ID
  • UPDATETIME
  • VERSIONFLAGS
RFQRSPEVAL
  • EVALRESULT
  • REMARKS
  • RFQRSPEVAL_ID
  • RFQRSPPROD_ID
  • RFQRSP_ID
  • RFQ_ID
  • UPDATETIME
RFQRSPPARL
  • RFQPATTRVALUE_ID
  • RFQRSPPARL_ID
  • RFQRSPPATTRVAL_ID
  • RFQRSP_ID
  • RFQ_ID
RFQRSPPROD
  • CATENTRY_ID
  • CURRENCY
  • PRICE
  • QTYUNIT_ID
  • QUANTITY
  • RFQCATENTRYID
  • RFQPROD_ID
  • RFQRSPPROD_ID
  • RFQRSP_ID
  • SKUGENFLAG
RFQRSPTCRL
  • CHANGEFLAG
  • RFQRSPTCRL_ID
  • RFQRSPTC_ID
  • RFQRSP_ID
  • RFQTC_ID
  • RFQ_ID
RFQTARGET
  • RFQ_ID
  • STORE_ID
RICHATTR
  • C5
  • CATENTRY_ID
  • FLOATVALUE
  • INTEGERVALUE
  • LANGUAGE_ID
  • NAME
  • STRINGVALUE
RICHATTRCG
  • C5
  • CATENTRY_ID
  • CATGROUP_ID
  • FLOATVALUE
  • INTEGERVALUE
  • LANGUAGE_ID
  • NAME
  • STRINGVALUE
RLDISCOUNT
  • CALCODE_ID
  • PRIORITY
  • RULEXML
  • TARGETSALES
RMA
  • COMMENTS
  • CURRENCY
  • FFMCENTER_ID
  • INUSE
  • LASTUPDATE
  • MEMBER_ID
  • ORGENTITY_ID
  • POLICY_ID
  • PREPARED
  • REFUNDAGAINSTORDID
  • RMADATE
  • RMA_ID
  • STATUS
  • STORE_ID
  • TOTALCREDIT
  • TRADING_ID
RMAAUTHLOG
  • AUTHNOTICEDATE
  • RMAAUTHLOG_ID
  • RMA_ID
RMACHARGE
  • AMOUNT
  • CHARGETYPE_ID
  • CURRENCY
  • RMACHARGE_ID
  • RMAITEM_ID
  • RMA_ID
RMAIADJCRD
  • AMOUNT
  • ORDADJUST_ID
  • RMAIADJCRD_ID
  • RMAITEM_ID
RMAIDNYRSN
  • RMAITEM_ID
  • RTNDNYRSN_ID
RMAITEM
  • ADJUSTMENT
  • ADJUSTMENTCREDIT
  • CATENTRY_ID
  • COMMENTS
  • CREDITAMOUNT
  • CREDITDATE
  • CURRENCY
  • INVQUANTITY
  • ITEMSPC_ID
  • LASTUPDATE
  • MEMBER_ID
  • ORDERITEMS_ID
  • QUANTITY
  • REFUNDORREPLACE
  • RMAITEM_ID
  • RMA_ID
  • RTNREASON_ID
  • STATUS
  • TAXAMOUNT
  • TOTALCREDIT
RMAITEMCMP
  • CATENTRY_ID
  • INVQUANTITY
  • ITEMSPC_ID
  • QUANTITY
  • RMAITEMCMP_ID
  • RMAITEM_ID
  • SHOULDRECEIVE
RMATAX
  • LASTUPDATE
  • RMA_ID
  • TAXAMOUNT
  • TAXCGRY_ID
ROLE
  • DESCRIPTION
  • NAME
  • ROLE_ID
ROLEDESC
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
  • ROLE_ID
RTNDNYDESC
  • DESCRIPTION
  • LANGUAGE_ID
  • RTNDNYRSN_ID
RTNDNYRSN
  • CODE
  • MARKFORDELETE
  • RTNDNYRSN_ID
  • STOREENT_ID
RTNDSPCODE
  • CODE
  • MARKFORDELETE
  • RETURNTOINVENTORY
  • RTNDSPCODE_ID
  • STOREENT_ID
RTNDSPDESC
  • DESCRIPTION
  • LANGUAGE_ID
  • RTNDSPCODE_ID
RTNRCPTDSP
  • COMMENTS
  • DISPOSITIONDATE
  • QUANTITY
  • RTNDSPCODE_ID
  • RTNRCPTDSP_ID
  • RTNREASON_ID
  • RTNRECEIPT_ID
RTNREASON
  • CODE
  • MARKFORDELETE
  • REASONTYPE
  • RTNREASON_ID
  • STOREENT_ID
RTNRECEIPT
  • DATERECEIVED
  • DISPOSITIONEDQTY
  • LASTUPDATE
  • QUANTITY
  • RMAITEMCMP_ID
  • RMA_ID
  • RTNRECEIPT_ID
  • VERSIONSPC_ID
RTNRSNDESC
  • DESCRIPTION
  • LANGUAGE_ID
  • RTNREASON_ID
SCHACTIVE
  • SCSACTLSTART
  • SCSATTLEFT
  • SCSEND
  • SCSINSTRECOV
  • SCSINSTREFNUM
  • SCSJOBNBR
  • SCSPREFSTART
  • SCSPRIORITY
  • SCSQUEUE
  • SCSRESULT
  • SCSSEQUENCE
  • SCSSTATE
SCHCMD
  • PATHINFO
  • SCHCMD_ID
  • STOREENT_ID
SCHCONFIG
  • INTERFACENAME
  • STOREENT_ID
SCHERRORLOG
  • SCSERROR
  • SCSINSTREFNUM
SEGMENTATION
  • LAST_UPDATED
  • LAST_UPDATED_ID
  • NUM_ATTRIBUTES
  • NUM_ITEMS
  • NUM_SEGMENTS
  • PER_ID
  • SAMPLE_SIZE_PCT
  • SEGMENTATION_ALG
  • SEGMENTATION_DESC
  • SEGMENTATION_ID
  • SEGMENTATION_NAME
  • SEGMENTATION_TYPE
SEGMENTATION_REF
  • LANGUAGE_ID
  • LAST_UPDATED
  • LAST_UPDATED_ID
  • SEGMENTATION_DESC
  • SEGMENTATION_ID
SHIPMODE
  • MARKFORDELETE
SHPARJURGP
  • JURSTGROUP_ID
  • SHPARRANGE_ID
SHPARRANGE
  • FLAGS
SHPMODCLCD
  • CALCODE_ID
  • SHIPMODE_ID
  • SHPMODCLCD_ID
  • STORE_ID
  • TRADING_ID
SMTPHOST
  • HOST
  • PORT
STADDRESS
  • URL
STCGRYDESC
  • DESCRIPTION
  • DISPLAYNAME
  • LANGUAGE_ID
  • STORECGRY_ID
STDPRICE
  • C5
  • CATENTRY_ID
  • CURRENCY
  • PRICE
STENCALUSG
  • CALMETHOD_ID_APP
  • CALMETHOD_ID_FIN
  • CALMETHOD_ID_INI
  • CALMETHOD_ID_SUM
  • SEQUENCE
  • USAGEFLAGS
STGUINDTAB
  • TABNAME
STORE
  • ALLOCATIONGOODFOR
  • AVSACCEPTCODES
  • BOPMPADFACTOR
  • CRTDBYCNTR_ID
  • DEFAULTBOOFFSET
  • FFMCSELECTIONFLAGS
  • LASTUPDATESTATUS
  • MAXBOOFFSET
  • PRICEREFFLAGS
  • REJECTEDORDEXPIRY
  • RMAGOODFOR
  • RTNFFMCTR_ID
  • STORETYPE
STORECAT
  • LASTUPDATE
  • MASTERCATALOG
STORECNTR
  • CONTRACT_ID
  • STORE_ID
STOREENT
  • MARKFORDELETE
  • SETCCURR
STOREITEM
  • BACKORDERABLE
  • BASEITEM_ID
  • CREDITABLE
  • FORCEBACKORDER
  • FOREIGNSKU
  • FOREIGNSYSTEM
  • LASTUPDATE
  • MINQTYFORSPLIT
  • RELEASESEPARATELY
  • RETURNNOTDESIRED
  • STOREENT_ID
  • TRACKINVENTORY
STOREREL
  • RELATEDSTORE_ID
  • SEQUENCE
  • STATE
  • STORE_ID
  • STRELTYP_ID
STORITMFFC
  • BASEITEM_ID
  • FFMCENTER_ID
  • SHIPPINGOFFSET
  • STOREENT_ID
STRELTYP
  • NAME
  • STRELTYP_ID
STRELTYPDS
  • DESCRIPTION
  • LANGUAGE_ID
  • STRELTYP_ID
TAXCGRY
  • MARKFORDELETE
TAXJCRULE
  • TAXJCRULE_ID
TCATTR
  • SEQUENCE
  • TERMCOND_ID
  • TRADING_ID
  • TYPE
  • XMLDEFINITION
TCDESC
  • DESCRIPTION
  • LANGUAGE_ID
  • LONGDESCRIPTION
  • TERMCOND_ID
  • TIMECREATED
  • TIMEUPDATED
TCPITMAP
  • CPWALLET_ID
  • DISCAMT
  • ORDERITEMS_ID
TCSUBTYPDS
  • DESCRIPTION
  • LANGUAGE_ID
  • TCSUBTYPE_ID
TCSUBTYPE
  • ACCESSBEANNAME
  • DEPLOYCOMMAND
  • TCSUBTYPE_ID
  • TCTYPE_ID
TCTYPE
  • TCTYPE_ID
TERMCOND
  • BIGINTFIELD1
  • BIGINTFIELD2
  • BIGINTFIELD3
  • CHANGEABLE
  • DECIMALFIELD1
  • DECIMALFIELD2
  • DECIMALFIELD3
  • FLOATFIELD1
  • FLOATFIELD2
  • FLOATFIELD3
  • INTEGERFIELD1
  • INTEGERFIELD2
  • INTEGERFIELD3
  • MANDATORY
  • SEQUENCE
  • STRINGFIELD1
  • STRINGFIELD2
  • STRINGFIELD3
  • TCSUBTYPE_ID
  • TERMCOND_ID
  • TIMECREATED
  • TIMEFIELD1
  • TIMEFIELD2
  • TIMEFIELD3
  • TIMEUPDATED
  • TRADING_ID
TFALGOPOL
  • TFALGOPOL_ID
  • TFALGOTYPE_ID
TFALGOREG
  • ALLOCPOL
  • CLASSNAME
  • CREATETIME
  • ENDTIME
  • MATCHPOL
  • MEMBER_ID
  • NAME
  • PRICEPOL
  • TFALGOREG_ID
  • TFALGOTYPE_ID
  • TFDOMAIN_ID
  • TFSBDOMAIN_ID
  • UPDATETIME
TFALGOTYPE
  • TFALGOTYPE_ID
TFALGPOLDS
  • DESCRIPTION
  • LANGUAGE_ID
  • TFALGOPOL_ID
TFALGTYPDS
  • DESCRIPTION
  • LANGUAGE_ID
  • TFALGOTYPE_ID
TFALREGDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • LONGDESCRIPTION
  • TFALGOREG_ID
TFDOMAIN
  • TFDOMAIN_ID
TFDOMDSC
  • CREATETIME
  • DOMAINNAME
  • LANGUAGE_ID
  • TFDOMAIN_ID
  • UPDATETIME
TFEXTENG
  • HANDLERCLASSNAME
  • ROUNDNUM
  • STAGENUM
  • TFALGOREG_ID
  • TFDOMAIN_ID
  • TFEXTENG_ID
  • TFSBDOMAIN_ID
  • TFTRADENG_ID
TFSBDOMAIN
  • TFSBDOMAIN_ID
TFSBDOMDSC
  • LANGUAGE_ID
  • SUBDOMAINNAME
  • TFDOMAIN_ID
  • TFSBDOMAIN_ID
TFTRADENG
  • CANCELTIME
  • CREATETIME
  • MEMBER_ID
  • MULTISTAGE
  • NAME
  • OFFERLIMIT
  • STARTTIME
  • STATUS
  • STOPTIME
  • STORE_ID
  • TFTRADENG_ID
  • UPDATETIME
TFTRENGDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • LONGDESCRIPTION
  • TFTRADENG_ID
TMPBOLIST
  • BASEITEM_ID
  • EXPECTEDDATE
  • FFMCENTER_ID
  • FORCEBACKORDER
  • ITEMSPC_ID
  • MARKFORDELETE
  • QTYALLOCBO
  • QTYNEEDED
  • SID
  • STATUS
TMPCMPLIST
  • BASEITEM_ID
  • EXPLODED
  • ITEMSPC_ID
  • MARKFORDELETE
  • QTYALLOCBO
  • QTYAVAILABLE
  • QTYBUILDABLE
  • REQUIRED
  • SID
  • TOTALNEED
  • TRACKINVENTORY
  • UNITQTY
  • VERSIONSPC_ID
TMPFFCLIST
  • EXPSHIPDATE
  • FFMCENTER_ID
  • PRECEDENCE
  • SID
  • STATUS
TMPPROCID
  • SID
TMPRADTL
  • EXPECTEDDATE
  • FFMCENTER_ID
  • ITEMSPC_ID
  • QTYALLOCATED
  • QTYAVAILABLE
  • RADETAIL_ID
  • SID
TMPRCTLIST
  • ALLOCATED
  • ORDERABLE
  • PRECEDENCE
  • QTYINPROCESS
  • QTYONHAND
  • RECEIPT_ID
  • SID
  • VERSIONSPC_ID
TORCPMAP
  • CPWALLET_ID
  • ORDERS_ID
TRADEPOSCN
  • MARKFORDELETE
  • PRECEDENCE
  • PRODUCTSET_ID
  • TYPE
TRADING
  • ACCOUNT_ID
  • CREDITALLOWED
  • ENDTIME
  • MARKFORDELETE
  • REFERENCECOUNT
  • REFTRADING_ID
  • STARTTIME
  • STATE
  • TRADING_ID
  • TRDTYPE_ID
TRDATTACH
  • ATTACHMENT_ID
  • TRADING_ID
TRDDEPAMT
  • AMOUNT
  • ORDERITEMS_ID
  • ORDERS_ID
  • SETCCURR
  • TRADING_ID
  • TRDDEPAMT_ID
TRDDESC
  • DESCRIPTION
  • LANGUAGE_ID
  • LONGDESCRIPTION
  • TIMECREATED
  • TIMEUPDATED
  • TRADING_ID
TRDPSCNXML
  • FIELD1
  • FIELD2
  • SEQUENCE
  • TRADEPOSCN_ID
  • XMLDEFINITION
TRDPURAMT
  • AMOUNT
  • ORDERITEMS_ID
  • ORDERS_ID
  • SETCCURR
  • TRADING_ID
  • TRDPURAMT_ID
TRDREFAMT
  • AMOUNT
  • ORDERS_ID
  • RMA_ID
  • SETCCURR
  • TRADING_ID
TRDTYPE
  • TRDTYPE_ID
TRDTYPEDSC
  • DESCRIPTION
  • LANGUAGE_ID
  • TRDTYPE_ID
USERPVCDEV
  • PVCSESSION_ID
USERREG
  • PASSWORDCREATION
  • PASSWORDINVALID
  • PASSWORDRETRIES
  • PLCYACCT_ID
  • SALT
  • TIMEOUT
USRTRAFFIC
  • CATENTRY_ID
  • CATGROUP_ID
  • SESSIONID
  • STORE_ID
VENDOR
  • LASTUPDATE
  • MARKFORDELETE
  • STOREENT_ID
  • VENDORNAME
  • VENDOR_ID
VENDORDESC
  • DESCRIPTION
  • LANGUAGE_ID
  • LASTUPDATE
  • STADDRESS_ID
  • VENDOR_ID
VERSIONSPC
  • ITEMSPC_ID
  • ITEMVERSN_ID
  • LASTUPDATE
  • VERSIONSPC_ID
WCSDICTNRY
  • META
  • NAME
  • TYPE
  • WCSDICTNRY_ID
WCSDTNRYDS
  • DESCRIPTION
  • LANGUAGE_ID
  • WCSDICTNRY_ID

Tables removed since version 5.1

CACHLOG
The CACHLOG table records when product or category information is changed in the database. Several tables populate the CACHLOG table using DB2 triggers.
CMPGNINTV
This is a relationship table between the IDs of campaign and initiative.
CMPGNRV
This is a relationship table between the IDs of campaign and rulevalue.
INTVMPE
This is a relationship table between initiative and marketing page element (e-marketing spot).
INTVSGMT
This is a relationship table between initiative and segment.
MAFAMILY
This table contains the data describing a Marketing Asset Family.A Marketing Asset Type belongs to one of the Marketing Asset Family.
MAIN
Clear your cache to avoid retrieving out of date information.
MATYPE
This table contains the data describing a Marketing Asset Type.A Marketing Asset Type belongs to a Marketing Asset Family.
MPE
This table contains the data describing a marketing page element.A marketing page element is also called an e-marketing spot.
MPETYPE
The table contains the data describing a marketing page element type.A marketing page element is also called a e-marketing spot.
SEGMENT
This table contains the data describing a segment. A segment is also called a customer profile.
ZIPCODE
This table is reserved for IBM internal use only

Deprecated tables

ACCCMDGRP
This table defines all commands and views that require access control and categorize them into different groups. This table is deprecated and is provided for backward compatibility only.
ACCCMDTYPE
This table defines all the valid ACCCMDTYPE_ID that can be used in the ACCCMDGRP table. This table is deprecated and is provided for backward compatibility only.
ACCCUSTEXC
This table excludes a command or view from a customer group for a specific owner. This table is deprecated and is provided for backward compatibility only.
ACCMBRGRP
This table is used to assign an administrative user to various access groups for a particular store owner. This table is deprecated and is provided for backward compatibility only.
ACORGPOL
This table enables an organization to be exempted from one or more of the template policies. This table is deprecated and is provided for backward compatibility only.
CATENTATTR
This table holds descriptive Attributes for Catalog Entries. These Attributes are only used for descriptive purposes, and not SKU resolution. This table is deprecated and is provided for backward compatibility only.
MGPTRDPSCN
A row in this table associates a TradingPositionContainer with a MemberGroup. Task commands can use this relationship to restrict use of the TradingPositionContainer to members of certain MemberGroups. (See also the STOREMBRGP table.) This table is deprecated and is provided for backward compatibility only. Use TermAndCondition objects and Participant objects to limit the use of TradingPositionContainers to certain customers. See the TRADING, TERMCOND, and PARTICIPNT tables for current information.
PAYMTHD
This table is a site-wide table that lists all the Cashier profiles used in the store group. Each profile has a unique integer ID and a name. This table is deprecated and is provided for backward compatibility only.
PAYMTHDDSC
This table is a site-wide table that contains a short description of the Cashier profiles in each of the supported language. This table is deprecated and is provided for backward compatibility only.
PAYMTHDSUP
This table lists all the profiles supported by the Store or StoreGroup. This table is deprecated and is provided for backward compatibility only.
PKGITEMREL
This table holds the relationship between Packages, and the Items they contain. This table is deprecated and is provided for backward compatibility only.

Tables containing deprecated columns

ACPOLGRP
POLICYTYPE
ORGCODE
MEMBER_ID
PVCBINDING
PARAMETERS
PVCBUFFER
MODELNAME
PVCDEVMDL
SESSIONTYPE
STORECGRP
REMARK
TAXJCRULE
SEQUENCE
TORCPMAP
FLAGS
USERPROF
DEVICEIDENTIFIER
USERREG
REGISTERTYPE

Tables containing changed columns

AUTOBID
PAYTYPE
  • Version 5.1: CHARACTER (4) NOT NULL
  • Version 5.5: CHARACTER (64) NOT NULL
AUTOBIDLOG
PAYTYPE
  • Version 5.1: CHARACTER (4) NULL
  • Version 5.5: CHARACTER (64) NULL
BID
PAYTYPE
  • Version 5.1: CHARACTER (4) NOT NULL
  • Version 5.5: CHARACTER (64) NOT NULL
BIDLOG
PAYTYPE
  • Version 5.1: CHARACTER (4) NULL
  • Version 5.5: CHARACTER (64) NULL
BIDPAYMENT
PAYTYPE
  • Version 5.1: CHARACTER (4) NULL
  • Version 5.5: CHARACTER (64) NULL
BZRPENTSTG
VALUE
  • Version 5.1: LONG VARCHAR (32700) NOT NULL
  • Version 5.5: VARCHAR (4000) NOT NULL
CALCODE
CODE
  • Version 5.1: CHARACTER (30) NULL
  • Version 5.5: CHARACTER (128) NOT NULL
CALCODEDSC
LONGDESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
CALMETHOD
DESCRIPTION
  • Version 5.1: VARCHAR (254) NULL
  • Version 5.5: VARCHAR (508) NULL
CATALOGDSC
LONGDESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
CATENTDESC
AUXDESCRIPTION1
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
AUXDESCRIPTION2
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
LONGDESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
NAME
  • Version 5.1: CHARACTER (64) NULL
  • Version 5.5: CHARACTER (128) NULL
XMLDETAIL
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: LONG VARCHAR NULL
CATENTSHIP
QUANTITYMEASURE
  • Version 5.1: CHARACTER (16) NOT NULL
  • Version 5.5: CHARACTER (16) NOT NULL, DEFAULT 'C62'
CATGRPDESC
LONGDESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
CLEANCONF
DAYSARG
  • Version 5.1: CHARACTER (10) NULL
  • Version 5.5: CHARACTER (10) NOT NULL
NAMEARG
  • Version 5.1: CHARACTER (10) NULL
  • Version 5.5: CHARACTER (10) NOT NULL
TYPE
  • Version 5.1: CHARACTER (40) NULL
  • Version 5.5: CHARACTER (40) NOT NULL
COLLDESC
MARKETINGTEXT
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
CONTRACT
MEMBER_ID
  • Version 5.1: BIGINT NULL
  • Version 5.5: BIGINT NOT NULL
NAME
  • Version 5.1: VARCHAR (254) NULL
  • Version 5.5: VARCHAR (200) NOT NULL
CONTRLRULE
RULETEXT
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
CPGNLOG
INITIATIVE_ID
  • Version 5.1: INTEGER NULL
  • Version 5.5: INTEGER NOT NULL
FFMCENTDS
DESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
FORUM
DESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
FORUMMSG
ACTREMARK
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
MSGBODY
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
ICEXPLDESC
NAME
  • Version 5.1: VARCHAR (64) NOT NULL
  • Version 5.5: VARCHAR (254) NOT NULL
ICEXPLFEAT
COLUMNNAME
  • Version 5.1: CHARACTER (18) NOT NULL
  • Version 5.5: VARCHAR (254) NOT NULL
INVENTORY
QUANTITYMEASURE
  • Version 5.1: CHARACTER (16) NOT NULL
  • Version 5.5: CHARACTER (16) NOT NULL, DEFAULT 'C62'
KEYS
COLUMNNAME
  • Version 5.1: CHARACTER (18) NOT NULL
  • Version 5.5: VARCHAR (18) NOT NULL
TABLENAME
  • Version 5.1: CHARACTER (18) NOT NULL
  • Version 5.5: VARCHAR (18) NOT NULL
MBRGRP
DESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (512) NULL
MESSAGE
CONTENT
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: LONG VARCHAR NULL
MSGSTORE
MESSAGE
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: LONG VARCHAR NULL
MSGVIEW
CONTENT
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: LONG VARCHAR NULL
OFFER
IDENTIFIER
  • Version 5.1: BIGINT NOT NULL, DEFAULT 1
  • Version 5.5: BIGINT NULL
ORDOPTIONS
NOTIFYMERCHANT
  • Version 5.1: SMALLINT NULL
  • Version 5.5: INTEGER NULL
NOTIFYSHOPPER
  • Version 5.1: SMALLINT NULL
  • Version 5.5: INTEGER NULL
ORGENTITY
DESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (512) NULL
PAYSTATUS
PENDING
  • Version 5.1: SMALLINT NULL
  • Version 5.5: INTEGER NULL
SETSWAKEUPMSG
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
PKGATTRVAL
LANGUAGE_ID
  • Version 5.1: INTEGER NULL
  • Version 5.5: INTEGER NOT NULL
PVCDEVMDL
MODELNAME
  • Version 5.1: VARCHAR (40) NOT NULL
  • Version 5.5: VARCHAR (40) NULL
PVCDEVSPEC
SESSIONTYPE
  • Version 5.1: VARCHAR (32) NOT NULL
  • Version 5.5: VARCHAR (32) NULL
RULECLSREG
NAME
  • Version 5.1: VARCHAR (64) NULL
  • Version 5.5: VARCHAR (128) NULL
SCHCONFIG
SCCAPPTYPE
  • Version 5.1: VARCHAR (20) NULL
  • Version 5.5: CHARACTER (20) NULL
SCCPATHINFO
  • Version 5.1: VARCHAR (128) NOT NULL
  • Version 5.5: VARCHAR (254) NOT NULL
SCCQUERY
  • Version 5.1: VARCHAR (1000) NULL
  • Version 5.5: VARCHAR (3000) NULL
SETSTATUS
PENDING
  • Version 5.1: SMALLINT NULL
  • Version 5.5: INTEGER NULL
SETSWAKEUPMSG
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
SHIPMODE
TRACKINGURL
  • Version 5.1: VARCHAR (64) NULL
  • Version 5.5: VARCHAR (254) NULL
SHPARRANGE
SHIPMODE_ID
  • Version 5.1: INTEGER NOT NULL
  • Version 5.5: INTEGER NULL
SHPJCRULE
FFMCENTER_ID
  • Version 5.1: INTEGER NOT NULL
  • Version 5.5: INTEGER NULL
JURSTGROUP_ID
  • Version 5.1: INTEGER NOT NULL
  • Version 5.5: INTEGER NULL
SHIPMODE_ID
  • Version 5.1: INTEGER NOT NULL
  • Version 5.5: INTEGER NULL
STAGLOG
STGKEY5NAME
  • Version 5.1: CHARACTER (32) NULL, DEFAULT NULL
  • Version 5.5: CHARACTER (32) NULL
STGLDCOLS
  • Version 5.1: LONG VARCHAR (32700) NULL, DEFAULT NULL
  • Version 5.5: VARCHAR (4000) NULL
STGLDPTH
  • Version 5.1: VARCHAR (254) NULL, DEFAULT NULL
  • Version 5.5: VARCHAR (254) NULL
STGNKEY5
  • Version 5.1: VARCHAR (254) NULL, DEFAULT NULL
  • Version 5.5: VARCHAR (254) NULL
STGOKEY5
  • Version 5.1: VARCHAR (254) NULL, DEFAULT NULL
  • Version 5.5: VARCHAR (254) NULL
STGTABLE
  • Version 5.1: CHARACTER (18) NOT NULL
  • Version 5.5: CHARACTER (10) NOT NULL
STORE
STATUS
  • Version 5.1: INTEGER NULL
  • Version 5.5: INTEGER NOT NULL, DEFAULT 1
STORECGRY
NAME
  • Version 5.1: CHARACTER (50) NULL
  • Version 5.5: CHARACTER (50) NOT NULL
STOREENTDS
DESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
SUBKEYS
TABLENAME
  • Version 5.1: CHARACTER (18) NOT NULL
  • Version 5.5: CHARACTER (10) NOT NULL
TAXJCRULE
FFMCENTER_ID
  • Version 5.1: INTEGER NOT NULL
  • Version 5.5: INTEGER NULL
JURSTGROUP_ID
  • Version 5.1: INTEGER NOT NULL
  • Version 5.5: INTEGER NULL
TRADEPOSCN
NAME
  • Version 5.1: VARCHAR (254) NULL
  • Version 5.5: VARCHAR (254) NOT NULL
USERPROF
DESCRIPTION
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
USRTRAFFIC
PREVURL
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (254) NULL
QUERYSTRING
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (4000) NULL
REFURL
  • Version 5.1: LONG VARCHAR (32700) NULL
  • Version 5.5: VARCHAR (254) NULL