{ "info": { "author": "Therp BV, Odoo Community Association (OCA)", "author_email": "support@odoo-community.org", "bugtrack_url": null, "classifiers": [ "Framework :: Odoo", "License :: OSI Approved :: GNU Affero General Public License v3", "Programming Language :: Python" ], "description": ".. image:: https://img.shields.io/badge/licence-AGPL--3-blue.svg\n :alt: License: AGPL-3\n\nUnique bank account numbers\n===========================\n\nIt can be desirable to be able to rely on a bank account number identifying\nexactly one partner. This module allows you to enforce this, so that an\naccount number is unique in the system.\n\nThere are some valid corner cases were it is valid to have multiple records\nfor the same account number. For instance in a multicompany setup where the\nbank-account linked to one company, is a partner bank account for another\ncompany.\n\nBecause of these corner cases, the constraint is no longer implemented as\na SQL unique index. This has the added advantage, that the module can be\ninstalled on databases where the bank-account numbers are not unique already.\n\nTo find records that are not unique, you could use the following SQL\nstatement::\n\n with res_partner_bank_sanitized as (\n select\n id, acc_number, coalesce(company_id, 0) as company_id,\n sanitized_acc_number\n from res_partner_bank\n ),\n res_partner_bank_sanitized_grouped as (\n select\n array_agg(id) ids, sanitized_acc_number, count(*) kount,\n company_id\n from res_partner_bank_sanitized\n group by sanitized_acc_number, company_id\n )\n select * from res_partner_bank_sanitized_grouped where kount > 1;\n\nInstallation\n============\n\nThe constraint is active for new and changed numbers, from the moment of\ninstallation.\n\n\nBug Tracker\n===========\n\nBugs are tracked on\n`GitHub Issues `_.\n\nCredits\n=======\n\nContributors\n------------\n\n* Holger Brunn \n* Ronald Portier \n\nMaintainer\n----------\n\n.. image:: https://odoo-community.org/logo.png\n :alt: Odoo Community Association\n :target: https://odoo-community.org\n\nThis module is maintained by the OCA.\n\nOCA, or the Odoo Community Association, is a nonprofit organization whose\nmission is to support the collaborative development of Odoo features and\npromote its widespread use.\n\nTo contribute to this module, please visit http://odoo-community.org.\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "", "keywords": "", "license": "AGPL-3", "maintainer": "", "maintainer_email": "", "name": "odoo8-addon-base-bank-account-number-unique", "package_url": "https://pypi.org/project/odoo8-addon-base-bank-account-number-unique/", "platform": "", "project_url": "https://pypi.org/project/odoo8-addon-base-bank-account-number-unique/", "project_urls": null, "release_url": "https://pypi.org/project/odoo8-addon-base-bank-account-number-unique/8.0.1.1.0.99.dev3/", "requires_dist": [ "odoo8-addon-account-bank-statement-import", "odoo (<9.0a,>=8.0a)" ], "requires_python": "~=2.7", "summary": "Enforce uniqueness on bank accounts", "version": "8.0.1.1.0.99.dev3" }, "last_serial": 4578905, "releases": { "8.0.1.0.1.99.dev3": [ { "comment_text": "", "digests": { "md5": "bdd8dfcea994802f22eb7b90c505dc4a", "sha256": "fd11c333f559bf95779775804138a96e9aec859d56f72a2fb337453381733432" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev3-py2-none-any.whl", "has_sig": false, "md5_digest": "bdd8dfcea994802f22eb7b90c505dc4a", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 21813, "upload_time": "2017-04-11T10:09:17", "url": "https://files.pythonhosted.org/packages/f9/54/e23c56e7b7e52a241fadca4841ddae4eacbe73500864b202200582e9e740/odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev3-py2-none-any.whl" } ], "8.0.1.0.1.99.dev4": [ { "comment_text": "", "digests": { "md5": "93bf4a86cf16fab5f088914acb6cb3ba", "sha256": "3238e6f191cf312d9b607e69bf735487a86c4ef6ca5a4e0f79b7f951967d81d0" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev4-py2-none-any.whl", "has_sig": false, "md5_digest": "93bf4a86cf16fab5f088914acb6cb3ba", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 22928, "upload_time": "2017-04-11T10:09:21", "url": "https://files.pythonhosted.org/packages/3b/0b/2fbb3e8f81613d024e6f3950d97cda9c8eba48c5cea3b50645700e19fa4c/odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev4-py2-none-any.whl" } ], "8.0.1.0.1.99.dev5": [ { "comment_text": "", "digests": { "md5": "74d4fd62608d9b1b0428c9b62033732e", "sha256": "3743f978cb246ccd25bfd97b1e858395e71259739317ac886bf9d1e9f87b5e69" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev5-py2-none-any.whl", "has_sig": false, "md5_digest": "74d4fd62608d9b1b0428c9b62033732e", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 23213, "upload_time": "2017-04-11T10:09:23", "url": "https://files.pythonhosted.org/packages/7c/08/25ea131bb8efdef591d630a98c31aa6f046a26420fdf0d20d510325eb117/odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev5-py2-none-any.whl" } ], "8.0.1.0.1.99.dev6": [ { "comment_text": "", "digests": { "md5": "52b6ead46ca6f8ffcf7f77edf1c037e6", "sha256": "9e8d8113cf9e9449986b6f42d8595da7c31ef2479eea4f1bbc9f2c14bdc0c2ef" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev6-py2-none-any.whl", "has_sig": false, "md5_digest": "52b6ead46ca6f8ffcf7f77edf1c037e6", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": null, "size": 24099, "upload_time": "2017-04-11T10:09:27", "url": "https://files.pythonhosted.org/packages/19/dd/99970e47f5b93ad342684a2120af0e92b7260c2f040771700ac8ff6b9c3e/odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev6-py2-none-any.whl" } ], "8.0.1.0.1.99.dev7": [ { "comment_text": "", "digests": { "md5": "197d8c8ed46f0bf880748a8736cc4e4d", "sha256": "60057950b05407aaf1a62552b22b05c0ba85d02078ea3de3784ef2e551872f6a" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev7-py2-none-any.whl", "has_sig": false, "md5_digest": "197d8c8ed46f0bf880748a8736cc4e4d", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 23293, "upload_time": "2018-06-16T04:32:55", "url": "https://files.pythonhosted.org/packages/ff/6d/289383ee48aa2c19d7f6fa1ce7473d1a3edf40e8ad0ecb8bec7c5909dc97/odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev7-py2-none-any.whl" } ], "8.0.1.0.1.99.dev8": [ { "comment_text": "", "digests": { "md5": "5a7cbb962621f60e96dbdbd2d01e32ff", "sha256": "cb32e227324ee4f935334ea02277600ca0c69d6f2352b7feaa587caa2b9f19c6" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev8-py2-none-any.whl", "has_sig": false, "md5_digest": "5a7cbb962621f60e96dbdbd2d01e32ff", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 22094, "upload_time": "2018-08-09T04:31:31", "url": "https://files.pythonhosted.org/packages/a4/69/65b1f352092afd4c8d11b18a435c569a89685aeef5a59d99e46cf3d91f6d/odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev8-py2-none-any.whl" } ], "8.0.1.1.0.99.dev1": [ { "comment_text": "", "digests": { "md5": "75e7e3cb8f3cb781401a29f165d18d79", "sha256": "850fd46fc424309c5226606a1d12bd1615929b0dc12c3aa9c79fd2515fbebaac" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev1-py2-none-any.whl", "has_sig": false, "md5_digest": "75e7e3cb8f3cb781401a29f165d18d79", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 19092, "upload_time": "2018-08-13T04:31:23", "url": "https://files.pythonhosted.org/packages/e9/7a/60cabb3c489e09f417d1017db861695235048577e56e172d395dc68eae5f/odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev1-py2-none-any.whl" } ], "8.0.1.1.0.99.dev2": [ { "comment_text": "", "digests": { "md5": "7a5816cebc06e18b522fd57e65cde3e0", "sha256": "d0831ef896c2bd213536f24f3e85dfbc2c36e789e62bb4bbeb318a9d7f821cc3" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev2-py2-none-any.whl", "has_sig": false, "md5_digest": "7a5816cebc06e18b522fd57e65cde3e0", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 19088, "upload_time": "2018-08-14T04:31:27", "url": "https://files.pythonhosted.org/packages/13/46/0831134a1734003379fc21aef1175ff782a30b9e58fa9b1625476319c648/odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev2-py2-none-any.whl" } ], "8.0.1.1.0.99.dev3": [ { "comment_text": "", "digests": { "md5": "c90b92216e820b1f929f69e5f44805cf", "sha256": "47004ecdc63827918376f0024b69bab7934fa8d4eaf344529d4ded6497b64075" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev3-py2-none-any.whl", "has_sig": false, "md5_digest": "c90b92216e820b1f929f69e5f44805cf", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 19090, "upload_time": "2018-12-10T05:32:10", "url": "https://files.pythonhosted.org/packages/98/59/0ae2ba4876adde0e1d249ec32081c64b33cefc4813f5fb9f20192e3fd74a/odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev3-py2-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "c90b92216e820b1f929f69e5f44805cf", "sha256": "47004ecdc63827918376f0024b69bab7934fa8d4eaf344529d4ded6497b64075" }, "downloads": -1, "filename": "odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev3-py2-none-any.whl", "has_sig": false, "md5_digest": "c90b92216e820b1f929f69e5f44805cf", "packagetype": "bdist_wheel", "python_version": "py2", "requires_python": "~=2.7", "size": 19090, "upload_time": "2018-12-10T05:32:10", "url": "https://files.pythonhosted.org/packages/98/59/0ae2ba4876adde0e1d249ec32081c64b33cefc4813f5fb9f20192e3fd74a/odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev3-py2-none-any.whl" } ] }