Dev GuideAPI Reference
Dev GuideAPI ReferenceUser GuideGitHubNuGetDev CommunitySubmit a ticketLog In
GitHubNuGetDev CommunitySubmit a ticket

Database objects to user interface label mapping

Describes database objects to user interface label mapping.

With the overhaul of the Admin Console in version 4.2 of Optimizely Configured Commerce, some field and property names were updated to match more common industry language or to improve understanding. Listed below are the mappings.

Field names (sorted by label)

Entity NameLabelPluralized Label
productUnitOfMeasureAlternate Unit of MeasureAlternate Units of Measure
attributeTypeAttributeAttributes
auditAudit LogAudit Logs
categoryAttributeTypeCategory AttributeCategory Attributes
websiteCurrencyCurrencyCurrencies
translationPropertyField TranslationField Translations
integrationJobLogJob LogJob Logs
jobDefinitionStepFieldMapJob Step Field MappingJob Step Field Mappings
websiteLanguageLanguageLanguages
salespersonSales RepSales Representatives
shipViaShipping ServiceShipping Services
applicationMessageSite MessageSite Messages
searchSynonymSynonymSynonyms
htmlRedirectURL RedirectURL Redirects
userProfileUserUsers
styleClassVariantVariants
styleTraitVariant TraitVariant Traits
styleTraitValueVariant Trait ValueVariant Trait Values
productWarehouseWarehouseWarehouses
websiteConfigurationWebsite SettingWebsite Settings

Property names (sorted by property name)

Entity NameProperty NameProperty Value
punchOutCustomerUserProfileMapaddressIdAddress
contentapprovedByUserProfileApproved By User
contentapprovedByUserProfileIdApproved By
contentapprovedOnApproved
userProfileapproverUserProfileIdApprover
attributeValueattributeTypeIdAttribute Type
categoryAttributeTypeattributeTypeIdAttribute Type
carrierbackUpCarrierIdBack Up Carrier
customerOrderbtAddress1Address 1
customerOrderbtAddress2Address 2
customerOrderbtAddress3Address 3
customerOrderbtAddress4Address 4
customerOrderbtCityCity
customerOrderbtCompanyNameCompany Name
customerOrderbtCountryCountry
customerOrderbtEmailEmail
customerOrderbtFirstNameFirst Name
customerOrderbtLastNameLast Name
customerOrderbtMiddleNameMiddle Name
customerOrderbtPhonePhone
customerOrderbtPostalCodePostal Code
customerOrderbtStateState
carrierPackagecarrierIdCarrier
carrierZonecarrierIdCarrier
shipChargecarrierIdCarrier
shipRulecarrierIdCarrier
carrierZonePostalCodeRangecarrierZoneIdCarrier Zone
categoryAttributeTypecategoryIdCategory
shippingRestrictioncategoryIdCategory
shipRulecategoryIdCategory
configurationOptioncomboConditionalListConditional List Values
configurationOptioncomboMultiSelectMultiple Selection Allowed
productconfigurationObjectIdConfiguration Object
integrationConnectionconnectionsLimitPeak Connections Limit
integrationConnectionconnectionStringGenerated String
integrationConnectionconnectionTimeoutIdle Timeout
configurationOptioncontainerFileLocationLocation
configurationOptioncontainerFileTypeType
categorycontentManagerCategory Description
productcontentManagerProduct Description
categorycontentManagerIdCategory Description
emailTemplatecontentManagerIdContent Manager
productcontentManagerIdProduct Description
customercountryIdCountry
shipRulecountryIdCountry
statecountryIdCountry
vendorcountryIdCountry
warehousecountryIdCountry
websitecountryIdCountry
contentcreatedByUserProfileCreated By User
contentcreatedByUserProfileIdCreated By
carriercurrencyIdCurrency
customercurrencyIdCurrency Code
userProfilecurrencyIdPreferred Currency
websiteCurrencycurrencyIdCurrency Code
punchOutCustomerUserProfileMapcustomerIdCustomer
shipRulecustomerIdCustomer
messageAuditcustomerOrderIdCustomer Order
customercustomerSequenceCustomer ShipTo Number
integrationJobdatasetFileLocationDataSet Name
integrationJobdataSizeDataSet Size
configurationOptiondateCheckRangeCheck Date Range
configurationOptiondateMaxDaysBackMax Days Back
configurationOptiondateMaxDaysForwardMax Days Forward
messagedateToDisplayDisplay Date
userProfiledefaultCustomerIdDefault Customer
customerdefaultWarehouseIdDefault Warehouse
jobDefinitionStepdeleteActionAction
jobDefinitionStepdeleteActionFieldToSetField To Set
jobDefinitionStepdeleteActionValueToSetValue To Set
contentdeviceTypeDevice
configurationdisplaySummaryDisplay configuration values on summary
websitedomainNameDomain Names
customerOrderdropShipCustomerDrop Ship
integrationJobdurationElapsed Time
emailListemailTemplateIdEmail Template
jobDefinitionemailTemplateIdEmail Template
carrierenableEnabled
shipChargeenableEnabled
integrationJobendDateTimeDate Completed
propertyConfigurationentityConfigurationIdEntity Configuration
customererpNumberERP BillTo Number
producterpNumberProduct Number
customererpSequenceERP ShipTo Number
integrationJoberrorCount/Errors
=======
jobDefinitionStepflatFileErrorHandlingMissing File Action
messageAuditfromUserProfileIdFrom User Profile
configurationhasSmartPartCreates a SmartPart number
customerOrderinitiatedByUserProfileInitiated By
jobDefinitionintegrationConnectionConnection
jobDefinitionintegrationConnectionIdConnection
jobDefinitionStepintegrationConnectionOverrideIdConnection Override
integrationJobintegrationJobLogsJob Logs
attributeTypeisActiveActive
attributeValueisActiveActive
carrierPackageisActiveActive
categoryAttributeTypeisActiveActive
countryisActiveActive
customerisActiveActive
customerCostCodeisActiveActive
shippingRestrictionisActiveActive
specificationisActiveActive
stateisActiveActive
styleClassisActiveActive
websiteisActiveActive
customerisBillToBill To
attributeTypeisComparableComparable
productisConfiguredConfigured
paymentMethodisCreditCardCredit Card
currencyisDefaultDefault Currency
languageisDefaultDefault System Language
personaisDefaultDefault
productUnitOfMeasureisDefaultDefault
shipViaisDefaultDefault
styleTraitValueisDefaultDefault Value
websiteCurrencyisDefaultDefault Website Currency
warehouseisDefaultWarehouseDefault Warehouse
productisDiscontinuedDiscontinued
customerisDropShipDrop Ship
categoryisDynamicDynamic
jobDefinitionStepFieldMapisErpKeyIs Dataset Key
categoryisFeaturedFeatured
attributeTypeisFilterFilterable
productisFixedConfigurationFixed Configuration
productisGiftCardGift Card
customerisGuestGuest
productisHazardousGoodHazardous Good
carrierisLiveLive
promotionisLiveLive
websiteCurrencyisLiveLive
countryisoCode2ISO alpha-2 Code
countryisoCode3ISO alpha-3 Code
productisOutOfStockOut Of Stock
salespersonisOutsideRepOutside Rep
userProfileisPasswordChangeRequiredPassword Change Required
carrierisPrimaryCarrierPrimary Carrier
productisQuoteRequiredQuote Required
configurationOptionisRequiredRequired
websiteisRestrictedRestricted Website
customerisShipToShip To
customerisSoldToSold To
productisSpecialOrderSpecial Order
productisSponsoredSponsored
productisSubscriptionSubscription
configurationOptionisVisibleVisible
integrationJobjobDefinitionIdJob Name
jobDefinitionStepjobDefinitionStepFieldMapsField Maps
configurationOptionlabelValueLabel
contentlanguageIdLanguage
messagelanguageIdLanguage
searchSynonymlanguageIdLanguage
translationDictionarylanguageIdLanguage
translationPropertylanguageIdLanguage
userProfilelanguageIdLanguage
websiteLanguagelanguageIdLanguage
productlargeImagePathLarge Image
jobDefinitionlinkedJobConditionLink Condition
jobDefinitionlinkedJobIdLinked Job
websitemapProductsToCategoriesAuto Map Products To Categories
jobDefinitionmaxDeactivationPercentMax Deactivation %
jobDefinitionmaxErrorsBeforeFailMax Errors Before Failing
jobDefinitionmaxWarningsBeforeFailMax Warnings Before Failing
productmediumImagePathMedium Image
integrationJobLogmessageDescription
messageStatusmessageIdMessage
customerProductnameCustomer Specific Name
customerProductSetnameRestriction Group Name
jobDefinitionnameJob Name
jobDefinitionStepnameStep Name
restrictionGroupnameRestriction Group Name
translationPropertynameProperty Name
jobDefinitionnotifyEmailNotification Email List
configurationOptionnumberDecimalsNumber of Decimals
configurationOptionnumberMaxValueMaximum Value
configurationOptionnumberMinValueMinimum Value
jobDefinitionStepobjectNameTarget Object
configurationoverrideOnRefreshOverride local configuration on refresh
jobDefinitionStepFieldMapoverwriteCan Overwrite
configurationPagepageNumberPage #
configurationPagepageTitleTitle
categoryparentParent Category
customerparentParent Customer
categoryparentIdParent Category
customerparentIdParent
translationPropertyparentTableParent Object
websiteparentWebsiteIdParent Website
contentpersonaIdPersona
salespersonphone1Phone
customerpricingCustomerIdPricing Customer
customerprimarySalespersonPrimary Sales Rep
customerprimarySalespersonIdPrimary Sales Rep
customerProductproductIdProduct
productWarehouseproductIdProduct
shippingRestrictionproductIdProduct
shipRuleproductIdProduct
productproductWarehousesWarehouses
contentpublishToProductionOnPublish
productUnitOfMeasureqtyPerBaseUnitOfMeasureQty Per U/M
configurationOptionConditionqueryDisplayFieldDisplay Field
configurationOptionConditionqueryInputFieldInput Field
configurationOptionradioButtonOrientationDisplay Orientation
integrationJobrecordCountTotal
integrationJobrecordsAddedAdded
integrationJobrecordsDeletedDeleted
integrationJobrecordsModifiedModified
jobDefinitionrecurringEndDateTimeEnd Date/Time
jobDefinitionrecurringIntervalRepeat Every
jobDefinitionrecurringJobRun as a Recurring Job
jobDefinitionrecurringStartDateTimeStart Date/Time
searchTermRedirectredirectUriRedirect URL
productreplacementProductIdReplacement Product
productrestrictionGroupIdRestriction Group
carrierruleManagerIdRule Manager
categoryruleManagerIdRule Manager
shipViaruleManagerIdRule Manager
ruleTypeOptionruleTypeIdRule Type
ruleClauseruleTypeOptionIdRule Type Option
integrationJobrunStandaloneSkip Linked Jobs
salespersonsalesManagerIdSales Manager
customerOrdersalespersonSales Rep
invoiceHistorysalespersonSales Rep
orderHistorysalespersonSales Rep
userProfilesalespersonSales Rep
customerOrdersalespersonIdSales Rep
salespersonsalespersonNumberSales Rep Number
integrationJobscheduleDateTimeDate Scheduled
configurationOptionConditionscriptConditionCondition Script
configurationOptionscriptOnEntryOn Entry Script
configurationPagescriptOnEntryOn Entry Script
configurationscriptOnFinalizeFinalize Script
configurationscriptOnInitializeInitialize Script
configurationOptionscriptOnLeaveOn Leave Script
configurationPagescriptOnLeaveOn Leave Script
configurationscriptOnPricingRequestPricing Request Script - C#
configurationPagescriptPassFailPass/Fail Script
configurationOptionscriptPromptWhenPrompt When Script
configurationPagescriptPromptWhenPrompt When Script
configurationOptionselectionListDisplaysDisplay Value
configurationOptionConditionselectionListDisplaysDisplay Value
configurationOptionselectionListPriceAdjustmentPrice
configurationOptionConditionselectionListPriceAdjustmentPrice
configurationOptionselectionListValuesInput Value
configurationOptionConditionselectionListValuesInput Value
configurationOptionsetAsFutureDefaultDefault for other configurations
customershipCodeDefault Shipping Service
shipRuleshipRateIdShip Rate
customerBudgetshipToCustomerShip To
shipChargeshipViaIdShip Via
shipRuleshipViaIdShip Via
categoryshortDescriptionCategory Title
productshortDescriptionProduct Title
configurationPageskipIfNoInputsSkip Page if no active inputs
configurationPageskipScriptsIfNoInputsSkip Scripts if no active inputs
productsmallImagePathSmall Image
configurationsmartPartPrefixPrefix
configurationsmartPartSeparatorSeparator
customerOrderstAddress1Address 1
customerOrderstAddress2Address 2
customerOrderstAddress3Address 3
customerOrderstAddress4Address 4
integrationJobstartDateTimeDate Started
customerstateIdState
shippingRestrictionstateIdState
shipRulestateIdState
customerOrderstCityCity
customerOrderstCompanyNameCompany Name
customerOrderstCountryCountry
customerOrderstEmailEmail
customerOrderstFirstNameFirst Name
customerOrderstLastNameLast Name
customerOrderstMiddleNameMiddle Name
customerOrderstPhonePhone
customerOrderstPostalCodePostal Code
customerOrderstStateState
productstyleChildrenVariant Children
productstyleClassVariant Type
productstyleClassIdVariant Type
productstyleParentIdVariant Parent
styleClassstyleTraitsVariant Traits
styleTraitstyleTraitValuesVariant Trait Values
productsubscriptionShipViaIdSubscription Ship Via
categoryRelatedProductsystemListValueIdProduct Relationship System List Value ID
productRelatedProductsystemListValueIdProduct Relationship System List Value ID
customertermsCodeDefault Payment Method
configurationOptiontextCharacterTypeCharacter Types
configurationOptiontextIsMultilineMultiline Entry
configurationOptiontextMaxLengthMaximum Length
configurationOptiontextMinLengthMinimum Length
configurationOptiontextValidEntryListValidation List
messageAudittoUserProfileIdTo User Profile
translationPropertytranslatedValueTranslation
integrationJobLogtypeNameType
productUnitOfMeasureunitOfMeasureU/M
messageStatususerProfileIdUser Profile
punchOutCustomerUserProfileMapuserProfileIdUser Profile
salespersonuserProfileIdUser Profile
productvendorIdVendor
productWarehousewarehouseIdWarehouse
integrationJobwarningCount/Warnings
=========
applicationMessagewebsiteIdWebsite Target
categorywebsiteIdWebsite
searchTermRedirectwebsiteIdWebsite
websiteCurrencywebsiteIdWebsite
websiteLanguagewebsiteIdWebsite
searchSynonymwordKeyword
configurationOptionxPositionX-Position
configurationOptionyPositionY-Position