assemblyItemCorrelateditem

The AssemblyItemCorrelatedItem table maintains relationships between related assembly items, aiding in recommendations and alternate selections.

Columns


Name	Type	References	Description
correlationfld	Double		The correlation percentage representing the statistical relationship between this item and a correlated item based on past purchase behavior or inventory movements. A higher correlation indicates a stronger likelihood of these items being purchased together.
countfld	Integer		The number of times this item has been sold or used in conjunction with the correlated item. This field helps in identifying frequently paired products for cross-selling and inventory planning.
item	String		The unique identifier (Id) for the primary item in the correlation analysis. This item is analyzed to determine its relationship with other items based on sales data, usage patterns, or historical transactions.
itemnkeyfld	String		The correlated item that has been frequently purchased or used with the primary item. This item is used for product bundling, recommendation engines, and demand forecasting.
liftfld	Double		The lift percentage representing the increase in likelihood of purchasing the correlated item when the primary item is bought. A lift value greater than 1.0 indicates that the correlated item is more likely to be purchased together with the primary item than by random chance.