Companies and Structures

The goal is to develop a system that hepls maintaining all our regulatory information and deadlines across our group. Currently this information is stored and managed either in be-spoke excel documents or on networks in several offices across the globe. We want to migrate to a centralized system over the web. The project implies creating a database for storing entities like Indivuals, Companies, Countries, and a set of relationships between them. ## Deliverables Please find below the list of data we need to be able to store/retrieve: (*) denotes a relation to another entity Entities 1. Company: 1. Name 2. Short code 3. Former Name 4. Status 5. Activity 6. Registration Number 7. Registered office 8. Country (*) 9. Registered Office Agent 10. Regulated 11. Regulatory Number 12. Auditor 13. Date of Incorporation 14. Date of Termination 15. VAT Number 16. Tax Numer 17. Financial Year End 18. Share Capital Currency (*) 19. Authorized Share Capital 20. Issued Share Capital 21. Nominal Value 22. Issued Shares Total 23. Ordinary Shares 24. Preferred Shares 25. Paid in 26. Comments 2. Individuals: 1. First Name 2. Last Name 3. Home Adress 4. Country (*) 5. Telephone Number 6. Email Adress 7. Date of Birth 8. Citizenship 9. Passport Number 3. Country: 1. list of countries 4. Currency : 1. name 2. code 5. Bank Account (can be several bank accounts) 1. Company (*) 2. Name of Bank 3. Adress 4. Country (*) 5. Account name 6. Currency (*) 7. Account Number 8. Swift Code 9. Signatories on Bank Accounts(can be “joined?? or “single??) 1. People 2. Date of Appointment 3. Date of Resignation Relationships 1. Directors: 1. Company 2. People 3. Date of Appointment 4. Date of Resignation 2. Secretary: 1. Company 2. People 3. Date of Appointment 4. Date of Resignation 3. Authorized Signatories 1. Company 2. People 3. Date of Appointment 4. Date of Resignation 4. Beneficial Owner: 1. Company 2. People 3. Start Date 4. End Date 5. Shares 1. Company 2. People 3. Number of shares 1. Share Certificate Number (can be several per shareholder) 2. purchase date 3. sale date 4. Current situation 5. % of Capital The zip attachment contains an excel showing the type of information we would like to have on the web (just to give an idea, we do not expect the web site to look like the excel file). The excel file is not really practical anyway, that is why we would like to have a web page.