- ACACGPDESC
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
- ACACTACTGP
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
- ACACTDESC
This table stores locale-specific information for Access Control actions which are stored in the ACACTION table.
- ACACTGRP
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
- ACACTION
This table stores all the access control actions in the system.
- ACATTR
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
- ACATTRDESC
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
- ACCCMDGRP
This table is deprecated and is provided for backward compatibility only.
- ACCCMDTYPE
This table is deprecated and is provided for backward compatibility only.
- ACCCUSTEXC
This table is deprecated and is provided for backward compatibility only.
- 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.
- ACCMBRGRP
This table is deprecated and is provided for backward compatibility only.
- ACCOUNT
Each row of this table represents a business account between a Buyer organization and a Seller organization. A business account can be used to organize various trading agreements, and to specify special trading terms and conditions.
- ACORGPOL
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 multiple organizations can subscribe to the same policy group.
- 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 row in this table represents a policy group.
- ACPOLICY
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
- ACPOLSUBGP
This table is deprecated and is provided for backward compatibility only.
- ACRELATION
This table is a master list of all the access control relationships that exist in the system. These relationships are between resources that are protected and the members in the system.
- ACRELDESC
This table stores the locale-specific information for the access control relationships which are stored in the ACRELATION table.
- ACRELGRP
This table is a master list of all the access control 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 access control resources and actions. Given a resource, you can find out the associated actions from this table.
- ACRESATREL
This table stores the relationship between access control resources and attributes. These attributes are used to implicitly group resources. Given a resource, you can find out the supported attributes from this table. The metadata information about attributes is used in the GUI for defining resource groups and also for generating the SQL statements for filtering.
- ACRESCGRY
This table stores all the access control resource categories in the system and the metadata information about them. The metadata includes information about the table and the columns that store the resources belonging to the resource category.
- ACRESGPDES
This table stores locale specific display information for the ACRESGRP table.
- ACRESGPRES
This table associates access control resource groups with resource categories (or the classes of resources). You can use this table to group various resources together based on their class names.
- ACRESGRP
This table stores all the access control 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 is an access control table that stores resource-member relationships for resources of different types.
- ACRESPRIM
This table stores the primary resource column names for an access control resource. A given resource can have more than one primary column.
- ACRESREL
This table associates an access control resource with the relationships that it supports. Given a resource, you can find out the possible relationships that it can have and also the table and the columns in which these relationships are stored.
- ACRLGPDESC
This table stores locale-specific information for the ACRELGRP table.
- ACRSCGDES
This table stores locale-specific information for the ACRESCGRY table.
- ADDRBOOK
This table contains information about an address book. An address book is a container for addresses owned by a member. A member can only have one address book.
- ADDRESS
This table stores the addresses of users or organizations in the HCL Commerce system. The addresses can be the members' own addresses or for their friends, associates, or clients, and so on. Some columns here replace columns used in previous versions.
- ALCHARGE
Reserved for HCL internal use.
- APPEASEMENT
This table holds the details of the order appeasements.
- APPEASEMENTITEM
This table holds the details of the order appeasement items.
- APPLY_INIT
This table is deprecated and is provided for backward compatibility only.
- APPLY_MEMBER
This table is deprecated and is provided for backward compatibility only.
- APPLY_RESULT
This table is deprecated and is provided for backward compatibility only.
- APPSJUSTREL
This table holds the relationships between appeasements and justifications.
- ../../database/database/approval_type.html
- ../../database/database/approval.html
- ../../database/database/approval_state.html
- ../../database/database/approval_state_flow.html
- ../../database/database/approval_state_flow_steps.html
- APRVSTATUS
This table contains information about the status of an approval.
- ATCHAST
This table holds the metadata for the attachment asset in the attachment target.
- ATCHASTLG
This table holds the attachment asset to language relationship.
- ATCHOBJTYP
This table holds the information about the types of business objects that are configured to have attachments. For example, attachments can be associated to CATALOG, CATGROUP, and CATENTRY business objects.
- ATCHREL
This table holds the attachment relation between a business object and an attachment target.
- ATCHRELDSC
This is a description table for an attachment relation.
- ATCHRLUS
This table holds usage information for attachment relations. For example, an attachment can be a warranty document related to a product. In this case the usage is 'warranty'.
- ATCHRLUSDS
This table holds the description of an attachment relation usage.
- ATCHTGT
This table holds information about the target, which is used to hold a collection of assets, for use as an attachment target.
- ATCHTGTDSC
This table holds the description of an attachment target.
- 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.
- ATTR
Stores attribute dictionary attributes. These attributes can be used for descriptive or SKU resolution purposes, and can be shared by catalog entries. Non attribute dictionary attributes used for a single catalog entry are stored in the ATTRIBUTE table.
- ATTRDESC
This table holds the language sensitive attribute description. Before loading attributes in multiple languages, the attributes must already exist in the database with default data.
- ATTRDICT
Table used to store the attribute dictionaries configured for the site. Each attribute dictionary is owned by a store, but can be used by children stores through store relationships. There can be only one attribute dictionary owned by any given store.
- ATTRDICTGRP
Table used to store attribute dictionary attribute groups. These groups are a convenience mechanism used during administration of the attribute dictionary and when assigning attribute dictionary attributes to catalog entries or catalog groups. Attributes can belong to zero or more attribute groups.
- ATTRDICTGRPATTRREL
Stores the relationship between the attribute dictionary group and the attribute dictionary attribute.
- ATTRDICTGRPDESC
The table holds the attribute dictionary group description
- ATTRDICTGRPREL
Defines the relationships between attribute dictionary attribute groups. An attribute dictionary attribute group can have only one parent group.
- ATTRDICTSRCHCONF
The mapping table between attribute dictionary attribute's identifiers and fields in search schema.
- ATTRIBUTE
This table holds catalog entry attributes used for descriptive or SKU resolution purposes. An attribute stored in this table is for a single catalog entry and is not shared between catalog entries. Attribute dictionary attributes are stored in the ATTR table.
- ATTRTYPE
This table holds the type identifier for product attributes.
- ATTRVAL
This table holds an attribute value that can be a shareable global attribute value or a local attribute value defined for a catalog entry.
- ATTRVALDESC
This table holds the language sensitive attribute value description.
- ATTRVALUE
This table holds the values assigned to product attributes and relates them back to catalog entries for SKU resolution.
- ATTR_EXTERNAL_CONTENT_REL
Reserved for HCL internal use.
- AUCPAYINFO
This table is deprecated and is provided for backward compatibility only.
- AUCTBIDVW
This view is deprecated and is provided for backward compatibility only.
- AUCTDESC
This table is deprecated and is provided for backward compatibility only.
- AUCTION
This table is deprecated and is provided for backward compatibility only.
- AUCTIONLOG
This table is deprecated and is provided for backward compatibility only.
- AUCTSTRREL
This table is deprecated and is provided for backward compatibility only.
- AUCTSTYLE
This table is deprecated and is provided for backward compatibility only.
- AUCTVIEW
This view is deprecated and is provided for backward compatibility only.
- AUTOBID
This table is deprecated and is provided for backward compatibility only.
- AUTOBIDLOG
This table is deprecated and is provided for backward compatibility only.