Location Product Inventory Change DMO

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

• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• LocationId has a FOREIGNKEY relationship with the Location DMO Id field.

• AvailableToFulfillQuantity
• AvailableToOrderQuantity
• cdp_sys_record_currency
• ChangeDateTime
• DataSourceId
• DataSourceObjectId
• EffectiveDateTime
• ExternalLocationIdentifier
• Id
• InternalOrganizationId
• IsDeleted
• KQ_Id
• KQ_LocationId
• KQ_ProductId
• LocationId
• OnHandQuantity
• ProductId
• ReservedQuantity
• SafetyStockQuantity
• SKUNumber

• Field API Name: ssot__AvailableToFulfillQuantity__c
• Data Type: DOUBLE
• Description: Available to Fulfill is a computed quantity on the availability to fulfill inventory at a location.

• Field API Name: ssot__AvailableToOrderQuantity__c
• Data Type: DOUBLE
• Description: Available to Order is a computed quantity on the availability to order the inventory. It takes into account futures as well.

• 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__ChangeDateTime__c
• Data Type: DATETIME
• Description: Last updated date and time of the source record.

• 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__EffectiveDateTime__c
• Data Type: DATETIME
• Description: The primary locale where an Employee assigned to the Job Position works.

• Field API Name: ssot__ExternalLocationIdentifier__c
• Data Type: TEXT
• Description: Location Identifier in an external system.

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

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

• Field API Name: ssot__IsDeleted__c
• Data Type: TEXT
• Description: Whether the record is deleted.

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

• Field API Name: KQ_LocationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocationId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: ssot__LocationId__c
• Data Type: TEXT
• Description: Reference to the associated location of the inventory.

• Field API Name: ssot__OnHandQuantity__c
• Data Type: DOUBLE
• Description: Inventory on hand at a location.

• Field API Name: ssot__ProductId__c
• Data Type: TEXT
• Description: Reference to the associated product.

• Field API Name: ssot__ReservedQuantity__c
• Data Type: DOUBLE
• Description: Reserved inventory at the location for the SKU.

• Field API Name: ssot__SafetyStockQuantity__c
• Data Type: DOUBLE
• Description: Inventory quantity that a merchant wants to hold back and not use in ATO/ATF calculations.

• Field API Name: ssot__SKUNumber__c
• Data Type: TEXT
• Description: Stock Keeping Unit.