Development of d_company

Introduction - company table is used for  financial reporting and legal entities. To enhance the financial reporting framework for [specific legal entity or function], ensuring compliance with applicable standards (e.g., GAAP, IFRS) and establishing clear roles and responsibilities.

 

This task is part of the ongoing efforts to improve financial reporting .Proper ownership and accountability at the operational level are essential for accurate and timely financial reporting across our legal entities

 

Requirement: Develop an SQL-based logic for the company table (d_comp) based on the field mappings provided in the attached Excel file.  Map only the column  where Mandatory for mapping and Need Mapping column has value ‘Yes’ and  for other column map as null. The Excel file contains a detailed mapping of each field in the target table, sourced from multiple corresponding source tables.