Reference > WebSphere Commerce Web services

Catalog

This section displays the mapping between the logical schema path to physical database mapping for nouns in the catalog components.

Logical schema path to Physical database mapping

The following logical schema path to physical database schema for nouns in the catalog components are shown:

• Attribute noun

• Catalog noun

• CatalogEntry noun

• CatalogGroup noun

Attribute noun

Attribute dictionary logical schema path to database mapping

Logical Schema Path	Database Schema
AttributeIdentifier/ExternalIdentifier/Identifier	ATTR.IDENTIFIER
AttributeDataType	ATTR.ATTRTYPE_ID
Name	ATTR.NAME
Description	ATTRDESC.DESCRIPTION
ExtendedData/SecondaryDescription	ATTRDESC.DESCRIPTION2
ParentAttributeGroup/ExternalIdentifier/Identifier	ATTRDESC.GROUPNAME
ExtendedData/Field1	ATTRDESC.FIELD1
ExtendedData/Footnote	ATTRDESC.NOTEINFO
ExtendedData/UnitOfMeasure	ATTRDESC.QTYUNIT_ID

Catalog noun

Catalog logical schema path to database mapping

Logical schema path	Database schema
CatalogIdentifier/ExternalIdentifier/Identifier	CATALOG.IDENTIFIER
Description[0]/Name	CATALOGDSC.NAME
Attributes/description	CATALOG.DESCRIPTION
Description[0]/ShortDescription	CATALOGDSC.SHORTDESCRIPTION
Description[0]/LongDescription	CATALOGDSC.LONGDESCRIPTION
Description[0]/Thumbnail	CATALOGDSC.THUMBNAIL
Description[0]/FullImage	CATALOGDSC.FULLIMAGE
@primary	STORECAT.MASTERCATALOG

CatalogEntry noun

CatalogEntry logical schema path to database mapping

Logical schema path	Database schema
CatalogEntryIdentifier/ExternalIdentifier/PartNumber	CATENTRY.PARTNUMBER
catalogEntryTypeCode	CATENTRY.CATENTTYPE_ID
LISTPRICE/CURRENCY	LISTPRICE.CURRENCY
ListPrice/Price	LISTPRICE.LISTPRICE
ParentCatalogGroupIdentifier/ExternalIdentifier/GroupIdentifier	CATGROUP.IDENTIFIER
sequence	CATENTREL.SEQUENCE
Description[0]/Language	CATENTDESC.LANGUAGEID
Description[0]/Name	CATENTDESC.NAME
Description[0]/ShortDescription	CATENTDESC.SHORTDESCRIPTION
Description[0]/LongDescription	CATENTDESC.LONGDESCRIPTION
Description[0]/Thumbnail	CATENTDESC.THUMBNAIL
Description[0]/FullImage	CATENTDESC.FULLIMAGE
Description[0]/Attributes/auxDescription1	CATENTDESC.AUXDESCRIPTION1
Description[0]/Attributes/auxDescription2	CATENTDESC.AUXDESCRIPTION2
Description[0]/Attributes/available	CATENTDESC.AVAILABLE
Description[0]/Attributes/published	CATENTDESC.PUBLISHED
Description[0]/Attributes/availabilityDate	CATENTDESC.AVAILABILITYDATE
Description[0]/Keyword	CATENTDESC.KEYWORD
CatalogEntryAttributes/Attributes[n]/Name/manufacturerPartNumber CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.MFPARTNUMBER
CatalogEntryAttributes/Attributes[n]/Name/manufacturer CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.MFNAME
CatalogEntryAttributes/Attributes[n]/Name/url CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.URL
CatalogEntryAttributes/Attributes[n]/Name/field1 CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.FIELD1
CatalogEntryAttributes/Attributes[n]/Name/field2 CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.FIELD2
CatalogEntryAttributes/Attributes[n]/Name/field3 CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.FIELD3
CatalogEntryAttributes/Attributes[n]/Name/field4 CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.FIELD4
CatalogEntryAttributes/Attributes[n]/Name/field5 CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.FIELD5
CatalogEntryAttributes/Attributes[n]/Name/onSpecial CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.ONSPECIAL
CatalogEntryAttributes/Attributes[n]/Name/onAuction CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.ONAUCTION
CatalogEntryAttributes/Attributes[n]/Name/buyable CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.BUYABLE
CatalogEntryAttributes/Attributes[n]/Name/startDate CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.STARTDATE
CatalogEntryAttributes/Attributes[n]/Name/endDate CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.ENDDATE
CatalogEntryAttributes/Attributes[n]/Name/availabilityDate CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.AVAILABILITYDATE
CatalogEntryAttributes/Attributes[n]/Name/lastOrderDate CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.LASTORDERDATE
CatalogEntryAttributes/Attributes[n]/Name/endOfServiceDate CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.ENDOFSERVICEDATE
CatalogEntryAttributes/Attributes[n]/Name/discontinueDate CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTRY.DISCONTINUEDATE
CatalogEntryAttributes/Attributes[n]/Name/weightMeasure CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.WEIGHTMEASURE
CatalogEntryAttributes/Attributes[n]/Name/weight CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.WEIGHT
CatalogEntryAttributes/Attributes[n]/Name/length CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.LENGTH
CatalogEntryAttributes/Attributes[n]/Name/width CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.WIDTH
CatalogEntryAttributes/Attributes[n]/Name/height CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.HEIGHT
CatalogEntryAttributes/Attributes[n]/Name/sizeMeasure CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.SIZEMEASURE
CatalogEntryAttributes/Attributes[n]/Name/nominalQuantity CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.NOMINALQUANTITY
CatalogEntryAttributes/Attributes[n]/Name/quantityMultiple CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.QUANTITYMULTIPLE
CatalogEntryAttributes/Attributes[n]/Name/quantityMeasure CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTSHIP.QUANTITYMEASURE
ParentCatalogEntryIdentifier/ExternalIdentifier/PartNumber	CATENTRY.PARTNUMBER
CatalogEntryAttributes/Attributes[n]/Name/CATENTREL_field1 CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTREL.FIELD1
CatalogEntryAttributes/Attributes[n]/Name/CATENTREL_field2 CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTREL.FIELD2
CatalogEntryAttributes/Attributes[n]/Name/CATENTREL_field3 CatalogEntryAttributes/Attributes[n]/StringValue/Value	CATENTREL.FIELD3
CatalogEntryAttributes/Attributes[0]/AttributeDataType	ATTRIBUTE.ATTRTYPE_ID
CatalogEntryAttributes/Attributes[0]/Name	ATTRIBUTE.NAME
CatalogEntryAttributes/Attributes[0](@displaySequence)	ATTRIBUTE.SEQUENCE
CatalogEntryAttributes/Attributes[0]/Description	ATTRIBUTE.DESCRIPTION
CatalogEntryAttributes/Attributes[0]/ExtendedData/SecondaryDescription	ATTRIBUTE.DESCRIPTION2
CatalogEntryAttributes/Attributes[0]/ExtendedData/DisplayGroupName	ATTRIBUTE.GROUPNAME
CatalogEntryAttributes/Attributes[0]/ExtendedData/Field1	ATTRIBUTE.FIELD1
CatalogEntryAttributes/Attributes[0]/ExtendedData/Footnote	ATTRIBUTE.NOTEINFO
CatalogEntryAttributes/Attributes[0]/AttributeValue/Name	ATTRVALUE.NAME
CatalogEntryAttributes/Attributes[0]/StringValue/Value	ATTRVALUE.STRINGVALUE
CatalogEntryAttributes/Attributes[0]/AttributeValue/ExtendedValue/Image1	ATTRVALUE.IMAGE1
CatalogEntryAttributes/Attributes[0]/AttributeValue/ExtendedValue/Image2	ATTRVALUE.IMAGE2
CatalogEntryAttributes/Attributes[0]/AttributeValue/ExtendedValue/Field1	ATTRVALUE.FIELD1
CatalogEntryAttributes/Attributes[0]/AttributeValue/ExtendedValue/Field2	ATTRVALUE.FIELD2
CatalogEntryAttributes/Attributes[0]/AttributeValue/ExtendedValue/Field3	ATTRVALUE.FIELD3
CatalogEntryAttributes/Attributes[0]/AttributeValue/ExtendedValue/UnitOfMeasure	ATTRVALUE.QTYUNIT_ID
CatalogEntryAttributes/Attributes[0]/ExtendedValue/AttachmentID	ATTRVALUE.ATTACHMENT_ID
CatalogEntryIdentifier/ExternalIdentifier/PartNumber	CATENTRY.PARTNUMBER
CatalogEntryIdentifier/ExternalIdentifier/StoreIdentifier/ExternalIdentifier/NameIdentifier	STOREENT.IDENTIFIER
Association/Name	MASSOCCECE.MASSOCTYPE_ID
Association/CatalogEntryReference/CatalogEntryIdentifier/ExternalIdentifier/PartNumber	CATENTRY.PARTNUMBER
Association/CatalogEntryReference/CatalogEntryIdentifier/ExternalIdentifier/StoreIdentifier/ ExternalIdentifier/NameIdentifier	STOREENT.IDENTIFIER
Association/sequence	MASSOCECE.RANK
Association/semantic	MASSOCECE.MASSOC_ID
Association/quantity	CMASSOCECE.QUANTITY
Association/Attributes[n]/field1, Association/Attributes[n]/Value	MASSOCECE.FIELD1
Association/Attributes[n]/field2, Association/Attributes[n]/Value	MASSOCECE.FIELD2
Association/Attributes[n]/field3, Association/Attributes[n]/Value	MASSOCECE.FIELD3
Association/Attributes[n]/date1, Association/Attributes[n]/Value	MASSOCECE.DATE1

CatalogGroup noun

CatalogGroup logical schema path to database mapping

Logical schema path	Database schema
CatalogGroupIdentifier/ExternalIdentifier/GroupIdentifier	CATGROUP.IDENTIFIER
ParentCatalogGroupIdentifier/ExternalIdentifier/GroupIdentifier	CATGROUP.IDENTIFIER
topCatalogGroup	CATTOGRP
displaySequence	CATGRPREL.SEQUENCE
Description[0]/Name	CATGRPDESC.NAME
Description[0]/ShortDescription	CATGRPDESC.SHORTDESCRIPTION
Description[0]/LongDescription	CATGRPDESC.LONGDESCRIPTION
Description[0]/Thumbnail	CATGRPDESC.THUMBNAIL
Description[0]/FullImage	CATGRPDESC.FULLIMAGE
Description[0]/Attributes/published	CATGRPDESC.PUBLISHED
Description[0]/Keyword	CATGRPDESC.KEYWORD
Description[0]/Attributes/note	CATGRPDESC.NOTE
Attributes/field1	CATGROUP.FIELD1
Attributes/field2	CATGROUP.FIELD2
CatalogGroupIdentifier/ExternalIdentifier/StoreIdentifier/ExternalIdentifier/NameIdentifier	STOREENT.IDENTIFIER
ParentCatalogGroupIdentifier/ExternalIdentifier/StoreIdentifier/ExternalIdentifier/NameIdentifier	STOREENT.IDENTIFIER
Association/Name	MASSOCCECE.MASSOCTYPE_ID
Association/CatalogGroupReference/CatalogGroupIdentifier/ExternalIdentifier/GroupIdentifier	CATGROUP.IDENTIFIER
Association/sequence	MASOCGPGP.RANK
Association/semantic	MASOCGPGP.MASSOC_ID
Association/quantity	MASOCGPGP.QUANTITY
Association/Attributes[n]/Name/field1, Association/Attributes[n]/Value	MASOCGPGP.FIELD1
Association/Attributes[n]/Name/field2, Association/Attributes[n]/Value	MASOCGPGP.FIELD2
Association/Attributes[n]/Name/field3, Association/Attributes[n]/Value	MASOCGPGP.FIELD3
Association/Attributes[n]/Name/Date1, Association/Attributes[n]/Value	MASOCGPGP.DATE1
Association/CatalogGroupReference/CatalogGroupReference/CatalogGroupIdentifier/ExternalIdentifier/StoreIdentifier/ ExternalIdentifier/NameIdentifier	STOREENT.IDENTIFIER

• Catalog
  

• CatalogEntry
  

• CatalogGroup
  

+

Search Tips   |   Advanced Search