Hello,

The SQL constraint shown is defining a check constraint named "accountable_required_fields" for the sale order line model in Odoo.

The purpose of the constraint is to ensure that any sale order line that is considered "accountable" (i.e. requires certain information to be recorded for proper accounting) has all the necessary fields filled in.

The constraint consists of three parts:

1. A name for the constraint: 'accountable_required_fields'

2. The check itself: "CHECK(display_type IS NOT NULL OR (product_id IS NOT NULL AND product_uom IS NOT NULL))". This check specifies that either the "display_type" field must not be null or both the "product_id" and "product_uom" fields must not be null.

3. An error message to display if the constraint is violated: "Missing required fields on accountable sale order line."

Thanks & Regards,

​

CandidRoot Solutions Pvt. Ltd.

Mobile: (+91) 8849036209
Email: info@candidroot.com
Skype: live:candidroot
Web: https://www.candidroot.com
Address: 1229-1230, Iconic Shyamal, Near Shyamal Cross Road, Ahmedabad, Gujarat