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
-
- 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
-
- ACPLGPDESC
- ACPOLGRP_ID
- DESCRIPTION
- DISPLAYNAME
- LANGUAGE_ID
- ACPLGPSUBS
-
- ACPOLDESC
- ACPOLICY_ID
- DESCRIPTION
- DISPLAYNAME
- LANGUAGE_ID
- ACPOLGPPOL
-
- 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
-
- ACRELATION
- ACRELATION_ID
- RELATIONNAME
- ACRELDESC
- ACRELATION_ID
- DESCRIPTION
- DISPLAYNAME
- LANGUAGE_ID
- ACRELGRP
- ACRELGRP_ID
- CONDITIONS
- DESCRIPTION
- FIELD1
- GRPNAME
- MEMBER_ID
- ACRESACT
-
- 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
-
- 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
-
- AUTOBIDLOG
-
- 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
-
- BKORDALLOC
- BKORDNUM
- ITEMSPC_ID
- LASTUPDATE
- ORDERITEMS_ID
- QTYALLOCATED
- QTYAVAILABLE
- QTYNEEDED
- BKORDITEM
- DATEEXPECTED
- LASTUPDATE
- ORDERITEMS_ID
- BUSPROF
-
- BUYERPO
- ACCOUNT_ID
- AMOUNT
- BUYERPOTYP_ID
- BUYERPO_ID
- PONUMBER
- SETCCURR
- STATE
- BUYERPOTYP
-
- 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
-
- CALRANGE
-
- CAMPAIGN
-
- CATALOG
-
- CATCLSFCOD
-
- CATCONFINF
- CATENTRY_ID
- FIELD1
- FIELD2
- FIELD3
- FIELD4
- FIELD5
- REFERENCE
- URL
- CATENTDESC
-
- CATENTRY
- BASEITEM_ID
- ENDDATE
- ITEMSPC_ID
- STARTDATE
- STATE
- CATGPENREL
-
- CATGRPATTR
-
- CATGRPDESC
-
- 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
-
- CHARGETYPE
- CHARGETYPE_ID
- CODE
- DISPLAYAGGREGATED
- MARKFORDELETE
- STOREENT_ID
- CHKARRANG
-
- 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
-
- CNTRSTORE
-
- 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
-
- CURFORMAT
- MINAPPROVEAMOUNT
- NUMBRUSG_ID
- CWMEMBER
-
- DISPCGPREL
-
- DISPENTREL
-
- 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
-
- 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
-
- 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
-
- JURSTGROUP
-
- LANGUAGE
-
- 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
-
- MASSOCGPGP
-
- MBRATTR
- ATTRTYPE_ID
- DESCRIPTION
- MBRATTR_ID
- NAME
- MBRATTRVAL
- ATTRTYPE_ID
- DATETIMEVALUE
- FLOATVALUE
- INTEGERVALUE
- MBRATTRVAL_ID
- MBRATTR_ID
- MEMBER_ID
- STOREENT_ID
- STRINGVALUE
- MBRGRP
-
- MBRGRPCOND
- CONDITIONS
- FIELD1
- FIELD2
- MBRGRP_ID
- MBRGRPDESC
- DESCRIPTION
- DISPLAYNAME
- LANGUAGE_ID
- MBRGRP_ID
- MBRGRPMBR
-
- MBRGRPTYPE
-
- MBRREL
- ANCESTOR_ID
- DESCENDANT_ID
- SEQUENCE
- MBRROLE
- MEMBER_ID
- ORGENTITY_ID
- ROLE_ID
- MEMBER
-
- MLTIME
-
- 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
-
- 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
-
- ORDADJUST
-
- 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
-
- 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
-
- ORDIPROF
- ORDERITEMS_ID
- PROFILENAME
- ORDISTAT
-
- ORDITRD
-
- 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
-
- ORDTAX
-
- ORGCODE
- CODE
- CODETYPE
- ORGCODE_ID
- ORGENTITY_ID
- ORGENTITY
-
- 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
-
- 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
-
- POLICYTYPE
-
- PRATRSTATR
- ATTR_ID
- ATTR_NAME
- ATTR_PARTNUMBER
- ATTR_PRODUCT_ID
- LANG_ID
- TYPE_ID
- PRCEOFFPRD
-
- 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
-
- 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
-
- PVCBUFFER
-
- PVCDEVMDL
-
- QTYFMTDESC
-
- QTYFORMAT
-
- QTYUNITMAP
- FIELD1
- QTYUNIT_ID
- UOMCODE
- UOMSTANDARD
- QUEUE
- ALLCSR
- NAME
- QUEUE_ID
- STORE_ID
- QUEUECSR
-
- 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
-
- 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
- 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
-
- 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
-
- 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
-
- SHPARJURGP
- JURSTGROUP_ID
- SHPARRANGE_ID
- SHPARRANGE
-
- SHPMODCLCD
- CALCODE_ID
- SHIPMODE_ID
- SHPMODCLCD_ID
- STORE_ID
- TRADING_ID
- SMTPHOST
-
- STADDRESS
-
- 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
-
- STORE
- ALLOCATIONGOODFOR
- AVSACCEPTCODES
- BOPMPADFACTOR
- CRTDBYCNTR_ID
- DEFAULTBOOFFSET
- FFMCSELECTIONFLAGS
- LASTUPDATESTATUS
- MAXBOOFFSET
- PRICEREFFLAGS
- REJECTEDORDEXPIRY
- RMAGOODFOR
- RTNFFMCTR_ID
- STORETYPE
- STORECAT
-
- STORECNTR
-
- STOREENT
-
- 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
-
- STRELTYPDS
- DESCRIPTION
- LANGUAGE_ID
- STRELTYP_ID
- TAXCGRY
-
- TAXJCRULE
-
- 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
-
- 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
-
- TFALGPOLDS
- DESCRIPTION
- LANGUAGE_ID
- TFALGOPOL_ID
- TFALGTYPDS
- DESCRIPTION
- LANGUAGE_ID
- TFALGOTYPE_ID
- TFALREGDSC
- DESCRIPTION
- LANGUAGE_ID
- LONGDESCRIPTION
- TFALGOREG_ID
- TFDOMAIN
-
- TFDOMDSC
- CREATETIME
- DOMAINNAME
- LANGUAGE_ID
- TFDOMAIN_ID
- UPDATETIME
- TFEXTENG
- HANDLERCLASSNAME
- ROUNDNUM
- STAGENUM
- TFALGOREG_ID
- TFDOMAIN_ID
- TFEXTENG_ID
- TFSBDOMAIN_ID
- TFTRADENG_ID
- TFSBDOMAIN
-
- 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
-
- TMPRADTL
- EXPECTEDDATE
- FFMCENTER_ID
- ITEMSPC_ID
- QTYALLOCATED
- QTYAVAILABLE
- RADETAIL_ID
- SID
- TMPRCTLIST
- ALLOCATED
- ORDERABLE
- PRECEDENCE
- QTYINPROCESS
- QTYONHAND
- RECEIPT_ID
- SID
- VERSIONSPC_ID
- TORCPMAP
-
- TRADEPOSCN
- MARKFORDELETE
- PRECEDENCE
- PRODUCTSET_ID
- TYPE
- TRADING
- ACCOUNT_ID
- CREDITALLOWED
- ENDTIME
- MARKFORDELETE
- REFERENCECOUNT
- REFTRADING_ID
- STARTTIME
- STATE
- TRADING_ID
- TRDTYPE_ID
- TRDATTACH
-
- 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
-
- TRDTYPEDSC
- DESCRIPTION
- LANGUAGE_ID
- TRDTYPE_ID
- USERPVCDEV
-
- 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
|
© Copyright IBM Corporation 1996, 2003. All Rights Reserved.