Goods Product DMO

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

• 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.

• 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

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

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

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

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

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

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

• 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• 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.

• 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.

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

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

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

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

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

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

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

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

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

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