@Goutham, application should be able to attach the product to a offices as per below scenarios. Scenario 1) At organizational level Scenario 2) To multiple branches/offices Scenario 3) To a offices and all the offices/branches below that office. Scenario 4) To a multiple offices and all the offices/branches below those offices.
My opinion about table name is m_product_loan_applicable_offices.
Make sure when new branch or office is created it has to get the products defined at organizational level and as well as defined at parent office with applicable to it's below offices.
|