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 Name | Label | Pluralized Label |
|---|---|---|
| productUnitOfMeasure | Alternate Unit of Measure | Alternate Units of Measure |
| attributeType | Attribute | Attributes |
| audit | Audit Log | Audit Logs |
| categoryAttributeType | Category Attribute | Category Attributes |
| websiteCurrency | Currency | Currencies |
| translationProperty | Field Translation | Field Translations |
| integrationJobLog | Job Log | Job Logs |
| jobDefinitionStepFieldMap | Job Step Field Mapping | Job Step Field Mappings |
| websiteLanguage | Language | Languages |
| salesperson | Sales Rep | Sales Representatives |
| shipVia | Shipping Service | Shipping Services |
| applicationMessage | Site Message | Site Messages |
| searchSynonym | Synonym | Synonyms |
| htmlRedirect | URL Redirect | URL Redirects |
| userProfile | User | Users |
| styleClass | Variant | Variants |
| styleTrait | Variant Trait | Variant Traits |
| styleTraitValue | Variant Trait Value | Variant Trait Values |
| productWarehouse | Warehouse | Warehouses |
| websiteConfiguration | Website Setting | Website Settings |
Property names (sorted by property name)
| Entity Name | Property Name | Property Value |
|---|---|---|
| punchOutCustomerUserProfileMap | addressId | Address |
| content | approvedByUserProfile | Approved By User |
| content | approvedByUserProfileId | Approved By |
| content | approvedOn | Approved |
| userProfile | approverUserProfileId | Approver |
| attributeValue | attributeTypeId | Attribute Type |
| categoryAttributeType | attributeTypeId | Attribute Type |
| carrier | backUpCarrierId | Back Up Carrier |
| customerOrder | btAddress1 | Address 1 |
| customerOrder | btAddress2 | Address 2 |
| customerOrder | btAddress3 | Address 3 |
| customerOrder | btAddress4 | Address 4 |
| customerOrder | btCity | City |
| customerOrder | btCompanyName | Company Name |
| customerOrder | btCountry | Country |
| customerOrder | btEmail | |
| customerOrder | btFirstName | First Name |
| customerOrder | btLastName | Last Name |
| customerOrder | btMiddleName | Middle Name |
| customerOrder | btPhone | Phone |
| customerOrder | btPostalCode | Postal Code |
| customerOrder | btState | State |
| carrierPackage | carrierId | Carrier |
| carrierZone | carrierId | Carrier |
| shipCharge | carrierId | Carrier |
| shipRule | carrierId | Carrier |
| carrierZonePostalCodeRange | carrierZoneId | Carrier Zone |
| categoryAttributeType | categoryId | Category |
| shippingRestriction | categoryId | Category |
| shipRule | categoryId | Category |
| configurationOption | comboConditionalList | Conditional List Values |
| configurationOption | comboMultiSelect | Multiple Selection Allowed |
| product | configurationObjectId | Configuration Object |
| integrationConnection | connectionsLimit | Peak Connections Limit |
| integrationConnection | connectionString | Generated String |
| integrationConnection | connectionTimeout | Idle Timeout |
| configurationOption | containerFileLocation | Location |
| configurationOption | containerFileType | Type |
| category | contentManager | Category Description |
| product | contentManager | Product Description |
| category | contentManagerId | Category Description |
| emailTemplate | contentManagerId | Content Manager |
| product | contentManagerId | Product Description |
| customer | countryId | Country |
| shipRule | countryId | Country |
| state | countryId | Country |
| vendor | countryId | Country |
| warehouse | countryId | Country |
| website | countryId | Country |
| content | createdByUserProfile | Created By User |
| content | createdByUserProfileId | Created By |
| carrier | currencyId | Currency |
| customer | currencyId | Currency Code |
| userProfile | currencyId | Preferred Currency |
| websiteCurrency | currencyId | Currency Code |
| punchOutCustomerUserProfileMap | customerId | Customer |
| shipRule | customerId | Customer |
| messageAudit | customerOrderId | Customer Order |
| customer | customerSequence | Customer ShipTo Number |
| integrationJob | datasetFileLocation | DataSet Name |
| integrationJob | dataSize | DataSet Size |
| configurationOption | dateCheckRange | Check Date Range |
| configurationOption | dateMaxDaysBack | Max Days Back |
| configurationOption | dateMaxDaysForward | Max Days Forward |
| message | dateToDisplay | Display Date |
| userProfile | defaultCustomerId | Default Customer |
| customer | defaultWarehouseId | Default Warehouse |
| jobDefinitionStep | deleteAction | Action |
| jobDefinitionStep | deleteActionFieldToSet | Field To Set |
| jobDefinitionStep | deleteActionValueToSet | Value To Set |
| content | deviceType | Device |
| configuration | displaySummary | Display configuration values on summary |
| website | domainName | Domain Names |
| customerOrder | dropShipCustomer | Drop Ship |
| integrationJob | duration | Elapsed Time |
| emailList | emailTemplateId | Email Template |
| jobDefinition | emailTemplateId | Email Template |
| carrier | enable | Enabled |
| shipCharge | enable | Enabled |
| integrationJob | endDateTime | Date Completed |
| propertyConfiguration | entityConfigurationId | Entity Configuration |
| customer | erpNumber | ERP BillTo Number |
| product | erpNumber | Product Number |
| customer | erpSequence | ERP ShipTo Number |
| integrationJob | errorCount | /Errors |
| ======= | ||
| jobDefinitionStep | flatFileErrorHandling | Missing File Action |
| messageAudit | fromUserProfileId | From User Profile |
| configuration | hasSmartPart | Creates a SmartPart number |
| customerOrder | initiatedByUserProfile | Initiated By |
| jobDefinition | integrationConnection | Connection |
| jobDefinition | integrationConnectionId | Connection |
| jobDefinitionStep | integrationConnectionOverrideId | Connection Override |
| integrationJob | integrationJobLogs | Job Logs |
| attributeType | isActive | Active |
| attributeValue | isActive | Active |
| carrierPackage | isActive | Active |
| categoryAttributeType | isActive | Active |
| country | isActive | Active |
| customer | isActive | Active |
| customerCostCode | isActive | Active |
| shippingRestriction | isActive | Active |
| specification | isActive | Active |
| state | isActive | Active |
| styleClass | isActive | Active |
| website | isActive | Active |
| customer | isBillTo | Bill To |
| attributeType | isComparable | Comparable |
| product | isConfigured | Configured |
| paymentMethod | isCreditCard | Credit Card |
| currency | isDefault | Default Currency |
| language | isDefault | Default System Language |
| persona | isDefault | Default |
| productUnitOfMeasure | isDefault | Default |
| shipVia | isDefault | Default |
| styleTraitValue | isDefault | Default Value |
| websiteCurrency | isDefault | Default Website Currency |
| warehouse | isDefaultWarehouse | Default Warehouse |
| product | isDiscontinued | Discontinued |
| customer | isDropShip | Drop Ship |
| category | isDynamic | Dynamic |
| jobDefinitionStepFieldMap | isErpKey | Is Dataset Key |
| category | isFeatured | Featured |
| attributeType | isFilter | Filterable |
| product | isFixedConfiguration | Fixed Configuration |
| product | isGiftCard | Gift Card |
| customer | isGuest | Guest |
| product | isHazardousGood | Hazardous Good |
| carrier | isLive | Live |
| promotion | isLive | Live |
| websiteCurrency | isLive | Live |
| country | isoCode2 | ISO alpha-2 Code |
| country | isoCode3 | ISO alpha-3 Code |
| product | isOutOfStock | Out Of Stock |
| salesperson | isOutsideRep | Outside Rep |
| userProfile | isPasswordChangeRequired | Password Change Required |
| carrier | isPrimaryCarrier | Primary Carrier |
| product | isQuoteRequired | Quote Required |
| configurationOption | isRequired | Required |
| website | isRestricted | Restricted Website |
| customer | isShipTo | Ship To |
| customer | isSoldTo | Sold To |
| product | isSpecialOrder | Special Order |
| product | isSponsored | Sponsored |
| product | isSubscription | Subscription |
| configurationOption | isVisible | Visible |
| integrationJob | jobDefinitionId | Job Name |
| jobDefinitionStep | jobDefinitionStepFieldMaps | Field Maps |
| configurationOption | labelValue | Label |
| content | languageId | Language |
| message | languageId | Language |
| searchSynonym | languageId | Language |
| translationDictionary | languageId | Language |
| translationProperty | languageId | Language |
| userProfile | languageId | Language |
| websiteLanguage | languageId | Language |
| product | largeImagePath | Large Image |
| jobDefinition | linkedJobCondition | Link Condition |
| jobDefinition | linkedJobId | Linked Job |
| website | mapProductsToCategories | Auto Map Products To Categories |
| jobDefinition | maxDeactivationPercent | Max Deactivation % |
| jobDefinition | maxErrorsBeforeFail | Max Errors Before Failing |
| jobDefinition | maxWarningsBeforeFail | Max Warnings Before Failing |
| product | mediumImagePath | Medium Image |
| integrationJobLog | message | Description |
| messageStatus | messageId | Message |
| customerProduct | name | Customer Specific Name |
| customerProductSet | name | Restriction Group Name |
| jobDefinition | name | Job Name |
| jobDefinitionStep | name | Step Name |
| restrictionGroup | name | Restriction Group Name |
| translationProperty | name | Property Name |
| jobDefinition | notifyEmail | Notification Email List |
| configurationOption | numberDecimals | Number of Decimals |
| configurationOption | numberMaxValue | Maximum Value |
| configurationOption | numberMinValue | Minimum Value |
| jobDefinitionStep | objectName | Target Object |
| configuration | overrideOnRefresh | Override local configuration on refresh |
| jobDefinitionStepFieldMap | overwrite | Can Overwrite |
| configurationPage | pageNumber | Page # |
| configurationPage | pageTitle | Title |
| category | parent | Parent Category |
| customer | parent | Parent Customer |
| category | parentId | Parent Category |
| customer | parentId | Parent |
| translationProperty | parentTable | Parent Object |
| website | parentWebsiteId | Parent Website |
| content | personaId | Persona |
| salesperson | phone1 | Phone |
| customer | pricingCustomerId | Pricing Customer |
| customer | primarySalesperson | Primary Sales Rep |
| customer | primarySalespersonId | Primary Sales Rep |
| customerProduct | productId | Product |
| productWarehouse | productId | Product |
| shippingRestriction | productId | Product |
| shipRule | productId | Product |
| product | productWarehouses | Warehouses |
| content | publishToProductionOn | Publish |
| productUnitOfMeasure | qtyPerBaseUnitOfMeasure | Qty Per U/M |
| configurationOptionCondition | queryDisplayField | Display Field |
| configurationOptionCondition | queryInputField | Input Field |
| configurationOption | radioButtonOrientation | Display Orientation |
| integrationJob | recordCount | Total |
| integrationJob | recordsAdded | Added |
| integrationJob | recordsDeleted | Deleted |
| integrationJob | recordsModified | Modified |
| jobDefinition | recurringEndDateTime | End Date/Time |
| jobDefinition | recurringInterval | Repeat Every |
| jobDefinition | recurringJob | Run as a Recurring Job |
| jobDefinition | recurringStartDateTime | Start Date/Time |
| searchTermRedirect | redirectUri | Redirect URL |
| product | replacementProductId | Replacement Product |
| product | restrictionGroupId | Restriction Group |
| carrier | ruleManagerId | Rule Manager |
| category | ruleManagerId | Rule Manager |
| shipVia | ruleManagerId | Rule Manager |
| ruleTypeOption | ruleTypeId | Rule Type |
| ruleClause | ruleTypeOptionId | Rule Type Option |
| integrationJob | runStandalone | Skip Linked Jobs |
| salesperson | salesManagerId | Sales Manager |
| customerOrder | salesperson | Sales Rep |
| invoiceHistory | salesperson | Sales Rep |
| orderHistory | salesperson | Sales Rep |
| userProfile | salesperson | Sales Rep |
| customerOrder | salespersonId | Sales Rep |
| salesperson | salespersonNumber | Sales Rep Number |
| integrationJob | scheduleDateTime | Date Scheduled |
| configurationOptionCondition | scriptCondition | Condition Script |
| configurationOption | scriptOnEntry | On Entry Script |
| configurationPage | scriptOnEntry | On Entry Script |
| configuration | scriptOnFinalize | Finalize Script |
| configuration | scriptOnInitialize | Initialize Script |
| configurationOption | scriptOnLeave | On Leave Script |
| configurationPage | scriptOnLeave | On Leave Script |
| configuration | scriptOnPricingRequest | Pricing Request Script - C# |
| configurationPage | scriptPassFail | Pass/Fail Script |
| configurationOption | scriptPromptWhen | Prompt When Script |
| configurationPage | scriptPromptWhen | Prompt When Script |
| configurationOption | selectionListDisplays | Display Value |
| configurationOptionCondition | selectionListDisplays | Display Value |
| configurationOption | selectionListPriceAdjustment | Price |
| configurationOptionCondition | selectionListPriceAdjustment | Price |
| configurationOption | selectionListValues | Input Value |
| configurationOptionCondition | selectionListValues | Input Value |
| configurationOption | setAsFutureDefault | Default for other configurations |
| customer | shipCode | Default Shipping Service |
| shipRule | shipRateId | Ship Rate |
| customerBudget | shipToCustomer | Ship To |
| shipCharge | shipViaId | Ship Via |
| shipRule | shipViaId | Ship Via |
| category | shortDescription | Category Title |
| product | shortDescription | Product Title |
| configurationPage | skipIfNoInputs | Skip Page if no active inputs |
| configurationPage | skipScriptsIfNoInputs | Skip Scripts if no active inputs |
| product | smallImagePath | Small Image |
| configuration | smartPartPrefix | Prefix |
| configuration | smartPartSeparator | Separator |
| customerOrder | stAddress1 | Address 1 |
| customerOrder | stAddress2 | Address 2 |
| customerOrder | stAddress3 | Address 3 |
| customerOrder | stAddress4 | Address 4 |
| integrationJob | startDateTime | Date Started |
| customer | stateId | State |
| shippingRestriction | stateId | State |
| shipRule | stateId | State |
| customerOrder | stCity | City |
| customerOrder | stCompanyName | Company Name |
| customerOrder | stCountry | Country |
| customerOrder | stEmail | |
| customerOrder | stFirstName | First Name |
| customerOrder | stLastName | Last Name |
| customerOrder | stMiddleName | Middle Name |
| customerOrder | stPhone | Phone |
| customerOrder | stPostalCode | Postal Code |
| customerOrder | stState | State |
| product | styleChildren | Variant Children |
| product | styleClass | Variant Type |
| product | styleClassId | Variant Type |
| product | styleParentId | Variant Parent |
| styleClass | styleTraits | Variant Traits |
| styleTrait | styleTraitValues | Variant Trait Values |
| product | subscriptionShipViaId | Subscription Ship Via |
| categoryRelatedProduct | systemListValueId | Product Relationship System List Value ID |
| productRelatedProduct | systemListValueId | Product Relationship System List Value ID |
| customer | termsCode | Default Payment Method |
| configurationOption | textCharacterType | Character Types |
| configurationOption | textIsMultiline | Multiline Entry |
| configurationOption | textMaxLength | Maximum Length |
| configurationOption | textMinLength | Minimum Length |
| configurationOption | textValidEntryList | Validation List |
| messageAudit | toUserProfileId | To User Profile |
| translationProperty | translatedValue | Translation |
| integrationJobLog | typeName | Type |
| productUnitOfMeasure | unitOfMeasure | U/M |
| messageStatus | userProfileId | User Profile |
| punchOutCustomerUserProfileMap | userProfileId | User Profile |
| salesperson | userProfileId | User Profile |
| product | vendorId | Vendor |
| productWarehouse | warehouseId | Warehouse |
| integrationJob | warningCount | /Warnings |
| ========= | ||
| applicationMessage | websiteId | Website Target |
| category | websiteId | Website |
| searchTermRedirect | websiteId | Website |
| websiteCurrency | websiteId | Website |
| websiteLanguage | websiteId | Website |
| searchSynonym | word | Keyword |
| configurationOption | xPosition | X-Position |
| configurationOption | yPosition | Y-Position |
Updated over 1 year ago