GoodsProduct
The Goods Product DMO is a Data Cloud data model object (DMO) for a specific product, for example a carton of milk or a set of towels
Columns
| Name | Type | References | Description |
| Age | Varchar | A reference ID for the age the product is intended for, for example infants or adults. | |
| Allow Customer Return | Varchar | An indicator whether product is returnable. | |
| Allow Partial Refund | Varchar | An indicator whether a partial refund is allowed, for example if a membership is canceled early. | |
| Brand | Varchar | A reference ID to brand name. | |
| Color | Varchar | A reference ID to the color of the product. | |
| Created Date | Datetime | The date the record was created. | |
| Data Source | Varchar | A reference ID for the logical name for a system that is the source of records identified by external record ID. | |
| Data Source Object | Varchar | A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object. | |
| Depth | Double | The depth size of the product. | |
| Diameter | Double | The diameter of a product. | |
| Disposal Type | Varchar | A reference ID to how product is to be disposed, for example recycle or throw away. | |
| Drained Weight | Double | The weight of the product excluding packaging and after being drained. | |
| Environment Requirement | Varchar | A reference ID to environmental requirements of a product. | |
| External Record ID | Varchar | A reference ID for external data source record. | |
| External Source ID | Varchar | A reference ID for the system in which the external record ID was assigned. | |
| External Source Record ID | Varchar | A reference to record ID in external system where product originated. | |
| Fabric | Varchar | A reference ID for the product’s fabric type. | |
| Gender | Varchar | A reference ID for the gender the product was designed for. | |
| GL Account Code | Varchar | A reference ID to how instances of this product are accounted for, for example consumable, livestock, or merchandise. | |
| Goods Product ID | Varchar | A unique ID used as primary key for the Goods Product DMO. | |
| Gross Weight | Double | The weight of the product in its original packaging. | |
| Height | Double | The height of the product. | |
| Internal Organization | Varchar | A reference ID to business unit or other internal organization that owns business account. | |
| Is Auto Provisionable | Varchar | An indicator whether product can be auto installed. | |
| Is Back Ordered | Varchar | An indicator whether a product has been back ordered after being out of stock. | |
| Is Coupon Redemption Allowed | Varchar | An indicator whether coupon can be used to redeem product. | |
| Is Customer Discount Allowed | Varchar | An indicator whether customer can be offered product at discounted price. | |
| Is Dynamic Bundle | Varchar | An indicator whether content of product is bundled at point of use. | |
| Is Food stamp Payment Allowed | Varchar | An indicator whether product can be purchased with food stamps. | |
| Is Installable | Varchar | An indicator whether product can be installed. | |
| Is Intellectual Property Protected | Varchar | An indicator whether intellectual property of product is protected. | |
| Is Made To Order | Varchar | An indicator whether the product is created after being order, for example a monogrammed towel or a birthday cake. | |
| Is Manual Price Entry Required | Varchar | An indicator whether product price requires manual entry. | |
| Is Multiple Coupons Allowed | Varchar | An indicator whether multiple coupons can be applied to same product. | |
| Is Partner Discount Allowed | Varchar | An indicator whether seller and supplier partners can get a discount on product. | |
| Is Perishable | Varchar | An indicator whether the product is perishable. | |
| Is Pre Orderable | Varchar | An indicator whether product can be preordered. | |
| Is Quality Verification Required | Varchar | An indicator whether product requires visual inspection to designate quality. | |
| Is Quantity Entry Required | Varchar | An indicator whether quantity of product must be entered during checkout. | |
| Is Rain Check Allowed | Varchar | An indicator for when a product isn’t in stock, if a customer can sign up to purchase the product at current price when new shipment arrives. | |
| Is Returnable | Varchar | An indicator whether product can be returned. | |
| Is Sellable | Varchar | An indicator whether the product is intended to be sold. | |
| Is Sellable Independently | Varchar | An indicator whether a product can be sold by itself or only as part of a bundle. | |
| Is Sellable Without Price | Varchar | An indicator whether a product can be | |
| Is Serialized | Varchar | An indicator whether each individual product has a unique serial number. | |
| Is Weight Entry Required | Varchar | An indicator whether product weight is required. | |
| Is Worker Discount Allowed | Varchar | An indicator whether employees and contractors can get a discount on product. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Lot Identifier | Varchar | The name or number of the lot that manufactured product. | |
| Manufacturer Name | Varchar | The name of the product’s manufacturer. | |
| Master Product | Varchar | A reference ID referring to the parent or primary product. | |
| Max Holding Day Count | Double | The amount of time the product can be displayed before removal. | |
| Maximum Order Quantity Count | Double | The maximum quantity of the product allowed for purchase. | |
| Minimum Advertisement Amount | Double | The lowest price allowed (normally by manufacturer) to use in an ad. | |
| Minimum Advertisement Amount Currency | Varchar | The currency for the minimum advertisement amount. | |
| Minimum Advertisement Amount Start Date | Double | The earliest date the lowest manufacturer's price can be stated in an ad. | |
| Minimum Order Quantity Count | Double | The minimum quantity of product allowed for purchase. | |
| Model Number | Varchar | The identifier that manufacturer uses for product, for example SHOE-123-RED-8. | |
| Model Year | Double | The marketed model year for product. | |
| MSRP Amount | Double | The manufacturer suggested retail price or the default price of a product. | |
| MSRP Amount Currency | Varchar | The currency for the suggested retail price. | |
| Net Weight | Double | The weight of the product excluding packaging. | |
| Packaged in Country | Varchar | The country where the product is packaged. | |
| Pattern | Varchar | A reference ID to the pattern of a product, for example striped or checkered. | |
| Price Charge Type ID | Varchar | A reference ID to how product is priced, for example by weight, units, or usage. | |
| Primary Product Category | Varchar | The category of the product, for example shoes or frozen meals. | |
| Primary Sales Channel | Varchar | A reference ID to the primary sales channel used to sell product. | |
| Produced in Country | Varchar | The country where the product is produced. | |
| Product Description | Varchar | A general description of product. | |
| Product Long Description | Varchar | The long description of product. | |
| Product May Expand | Varchar | An indicator whether the product can become bigger under certain circumstances like heat. | |
| Product Name | Varchar | The name of the product. | |
| Product Security Requirement | Varchar | An indicator whether the product requires any special security for handling or selling. | |
| Product SKU | Varchar | The unique Stock Keeping Unit (SKU) identifier for product. | |
| Product Status | Varchar | A reference ID to status of product, for example active or inactive. | |
| Quantity Installment Count | Double | An indicator whether the product requires a number of installments. | |
| Quantity Installment Period | Varchar | A reference ID to a product's quantity schedule, the amount of time covered by the schedule. | |
| Quantity Schedule Type | Varchar | A reference ID to quantity schedule type, if product has one, for example Divide or Repeat. | |
| Quantity Scheduling Enabled | Varchar | An indicator whether product has a quantity schedule. | |
| Required Cleanup Process | Varchar | An indicator whether the product requires special cleanup procedures if it’s spilled or leaked. | |
| Required Deposit Amount | Double | An indicator whether a deposit is required to pick up or use the product. | |
| Required Deposit Amount Currency | Varchar | The currency of the required deposit. | |
| Required Deposit Percentage | Double | The percentage of the deposit that is required to pick up or use the product. | |
| Required Humidity Percentage | Double | The humidity percentage required for the product. | |
| Required Temperature Highest Number | Double | The highest temperature required for the product. | |
| Required Temperature Lowest Number | Double | The lowest temperature required for the product. | |
| Required Temperature UOM | Varchar | The required temperature’s Unit of Measure (UOM). | |
| Requires Individual Unit Pricing | Varchar | An indicator whether product requires individual price, for example due to variable weight or size. | |
| Requires Unit Price Label | Varchar | An indicator whether the unit price label must be visible on the product. | |
| Revenue Installment Count | Double | The number of installments from 1 to 150 if a product has a revenue schedule | |
| Revenue Installment Period | Varchar | A reference ID to the time covered by a revenue schedule, for example weekly or monthly. | |
| Revenue Schedule Type | Varchar | A reference ID to revenue schedule type. | |
| Revenue Scheduling Enabled | Varchar | An indicator whether product can have a revenue schedule. | |
| Reward Program Points Count | Double | The number of points given for the purchase of product. | |
| Season | Varchar | A reference ID to the season the product is intended for, for example summer or winter. | |
| Service Entitlement Template | Varchar | A reference ID to a service entitlement template. | |
| Shelf Facing Unit Count | Double | The number of units per row of the product that can be displayed. | |
| Size UOM | Varchar | A reference ID for the unit of measure for the product’s size. | |
| Standard Warranty Length Month | Double | The length of warranty included from the seller (not manufacturer). | |
| Stock Ledger Valuation Amount | Double | The total value of the products in stock. | |
| Stock Ledger Valuation Amount Currency | Varchar | The currency of the total value of the products in stock. | |
| Style | Varchar | A reference ID to the style of the product. | |
| Tare Weight | Double | The weight of the product packaging without the product content. | |
| Valid For Period Count | Double | The duration of time that product is valid. | |
| Valid For Period Unit Of Measure | Varchar | A reference ID to measurement of time associated with Valid For Period Count, for example hours, days, or months. | |
| Valid From Date | Datetime | The initial date that product can be used. | |
| Valid To Date | Datetime | The final date that product can be used. | |
| Version Number | Varchar | The product version. | |
| Weight UOM | Varchar | A reference ID for the unit of the measure used for a product’s weight. | |
| Width | Double | The width of a product. |