# Fulfillment Order Product DMO ## Object Properties **Object API Name:** `ssot__FulfillmentOrderProduct__dlm`\ **Category:** Unassigned\ **Availability:** Available in 254 and later versions\ **Primary Key Field:** Id ## Relationships - **FulfillmentOrderId** has a FOREIGNKEY relationship with the [Fulfillment Order DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-fulfillmentorderdmo-dmo.md) `Id` field. - **SalesOrderProductId** has a FOREIGNKEY relationship with the [Sales Order Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesorderproductdmo-dmo.md) `Id` field. - **OriginalSalesOrderProductId** has a FOREIGNKEY relationship with the [Sales Order Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesorderproductdmo-dmo.md) `Id` field. ## Fields - [cdp_sys_record_currency](#cdp_sys_record_currency) - [CreatedDate](#createddate) - [CurrencyCode](#currencycode) - [DataSourceId](#datasourceid) - [DataSourceObjectId](#datasourceobjectid) - [Description](#description) - [FulfilledQuantity](#fulfilledquantity) - [FulfillmentOrderId](#fulfillmentorderid) - [GrandTotalAmount](#grandtotalamount) - [GrossUnitPrice](#grossunitprice) - [Id](#id) - [InternalOrganizationId](#internalorganizationid) - [KQ_FulfillmentOrderId](#kq_fulfillmentorderid) - [KQ_Id](#kq_id) - [KQ_OriginalSalesOrderProductId](#kq_originalsalesorderproductid) - [KQ_SalesOrderProductId](#kq_salesorderproductid) - [Name](#name) - [Number](#number) - [OrderedQuantity](#orderedquantity) - [OriginalSalesOrderProductId](#originalsalesorderproductid) - [ProductAmount](#productamount) - [ProvisioningDate](#provisioningdate) - [QuantityUnitOfMeasure](#quantityunitofmeasure) - [RequestedEndDate](#requestedenddate) - [RequestedStartDate](#requestedstartdate) - [SalesOrderProductId](#salesorderproductid) - [TotalAdjustmentAmount](#totaladjustmentamount) - [TotalAdjustmentTaxAmount](#totaladjustmenttaxamount) - [TotalAmount](#totalamount) - [TotalLineAmountWithTax](#totallineamountwithtax) - [TotalOrderProductAdjTaxAmount](#totalorderproductadjtaxamount) - [TotalProductAdjAmount](#totalproductadjamount) - [TotalProductAdjTaxAmount](#totalproductadjtaxamount) - [TotalProductDstribAdjAmount](#totalproductdstribadjamount) - [TotalProductDstribAdjTaxAmount](#totalproductdstribadjtaxamount) - [TotalProductTaxAmount](#totalproducttaxamount) - [TotalTaxAmount](#totaltaxamount) - [UnitPriceAmount](#unitpriceamount) ### 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. ### CreatedDate - **Field API Name:** `ssot__CreatedDate__c` - **Data Type:** DATETIME - **Description:** Date and time when this record was created. ### CurrencyCode - **Field API Name:** `ssot__CurrencyCode__c` - **Data Type:** TEXT - **Description:** ISO 4217 code identifying the currency used in the transaction or record. ### 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. ### Description - **Field API Name:** `ssot__Description__c` - **Data Type:** TEXT - **Description:** Required. Description of the FulfillmentOrderLineItem. Maximum size is 255 characters. ### FulfilledQuantity - **Field API Name:** `ssot__FulfilledQuantity__c` - **Data Type:** DOUBLE - **Description:** Current quantity of the FulfillmentOrderLineItem. This amount is equal to the original quantity minus any canceled quantity. ### FulfillmentOrderId - **Field API Name:** `ssot__FulfillmentOrderId__c` - **Data Type:** TEXT - **Description:** Required. ID of the FulfillmentOrder associated with the FulfillmentOrderLineItem. This field is a relationship field. Maximum size is 36 characters. ### GrandTotalAmount - **Field API Name:** `ssot__GrandTotalAmount__c` - **Data Type:** DOUBLE - **Description:** Total, including adjustments but not tax, of the FulfillmentOrderLineItem. This amount is equal to UnitPrice times Quantity. ### GrossUnitPrice - **Field API Name:** `ssot__GrossUnitPrice__c` - **Data Type:** DOUBLE - **Description:** Unit price, including tax, of the FulfillmentOrderLineItem. This amount is equal to TotalPrice plus TotalTaxAmount. ### Id - **Field API Name:** `ssot__Id__c` - **Data Type:** TEXT - **Description:** Required. A unique, system-generated identifier for this FulfillmentOrderProduct 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. ### KQ_FulfillmentOrderId - **Field API Name:** `KQ_FulfillmentOrderId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for FulfillmentOrderId ### KQ_Id - **Field API Name:** `KQ_Id__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for Id ### KQ_OriginalSalesOrderProductId - **Field API Name:** `KQ_OriginalSalesOrderProductId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for OriginalSalesOrderProductId ### KQ_SalesOrderProductId - **Field API Name:** `KQ_SalesOrderProductId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for SalesOrderProductId ### Name - **Field API Name:** `ssot__Name__c` - **Data Type:** TEXT - **Description:** Name of a Fulfillment Order Product. ### Number - **Field API Name:** `ssot__Number__c` - **Data Type:** TEXT - **Description:** Autonumber identifier for a Fulfillment Order Product. ### OrderedQuantity - **Field API Name:** `ssot__OrderedQuantity__c` - **Data Type:** DOUBLE - **Description:** Original quantity of the FulfillmentOrderLineItem. ### OriginalSalesOrderProductId - **Field API Name:** `ssot__OriginalSalesOrderProductId__c` - **Data Type:** TEXT - **Description:** Required. ID of the product represented by the FulfillmentOrderLineItem. This field is a relationship field. Maximum size is 36 characters. ### ProductAmount - **Field API Name:** `ssot__ProductAmount__c` - **Data Type:** DOUBLE - **Description:** Total, not including adjustments or tax, of the FulfillmentOrderLineItem. ### ProvisioningDate - **Field API Name:** `ssot__ProvisioningDate__c` - **Data Type:** DATETIME - **Description:** The date or date-time when the fulfilled product is enabled. ### QuantityUnitOfMeasure - **Field API Name:** `ssot__QuantityUnitOfMeasure__c` - **Data Type:** TEXT - **Description:** Unit of measure of the quantity, for example, unit, gallon, ton, or case. ### RequestedEndDate - **Field API Name:** `ssot__RequestedEndDate__c` - **Data Type:** DATETIME - **Description:** The date and time of the requested end date. ### RequestedStartDate - **Field API Name:** `ssot__RequestedStartDate__c` - **Data Type:** DATETIME - **Description:** The date and time of the requested start date. ### SalesOrderProductId - **Field API Name:** `ssot__SalesOrderProductId__c` - **Data Type:** TEXT - **Description:** Required. ID of the OrderItemSummary associated with the FulfillmentOrderLineItem. This field is a relationship field. Maximum size is 36 characters. ### TotalAdjustmentAmount - **Field API Name:** `ssot__TotalAdjustmentAmount__c` - **Data Type:** DOUBLE - **Description:** Total of any price adjustments applied to the FulfillmentOrderLineItem. ### TotalAdjustmentTaxAmount - **Field API Name:** `ssot__TotalAdjustmentTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Total amount of the price adjustments applied to the FulfillmentOrderProduct, inclusive of tax. This amount is equal to TotalAdjustmentAmount plus TotalAdjustmentTaxAmount. ### TotalAmount - **Field API Name:** `ssot__TotalAmount__c` - **Data Type:** DOUBLE - **Description:** Total, including adjustments and tax, of the FulfillmentOrderLineItem. ### TotalLineAmountWithTax - **Field API Name:** `ssot__TotalLineAmountWithTax__c` - **Data Type:** DOUBLE - **Description:** TotalLineTaxAmount. Total product tax amount, excluding tax amount of adjustments. ### TotalOrderProductAdjTaxAmount - **Field API Name:** `ssot__TotalOrderProductAdjTaxAmount__c` - **Data Type:** DOUBLE - **Description:** The total order product adj tax amount for the fulfillment order product. ### TotalProductAdjAmount - **Field API Name:** `ssot__TotalProductAdjAmount__c` - **Data Type:** DOUBLE - **Description:** Σ FulfillmentOrderProductIPriceAdjustment.AdjustmentAmountIncludes both GoodsProduct and ServiceProduct adjustments. Excludes distributed adjustments. ### TotalProductAdjTaxAmount - **Field API Name:** `ssot__TotalProductAdjTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Σ FulfillmentOrderPriceAdjustmentTax.FulfillmentOrderPriceAdjustmentAmount \nCould be either product or service taxes. Adjustment taxes only. ### TotalProductDstribAdjAmount - **Field API Name:** `ssot__TotalProductDstribAdjAmount__c` - **Data Type:** DOUBLE - **Description:** Σ FulfillmentOrderPriceAdjustmentTax.FulfillmentOrderPriceAdjustmentAmount Could be either product or service taxes. Adjustment taxes only. ### TotalProductDstribAdjTaxAmount - **Field API Name:** `ssot__TotalProductDstribAdjTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Σ FulfillmentOrderPriceAdjustmentTax.FulfillmentOrderProductPriceAdjustmentAmount(FulfillmentOrderProductPriceAdjustment.FulfillmentOrderProductItemAdjustmentType == Distributed)\nDistributed Adjustment taxes only. ### TotalProductTaxAmount - **Field API Name:** `ssot__TotalProductTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Tax on the TotalLineAmount. ### TotalTaxAmount - **Field API Name:** `ssot__TotalTaxAmount__c` - **Data Type:** DOUBLE - **Description:** Tax on the TotalPrice. ### UnitPriceAmount - **Field API Name:** `ssot__UnitPriceAmount__c` - **Data Type:** DOUBLE - **Description:** Unit price of the FulfillmentOrderLineItem.