MasterProduct
The Master Product DMO is a Data Cloud data model object (DMO) for data about a company’s products.
Columns
| Name | Type | References | Description |
| Allow Customer Return | Varchar | An indicator whether a product is returnable. | |
| Allow Partial Refund | Varchar | An indicator if a partial refund is allowed, for example, refunding a membership fee. | |
| Brand | Varchar | A reference ID to the brand’s name. | |
| Created Date | Datetime | The date a record was created. | |
| Data Source | Varchar | A reference ID to a logical name for a system that is the source of records identified by the external record ID. | |
| Data Source Object | Varchar | A reference ID to the logical name of the object where the record originated, for example a cloud storage file or another connector’s external object. | |
| Disposal Type | Varchar | A reference ID to how the product is to be disposed, for example, recycled or thrown away. | |
| External Record Id | Varchar | A reference ID for an external data source record. | |
| External Source Id | Varchar | A reference ID to the system where the external record ID was assigned. | |
| External Source Record Id | Varchar | A reference to the record ID in the external system where the product originated. | |
| GL Account Code | Varchar | A code that describes how instances of this product are accounted for, for example, are they consumable, livestock, or merchandise. | |
| Internal Organization | Varchar | A reference ID to a business unit or other internal organization that owns a business account. | |
| Is Auto Provisionable | Varchar | An indicator whether a product can be auto-installed. | |
| Is Back Ordered | Varchar | An indicator if a product is out of stock or backordered. | |
| Is Coupon Redemption Allowed | Varchar | An indicator whether a coupon can be used to redeem a product. | |
| Is Customer Discount Allowed | Varchar | An indicator whether a customer can be offered a product at a discounted price. | |
| Is Dynamic Bundle | Varchar | An indicator whether a content of a product is bundled at the point of use. | |
| Is Foodstamp Payment Allowed | Varchar | An indicator whether a product can be purchased with food stamps. | |
| Is Installable | Varchar | An indicator whether a product can be installed. | |
| Is Intellectual Property Protected | Varchar | An indicator whether the intellectual property of a product is protected. | |
| Is Manual Price Entry Required | Varchar | An indicator whether a price requires manual entry. | |
| Is Multiple Coupons Allowed | Varchar | An indicator whether multiple coupons can be applied to the same product. | |
| Is Partner Discount Allowed | Varchar | An indicator whether the seller and supplier partners can get a discount on a product. | |
| Is Pre Orderable | Varchar | An indicator whether a product can be preordered. | |
| Is Quality Verification Required | Varchar | An indicator whether a product requires visual inspection to designate quality. | |
| Is Quantity Entry Required | Varchar | An indicator whether the quantity of a product must be entered during checkout. | |
| Is Rain Check Allowed | Varchar | If a product isn’t in stock, an indicator if a customer can sign up to purchase the product at the current price when a new shipment arrives. | |
| Is Returnable | Varchar | An indicator whether a product can be returned. | |
| Is Sellable | Varchar | An indicator whether a product can be sold. | |
| Is Sellable Independently | Varchar | An indicator whether a product can be sold individually or as a part of a bundle. | |
| Is Sellable Without Price | Varchar | An indicator whether a product can be sold without a price, for example, a free monogram. | |
| Is Serialized | Varchar | An indicator whether each individual product has a unique serial number. | |
| Is Weight Entry Required | Varchar | An indicator if a product weight is required. | |
| Is Worker Discount Allowed | Varchar | An indicator if employees and contractors can get a discount on a product. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Lot Identifier | Varchar | The name or lot number of the manufactured product. | |
| Manufacturer Name | Varchar | The name of the product manufacturer. | |
| Master Product | Varchar | A reference ID for the master product. | |
| Master Product Id | Varchar | A unique ID that is used as the primary key for the Master Product DMO. | |
| Maximum Order Quantity Count | Double | The maximum quantity of product allowed for purchase. | |
| Minimum Advertisement Amount | Double | The lowest price allowed to be used in ads (normally established by a manufacturer). | |
| 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 the manufacturer uses for product, for example, SHOE-123-RED-8. | |
| Model Year | Double | The product’s model year. | |
| MSRP Amount | Double | The default price for the product called the Manufacturer Suggested Retail Price (MSRP). | |
| MSRP Amount Currency | Varchar | The currency of the MSRP. | |
| Packaged in Country | Varchar | The country where the product is packaged. | |
| Price Charge Type Id | Varchar | A reference ID to how the product is priced, for example by weight, units, or usage. | |
| Primary Product Category | Varchar | The name of the primary product category. | |
| Primary Sales Channel | Varchar | A reference ID to the primary channel used to sell the product. | |
| Produced in Country | Varchar | The country where the product is produced. | |
| Product Description | Varchar | A general description of the product. | |
| Product Long Description | Varchar | A product’s long description. | |
| Product Name | Varchar | The name of the product. | |
| Product SKU | Varchar | The unique stock keeping unit (SKU) for product, for example, SHOE-NIKE-MOD1-SZ12-RED. | |
| Product Status | Varchar | A reference ID to the status of the product, for example Active or Inactive. | |
| Quantity Installment Count | Double | The number of installments, if the product has a quantity schedule. | |
| Quantity Installment Period | Varchar | A reference ID to the product's quantity schedule, the amount of time covered by the schedule. | |
| Quantity Schedule Type | Varchar | A reference ID to the quantity schedule type, for example, divide or repeat. | |
| Quantity Scheduling Enabled | Varchar | An indicator whether a product has a quantity schedule. | |
| Required Deposit Amount | Double | The deposit required to pick up or use a product. | |
| Required Deposit Amount Currency | Varchar | The currency of the required deposit amount. | |
| Required Deposit Percentage | Double | The percentage of deposit required to pick up or use product. | |
| Requires Individual Unit Pricing | Varchar | An indicator whether a product requires an individual price, for example, due to its variable weight or size. | |
| Revenue Installment Count | Double | The number of installments if a product has a revenue schedule. | |
| Revenue Installment Period | Varchar | A reference ID to the time period covered by a schedule, for example, weekly or monthly. | |
| Revenue Schedule Type | Varchar | A reference ID to the revenue schedule type, for example, divide or repeat. | |
| Revenue Scheduling Enabled | Varchar | An indicator whether the product has a revenue schedule. | |
| Reward Program Points Count | Double | The number of points given for the purchase of a product. | |
| Service Entitlement Template | Varchar | A reference ID for the types of customer support, such as phone support, for which a customer is eligible to use under the terms of a contract. | |
| Standard Warranty Length Month | Double | The length of warranty included from the seller (not the manufacturer). | |
| Stock Ledger Valuation Amount | Double | The total value of the product in stock. | |
| Stock Ledger Valuation Amount Currency | Varchar | The currency for the stock ledger valuation amount. | |
| Valid For Period Count | Double | The numeric duration of time that the product is valid, for example, 1, 2, or 3. | |
| Valid For Period Unit Of Measure | Varchar | A reference ID to the measurement of time associated with “Valid For Period Count,” for example, hours or months. | |
| Valid From Date | Datetime | The initial date that the product can be used. | |
| Valid To Date | Datetime | The final date that the product can be used. | |
| Version Number | Varchar | The product version, for example, 1.3.5. |