Goods Product DMO

Object Properties

Object API Name: ssot__GoodsProduct__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

Relationships

• PrimaryProductCategory has a FOREIGNKEY relationship with the Product Category DMO Id field.
• MasterProductId has a FOREIGNKEY relationship with the Master Product DMO Id field.
• MasterProductId has a FOREIGNKEY relationship with the Bundle Product DMO Id field.
• BrandId has a FOREIGNKEY relationship with the Brand DMO Id field.
• MasterProductId has a FOREIGNKEY relationship with the Goods Product DMO Id field.

Fields

• AgeId
• AllowCustomerReturn
• AllowPartialRefund
• BrandId
• CanUseQuantitySchedule
• CanUseRevenueSchedule
• cdp_sys_record_currency
• ColorId
• CreatedDate
• DataSourceId
• DataSourceObjectId
• Depth
• Description
• Diameter
• DisposalTypeId
• DrainedWeight
• EnvironmentRequirementId
• ExternalRecordId
• ExternalSourceId
• ExternalSourceRecordId
• FabricId
• GenderId
• GlAccountCode
• GrossWeight
• Height
• Id
• InternalOrganizationId
• IsAutoProvisionable
• IsBackOrdered
• IsCouponRedemptionAllowed
• IsCustomerDiscountAllowed
• IsDynamicBundle
• IsFoodstampPaymentAllowed
• IsInstallable
• IsIntellectualPropertyProtected
• IsMadeToOrder
• IsManualPriceEntryRequired
• IsMultipleCouponsAllowed
• IsPartnerDiscountAllowed
• IsPerishable
• IsPreOrderable
• IsQualityVerificationRequired
• IsQuantityEntryRequired
• IsRainCheckAllowed
• IsReturnable
• IsSellable
• IsSellableIndependently
• IsSellableWithoutPrice
• IsSerialized
• IsWeightEntryRequired
• IsWorkerDiscountAllowed
• KQ_BrandId
• KQ_Id
• KQ_MasterProductId
• KQ_PrimaryProductCategory
• LastModifiedDate
• LongDescription
• LotIdentifier
• ManufacturerName
• MasterProductId
• MaxHoldingDayCount
• MaximumOrderQuantityCount
• MinimumAdvertisementAmount
• MinimumAdvertisementAmountCurrency
• MinimumAdvertisementAmountStartDate
• MinimumOrderQuantityCount
• ModelNumber
• ModelYear
• MSRPAmount
• MSRPAmountCurrency
• Name
• NetWeight
• PackagedInCountry
• PatternId
• PriceChargeTypeId
• PrimaryProductCategory
• PrimarySalesChannelId
• ProducedInCountry
• ProductMayExpand
• ProductSecurityRequirementId
• ProductSKU
• ProductStatusId
• QuantityInstallmentCount
• QuantityInstallmentPeriodId
• QuantityScheduleTypeId
• RequiredCleanupProcessId
• RequiredDepositAmount
• RequiredDepositAmountCurrency
• RequiredDepositPercentage
• RequiredHumidityPercentage
• RequiredTemperatureHighestNumber
• RequiredTemperatureLowestNumber
• RequiredTemperatureUOMId
• RequiresInvididualUnitPricing
• RequiresUnitPriceLabel
• RevenueInstallmentCount
• RevenueInstallmentPeriodId
• RevenueScheduleTypeId
• RewardProgramPointsCount
• SeasonId
• ServiceEntitlementTemplateId
• ShelfFacingUnitCount
• SizeUOMId
• StandardWarrantyLengthMonth
• StockLedgerValuationAmount
• StockLedgerValuationAmountCurrency
• StyleId
• TareWeight
• ValidForPeriodCount
• ValidForPeriodUOMId
• ValidFromDate
• ValidToDate
• VersionNumber
• WeightUOMId
• Width

AgeId

• Field API Name: ssot__AgeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

AllowCustomerReturn

• Field API Name: ssot__AllowCustomerReturn__c
• Data Type: TEXT
• Description: Alphanumeric string representing the allow customer return.

AllowPartialRefund

• Field API Name: ssot__AllowPartialRefund__c
• Data Type: TEXT
• Description: Alphanumeric string representing the allow partial refund.

BrandId

• Field API Name: ssot__BrandId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

CanUseQuantitySchedule

• Field API Name: ssot__CanUseQuantitySchedule__c
• Data Type: TEXT
• Description: Alphanumeric string representing the can use quantity schedule.

CanUseRevenueSchedule

• Field API Name: ssot__CanUseRevenueSchedule__c
• Data Type: TEXT
• Description: Alphanumeric string representing the can use revenue schedule.

cdp_sys_record_currency

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

ColorId

• Field API Name: ssot__ColorId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

CreatedDate

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

DataSourceId

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DataSourceObjectId

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

Depth

• Field API Name: ssot__Depth__c
• Data Type: DOUBLE
• Description: What is the depth size of the product.

Description

• Field API Name: ssot__Description__c
• Data Type: TEXT
• Description: Description of this record.

Diameter

• Field API Name: ssot__Diameter__c
• Data Type: DOUBLE
• Description: What is the diameter size of the cylindracal product.

DisposalTypeId

• Field API Name: ssot__DisposalTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DrainedWeight

• Field API Name: ssot__DrainedWeight__c
• Data Type: DOUBLE
• Description: What is the weigth of the product excluding packaging after drainage.

EnvironmentRequirementId

• Field API Name: ssot__EnvironmentRequirementId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ExternalRecordId

• Field API Name: ssot__ExternalRecordId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ExternalSourceId

• Field API Name: ssot__ExternalSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ExternalSourceRecordId

• Field API Name: ssot__ExternalSourceRecordId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

FabricId

• Field API Name: ssot__FabricId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

GenderId

• Field API Name: ssot__GenderId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

GlAccountCode

• Field API Name: ssot__GlAccountCode__c
• Data Type: TEXT
• Description: Alphanumeric string representing the gl account code.

GrossWeight

• Field API Name: ssot__GrossWeight__c
• Data Type: DOUBLE
• Description: What is the weight of the product in its original packaging.

Height

• Field API Name: ssot__Height__c
• Data Type: DOUBLE
• Description: Numeric value representing the height. Do not include currency symbols or commas.

Id

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this GoodsProduct record. Maximum size is 36 characters.

InternalOrganizationId

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

IsAutoProvisionable

• Field API Name: ssot__IsAutoProvisionable__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is auto provisionable.

IsBackOrdered

• Field API Name: ssot__IsBackOrdered__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is back ordered.

IsCouponRedemptionAllowed

• Field API Name: ssot__IsCouponRedemptionAllowed__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is coupon redemption allowed.

IsCustomerDiscountAllowed

• Field API Name: ssot__IsCustomerDiscountAllowed__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is customer discount allowed.

IsDynamicBundle

• Field API Name: ssot__IsDynamicBundle__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is dynamic bundle.

IsFoodstampPaymentAllowed

• Field API Name: ssot__IsFoodstampPaymentAllowed__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is foodstamp payment allowed.

IsInstallable

• Field API Name: ssot__IsInstallable__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is installable.

IsIntellectualPropertyProtected

• Field API Name: ssot__IsIntellectualPropertyProtected__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is intellectual property protected.

IsMadeToOrder

• Field API Name: ssot__IsMadeToOrder__c
• Data Type: TEXT
• Description: Does product only exist once it was ordered. For example, monogrammed birth day cake.

IsManualPriceEntryRequired

• Field API Name: ssot__IsManualPriceEntryRequired__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is manual price entry required.

IsMultipleCouponsAllowed

• Field API Name: ssot__IsMultipleCouponsAllowed__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is multiple coupons allowed.

IsPartnerDiscountAllowed

• Field API Name: ssot__IsPartnerDiscountAllowed__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is partner discount allowed.

IsPerishable

• Field API Name: ssot__IsPerishable__c
• Data Type: TEXT
• Description: Is this a stable or perishable item.

IsPreOrderable

• Field API Name: ssot__IsPreOrderable__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is pre orderable.

IsQualityVerificationRequired

• Field API Name: ssot__IsQualityVerificationRequired__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is quality verification required.

IsQuantityEntryRequired

• Field API Name: ssot__IsQuantityEntryRequired__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is quantity entry required.

IsRainCheckAllowed

• Field API Name: ssot__IsRainCheckAllowed__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is rain check allowed.

IsReturnable

• Field API Name: ssot__IsReturnable__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is returnable.

IsSellable

• Field API Name: ssot__IsSellable__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is sellable.

IsSellableIndependently

• Field API Name: ssot__IsSellableIndependently__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is sellable independently.

IsSellableWithoutPrice

• Field API Name: ssot__IsSellableWithoutPrice__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is sellable without price.

IsSerialized

• Field API Name: ssot__IsSerialized__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is serialized.

IsWeightEntryRequired

• Field API Name: ssot__IsWeightEntryRequired__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is weight entry required.

IsWorkerDiscountAllowed

• Field API Name: ssot__IsWorkerDiscountAllowed__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is worker discount allowed.

KQ_BrandId

• Field API Name: KQ_BrandId__c
• Data Type: TEXT
• Description: Key Qualifier system field for BrandId

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_MasterProductId

• Field API Name: KQ_MasterProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MasterProductId

KQ_PrimaryProductCategory

• Field API Name: KQ_PrimaryProductCategory__c
• Data Type: TEXT
• Description: Key Qualifier system field for PrimaryProductCategory

LastModifiedDate

• Field API Name: ssot__LastModifiedDate__c
• Data Type: DATETIME
• Description: The date and time of the last modification to this record.

LongDescription

• Field API Name: ssot__LongDescription__c
• Data Type: TEXT
• Description: Alphanumeric string representing the long description.

LotIdentifier

• Field API Name: ssot__LotIdentifier__c
• Data Type: TEXT
• Description: Alphanumeric string representing the lot identifier.

ManufacturerName

• Field API Name: ssot__ManufacturerName__c
• Data Type: TEXT
• Description: The manufacturer name for the product.

MasterProductId

• Field API Name: ssot__MasterProductId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

MaxHoldingDayCount

• Field API Name: ssot__MaxHoldingDayCount__c
• Data Type: DOUBLE
• Description: How long. For example, drug or newspaper can be displayed before removal.

MaximumOrderQuantityCount

• Field API Name: ssot__MaximumOrderQuantityCount__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

MinimumAdvertisementAmount

• Field API Name: ssot__MinimumAdvertisementAmount__c
• Data Type: DOUBLE
• Description: Numeric value representing the minimum advertisement amount. Do not include currency symbols or commas.

MinimumAdvertisementAmountCurrency

• Field API Name: ssot__MinimumAdvertisementAmountCurrency__c
• Data Type: TEXT
• Description: Alphanumeric string representing the minimum advertisement amount currency.

MinimumAdvertisementAmountStartDate

• Field API Name: ssot__MinimumAdvertisementAmountStartDate__c
• Data Type: DOUBLE
• Description: Numeric value representing the minimum advertisement amount start date. Do not include currency symbols or commas.

MinimumOrderQuantityCount

• Field API Name: ssot__MinimumOrderQuantityCount__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

ModelNumber

• Field API Name: ssot__ModelNumber__c
• Data Type: TEXT
• Description: Alphanumeric string representing the model number.

ModelYear

• Field API Name: ssot__ModelYear__c
• Data Type: DOUBLE
• Description: The year when the model of the product was first launched.

MSRPAmount

• Field API Name: ssot__MSRPAmount__c
• Data Type: DOUBLE
• Description: Numeric value representing the msrpamount. Do not include currency symbols or commas.

MSRPAmountCurrency

• Field API Name: ssot__MSRPAmountCurrency__c
• Data Type: TEXT
• Description: Alphanumeric string representing the msrpamount currency.

Name

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: The primary name or label for this record.

NetWeight

• Field API Name: ssot__NetWeight__c
• Data Type: DOUBLE
• Description: What is the weight of the product excluding packaging.

PackagedInCountry

• Field API Name: ssot__PackagedInCountry__c
• Data Type: TEXT
• Description: Alphanumeric string representing the packaged in country.

PatternId

• Field API Name: ssot__PatternId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

PriceChargeTypeId

• Field API Name: ssot__PriceChargeTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

PrimaryProductCategory

• Field API Name: ssot__PrimaryProductCategory__c
• Data Type: TEXT
• Description: Alphanumeric string representing the primary product category.

PrimarySalesChannelId

• Field API Name: ssot__PrimarySalesChannelId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ProducedInCountry

• Field API Name: ssot__ProducedInCountry__c
• Data Type: TEXT
• Description: Alphanumeric string representing the produced in country.

ProductMayExpand

• Field API Name: ssot__ProductMayExpand__c
• Data Type: TEXT
• Description: Indicates product may become bigger under certain circumstances. For example, heat.

ProductSecurityRequirementId

• Field API Name: ssot__ProductSecurityRequirementId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ProductSKU

• Field API Name: ssot__ProductSKU__c
• Data Type: TEXT
• Description: Alphanumeric string representing the product sku.

ProductStatusId

• Field API Name: ssot__ProductStatusId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

QuantityInstallmentCount

• Field API Name: ssot__QuantityInstallmentCount__c
• Data Type: DOUBLE
• Description: The count or numerical value of the quantity for this record.

QuantityInstallmentPeriodId

• Field API Name: ssot__QuantityInstallmentPeriodId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

QuantityScheduleTypeId

• Field API Name: ssot__QuantityScheduleTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

RequiredCleanupProcessId

• Field API Name: ssot__RequiredCleanupProcessId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

RequiredDepositAmount

• Field API Name: ssot__RequiredDepositAmount__c
• Data Type: DOUBLE
• Description: Numeric value representing the required deposit amount. Do not include currency symbols or commas.

RequiredDepositAmountCurrency

• Field API Name: ssot__RequiredDepositAmountCurrency__c
• Data Type: TEXT
• Description: Alphanumeric string representing the required deposit amount currency.

RequiredDepositPercentage

• Field API Name: ssot__RequiredDepositPercentage__c
• Data Type: DOUBLE
• Description: Numeric value representing the required deposit percentage. Do not include currency symbols or commas.

RequiredHumidityPercentage

• Field API Name: ssot__RequiredHumidityPercentage__c
• Data Type: DOUBLE
• Description: Humidity required for product. For example, 50%.

RequiredTemperatureHighestNumber

• Field API Name: ssot__RequiredTemperatureHighestNumber__c
• Data Type: DOUBLE
• Description: Highest temperature allowed for product. For example, +20.

RequiredTemperatureLowestNumber

• Field API Name: ssot__RequiredTemperatureLowestNumber__c
• Data Type: DOUBLE
• Description: Lowest temperature allowed for product. For example, -1.

RequiredTemperatureUOMId

• Field API Name: ssot__RequiredTemperatureUOMId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

RequiresInvididualUnitPricing

• Field API Name: ssot__RequiresInvididualUnitPricing__c
• Data Type: TEXT
• Description: Alphanumeric string representing the requires invididual unit pricing.

RequiresUnitPriceLabel

• Field API Name: ssot__RequiresUnitPriceLabel__c
• Data Type: TEXT
• Description: Must a label of the price be visible for the product or not.

RevenueInstallmentCount

• Field API Name: ssot__RevenueInstallmentCount__c
• Data Type: DOUBLE
• Description: The number of revenue installments for this record.

RevenueInstallmentPeriodId

• Field API Name: ssot__RevenueInstallmentPeriodId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

RevenueScheduleTypeId

• Field API Name: ssot__RevenueScheduleTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

RewardProgramPointsCount

• Field API Name: ssot__RewardProgramPointsCount__c
• Data Type: DOUBLE
• Description: The number of reward program points for this record.

SeasonId

• Field API Name: ssot__SeasonId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ServiceEntitlementTemplateId

• Field API Name: ssot__ServiceEntitlementTemplateId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ShelfFacingUnitCount

• Field API Name: ssot__ShelfFacingUnitCount__c
• Data Type: DOUBLE
• Description: How many units per facing (row) displayed of a product on a shelf.

SizeUOMId

• Field API Name: ssot__SizeUOMId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

StandardWarrantyLengthMonth

• Field API Name: ssot__StandardWarrantyLengthMonth__c
• Data Type: DOUBLE
• Description: Numeric value representing the standard warranty length month. Do not include currency symbols or commas.

StockLedgerValuationAmount

• Field API Name: ssot__StockLedgerValuationAmount__c
• Data Type: DOUBLE
• Description: Numeric value representing the stock ledger valuation amount. Do not include currency symbols or commas.

StockLedgerValuationAmountCurrency

• Field API Name: ssot__StockLedgerValuationAmountCurrency__c
• Data Type: TEXT
• Description: Alphanumeric string representing the stock ledger valuation amount currency.

StyleId

• Field API Name: ssot__StyleId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

TareWeight

• Field API Name: ssot__TareWeight__c
• Data Type: DOUBLE
• Description: What is the weigth of the product packaging without product content.

ValidForPeriodCount

• Field API Name: ssot__ValidForPeriodCount__c
• Data Type: DOUBLE
• Description: The number of valid for periods for this record.

ValidForPeriodUOMId

• Field API Name: ssot__ValidForPeriodUOMId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ValidFromDate

• Field API Name: ssot__ValidFromDate__c
• Data Type: DATETIME
• Description: The date and time of the valid from date.

ValidToDate

• Field API Name: ssot__ValidToDate__c
• Data Type: DATETIME
• Description: The date and time of the valid to date.

VersionNumber

• Field API Name: ssot__VersionNumber__c
• Data Type: TEXT
• Description: Version number associated with the record or object.

WeightUOMId

• Field API Name: ssot__WeightUOMId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

Width

• Field API Name: ssot__Width__c
• Data Type: DOUBLE
• Description: Numeric value representing the width. Do not include currency symbols or commas.