ParentItemId in ac_OrderItems Table

[jharri26]

I was wondering if someone could shed some light on what the ParentItemId field in the Order Items table is used for. I have a situation where I think that field will work for what I need it to but was wondering what it was and if it may impact something I am doing.

Thanks

[mazhar]

ParentItemId has major usage in application logic. Some times some items might be dependent upon some different items. For example consider kit product case where one product can have multiple child kitted items. When order is placed for that kit it will generate corresponding order item for main product and each of its child products where order items created for child products will point to their parent item created for kit using ParentItemId. So better don't try to use this field for custom purpose it can break things. OrderItem table has a field called custom fields that can contain name value pairs so you can look into that if you simply want to keep some information with each order item.