How to automatically populate a DFF in INV_MATERIAL_TXNS based on standard attribute in SO Header

Hello,

our customer needs to have an information automatically stored in a Descriptive Flexfield in INV_MATERIAL_TXNS table.

In particular, the requirement is to automatically populate a DFF configured in INV_MATERIAL_TXNS table based on Order Type attribute defined in the Sales Order Header.

Is there any way to achieve the requirement?

Thank you in advance for your support.

Best Regards,

Mirko Amoroso