text: ﻿IF NOT EXISTS(SELECT * FROM dbo.[AccountTypes])
  BEGIN
  DECLARE @AT TABLE (
  	[Index] INT, [StandardAndPure] BIT, [IsMonetary] BIT, [Code] NVARCHAR(50),
  	[Node] HIERARCHYID, [EntryTypeParentConcept] NVARCHAR (255), [Concept] NVARCHAR (255), [Name] NVARCHAR (512), [Description] NVARCHAR (MAX)
  )
  --Script
  INSERT INTO @AT VALUES(1,0,0,'1', '/1/', NULL,N'StatementOfFinancialPositionAbstract', N'Statement of financial position [abstract]',N'')
  INSERT INTO @AT VALUES(11,0,0,'11', '/1/1/', NULL,N'Assets', N'Assets',N'The amount of resources: (a) controlled by the entity as a result of past events; and (b) from which future economic benefits are expected to flow to the entity.')
  INSERT INTO @AT VALUES(111,0,0,'111', '/1/1/1/', NULL,N'NoncurrentAssets', N'Non-current assets',N'The amount of assets that do not meet the definition of current assets. [Refer: Current assets]')
  INSERT INTO @AT VALUES(11101,1,0,'11101', '/1/1/1/1/', N'ChangesInPropertyPlantAndEquipment',N'PropertyPlantAndEquipment', N'Property, plant and equipment',N'The amount of tangible assets that: (a) are held for use in the production or supply of goods or services, for rental to others, or for administrative purposes; and (b) are expected to be used during more than one period.')
  INSERT INTO @AT VALUES(1110101,1,0,'1110101', '/1/1/1/1/1/', N'ChangesInPropertyPlantAndEquipment',N'LandAndBuildings', N'Land and buildings',N'The amount of property, plant and equipment representing land and depreciable buildings and similar structures for use in operations. [Refer: Buildings; Land; Property, plant and equipment]')
  INSERT INTO @AT VALUES(11101011,1,0,'11101011', '/1/1/1/1/1/1/', N'ChangesInPropertyPlantAndEquipment',N'Land', N'Land',N'The amount of property, plant and equipment representing land held by the entity for use in operations. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(11101012,1,0,'11101012', '/1/1/1/1/1/2/', N'ChangesInPropertyPlantAndEquipment',N'Buildings', N'Buildings',N'The amount of property, plant and equipment representing depreciable buildings and similar structures for use in operations. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(1110102,1,0,'1110102', '/1/1/1/1/2/', N'ChangesInPropertyPlantAndEquipment',N'Machinery', N'Machinery',N'The amount of property, plant and equipment representing long-lived, depreciable machinery used in operations. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(1110103,1,0,'1110103', '/1/1/1/1/3/', N'ChangesInPropertyPlantAndEquipment',N'Vehicles', N'Vehicles',N'The amount of property, plant and equipment representing vehicles used in the entity''s operations, specifically to include aircraft, motor vehicles and ships. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(11101031,1,0,'11101031', '/1/1/1/1/3/1/', N'ChangesInPropertyPlantAndEquipment',N'Ships', N'Ships',N'The amount of property, plant and equipment representing seafaring or other maritime vessels used in the entity''s operations. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(11101032,1,0,'11101032', '/1/1/1/1/3/2/', N'ChangesInPropertyPlantAndEquipment',N'Aircraft', N'Aircraft',N'The amount of property, plant and equipment representing aircraft used in the entity''s operations.')
  INSERT INTO @AT VALUES(11101033,1,0,'11101033', '/1/1/1/1/3/3/', N'ChangesInPropertyPlantAndEquipment',N'MotorVehicles', N'Motor Vehicles',N'The amount of property, plant and equipment representing self-propelled ground vehicles used in the entity''s operations. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(1110106,1,0,'1110106', '/1/1/1/1/6/', N'ChangesInPropertyPlantAndEquipment',N'FixturesAndFittings', N'Fixtures and fittings',N'The amount of fixtures and fittings, not permanently attached to real property, used in the entity''s operations.')
  INSERT INTO @AT VALUES(1110107,1,0,'1110107', '/1/1/1/1/7/', N'ChangesInPropertyPlantAndEquipment',N'OfficeEquipment', N'Office equipment',N'The amount of property, plant and equipment representing equipment used to support office functions, not specifically used in the production process. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(1110108,1,0,'1110108', '/1/1/1/1/8/', N'ChangesInPropertyPlantAndEquipment',N'BearerPlants', N'Bearer plants',N'The amount of property, plant and equipment representing bearer plants. Bearer plant is a living plant that (a) is used in the production or supply of agricultural produce; (b) is expected to bear produce for more than one period; and (c) has a remote likelihood of being sold as agricultural produce, except for incidental scrap sales. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(1110109,1,0,'1110109', '/1/1/1/1/9/', N'ChangesInPropertyPlantAndEquipment',N'TangibleExplorationAndEvaluationAssets', N'Tangible exploration and evaluation assets',N'The amount of exploration and evaluation assets recognised as tangible assets in accordance with the entity''s accounting policy. [Refer: Exploration and evaluation assets [member]]')
  INSERT INTO @AT VALUES(1110110,1,0,'1110110', '/1/1/1/1/10/', N'ChangesInPropertyPlantAndEquipment',N'MiningAssets', N'Mining assets',N'The amount of assets related to mining activities of the entity.')
  INSERT INTO @AT VALUES(1110111,1,0,'1110111', '/1/1/1/1/11/', N'ChangesInPropertyPlantAndEquipment',N'OilAndGasAssets', N'Oil and gas assets',N'The amount of assets related to the exploration, evaluation, development or production of oil and gas.')
  INSERT INTO @AT VALUES(1110112,0,0,'1110112', '/1/1/1/1/12/', NULL,N'ConstructionInProgress', N'Construction in progress',N'The amount of expenditure capitalised during the construction of non-current assets that are not yet available for use. [Refer: Non-current assets]')
  INSERT INTO @AT VALUES(1110113,1,0,'1110113', '/1/1/1/1/13/', N'ChangesInPropertyPlantAndEquipment',N'OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModel', N'Owner-occupied property measured using investment property fair value model',N'The amount of property, plant and equipment representing owner-occupied property measured using the investment property fair value model applying paragraph 29A of IAS 16. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(1110199,1,0,'1110199', '/1/1/1/1/99/', N'ChangesInPropertyPlantAndEquipment',N'OtherPropertyPlantAndEquipment', N'Other property, plant and equipment',N'The amount of property, plant and equipment that the entity does not separately disclose in the same statement or note. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(11102,0,0,'11102', '/1/1/1/2/', NULL,N'InvestmentProperty', N'Investment property',N'The amount of property (land or a building - or part of a building - or both) held (by the owner or by the lessee as a right-of-use asset) to earn rentals or for capital appreciation or both, rather than for: (a) use in the production or supply of goods or services or for administrative purposes; or (b) sale in the ordinary course of business.')
  INSERT INTO @AT VALUES(111021,1,0,'111021', '/1/1/1/2/1/', N'ChangesInInvestmentProperty',N'InvestmentPropertyCompleted', N'Investment property completed',N'The amount of investment property whose construction or development is complete. [Refer: Investment property]')
  INSERT INTO @AT VALUES(111022,0,0,'111022', '/1/1/1/2/2/', NULL,N'InvestmentPropertyUnderConstructionOrDevelopment', N'Investment property under construction or development',N'The amount of property that is being constructed or developed for future use as investment property. [Refer: Investment property]')
  INSERT INTO @AT VALUES(11103,0,0,'11103', '/1/1/1/3/', N'ChangesInGoodwill',N'Goodwill', N'Goodwill',N'The amount of assets representing the future economic benefits arising from other assets acquired in a business combination that are not individually identified and separately recognised. [Refer: Business combinations [member]]')
  INSERT INTO @AT VALUES(11104,1,0,'11104', '/1/1/1/4/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'IntangibleAssetsOtherThanGoodwill', N'Intangible assets other than goodwill',N'The amount of identifiable non-monetary assets without physical substance. This amount does not include goodwill. [Refer: Goodwill]')
  INSERT INTO @AT VALUES(111041,1,0,'111041', '/1/1/1/4/1/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'BrandNames', N'Brand names',N'The amount of intangible assets representing rights to a group of complementary assets such as a trademark (or service mark) and its related trade name, formulas, recipes and technological expertise. [Refer: Intangible assets other than goodwill]')
  INSERT INTO @AT VALUES(111042,1,0,'111042', '/1/1/1/4/2/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'IntangibleExplorationAndEvaluationAssets', N'Intangible exploration and evaluation assets',N'The amount of exploration and evaluation assets recognised as intangible assets in accordance with the entity''s accounting policy. [Refer: Exploration and evaluation assets [member]]')
  INSERT INTO @AT VALUES(111043,1,0,'111043', '/1/1/1/4/3/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'MastheadsAndPublishingTitles', N'Mastheads and publishing titles',N'The amount of intangible assets representing rights acquired through registration to use mastheads and publishing titles. [Refer: Intangible assets other than goodwill]')
  INSERT INTO @AT VALUES(111044,1,0,'111044', '/1/1/1/4/4/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'ComputerSoftware', N'Computer software',N'The amount of intangible assets representing computer software. [Refer: Intangible assets other than goodwill]')
  INSERT INTO @AT VALUES(111045,1,0,'111045', '/1/1/1/4/5/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'LicencesAndFranchises', N'Licences and franchises',N'The amount of intangible assets representing the right to use certain intangible assets owned by another entity and the right to operate a business using the name, merchandise, services, methodologies, promotional support, marketing and supplies granted by another entity. [Refer: Intangible assets other than goodwill]')
  INSERT INTO @AT VALUES(111046,1,0,'111046', '/1/1/1/4/6/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights', N'Copyrights, patents and other industrial property rights, service and operating rights',N'The amount of intangible assets representing copyrights, patents and other industrial property rights, service and operating rights. [Refer: Intangible assets other than goodwill]')
  INSERT INTO @AT VALUES(111047,1,0,'111047', '/1/1/1/4/7/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'RecipesFormulaeModelsDesignsAndPrototypes', N'Recipes, formulae, models, designs and prototypes',N'The amount of intangible assets representing recipes, formulae, models, designs and prototypes. [Refer: Intangible assets other than goodwill]')
  INSERT INTO @AT VALUES(111048,1,0,'111048', '/1/1/1/4/8/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'IntangibleAssetsUnderDevelopment', N'Intangible assets under development',N'The amount of intangible assets representing such assets under development. [Refer: Intangible assets other than goodwill]')
  INSERT INTO @AT VALUES(111049,1,0,'111049', '/1/1/1/4/9/', N'ChangesInIntangibleAssetsOtherThanGoodwill',N'OtherIntangibleAssets', N'Other intangible assets',N'The amount of intangible assets that the entity does not separately disclose in the same statement or note. [Refer: Intangible assets other than goodwill]')
  INSERT INTO @AT VALUES(11105,0,0,'11105', '/1/1/1/5/', NULL,N'InvestmentAccountedForUsingEquityMethod', N'Investments accounted for using equity method',N'The amount of investments accounted for using the equity method. The equity method is a method of accounting whereby the investment is initially recognised at cost and adjusted thereafter for the post-acquisition change in the investor''s share of net assets of the investee. The investor''s profit or loss includes its share of the profit or loss of the investee. The investor''s other comprehensive income includes its share of the other comprehensive income of the investee. [Refer: At cost [member]]')
  INSERT INTO @AT VALUES(111051,0,0,'111051', '/1/1/1/5/1/', NULL,N'InvestmentsInAssociatesAccountedForUsingEquityMethod', N'Investments in associates accounted for using equity method',N'The amount of investments in associates accounted for using the equity method. [Refer: Associates [member]; Investments accounted for using equity method]')
  INSERT INTO @AT VALUES(111052,0,0,'111052', '/1/1/1/5/2/', NULL,N'InvestmentsInJointVenturesAccountedForUsingEquityMethod', N'Investments in joint ventures accounted for using equity method',N'The amount of investments in joint ventures accounted for using the equity method. [Refer: Joint ventures [member]; Investments accounted for using equity method]')
  INSERT INTO @AT VALUES(11106,0,0,'11106', '/1/1/1/6/', NULL,N'InvestmentsInSubsidiariesJointVenturesAndAssociates', N'Investments in subsidiaries, joint ventures and associates',N'The amount of investments in subsidiaries, joint ventures and associates in an entity''s separate financial statements. [Refer: Associates [member]; Joint ventures [member]; Subsidiaries [member]; Investments in subsidiaries]')
  INSERT INTO @AT VALUES(111061,0,0,'111061', '/1/1/1/6/1/', NULL,N'InvestmentsInSubsidiaries', N'Investments in subsidiaries',N'The amount of investments in subsidiaries in an entity''s separate financial statements. [Refer: Subsidiaries [member]]')
  INSERT INTO @AT VALUES(111062,0,0,'111062', '/1/1/1/6/2/', NULL,N'InvestmentsInJointVentures', N'Investments in joint ventures',N'The amount of investments in joint ventures in an entity''s separate financial statements. [Refer: Joint ventures [member]]')
  INSERT INTO @AT VALUES(111063,0,0,'111063', '/1/1/1/6/3/', NULL,N'InvestmentsInAssociates', N'Investments in associates',N'The amount of investments in associates in an entity''s separate financial statements. [Refer: Associates [member]]')
  INSERT INTO @AT VALUES(11107,1,0,'11107', '/1/1/1/7/', N'ChangesInBiologicalAssets',N'NoncurrentBiologicalAssets', N'Non-current biological assets',N'The amount of living animals or plants recognised as assets.')
  INSERT INTO @AT VALUES(11108,0,0,'11108', '/1/1/1/8/', NULL,N'NoncurrentReceivables', N'Trade and other non-current receivables',N'The amount of non-current trade receivables and non-current other receivables. [Refer: Non-current trade receivables; Other non-current receivables]')
  INSERT INTO @AT VALUES(111081,0,1,'111081', '/1/1/1/8/1/', NULL,N'NoncurrentTradeReceivables', N'Non-current trade receivables',N'The amount of non-current trade receivables. [Refer: Trade receivables]')
  INSERT INTO @AT VALUES(111082,0,1,'111082', '/1/1/1/8/2/', NULL,N'NoncurrentReceivablesDueFromRelatedParties', N'Non-current receivables due from related parties',N'The amount of non-current receivables due from related parties. [Refer: Related parties [member]]')
  INSERT INTO @AT VALUES(111083,0,0,'111083', '/1/1/1/8/3/', NULL,N'NoncurrentPrepaymentsAndNoncurrentAccruedIncome', N'Non-current prepayments and non-current accrued income',N'The amount of non-current prepayments and non-current accrued income. [Refer: Prepayments; Accrued income]')
  INSERT INTO @AT VALUES(1110831,0,0,'1110831', '/1/1/1/8/3/1/', NULL,N'NoncurrentPrepayments', N'Non-current prepayments',N'The amount of non-current prepayments. [Refer: Prepayments]')
  INSERT INTO @AT VALUES(1110832,0,0,'1110832', '/1/1/1/8/3/2/', NULL,N'NoncurrentAccruedIncome', N'Non-current accrued income',N'The amount of non-current accrued income. [Refer: Accrued income]')
  INSERT INTO @AT VALUES(111084,0,1,'111084', '/1/1/1/8/4/', NULL,N'NoncurrentReceivablesFromTaxesOtherThanIncomeTax', N'Non-current receivables from taxes other than income tax',N'The amount of non-current receivables from taxes other than income tax. [Refer: Receivables from taxes other than income tax]')
  INSERT INTO @AT VALUES(1110841,0,1,'1110841', '/1/1/1/8/4/1/', NULL,N'NoncurrentValueAddedTaxReceivables', N'Non-current value added tax receivables',N'The amount of non-current value added tax receivables. [Refer: Value added tax receivables]')
  INSERT INTO @AT VALUES(111085,0,1,'111085', '/1/1/1/8/5/', NULL,N'NoncurrentReceivablesFromSaleOfProperties', N'Non-current receivables from sale of properties',N'The amount of non-current receivables from sale of properties. [Refer: Receivables from sale of properties]')
  INSERT INTO @AT VALUES(111086,0,1,'111086', '/1/1/1/8/6/', NULL,N'NoncurrentReceivablesFromRentalOfProperties', N'Non-current receivables from rental of properties',N'The amount of non-current receivables from rental of properties. [Refer: Receivables from rental of properties]')
  INSERT INTO @AT VALUES(111087,0,1,'111087', '/1/1/1/8/7/', NULL,N'OtherNoncurrentReceivables', N'Other non-current receivables',N'The amount of non-current other receivables. [Refer: Other receivables]')
  INSERT INTO @AT VALUES(11109,0,0,'11109', '/1/1/1/9/', NULL,N'NoncurrentInventories', N'Non-current inventories',N'The amount of non-current inventories. [Refer: Inventories]')
  INSERT INTO @AT VALUES(11110,0,1,'11110', '/1/1/1/10/', NULL,N'DeferredTaxAssets', N'Deferred tax assets',N'The amounts of income taxes recoverable in future periods in respect of: (a) deductible temporary differences; (b) the carryforward of unused tax losses; and (c) the carryforward of unused tax credits. [Refer: Temporary differences [member]; Unused tax credits [member]; Unused tax losses [member]]')
  INSERT INTO @AT VALUES(11111,0,1,'11111', '/1/1/1/11/', NULL,N'CurrentTaxAssetsNoncurrent', N'Current tax assets, non-current',N'The non-current amount of current tax assets. [Refer: Current tax assets]')
  INSERT INTO @AT VALUES(11112,0,1,'11112', '/1/1/1/12/', NULL,N'OtherNoncurrentFinancialAssets', N'Other non-current financial assets',N'The amount of non-current financial assets that the entity does not separately disclose in the same statement or note. [Refer: Other financial assets]')
  INSERT INTO @AT VALUES(111121,0,1,'111121', '/1/1/1/12/1/', NULL,N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLoss', N'Non-current financial assets at fair value through profit or loss',N'The amount of non-current financial assets measured at fair value through profit or loss. [Refer: Financial assets at fair value through profit or loss]')
  INSERT INTO @AT VALUES(1111211,0,1,'1111211', '/1/1/1/12/1/1/', NULL,N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition', N'Non-current financial assets at fair value through profit or loss, designated upon initial recognition or subsequently',N'The amount of non-current financial assets measured at fair value through profit or loss that were designated as such upon initial recognition or subsequently. [Refer: Financial assets at fair value through profit or loss, designated upon initial recognition or subsequently]')
  INSERT INTO @AT VALUES(1111212,0,1,'1111212', '/1/1/1/12/1/2/', NULL,N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForRepurchaseOfOwnFinancialLiabilities', N'Non-current financial assets at fair value through profit or loss, measured as such in accordance with exemption for repurchase of own financial liabilities',N'The amount of non-current financial assets at fair value through profit or loss measured as such in accordance with the exemption for repurchase of own financial liabilities. [Refer: Financial assets at fair value through profit or loss, measured as such in accordance with exemption for repurchase of own financial liabilities]')
  INSERT INTO @AT VALUES(1111213,0,1,'1111213', '/1/1/1/12/1/3/', NULL,N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForReacquisitionOfOwnEquityInstruments', N'Non-current financial assets at fair value through profit or loss, measured as such in accordance with exemption for reacquisition of own equity instruments',N'The amount of non-current financial assets at fair value through profit or loss measured as such in accordance with the exemption for reacquisition of own equity instruments. [Refer: Financial assets at fair value through profit or loss, measured as such in accordance with exemption for reacquisition of own equity instruments]')
  INSERT INTO @AT VALUES(1111214,0,1,'1111214', '/1/1/1/12/1/4/', NULL,N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading', N'Non-current financial assets at fair value through profit or loss, classified as held for trading',N'The amount of non-current financial assets that are measured at fair value through profit or loss and that are classified as held for trading. [Refer: Financial assets at fair value through profit or loss, classified as held for trading]')
  INSERT INTO @AT VALUES(1111215,0,1,'1111215', '/1/1/1/12/1/5/', NULL,N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMandatorilyMeasuredAtFairValue', N'Non-current financial assets at fair value through profit or loss, mandatorily measured at fair value',N'The amount of non-current financial assets mandatorily measured at fair value through profit or loss in accordance with IFRS 9. [Refer: Financial assets at fair value through profit or loss, mandatorily measured at fair value]')
  INSERT INTO @AT VALUES(111122,0,1,'111122', '/1/1/1/12/2/', NULL,N'NoncurrentFinancialAssetsAvailableforsale', N'Non-current financial assets available-for-sale',N'The amount of non-current financial assets available-for-sale. [Refer: Financial assets available-for-sale; Non-current financial assets]')
  INSERT INTO @AT VALUES(111123,0,1,'111123', '/1/1/1/12/3/', NULL,N'NoncurrentHeldtomaturityInvestments', N'Non-current held-to-maturity investments',N'The amount of non-current held-to-maturity investments. [Refer: Held-to-maturity investments]')
  INSERT INTO @AT VALUES(111124,0,1,'111124', '/1/1/1/12/4/', NULL,N'NoncurrentLoansAndReceivables', N'Non-current loans and receivables',N'The amount of non-current loans and receivables. [Refer: Loans and receivables]')
  INSERT INTO @AT VALUES(111125,0,1,'111125', '/1/1/1/12/5/', NULL,N'NoncurrentFinancialAssetsAtFairValueThroughOtherComprehensiveIncome', N'Non-current financial assets at fair value through other comprehensive income',N'The amount of non-current financial assets at fair value through other comprehensive income. [Refer: Financial assets at fair value through other comprehensive income]')
  INSERT INTO @AT VALUES(1111251,0,1,'1111251', '/1/1/1/12/5/1/', NULL,N'NoncurrentFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome', N'Non-current financial assets measured at fair value through other comprehensive income',N'The amount of non-current financial assets measured at fair value through other comprehensive income. [Refer: Financial assets measured at fair value through other comprehensive income]')
  INSERT INTO @AT VALUES(1111252,0,1,'1111252', '/1/1/1/12/5/2/', NULL,N'NoncurrentInvestmentsInEquityInstrumentsDesignatedAtFairValueThroughOtherComprehensiveIncome', N'Non-current investments in equity instruments designated at fair value through other comprehensive income',N'The amount of non-current investments in equity instruments that the entity has designated at fair value through other comprehensive income. [Refer: Investments in equity instruments designated at fair value through other comprehensive income]')
  INSERT INTO @AT VALUES(111126,0,1,'111126', '/1/1/1/12/6/', NULL,N'NoncurrentFinancialAssetsAtAmortisedCost', N'Non-current financial assets at amortised cost',N'The amount of non-current financial assets measured at amortised cost. [Refer: Financial assets at amortised cost]')
  INSERT INTO @AT VALUES(11113,0,0,'11113', '/1/1/1/13/', NULL,N'OtherNoncurrentNonfinancialAssets', N'Other non-current non-financial assets',N'The amount of non-current non-financial assets that the entity does not separately disclose in the same statement or note. [Refer: Financial assets]')
  INSERT INTO @AT VALUES(11114,0,0,'11114', '/1/1/1/14/', NULL,N'NoncurrentNoncashAssetsPledgedAsCollateralForWhichTransfereeHasRightByContractOrCustomToSellOrRepledgeCollateral', N'Non-current non-cash assets pledged as collateral for which transferee has right by contract or custom to sell or repledge collateral',N'The amount of non-current non-cash collateral assets (such as debt or equity instruments) provided to a transferee, for which the transferee has the right by contract or custom to sell or repledge the collateral.')
  INSERT INTO @AT VALUES(112,0,0,'112', '/1/1/2/', NULL,N'CurrentAssets', N'Current assets',N'The amount of assets that the entity (a) expects to realise or intends to sell or consume in its normal operating cycle; (b) holds primarily for the purpose of trading; (c) expects to realise within twelve months after the reporting period; or (d) classifies as cash or cash equivalents (as defined in IAS 7) unless the asset is restricted from being exchanged or used to settle a liability for at least twelve months after the reporting period. [Refer: Assets]')
  INSERT INTO @AT VALUES(1121,0,0,'1121', '/1/1/2/1/', NULL,N'CurrentAssetsOtherThanAssetsOrDisposalGroupsClassifiedAsHeldForSaleOrAsHeldForDistributionToOwners', N'Current assets other than non-current assets or disposal groups classified as held for sale or as held for distribution to owners',N'The amount of current assets other than non-current assets or disposal groups classified as held for sale or as held for distribution to owners. [Refer: Current assets; Disposal groups classified as held for sale [member]; Non-current assets or disposal groups classified as held for sale; Non-current assets or disposal groups classified as held for distribution to owners]')
  INSERT INTO @AT VALUES(11211,0,0,'11211', '/1/1/2/1/1/', N'ChangesInInventories',N'Inventories', N'Current inventories',N'The amount of current inventories. [Refer: Inventories]')
  INSERT INTO @AT VALUES(112111,0,0,'112111', '/1/1/2/1/1/1/', N'ChangesInInventories',N'CurrentInventoriesHeldForSale', N'Current inventories held for sale',N'A classification of current inventory representing the amount of inventories held for sale in the ordinary course of business. [Refer: Inventories]')
  INSERT INTO @AT VALUES(1121111,0,0,'1121111', '/1/1/2/1/1/1/1/', N'ChangesInInventories',N'Merchandise', N'Current merchandise',N'A classification of current inventory representing the amount of goods acquired for resale. [Refer: Inventories]')
  INSERT INTO @AT VALUES(1121112,0,0,'1121112', '/1/1/2/1/1/1/2/', N'ChangesInInventories',N'CurrentFoodAndBeverage', N'Current food and beverage',N'A classification of current inventory representing the amount of food and beverage. [Refer: Inventories]')
  INSERT INTO @AT VALUES(1121113,0,0,'1121113', '/1/1/2/1/1/1/3/', N'ChangesInInventories',N'CurrentAgriculturalProduce', N'Current agricultural produce',N'A classification of current inventory representing the amount of harvested produce of the entity''s biological assets. [Refer: Biological assets; Inventories]')
  INSERT INTO @AT VALUES(1121114,0,0,'1121114', '/1/1/2/1/1/1/4/', N'ChangesInInventories',N'FinishedGoods', N'Current finished goods',N'A classification of current inventory representing the amount of goods that have completed the production process and are held for sale in the ordinary course of business. [Refer: Inventories]')
  INSERT INTO @AT VALUES(1121115,0,0,'1121115', '/1/1/2/1/1/1/5/', N'ChangesInInventories',N'PropertyIntendedForSaleInOrdinaryCourseOfBusiness', N'Property intended for sale in ordinary course of business',N'The amount of property intended for sale in the ordinary course of business of the entity. Property is land or a building - or part of a building - or both.')
  INSERT INTO @AT VALUES(112112,0,0,'112112', '/1/1/2/1/1/2/', N'ChangesInInventories',N'WorkInProgress', N'Current work in progress',N'A classification of current inventory representing the amount of assets currently in production, which require further processes to be converted into finished goods or services. [Refer: Current finished goods; Inventories]')
  INSERT INTO @AT VALUES(112113,0,0,'112113', '/1/1/2/1/1/3/', N'ChangesInInventories',N'CurrentMaterialsAndSuppliesToBeConsumedInProductionProcessOrRenderingServices', N'Current materials and supplies to be consumed in production process or rendering services',N'A classification of current inventory representing the amount of materials and supplies to be consumed in a production process or while rendering services. [Refer: Inventories]')
  INSERT INTO @AT VALUES(1121131,0,0,'1121131', '/1/1/2/1/1/3/1/', N'ChangesInInventories',N'CurrentRawMaterialsAndCurrentProductionSupplies', N'Current raw materials and current production supplies',N'A classification of current inventory representing the amount of current raw materials and current production supplies. [Refer: Current production supplies; Current raw materials]')
  INSERT INTO @AT VALUES(11211311,0,0,'11211311', '/1/1/2/1/1/3/1/1/', N'ChangesInInventories',N'RawMaterials', N'Current raw materials',N'A classification of current inventory representing the amount of assets to be consumed in the production process or in the rendering of services. [Refer: Inventories]')
  INSERT INTO @AT VALUES(11211312,0,0,'11211312', '/1/1/2/1/1/3/1/2/', N'ChangesInInventories',N'ProductionSupplies', N'Current production supplies',N'A classification of current inventory representing the amount of supplies to be used for the production process. [Refer: Inventories]')
  INSERT INTO @AT VALUES(1121132,0,0,'1121132', '/1/1/2/1/1/3/2/', N'ChangesInInventories',N'CurrentPackagingAndStorageMaterials', N'Current packaging and storage materials',N'A classification of current inventory representing the amount of packaging and storage materials. [Refer: Inventories]')
  INSERT INTO @AT VALUES(1121133,0,0,'1121133', '/1/1/2/1/1/3/3/', N'ChangesInInventories',N'SpareParts', N'Current spare parts',N'A classification of current inventory representing the amount of interchangeable parts that are kept in an inventory and are used for the repair or replacement of failed parts. [Refer: Inventories]')
  INSERT INTO @AT VALUES(1121134,0,0,'1121134', '/1/1/2/1/1/3/4/', N'ChangesInInventories',N'CurrentFuel', N'Current fuel',N'A classification of current inventory representing the amount of fuel. [Refer: Inventories]')
  INSERT INTO @AT VALUES(112114,0,0,'112114', '/1/1/2/1/1/4/', N'ChangesInInventories',N'CurrentInventoriesInTransit', N'Current inventories in transit',N'A classification of current inventory representing the amount of inventories in transit. [Refer: Inventories]')
  INSERT INTO @AT VALUES(112119,0,0,'112119', '/1/1/2/1/1/9/', N'ChangesInInventories',N'OtherInventories', N'Other current inventories',N'The amount of inventory that the entity does not separately disclose in the same statement or note. [Refer: Inventories]')
  INSERT INTO @AT VALUES(11212,0,0,'11212', '/1/1/2/1/2/', NULL,N'TradeAndOtherCurrentReceivables', N'Trade and other current receivables',N'The amount of current trade receivables and current other receivables. [Refer: Current trade receivables; Other current receivables]')
  INSERT INTO @AT VALUES(112121,0,1,'112121', '/1/1/2/1/2/1/', NULL,N'CurrentTradeReceivables', N'Current trade receivables',N'The amount of current trade receivables. [Refer: Trade receivables]')
  INSERT INTO @AT VALUES(112122,0,1,'112122', '/1/1/2/1/2/2/', NULL,N'TradeAndOtherCurrentReceivablesDueFromRelatedParties', N'Current receivables due from related parties',N'The amount of current receivables due from related parties. [Refer: Related parties [member]]')
  INSERT INTO @AT VALUES(112123,0,0,'112123', '/1/1/2/1/2/3/', NULL,N'CurrentPrepaymentsAndCurrentAccruedIncome', N'Current prepayments and current accrued income',N'The amount of current prepayments and current accrued income. [Refer: Prepayments; Accrued income]')
  INSERT INTO @AT VALUES(1121231,0,0,'1121231', '/1/1/2/1/2/3/1/', NULL,N'CurrentPrepayments', N'Current prepayments',N'The amount of current prepayments. [Refer: Prepayments]')
  INSERT INTO @AT VALUES(11212311,0,1,'11212311', '/1/1/2/1/2/3/1/1/', NULL,N'CurrentAdvancesToSuppliers', N'Current advances to suppliers',N'The amount of current advances made to suppliers before goods or services are received.')
  INSERT INTO @AT VALUES(11212312,0,1,'11212312', '/1/1/2/1/2/3/1/2/', NULL,N'CurrentPrepaidExpenses', N'Current prepaid expenses',N'The amount recognised as a current asset for expenditures made prior to the period when the economic benefit will be realised.')
  INSERT INTO @AT VALUES(1121232,0,1,'1121232', '/1/1/2/1/2/3/2/', NULL,N'CurrentAccruedIncome', N'Current accrued income',N'The amount of current accrued income. [Refer: Accrued income]')
  INSERT INTO @AT VALUES(112124,0,1,'112124', '/1/1/2/1/2/4/', NULL,N'CurrentBilledNotReceivedFromSuppliersExtension', N'Current billed but not received',N'')
  INSERT INTO @AT VALUES(112125,0,1,'112125', '/1/1/2/1/2/5/', NULL,N'CurrentReceivablesFromTaxesOtherThanIncomeTax', N'Current receivables from taxes other than income tax',N'The amount of current receivables from taxes other than income tax. [Refer: Receivables from taxes other than income tax]')
  INSERT INTO @AT VALUES(1121251,0,1,'1121251', '/1/1/2/1/2/5/1/', NULL,N'CurrentValueAddedTaxReceivables', N'Current value added tax receivables',N'The amount of current value added tax receivables. [Refer: Value added tax receivables]')
  INSERT INTO @AT VALUES(112127,0,1,'112127', '/1/1/2/1/2/7/', NULL,N'CurrentReceivablesFromRentalOfProperties', N'Current receivables from rental of properties',N'The amount of current receivables from rental of properties. [Refer: Receivables from rental of properties]')
  INSERT INTO @AT VALUES(112128,0,1,'112128', '/1/1/2/1/2/8/', NULL,N'OtherCurrentReceivables', N'Other current receivables',N'The amount of current other receivables. [Refer: Other receivables]')
  INSERT INTO @AT VALUES(11213,0,1,'11213', '/1/1/2/1/3/', NULL,N'CurrentTaxAssetsCurrent', N'Current tax assets, current',N'The current amount of current tax assets. [Refer: Current tax assets]')
  INSERT INTO @AT VALUES(11214,0,0,'11214', '/1/1/2/1/4/', NULL,N'CurrentBiologicalAssets', N'Current biological assets',N'The amount of current biological assets. [Refer: Biological assets]')
  INSERT INTO @AT VALUES(11215,0,1,'11215', '/1/1/2/1/5/', NULL,N'OtherCurrentFinancialAssets', N'Other current financial assets',N'The amount of current financial assets that the entity does not separately disclose in the same statement or note. [Refer: Other financial assets; Current financial assets]')
  INSERT INTO @AT VALUES(112151,0,1,'112151', '/1/1/2/1/5/1/', NULL,N'CurrentFinancialAssetsAtFairValueThroughProfitOrLoss', N'Current financial assets at fair value through profit or loss',N'The amount of current financial assets measured at fair value through profit or loss. [Refer: Financial assets at fair value through profit or loss]')
  INSERT INTO @AT VALUES(1121511,0,1,'1121511', '/1/1/2/1/5/1/1/', NULL,N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition', N'Current financial assets at fair value through profit or loss, designated upon initial recognition or subsequently',N'The amount of Current financial assets measured at fair value through profit or loss that were designated as such upon initial recognition or subsequently. [Refer: Financial assets at fair value through profit or loss, designated upon initial recognition or subsequently]')
  INSERT INTO @AT VALUES(1121512,0,1,'1121512', '/1/1/2/1/5/1/2/', NULL,N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForRepurchaseOfOwnFinancialLiabilities', N'Current financial assets at fair value through profit or loss, measured as such in accordance with exemption for repurchase of own financial liabilities',N'The amount of Current financial assets at fair value through profit or loss measured as such in accordance with the exemption for repurchase of own financial liabilities. [Refer: Financial assets at fair value through profit or loss, measured as such in accordance with exemption for repurchase of own financial liabilities]')
  INSERT INTO @AT VALUES(1121513,0,1,'1121513', '/1/1/2/1/5/1/3/', NULL,N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForReacquisitionOfOwnEquityInstruments', N'Current financial assets at fair value through profit or loss, measured as such in accordance with exemption for reacquisition of own equity instruments',N'The amount of Current financial assets at fair value through profit or loss measured as such in accordance with the exemption for reacquisition of own equity instruments. [Refer: Financial assets at fair value through profit or loss, measured as such in accordance with exemption for reacquisition of own equity instruments]')
  INSERT INTO @AT VALUES(1121514,0,1,'1121514', '/1/1/2/1/5/1/4/', NULL,N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading', N'Current financial assets at fair value through profit or loss, classified as held for trading',N'The amount of Current financial assets that are measured at fair value through profit or loss and that are classified as held for trading. [Refer: Financial assets at fair value through profit or loss, classified as held for trading]')
  INSERT INTO @AT VALUES(1121515,0,1,'1121515', '/1/1/2/1/5/1/5/', NULL,N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossMandatorilyMeasuredAtFairValue', N'Current financial assets at fair value through profit or loss, mandatorily measured at fair value',N'The amount of Current financial assets mandatorily measured at fair value through profit or loss in accordance with IFRS 9. [Refer: Financial assets at fair value through profit or loss, mandatorily measured at fair value]')
  INSERT INTO @AT VALUES(112152,0,1,'112152', '/1/1/2/1/5/2/', NULL,N'CurrentFinancialAssetsAvailableforsale', N'Current financial assets available-for-sale',N'The amount of Current financial assets available-for-sale. [Refer: Financial assets available-for-sale; Current financial assets]')
  INSERT INTO @AT VALUES(112153,0,1,'112153', '/1/1/2/1/5/3/', NULL,N'CurrentHeldtomaturityInvestments', N'Current held-to-maturity investments',N'The amount of Current held-to-maturity investments. [Refer: Held-to-maturity investments]')
  INSERT INTO @AT VALUES(112154,0,1,'112154', '/1/1/2/1/5/4/', NULL,N'CurrentLoansAndReceivables', N'Current loans and receivables',N'The amount of Current loans and receivables. [Refer: Loans and receivables]')
  INSERT INTO @AT VALUES(112155,0,1,'112155', '/1/1/2/1/5/5/', NULL,N'CurrentFinancialAssetsAtFairValueThroughOtherComprehensiveIncome', N'Current financial assets at fair value through other comprehensive income',N'The amount of Current financial assets at fair value through other comprehensive income. [Refer: Financial assets at fair value through other comprehensive income]')
  INSERT INTO @AT VALUES(1121551,0,1,'1121551', '/1/1/2/1/5/5/1/', NULL,N'CurrentFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome', N'Current financial assets measured at fair value through other comprehensive income',N'The amount of Current financial assets measured at fair value through other comprehensive income. [Refer: Financial assets measured at fair value through other comprehensive income]')
  INSERT INTO @AT VALUES(1121552,0,1,'1121552', '/1/1/2/1/5/5/2/', NULL,N'CurrentInvestmentsInEquityInstrumentsDesignatedAtFairValueThroughOtherComprehensiveIncome', N'Current investments in equity instruments designated at fair value through other comprehensive income',N'The amount of Current investments in equity instruments that the entity has designated at fair value through other comprehensive income. [Refer: Investments in equity instruments designated at fair value through other comprehensive income]')
  INSERT INTO @AT VALUES(112156,0,1,'112156', '/1/1/2/1/5/6/', NULL,N'CurrentFinancialAssetsAtAmortisedCost', N'Current financial assets at amortised cost',N'The amount of Current financial assets measured at amortised cost. [Refer: Financial assets at amortised cost]')
  INSERT INTO @AT VALUES(11216,0,0,'11216', '/1/1/2/1/6/', NULL,N'OtherCurrentNonfinancialAssets', N'Other current non-financial assets',N'The amount of current non-financial assets that the entity does not separately disclose in the same statement or note. [Refer: Financial assets]')
  INSERT INTO @AT VALUES(11217,0,1,'11217', '/1/1/2/1/7/', N'IncreaseDecreaseInCashAndCashEquivalents',N'CashAndCashEquivalents', N'Cash and cash equivalents',N'The amount of cash on hand and demand deposits, along with short-term, highly liquid investments that are readily convertible to known amounts of cash and that are subject to an insignificant risk of changes in value. [Refer: Cash; Cash equivalents]')
  INSERT INTO @AT VALUES(112171,0,1,'112171', '/1/1/2/1/7/1/', N'IncreaseDecreaseInCashAndCashEquivalents',N'Cash', N'Cash',N'The amount of cash on hand and demand deposits. [Refer: Cash on hand]')
  INSERT INTO @AT VALUES(1121711,0,1,'1121711', '/1/1/2/1/7/1/1/', N'IncreaseDecreaseInCashAndCashEquivalents',N'CashOnHand', N'Cash on hand',N'The amount of cash held by the entity. This does not include demand deposits.')
  INSERT INTO @AT VALUES(1121712,0,1,'1121712', '/1/1/2/1/7/1/2/', N'IncreaseDecreaseInCashAndCashEquivalents',N'BalancesWithBanks', N'Balances with banks',N'The amount of cash balances held at banks.')
  INSERT INTO @AT VALUES(112172,0,1,'112172', '/1/1/2/1/7/2/', N'IncreaseDecreaseInCashAndCashEquivalents',N'CashEquivalents', N'Cash equivalents',N'The amount of short-term, highly liquid investments that are readily convertible to known amounts of cash and that are subject to an insignificant risk of changes in value.')
  INSERT INTO @AT VALUES(1121721,0,1,'1121721', '/1/1/2/1/7/2/1/', N'IncreaseDecreaseInCashAndCashEquivalents',N'ShorttermDepositsClassifiedAsCashEquivalents', N'Short-term deposits, classified as cash equivalents',N'A classification of cash equivalents representing short-term deposits. [Refer: Cash equivalents]')
  INSERT INTO @AT VALUES(1121722,0,1,'1121722', '/1/1/2/1/7/2/2/', N'IncreaseDecreaseInCashAndCashEquivalents',N'ShorttermInvestmentsClassifiedAsCashEquivalents', N'Short-term investments, classified as cash equivalents',N'A classification of cash equivalents representing short-term investments. [Refer: Cash equivalents]')
  INSERT INTO @AT VALUES(1121723,0,1,'1121723', '/1/1/2/1/7/2/3/', N'IncreaseDecreaseInCashAndCashEquivalents',N'BankingArrangementsClassifiedAsCashEquivalents', N'Other banking arrangements, classified as cash equivalents',N'A classification of cash equivalents representing banking arrangements that the entity does not separately disclose in the same statement or note. [Refer: Cash equivalents]')
  INSERT INTO @AT VALUES(112173,0,1,'112173', '/1/1/2/1/7/3/', N'IncreaseDecreaseInCashAndCashEquivalents',N'OtherCashAndCashEquivalents', N'Other cash and cash equivalents',N'The amount of cash and cash equivalents that the entity does not separately disclose in the same statement or note. [Refer: Cash and cash equivalents]')
  INSERT INTO @AT VALUES(11218,0,0,'11218', '/1/1/2/1/8/', NULL,N'CurrentNoncashAssetsPledgedAsCollateralForWhichTransfereeHasRightByContractOrCustomToSellOrRepledgeCollateral', N'Current non-cash assets pledged as collateral for which transferee has right by contract or custom to sell or repledge collateral',N'The amount of current non-cash collateral assets (such as debt or equity instruments) provided to a transferee, for which the transferee has the right by contract or custom to sell or repledge the collateral.')
  INSERT INTO @AT VALUES(1122,0,0,'1122', '/1/1/2/2/', NULL,N'NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForSaleOrAsHeldForDistributionToOwners', N'Non-current assets or disposal groups classified as held for sale or as held for distribution to owners',N'The amount of non-current assets or disposal groups classified as held for sale or as held for distribution to owners. [Refer: Non-current assets or disposal groups classified as held for distribution to owners; Non-current assets or disposal groups classified as held for sale]')
  INSERT INTO @AT VALUES(11221,0,0,'11221', '/1/1/2/2/1/', NULL,N'NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForSale', N'Non-current assets or disposal groups classified as held for sale',N'The amount of non-current assets or disposal groups classified as held for sale. [Refer: Disposal groups classified as held for sale [member]]')
  INSERT INTO @AT VALUES(11222,0,0,'11222', '/1/1/2/2/2/', NULL,N'NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForDistributionToOwners', N'Non-current assets or disposal groups classified as held for distribution to owners',N'The amount of non-current assets or disposal groups classified as held for distribution to owners. [Refer: Non-current assets]')
  INSERT INTO @AT VALUES(12,0,0,'12', '/1/2/', NULL,N'EquityAndLiabilities', N'Equity and liabilities',N'The amount of the entity''s equity and liabilities. [Refer: Equity; Liabilities]')
  INSERT INTO @AT VALUES(121,0,0,'121', '/1/2/1/', N'ChangesInEquity',N'Equity', N'Equity',N'The amount of residual interest in the assets of the entity after deducting all its liabilities.')
  INSERT INTO @AT VALUES(1211,0,0,'1211', '/1/2/1/1/', N'ChangesInEquity',N'IssuedCapital', N'Issued capital',N'The nominal value of capital issued.')
  INSERT INTO @AT VALUES(1212,0,0,'1212', '/1/2/1/2/', N'ChangesInEquity',N'RetainedEarnings', N'Retained earnings',N'A component of equity representing the entity''s cumulative undistributed earnings or deficit.')
  INSERT INTO @AT VALUES(1213,0,0,'1213', '/1/2/1/3/', N'ChangesInEquity',N'SharePremium', N'Share premium',N'The amount received or receivable from the issuance of the entity''s shares in excess of nominal value.')
  INSERT INTO @AT VALUES(1214,0,0,'1214', '/1/2/1/4/', N'ChangesInEquity',N'TreasuryShares', N'Treasury shares',N'An entity’s own equity instruments, held by the entity or other members of the consolidated group.')
  INSERT INTO @AT VALUES(1215,0,0,'1215', '/1/2/1/5/', N'ChangesInEquity',N'OtherEquityInterest', N'Other equity interest',N'The amount of equity interest of an entity without share capital that the entity does not separately disclose in the same statement or note.')
  INSERT INTO @AT VALUES(1216,0,0,'1216', '/1/2/1/6/', N'ChangesInEquity',N'OtherReserves', N'Other reserves',N'A component of equity representing reserves within equity, not including retained earnings. [Refer: Retained earnings]')
  INSERT INTO @AT VALUES(121601,0,0,'121601', '/1/2/1/6/1/', N'ChangesInEquity',N'RevaluationSurplus', N'Revaluation surplus',N'A component of equity representing the accumulated revaluation surplus on the revaluation of assets recognised in other comprehensive income. [Refer: Other comprehensive income]')
  INSERT INTO @AT VALUES(121602,0,0,'121602', '/1/2/1/6/2/', N'ChangesInEquity',N'ReserveOfExchangeDifferencesOnTranslation', N'Reserve of exchange differences on translation',N'A component of equity representing exchange differences on translation of financial statements of foreign operations recognised in other comprehensive income and accumulated in equity. [Refer: Other comprehensive income]')
  INSERT INTO @AT VALUES(121603,0,0,'121603', '/1/2/1/6/3/', N'ChangesInEquity',N'ReserveOfCashFlowHedges', N'Reserve of cash flow hedges',N'A component of equity representing the accumulated portion of gain (loss) on a hedging instrument that is determined to be an effective hedge for cash flow hedges. [Refer: Cash flow hedges [member]]')
  INSERT INTO @AT VALUES(121604,0,0,'121604', '/1/2/1/6/4/', N'ChangesInEquity',N'ReserveOfGainsAndLossesOnHedgingInstrumentsThatHedgeInvestmentsInEquityInstruments', N'Reserve of gains and losses on hedging instruments that hedge investments in equity instruments',N'A component of equity representing the accumulated gains and losses on hedging instruments that hedge investments in equity instruments that the entity has designated at fair value through other comprehensive income.')
  INSERT INTO @AT VALUES(121605,0,0,'121605', '/1/2/1/6/5/', N'ChangesInEquity',N'ReserveOfChangeInValueOfTimeValueOfOptions', N'Reserve of change in value of time value of options',N'A component of equity representing the accumulated change in the value of the time value of options when separating the intrinsic value and time value of an option contract and designating as the hedging instrument only the changes in the intrinsic value.')
  INSERT INTO @AT VALUES(121606,0,0,'121606', '/1/2/1/6/6/', N'ChangesInEquity',N'ReserveOfChangeInValueOfForwardElementsOfForwardContracts', N'Reserve of change in value of forward elements of forward contracts',N'A component of equity representing the accumulated change in the value of the forward elements of forward contracts when separating the forward element and spot element of a forward contract and designating as the hedging instrument only the changes in the spot element.')
  INSERT INTO @AT VALUES(121607,0,0,'121607', '/1/2/1/6/7/', N'ChangesInEquity',N'ReserveOfChangeInValueOfForeignCurrencyBasisSpreads', N'Reserve of change in value of foreign currency basis spreads',N'A component of equity representing the accumulated change in the value of foreign currency basis spreads of financial instruments when excluding them from the designation of these financial instruments as hedging instruments.')
  INSERT INTO @AT VALUES(121608,0,0,'121608', '/1/2/1/6/8/', N'ChangesInEquity',N'ReserveOfGainsAndLossesOnFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome', N'Reserve of gains and losses on financial assets measured at fair value through other comprehensive income',N'A component of equity representing the reserve of gains and losses on financial assets measured at fair value through other comprehensive income. [Refer: Financial assets measured at fair value through other comprehensive income; Other comprehensive income]')
  INSERT INTO @AT VALUES(121609,0,0,'121609', '/1/2/1/6/9/', N'ChangesInEquity',N'ReserveOfInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillBeReclassifiedToProfitOrLoss', N'Reserve of insurance finance income (expenses) from insurance contracts issued excluded from profit or loss that will be reclassified to profit or loss',N'A component of equity representing the accumulated insurance finance income (expenses) from insurance contracts issued excluded from profit or loss that will be reclassified subsequently to profit or loss. [Refer: Insurance finance income (expenses); Insurance contracts issued [member]]')
  INSERT INTO @AT VALUES(121610,0,0,'121610', '/1/2/1/6/10/', N'ChangesInEquity',N'ReserveOfInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillNotBeReclassifiedToProfitOrLoss', N'Reserve of insurance finance income (expenses) from insurance contracts issued excluded from profit or loss that will not be reclassified to profit or loss',N'A component of equity representing the accumulated insurance finance income (expenses) from insurance contracts issued excluded from profit or loss that will not be reclassified subsequently to profit or loss. [Refer: Insurance finance income (expenses); Insurance contracts issued [member]]')
  INSERT INTO @AT VALUES(121611,0,0,'121611', '/1/2/1/6/11/', N'ChangesInEquity',N'ReserveOfFinanceIncomeExpensesFromReinsuranceContractsHeldExcludedFromProfitOrLoss', N'Reserve of finance income (expenses) from reinsurance contracts held excluded from profit or loss',N'A component of equity representing the accumulated finance income (expenses) from reinsurance contracts held excluded from profit or loss. [Refer: Insurance finance income (expenses); Reinsurance contracts held [member]]')
  INSERT INTO @AT VALUES(121612,0,0,'121612', '/1/2/1/6/12/', N'ChangesInEquity',N'ReserveOfGainsAndLossesOnRemeasuringAvailableforsaleFinancialAssets', N'Reserve of gains and losses on remeasuring available-for-sale financial assets',N'A component of equity representing accumulated gains and losses on remeasuring available-for-sale financial assets. [Refer: Financial assets available-for-sale]')
  INSERT INTO @AT VALUES(121613,0,0,'121613', '/1/2/1/6/13/', N'ChangesInEquity',N'ReserveOfSharebasedPayments', N'Reserve of share-based payments',N'A component of equity resulting from share-based payments.')
  INSERT INTO @AT VALUES(121614,0,0,'121614', '/1/2/1/6/14/', N'ChangesInEquity',N'ReserveOfRemeasurementsOfDefinedBenefitPlans', N'Reserve of remeasurements of defined benefit plans',N'A component of equity representing the accumulated remeasurements of defined benefit plans. [Refer: Defined benefit plans [member]]')
  INSERT INTO @AT VALUES(121615,0,0,'121615', '/1/2/1/6/15/', N'ChangesInEquity',N'AmountRecognisedInOtherComprehensiveIncomeAndAccumulatedInEquityRelatingToNoncurrentAssetsOrDisposalGroupsHeldForSale', N'Amount recognised in other comprehensive income and accumulated in equity relating to non-current assets or disposal groups held for sale',N'The amount recognised in other comprehensive income and accumulated in equity, relating to non-current assets or disposal groups held for sale. [Refer: Non-current assets or disposal groups classified as held for sale; Other reserves; Other comprehensive income; Disposal groups classified as held for sale [member]]')
  INSERT INTO @AT VALUES(121616,0,0,'121616', '/1/2/1/6/16/', N'ChangesInEquity',N'ReserveOfGainsAndLossesFromInvestmentsInEquityInstruments', N'Reserve of gains and losses from investments in equity instruments',N'A component of equity representing accumulated gains and losses from investments in equity instruments that the entity has designated at fair value through other comprehensive income.')
  INSERT INTO @AT VALUES(121617,0,0,'121617', '/1/2/1/6/17/', N'ChangesInEquity',N'ReserveOfChangeInFairValueOfFinancialLiabilityAttributableToChangeInCreditRiskOfLiability', N'Reserve of change in fair value of financial liability attributable to change in credit risk of liability',N'A component of equity representing the accumulated change in fair value of financial liabilities attributable to change in the credit risk of the liabilities. [Refer: Credit risk [member]; Financial liabilities]')
  INSERT INTO @AT VALUES(121618,0,0,'121618', '/1/2/1/6/18/', N'ChangesInEquity',N'ReserveForCatastrophe', N'Reserve for catastrophe',N'A component of equity representing resources to provide for infrequent but severe catastrophic losses caused by events such as damage to nuclear installations or satellites, or earthquake damage.')
  INSERT INTO @AT VALUES(121619,0,0,'121619', '/1/2/1/6/19/', N'ChangesInEquity',N'ReserveForEqualisation', N'Reserve for equalisation',N'A component of equity representing resources to cover random fluctuations of claim expenses around the expected value of claims for some types of insurance contract.')
  INSERT INTO @AT VALUES(121620,0,0,'121620', '/1/2/1/6/20/', N'ChangesInEquity',N'ReserveOfDiscretionaryParticipationFeatures', N'Reserve of discretionary participation features',N'A component of equity resulting from discretionary participation features. Discretionary participation features are contractual rights to receive, as a supplement to guaranteed benefits, additional benefits: (a) that are likely to be a significant portion of the total contractual benefits; (b) whose amount or timing is contractually at the discretion of the issuer; and (c) that are contractually based on: (i) the performance of a specified pool of contracts or a specified type of contract; (ii) realised and/or unrealised investment returns on a specified pool of assets held by the issuer; or (iii) the profit or loss of the company, fund or other entity that issues the contract.')
  INSERT INTO @AT VALUES(121621,0,0,'121621', '/1/2/1/6/21/', N'ChangesInEquity',N'ReserveOfEquityComponentOfConvertibleInstruments', N'Reserve of equity component of convertible instruments',N'A component of equity representing components of convertible instruments classified as equity.')
  INSERT INTO @AT VALUES(121622,0,0,'121622', '/1/2/1/6/22/', N'ChangesInEquity',N'CapitalRedemptionReserve', N'Capital redemption reserve',N'A component of equity representing the reserve for the redemption of the entity''s own shares.')
  INSERT INTO @AT VALUES(121623,0,0,'121623', '/1/2/1/6/23/', N'ChangesInEquity',N'MergerReserve', N'Merger reserve',N'A component of equity that may result in relation to a business combination outside the scope of IFRS 3.')
  INSERT INTO @AT VALUES(121624,0,0,'121624', '/1/2/1/6/24/', N'ChangesInEquity',N'StatutoryReserve', N'Statutory reserve',N'A component of equity representing reserves created based on legal requirements.')
  INSERT INTO @AT VALUES(122,0,0,'122', '/1/2/2/', NULL,N'Liabilities', N'Liabilities',N'The amount of a present obligation of the entity to transfer an economic resource as a result of past events. Economic resource is a right that has the potential to produce economic benefits.')
  INSERT INTO @AT VALUES(1221,0,0,'1221', '/1/2/2/1/', NULL,N'NoncurrentLiabilities', N'Non-current liabilities',N'The amount of liabilities that do not meet the definition of current liabilities. [Refer: Current liabilities]')
  INSERT INTO @AT VALUES(12211,0,0,'12211', '/1/2/2/1/1/', NULL,N'NoncurrentProvisions', N'Non-current provisions',N'The amount of non-current provisions. [Refer: Provisions]')
  INSERT INTO @AT VALUES(122111,0,1,'122111', '/1/2/2/1/1/1/', NULL,N'NoncurrentProvisionsForEmployeeBenefits', N'Non-current provisions for employee benefits',N'The amount of non-current provisions for employee benefits. [Refer: Provisions for employee benefits]')
  INSERT INTO @AT VALUES(122112,0,0,'122112', '/1/2/2/1/1/2/', NULL,N'OtherLongtermProvisions', N'Other non-current provisions',N'The amount of non-current provisions other than provisions for employee benefits. [Refer: Non-current provisions]')
  INSERT INTO @AT VALUES(1221121,0,0,'1221121', '/1/2/2/1/1/2/1/', NULL,N'LongtermWarrantyProvision', N'Non-current warranty provision',N'The amount of non-current provision for warranties. [Refer: Warranty provision]')
  INSERT INTO @AT VALUES(1221122,0,1,'1221122', '/1/2/2/1/1/2/2/', NULL,N'LongtermRestructuringProvision', N'Non-current restructuring provision',N'The amount of non-current provision for restructuring. [Refer: Restructuring provision]')
  INSERT INTO @AT VALUES(1221123,0,1,'1221123', '/1/2/2/1/1/2/3/', NULL,N'LongtermLegalProceedingsProvision', N'Non-current legal proceedings provision',N'The amount of non-current provision for legal proceedings. [Refer: Legal proceedings provision]')
  INSERT INTO @AT VALUES(1221124,0,1,'1221124', '/1/2/2/1/1/2/4/', NULL,N'NoncurrentRefundsProvision', N'Non-current refunds provision',N'The amount of non-current provision for refunds. [Refer: Refunds provision]')
  INSERT INTO @AT VALUES(1221125,0,1,'1221125', '/1/2/2/1/1/2/5/', NULL,N'LongtermOnerousContractsProvision', N'Non-current onerous contracts provision',N'The amount of non-current provision for onerous contracts. [Refer: Onerous contracts provision]')
  INSERT INTO @AT VALUES(1221126,0,1,'1221126', '/1/2/2/1/1/2/6/', NULL,N'LongtermProvisionForDecommissioningRestorationAndRehabilitationCosts', N'Non-current provision for decommissioning, restoration and rehabilitation costs',N'The amount of non-current provision for decommissioning, restoration and rehabilitation costs. [Refer: Provision for decommissioning, restoration and rehabilitation costs]')
  INSERT INTO @AT VALUES(1221127,0,1,'1221127', '/1/2/2/1/1/2/7/', NULL,N'LongtermMiscellaneousOtherProvisions', N'Non-current miscellaneous other provisions',N'The amount of miscellaneous non-current other provisions. [Refer: Miscellaneous other provisions]')
  INSERT INTO @AT VALUES(12212,0,0,'12212', '/1/2/2/1/2/', NULL,N'NoncurrentPayables', N'Trade and other non-current payables',N'The amount of non-current trade payables and non-current other payables. [Refer: Other non-current payables; Non-current trade payables]')
  INSERT INTO @AT VALUES(122121,0,1,'122121', '/1/2/2/1/2/1/', NULL,N'NoncurrentPayablesToTradeSuppliers', N'Non-current trade payables',N'The non-current amount of payment due to suppliers for goods and services used in the entity''s business. [Refer: Trade payables]')
  INSERT INTO @AT VALUES(122122,0,1,'122122', '/1/2/2/1/2/2/', NULL,N'NoncurrentPayablesToRelatedParties', N'Non-current payables to related parties',N'The amount of non-current payables due to related parties. [Refer: Related parties [member]; Payables to related parties]')
  INSERT INTO @AT VALUES(122123,0,1,'122123', '/1/2/2/1/2/3/', NULL,N'AccrualsAndDeferredIncomeClassifiedAsNoncurrent', N'Accruals and deferred income classified as non-current',N'The amount of accruals and deferred income classified as non-current. [Refer: Accruals and deferred income]')
  INSERT INTO @AT VALUES(1221231,0,0,'1221231', '/1/2/2/1/2/3/1/', NULL,N'DeferredIncomeClassifiedAsNoncurrent', N'Deferred income classified as non-current',N'The amount of deferred income classified as non-current. [Refer: Deferred income]')
  INSERT INTO @AT VALUES(12212311,0,0,'12212311', '/1/2/2/1/2/3/1/1/', NULL,N'RentDeferredIncomeClassifiedAsNoncurrent', N'Rent deferred income classified as non-current',N'The amount of rent deferred income classified as non-current. [Refer: Rent deferred income]')
  INSERT INTO @AT VALUES(12212312,0,1,'12212312', '/1/2/2/1/2/3/1/2/', NULL,N'AccrualsClassifiedAsNoncurrent', N'Accruals classified as non-current',N'The amount of accruals classified as non-current. [Refer: Accruals]')
  INSERT INTO @AT VALUES(122124,0,1,'122124', '/1/2/2/1/2/4/', NULL,N'NoncurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTax', N'Non-current payables on social security and taxes other than income tax',N'The amount of non-current payables on social security and taxes other than incomes tax. [Refer: Payables on social security and taxes other than income tax]')
  INSERT INTO @AT VALUES(1221241,0,1,'1221241', '/1/2/2/1/2/4/1/', NULL,N'NoncurrentValueAddedTaxPayables', N'Non-current value added tax payables',N'The amount of non-current value added tax payables. [Refer: Value added tax payables]')
  INSERT INTO @AT VALUES(1221242,0,1,'1221242', '/1/2/2/1/2/4/2/', NULL,N'NoncurrentExciseTaxPayables', N'Non-current excise tax payables',N'The amount of non-current excise tax payables. [Refer: Excise tax payables]')
  INSERT INTO @AT VALUES(1221243,0,1,'1221243', '/1/2/2/1/2/5/', NULL,N'NoncurrentRetentionPayables', N'Non-current retention payables',N'The amount of non-current retention payables. [Refer: Retention payables]')
  INSERT INTO @AT VALUES(1221244,0,1,'1221244', '/1/2/2/1/2/6/', NULL,N'OtherNoncurrentPayables', N'Other non-current payables',N'The amount of non-current payables that the entity does not separately disclose in the same statement or note.')
  INSERT INTO @AT VALUES(12213,0,1,'12213', '/1/2/2/1/3/', NULL,N'DeferredTaxLiabilities', N'Deferred tax liabilities',N'The amounts of income taxes payable in future periods in respect of taxable temporary differences. [Refer: Temporary differences [member]]')
  INSERT INTO @AT VALUES(12214,0,1,'12214', '/1/2/2/1/4/', NULL,N'CurrentTaxLiabilitiesNoncurrent', N'Current tax liabilities, non-current',N'The non-current amount of current tax liabilities. [Refer: Current tax liabilities]')
  INSERT INTO @AT VALUES(12215,0,1,'12215', '/1/2/2/1/5/', NULL,N'OtherNoncurrentFinancialLiabilities', N'Other non-current financial liabilities',N'The amount of non-current financial liabilities that the entity does not separately disclose in the same statement or note. [Refer: Other financial liabilities]')
  INSERT INTO @AT VALUES(122151,0,1,'122151', '/1/2/2/1/5/1/', NULL,N'NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLoss', N'Non-current financial liabilities at fair value through profit or loss',N'The amount of non-current financial liabilities measured at fair value through profit or loss. [Refer: Financial liabilities at fair value through profit or loss]')
  INSERT INTO @AT VALUES(1221511,0,1,'1221511', '/1/2/2/1/5/1/1/', NULL,N'NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading', N'Non-current financial liabilities at fair value through profit or loss, classified as held for trading',N'The amount of non-current financial liabilities at fair value through profit or loss that meet the definition of held for trading. [Refer: Non-current financial liabilities at fair value through profit or loss]')
  INSERT INTO @AT VALUES(1221512,0,1,'1221512', '/1/2/2/1/5/1/2/', NULL,N'NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition', N'Non-current financial liability 1 at FVTPL, designated upon initial recognition or subsequently',N'The amount of non-current financial liabilities measured at fair value through profit or loss that were designated as such upon initial recognition or subsequently. [Refer: Financial liabilities at fair value through profit or loss, designated upon initial recognition or subsequently]')
  INSERT INTO @AT VALUES(122152,0,1,'122152', '/1/2/2/1/5/2/', NULL,N'NoncurrentFinancialLiabilitiesAtAmortisedCost', N'Non-current financial liabilities at amortised cost',N'The amount of non-current financial liabilities measured at amortised cost. [Refer: Financial liabilities at amortised cost]')
  INSERT INTO @AT VALUES(12216,0,0,'12216', '/1/2/2/1/6/', NULL,N'OtherNoncurrentNonfinancialLiabilities', N'Other non-current non-financial liabilities',N'The amount of non-current non-financial liabilities that the entity does not separately disclose in the same statement or note. [Refer: Other financial liabilities]')
  INSERT INTO @AT VALUES(1222,0,0,'1222', '/1/2/2/2/', NULL,N'CurrentLiabilities', N'Current liabilities',N'The amount of liabilities that: (a) the entity expects to settle in its normal operating cycle; (b) the entity holds primarily for the purpose of trading; (c) are due to be settled within twelve months after the reporting period; or (d) the entity does not have an unconditional right to defer settlement for at least twelve months after the reporting period.')
  INSERT INTO @AT VALUES(12221,0,0,'12221', '/1/2/2/2/1/', NULL,N'CurrentProvisions', N'Current provisions',N'The amount of current provisions. [Refer: Provisions]')
  INSERT INTO @AT VALUES(122211,0,1,'122211', '/1/2/2/2/1/1/', NULL,N'CurrentProvisionsForEmployeeBenefits', N'Current provisions for employee benefits',N'The amount of current provisions for employee benefits. [Refer: Provisions for employee benefits]')
  INSERT INTO @AT VALUES(122212,0,0,'122212', '/1/2/2/2/1/2/', N'ChangesInOtherProvisions',N'OtherShorttermProvisions', N'Other current provisions',N'The amount of current provisions other than provisions for employee benefits. [Refer: Provisions]')
  INSERT INTO @AT VALUES(1222121,0,0,'1222121', '/1/2/2/2/1/2/1/', N'ChangesInOtherProvisions',N'ShorttermWarrantyProvision', N'Current warranty provision',N'The amount of current provision for warranties. [Refer: Warranty provision]')
  INSERT INTO @AT VALUES(1222122,0,1,'1222122', '/1/2/2/2/1/2/2/', N'ChangesInOtherProvisions',N'ShorttermRestructuringProvision', N'Current restructuring provision',N'The amount of current provision for restructuring. [Refer: Restructuring provision]')
  INSERT INTO @AT VALUES(1222123,0,1,'1222123', '/1/2/2/2/1/2/3/', N'ChangesInOtherProvisions',N'ShorttermLegalProceedingsProvision', N'Current legal proceedings provision',N'The amount of current provision for legal proceedings. [Refer: Legal proceedings provision]')
  INSERT INTO @AT VALUES(1222124,0,1,'1222124', '/1/2/2/2/1/2/4/', N'ChangesInOtherProvisions',N'CurrentRefundsProvision', N'Current refunds provision',N'The amount of current provision for refunds. [Refer: Refunds provision]')
  INSERT INTO @AT VALUES(1222125,0,1,'1222125', '/1/2/2/2/1/2/5/', N'ChangesInOtherProvisions',N'ShorttermOnerousContractsProvision', N'Current onerous contracts provision',N'The amount of current provision for onerous contracts. [Refer: Onerous contracts provision]')
  INSERT INTO @AT VALUES(1222126,0,1,'1222126', '/1/2/2/2/1/2/6/', N'ChangesInOtherProvisions',N'ShorttermProvisionForDecommissioningRestorationAndRehabilitationCosts', N'Current provision for decommissioning, restoration and rehabilitation costs',N'The amount of current provision for decommissioning, restoration and rehabilitation costs. [Refer: Provision for decommissioning, restoration and rehabilitation costs]')
  INSERT INTO @AT VALUES(1222127,0,1,'1222127', '/1/2/2/2/1/2/7/', N'ChangesInOtherProvisions',N'ShorttermMiscellaneousOtherProvisions', N'Current miscellaneous other provisions',N'The amount of miscellaneous current other provisions. [Refer: Miscellaneous other provisions]')
  INSERT INTO @AT VALUES(12222,0,0,'12222', '/1/2/2/2/2/', NULL,N'TradeAndOtherCurrentPayables', N'Trade and other current payables',N'The amount of current trade payables and current other payables. [Refer: Current trade payables; Other current payables]')
  INSERT INTO @AT VALUES(122221,0,1,'122221', '/1/2/2/2/2/1/', NULL,N'TradeAndOtherCurrentPayablesToTradeSuppliers', N'Current trade payables',N'The current amount of payment due to suppliers for goods and services used in entity''s business. [Refer: Current liabilities; Trade payables]')
  INSERT INTO @AT VALUES(122222,0,1,'122222', '/1/2/2/2/2/2/', NULL,N'TradeAndOtherCurrentPayablesToRelatedParties', N'Current payables to related parties',N'The amount of current payables due to related parties. [Refer: Related parties [member]; Payables to related parties]')
  INSERT INTO @AT VALUES(122224,0,0,'122224', '/1/2/2/2/2/4/', NULL,N'AccrualsAndDeferredIncomeClassifiedAsCurrent', N'Accruals and deferred income classified as current',N'The amount of accruals and deferred income classified as current. [Refer: Accruals and deferred income]')
  INSERT INTO @AT VALUES(1222241,0,0,'1222241', '/1/2/2/2/2/4/1/', NULL,N'DeferredIncomeClassifiedAsCurrent', N'Deferred income classified as current',N'The amount of deferred income classified as current. [Refer: Deferred income]')
  INSERT INTO @AT VALUES(12222411,0,0,'12222411', '/1/2/2/2/2/4/1/1/', NULL,N'RentDeferredIncomeClassifiedAsCurrent', N'Rent deferred income classified as current',N'The amount of deferred income arising on rental activity. [Refer: Deferred income]')
  INSERT INTO @AT VALUES(1222242,0,1,'1222242', '/1/2/2/2/2/4/2/', NULL,N'AccrualsClassifiedAsCurrent', N'Accruals classified as current',N'The amount of accruals classified as current. [Refer: Accruals]')
  INSERT INTO @AT VALUES(12222421,0,1,'12222421', '/1/2/2/2/2/4/2/1/', NULL,N'ShorttermEmployeeBenefitsAccruals', N'Short-term employee benefits accruals',N'The amount of accruals for employee benefits (other than termination benefits) that are expected to be settled wholly within twelve months after the end of the annual reporting period in which the employees render the related services. [Refer: Accruals classified as current]')
  INSERT INTO @AT VALUES(122225,0,0,'122225', '/1/2/2/2/2/5/', NULL,N'CurrentAdvancesFromCustomersExtension', N'Current advances from customers',N'The amount collected but against which there was no invoice issued to the customer')
  INSERT INTO @AT VALUES(122226,0,1,'122226', '/1/2/2/2/2/6/', NULL,N'CurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTax', N'Current payables on social security and taxes other than income tax',N'The amount of current payables on social security and taxes other than incomes tax. [Refer: Payables on social security and taxes other than income tax]')
  INSERT INTO @AT VALUES(1222261,0,1,'1222261', '/1/2/2/2/2/6/1/', NULL,N'CurrentValueAddedTaxPayables', N'Current value added tax payables',N'The amount of current value added tax payables. [Refer: Value added tax payables]')
  INSERT INTO @AT VALUES(1222262,0,1,'1222262', '/1/2/2/2/2/6/2/', NULL,N'CurrentExciseTaxPayables', N'Current excise tax payables',N'The amount of current excise tax payables. [Refer: Excise tax payables]')
  INSERT INTO @AT VALUES(1222263,0,1,'1222263', '/1/2/2/2/2/6/3/', NULL,N'OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension', N'Other current payables on social security and taxes other than income tax',N'')
  INSERT INTO @AT VALUES(122227,0,1,'122227', '/1/2/2/2/2/7/', NULL,N'CurrentRetentionPayables', N'Current retention payables',N'The amount of current retention payables. [Refer: Retention payables]')
  INSERT INTO @AT VALUES(122228,0,1,'122228', '/1/2/2/2/2/8/', NULL,N'OtherCurrentPayables', N'Other current payables',N'The amount of current payables that the entity does not separately disclose in the same statement or note.')
  INSERT INTO @AT VALUES(12223,0,1,'12223', '/1/2/2/2/3/', NULL,N'CurrentTaxLiabilitiesCurrent', N'Current tax liabilities, current',N'The current amount of current tax liabilities. [Refer: Current tax liabilities]')
  INSERT INTO @AT VALUES(12224,0,1,'12224', '/1/2/2/2/4/', NULL,N'OtherCurrentFinancialLiabilities', N'Other current financial liabilities',N'The amount of current financial liabilities that the entity does not separately disclose in the same statement or note. [Refer: Other financial liabilities; Current financial liabilities]')
  INSERT INTO @AT VALUES(122241,0,1,'122241', '/1/2/2/2/4/1/', NULL,N'CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossAbstract', N'Current financial liabilities at fair value through profit or loss',N'The amount of current financial liabilities measured at fair value through profit or loss. [Refer: Financial liabilities at fair value through profit or loss]')
  INSERT INTO @AT VALUES(1222411,0,1,'1222411', '/1/2/2/2/4/1/1/', NULL,N'CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading', N'Current financial liabilities at fair value through profit or loss, classified as held for trading',N'The amount of current financial liabilities at fair value through profit or loss that meet the definition of held for trading. [Refer: Current financial liabilities at fair value through profit or loss]')
  INSERT INTO @AT VALUES(1222412,0,1,'1222412', '/1/2/2/2/4/1/2/', NULL,N'CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition', N'Current financial liabilities at fair value through profit or loss, designated upon initial recognition or subsequently',N'The amount of current financial liabilities measured at fair value through profit or loss that were designated as such upon initial recognition or subsequently. [Refer: Financial liabilities at fair value through profit or loss, designated upon initial recognition or subsequently]')
  INSERT INTO @AT VALUES(122242,0,1,'122242', '/1/2/2/2/4/2/', NULL,N'CurrentFinancialLiabilitiesAtAmortisedCost', N'Current financial liabilities at amortised cost',N'The amount of current financial liabilities measured at amortised cost. [Refer: Financial liabilities at amortised cost]')
  INSERT INTO @AT VALUES(12225,0,0,'12225', '/1/2/2/2/5/', NULL,N'OtherCurrentNonfinancialLiabilities', N'Other current non-financial liabilities',N'The amount of current non-financial liabilities that the entity does not separately disclose in the same statement or note. [Refer: Other financial liabilities]')
  INSERT INTO @AT VALUES(12226,0,1,'12226', '/1/2/2/2/6/', NULL,N'LiabilitiesIncludedInDisposalGroupsClassifiedAsHeldForSale', N'Liabilities included in disposal groups classified as held for sale',N'The amount of liabilities included in disposal groups classified as held for sale. [Refer: Liabilities; Disposal groups classified as held for sale [member]]')
  
  INSERT INTO @AT VALUES(2,0,0,'2', '/2/', NULL,N'IncomeStatementAbstract', N'Profit or loss [abstract]',N'')
  INSERT INTO @AT VALUES(21,0,0,'21', '/2/1/', NULL,N'ProfitLoss', N'Profit (loss)',N'The total of income less expenses from continuing and discontinued operations, excluding the components of other comprehensive income. [Refer: Other comprehensive income]')
  INSERT INTO @AT VALUES(211,0,0,'211', '/2/1/1/', NULL,N'ProfitLossFromContinuingOperations', N'Profit (loss) from continuing operations',N'The profit (loss) from continuing operations. [Refer: Continuing operations [member]; Profit (loss)]')
  INSERT INTO @AT VALUES(2111,0,0,'2111', '/2/1/1/1/', NULL,N'ProfitLossBeforeTax', N'Profit (loss) before tax',N'The profit (loss) before tax expense or income. [Refer: Profit (loss)]')
  INSERT INTO @AT VALUES(211101,0,0,'211101', '/2/1/1/1/1/', NULL,N'ProfitLossFromOperatingActivities', N'Profit (loss) from operating activities',N'The profit (loss) from operating activities of the entity. [Refer: Profit (loss)]')
  INSERT INTO @AT VALUES(2111011,0,0,'2111011', '/2/1/1/1/1/1/', NULL,N'Revenue', N'Revenue',N'The income arising in the course of an entity''s ordinary activities. Income is increases in economic benefits during the accounting period in the form of inflows or enhancements of assets or decreases of liabilities that result in an increase in equity, other than those relating to contributions from equity participants.')
  INSERT INTO @AT VALUES(21110111,0,0,'21110111', '/2/1/1/1/1/1/1/', NULL,N'RevenueFromSaleOfGoods', N'Revenue from sale of goods',N'The amount of revenue arising from the sale of goods. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011101,0,0,'2111011101', '/2/1/1/1/1/1/1/1/', NULL,N'RevenueFromSaleOfCopper', N'Revenue from sale of copper',N'The amount of revenue arising from the sale of copper. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011102,0,0,'2111011102', '/2/1/1/1/1/1/1/2/', NULL,N'RevenueFromSaleOfGold', N'Revenue from sale of gold',N'The amount of revenue arising from the sale of gold. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011103,0,0,'2111011103', '/2/1/1/1/1/1/1/3/', NULL,N'RevenueFromSaleOfSilver', N'Revenue from sale of silver',N'The amount of revenue arising from the sale of silver. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011104,0,0,'2111011104', '/2/1/1/1/1/1/1/4/', NULL,N'RevenueFromSaleOfOilAndGasProducts', N'Revenue from sale of oil and gas products',N'The amount of revenue arising from the sale of oil and gas products. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011105,0,0,'2111011105', '/2/1/1/1/1/1/1/5/', NULL,N'RevenueFromSaleOfCrudeOil', N'Revenue from sale of crude oil',N'The amount of revenue arising from the sale of crude oil. [Refer: Current crude oil; Revenue]')
  INSERT INTO @AT VALUES(2111011111,0,0,'2111011111', '/2/1/1/1/1/1/1/11/', NULL,N'RevenueFromSaleOfAgriculturalProduce', N'Revenue from sale of agricultural produce',N'The amount of revenue arising from the sale of agricultural produce. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011114,0,0,'2111011114', '/2/1/1/1/1/1/1/14/', NULL,N'RevenueFromSaleOfFoodAndBeverage', N'Revenue from sale of food and beverage',N'The amount of revenue arising from the sale of food and beverage. [Refer: Revenue]')
  INSERT INTO @AT VALUES(21110112,0,0,'21110112', '/2/1/1/1/1/1/2/', NULL,N'RevenueFromRenderingOfServices', N'Revenue from rendering of services',N'The amount of revenue arising from the rendering of services. [Refer: Revenue]')
  INSERT INTO @AT VALUES(211101121,0,0,'211101121', '/2/1/1/1/1/1/2/1/', NULL,N'RevenueFromRenderingOfTelecommunicationServices', N'Revenue from rendering of telecommunication services',N'')
  INSERT INTO @AT VALUES(211101122,0,0,'211101122', '/2/1/1/1/1/1/2/2/', NULL,N'RevenueFromRenderingOfTransportServices', N'Revenue from rendering of transport services',N'The amount of revenue arising from the rendering of transport services. [Refer: Revenue]')
  INSERT INTO @AT VALUES(211101125,0,0,'211101125', '/2/1/1/1/1/1/2/5/', NULL,N'RevenueFromRenderingOfInformationTechnologyServices', N'Revenue from rendering of information technology services',N'The amount of revenue arising from the rendering of information technology services. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011251,0,0,'2111011251', '/2/1/1/1/1/1/2/5/1/', NULL,N'RevenueFromRenderingOfInformationTechnologyMaintenanceAndSupportServices', N'Revenue from rendering of information technology maintenance and support services',N'The amount of revenue arising from the rendering of maintenance and support services relating to information technology. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011252,0,0,'2111011252', '/2/1/1/1/1/1/2/5/2/', NULL,N'RevenueFromRenderingOfInformationTechnologyConsultingServices', N'Revenue from rendering of information technology consulting services',N'The amount of revenue arising from the rendering of consulting services relating to information technology. [Refer: Revenue]')
  INSERT INTO @AT VALUES(211101126,0,0,'211101126', '/2/1/1/1/1/1/2/6/', NULL,N'RevenueFromHotelOperations', N'Revenue from hotel operations',N'The amount of revenue arising from hotel operations. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111011261,0,0,'2111011261', '/2/1/1/1/1/1/2/6/1/', NULL,N'RevenueFromRoomOccupancyServices', N'Revenue from room occupancy services',N'The amount of revenue arising from room occupancy services. [Refer: Revenue]')
  INSERT INTO @AT VALUES(211101128,0,0,'211101128', '/2/1/1/1/1/1/2/8/', NULL,N'RevenueFromRenderingOfOtherPointOfTimeServicesExtension', N'Revenue from rendering of point services',N'')
  INSERT INTO @AT VALUES(211101129,0,0,'211101129', '/2/1/1/1/1/1/2/9/', NULL,N'RevenueFromRenderingOfOtherPeriodOfTimeServicesExtension', N'Revenue from rendering of period services',N'')
  INSERT INTO @AT VALUES(21110113,0,0,'21110113', '/2/1/1/1/1/1/3/', NULL,N'RevenueFromConstructionContracts', N'Revenue from construction contracts',N'The amount of revenue arising from construction contracts. Construction contracts are contracts specifically negotiated for the construction of an asset or a combination of assets that are closely interrelated or interdependent in terms of their design, technology and function or their ultimate purpose or use. [Refer: Revenue]')
  INSERT INTO @AT VALUES(21110114,0,0,'21110114', '/2/1/1/1/1/1/4/', NULL,N'RevenueFromRoyalties', N'Royalty income',N'The amount of income arising from royalties.')
  INSERT INTO @AT VALUES(21110115,0,0,'21110115', '/2/1/1/1/1/1/5/', NULL,N'LicenceFeeIncome', N'Licence fee income',N'The amount of income arising from licence fees.')
  INSERT INTO @AT VALUES(21110116,0,0,'21110116', '/2/1/1/1/1/1/6/', NULL,N'FranchiseFeeIncome', N'Franchise fee income',N'The amount of income arising from franchise fees.')
  INSERT INTO @AT VALUES(21110117,0,0,'21110117', '/2/1/1/1/1/1/7/', NULL,N'RevenueFromInterest', N'Interest income',N'The amount of income arising from interest.')
  INSERT INTO @AT VALUES(21110118,0,0,'21110118', '/2/1/1/1/1/1/8/', NULL,N'RevenueFromDividends', N'Dividend income',N'The amount of dividends recognised as income. Dividends are distributions of profits to holders of equity investments in proportion to their holdings of a particular class of capital.')
  INSERT INTO @AT VALUES(21110119,0,0,'21110119', '/2/1/1/1/1/1/9/', NULL,N'OtherRevenue', N'Other revenue',N'The amount of revenue arising from sources that the entity does not separately disclose in the same statement or note. [Refer: Revenue]')
  INSERT INTO @AT VALUES(2111012,0,0,'2111012', '/2/1/1/1/1/2/', NULL,N'OtherIncome', N'Other income',N'The amount of operating income that the entity does not separately disclose in the same statement or note.')
  INSERT INTO @AT VALUES(2111013,0,0,'2111013', '/2/1/1/1/1/3/', NULL,N'ChangesInInventoriesOfFinishedGoodsAndWorkInProgress', N'Decrease (increase) in inventories of finished goods and work in progress',N'The decrease (increase) in inventories of finished goods and work in progress. [Refer: Inventories; Current finished goods; Current work in progress]')
  INSERT INTO @AT VALUES(2111014,0,0,'2111014', '/2/1/1/1/1/4/', NULL,N'OtherWorkPerformedByEntityAndCapitalised', N'Other work performed by entity and capitalised',N'The amount of the entity''s own work capitalised from items originally classified as costs that the entity does not separately disclose in the same statement or note.')
  INSERT INTO @AT VALUES(2111015,0,0,'2111015', '/2/1/1/1/1/5/', N'ChangesInExpenseByNatureExtension',N'ExpenseByNature', N'Expenses by nature',N'The amount of expenses aggregated according to their nature (for example, depreciation, purchases of materials, transport costs, employee benefits and advertising costs), and not reallocated among functions within the entity.')
  INSERT INTO @AT VALUES(21110151,0,0,'21110151', '/2/1/1/1/1/5/1/', N'ChangesInExpenseByNatureExtension',N'RawMaterialsAndConsumablesUsed', N'Raw materials and consumables used',N'The amount of raw materials and consumables used in the production process or in the rendering of services. [Refer: Current raw materials]')
  INSERT INTO @AT VALUES(211101511,0,0,'211101511', '/2/1/1/1/1/5/1/1/', N'ChangesInExpenseByNatureExtension',N'FuelExpense', N'Fuel expense',N'The amount of expense arising from the consumption of fuel.')
  INSERT INTO @AT VALUES(211101512,0,0,'211101512', '/2/1/1/1/1/5/2/', N'ChangesInExpenseByNatureExtension',N'CostOfMerchandiseSold', N'Cost of merchandise sold',N'The amount of merchandise that was sold during the period and recognised as an expense.')
  INSERT INTO @AT VALUES(21110152,0,0,'21110152', '/2/1/1/1/1/5/3/', N'ChangesInExpenseByNatureExtension',N'ServicesExpense', N'Services expense',N'The amount of expense arising from services.')
  INSERT INTO @AT VALUES(211101521,0,0,'211101521', '/2/1/1/1/1/5/3/1/', N'ChangesInExpenseByNatureExtension',N'InsuranceExpense', N'Insurance expense',N'The amount of expense arising from purchased insurance.')
  INSERT INTO @AT VALUES(211101522,0,0,'211101522', '/2/1/1/1/1/5/3/2/', N'ChangesInExpenseByNatureExtension',N'ProfessionalFeesExpense', N'Professional fees expense',N'The amount of fees paid or payable for professional services.')
  INSERT INTO @AT VALUES(2111015221,0,0,'2111015221', '/2/1/1/1/1/5/3/2/1/', N'ChangesInExpenseByNatureExtension',N'RepairsAndMaintenanceExpense', N'Repairs and maintenance expense',N'The amount of expenses incurred for the day-to-day servicing of assets, which may include the cost of labour, consumables or small parts')
  INSERT INTO @AT VALUES(211101533,0,0,'211101533', '/2/1/1/1/1/5/3/3/', N'ChangesInExpenseByNatureExtension',N'TransportationExpense', N'Transportation expense',N'The amount of expense arising from transportation services.')
  INSERT INTO @AT VALUES(211101534,0,0,'211101534', '/2/1/1/1/1/5/3/4/', N'ChangesInExpenseByNatureExtension',N'BankAndSimilarCharges', N'Bank and similar charges',N'The amount of bank and similar charges recognised by the entity as an expense.')
  INSERT INTO @AT VALUES(211101535,0,0,'211101535', '/2/1/1/1/1/5/3/5/', N'ChangesInExpenseByNatureExtension',N'TravelExpense', N'Travel expense',N'The amount of expense arising from travel.')
  INSERT INTO @AT VALUES(211101536,0,0,'211101536', '/2/1/1/1/1/5/3/6/', N'ChangesInExpenseByNatureExtension',N'CommunicationExpense', N'Communication expense',N'The amount of expense arising from communication.')
  INSERT INTO @AT VALUES(211101537,0,0,'211101537', '/2/1/1/1/1/5/3/7/', N'ChangesInExpenseByNatureExtension',N'UtilitiesExpense', N'Utilities expense',N'The amount of expense arising from purchased utilities.')
  INSERT INTO @AT VALUES(211101538,0,0,'211101538', '/2/1/1/1/1/5/3/8/', N'ChangesInExpenseByNatureExtension',N'AdvertisingExpense', N'Advertising expense',N'The amount of expense arising from advertising.')
  INSERT INTO @AT VALUES(211101539,0,0,'211101539', '/2/1/1/1/1/5/3/9/', N'ChangesInExpenseByNatureExtension',N'RentalExpense', N'Rental expense',N'The amount of expense recognised on rental activities.')
  INSERT INTO @AT VALUES(21110154,0,0,'21110154', '/2/1/1/1/1/5/4/', N'ChangesInExpenseByNatureExtension',N'EmployeeBenefitsExpense', N'Employee benefits expense',N'The expense of all forms of consideration given by an entity in exchange for a service rendered by employees or for the termination of employment.')
  INSERT INTO @AT VALUES(211101531,0,0,'211101531', '/2/1/1/1/1/5/4/1/', N'ChangesInExpenseByNatureExtension',N'ShorttermEmployeeBenefitsExpense', N'Short-term employee benefits expense',N'The amount of expense from employee benefits (other than termination benefits) that are expected to be settled wholly within twelve months after the end of the annual reporting period in which the employees render the related services.')
  INSERT INTO @AT VALUES(2111015311,0,0,'2111015311', '/2/1/1/1/1/5/4/1/1/', N'ChangesInExpenseByNatureExtension',N'WagesAndSalaries', N'Wages and salaries',N'A class of employee benefits expense that represents wages and salaries. [Refer: Employee benefits expense]')
  INSERT INTO @AT VALUES(2111015312,0,0,'2111015312', '/2/1/1/1/1/5/4/1/2/', N'ChangesInExpenseByNatureExtension',N'SocialSecurityContributions', N'Social security contributions',N'A class of employee benefits expense that represents social security contributions. [Refer: Employee benefits expense]')
  INSERT INTO @AT VALUES(2111015313,0,0,'2111015313', '/2/1/1/1/1/5/4/1/3/', N'ChangesInExpenseByNatureExtension',N'OtherShorttermEmployeeBenefits', N'Other short-term employee benefits',N'The amount of expense from employee benefits (other than termination benefits), which are expected to be settled wholly within twelve months after the end of the annual reporting period in which the employees render the related services, that the entity does not separately disclose in the same statement or note. [Refer: Employee benefits expense]')
  INSERT INTO @AT VALUES(211101532,0,0,'211101532', '/2/1/1/1/1/5/4/2/', N'ChangesInExpenseByNatureExtension',N'PostemploymentBenefitExpenseDefinedContributionPlans', N'Post-employment benefit expense, defined contribution plans',N'The amount of post-employment benefit expense relating to defined contribution plans. Defined contribution plans are post-employment benefit plans under which an entity pays fixed contributions into a separate entity (a fund) and will have no legal or constructive obligation to pay further contributions if the fund does not hold sufficient assets to pay all employee benefits relating to employee service in the current and prior periods.')
  INSERT INTO @AT VALUES(211101543,0,0,'211101543', '/2/1/1/1/1/5/4/3/', N'ChangesInExpenseByNatureExtension',N'PostemploymentBenefitExpenseDefinedBenefitPlans', N'Post-employment benefit expense, defined benefit plans',N'The amount of post-employment benefit expense relating to defined benefit plans. [Refer: Defined benefit plans [member]]')
  INSERT INTO @AT VALUES(211101544,0,0,'211101544', '/2/1/1/1/1/5/4/4/', N'ChangesInExpenseByNatureExtension',N'TerminationBenefitsExpense', N'Termination benefits expense',N'The amount of expense in relation to termination benefits. Termination benefits are employee benefits provided in exchange for the termination of an employee''s employment as a result of either: (a) an entity''s decision to terminate an employee''s employment before the normal retirement date; or (b) an employee''s decision to accept an offer of benefits in exchange for the termination of employment. [Refer: Employee benefits expense]')
  INSERT INTO @AT VALUES(211101545,0,0,'211101545', '/2/1/1/1/1/5/4/5/', N'ChangesInExpenseByNatureExtension',N'OtherLongtermBenefits', N'Other long-term employee benefits',N'The amount of long-term employee benefits other than post-employment benefits and termination benefits. Such benefits may include long-term paid absences, jubilee or other long-service benefits, long-term disability benefits, long-term profit-sharing and bonuses and long-term deferred remuneration. [Refer: Employee benefits expense]')
  INSERT INTO @AT VALUES(211101546,0,0,'211101546', '/2/1/1/1/1/5/4/6/', N'ChangesInExpenseByNatureExtension',N'OtherEmployeeExpense', N'Other employee expense',N'The amount of employee expenses that the entity does not separately disclose in the same statement or note.')
  INSERT INTO @AT VALUES(211101549,0,0,'211101549', '/2/1/1/1/1/5/4/9/', N'ChangesInExpenseByNatureExtension',N'IndirectLaborCostControlExtension', N'Indirect labor cost control',N'')
  INSERT INTO @AT VALUES(21110155,0,0,'21110155', '/2/1/1/1/1/5/5/', N'ChangesInExpenseByNatureExtension',N'DepreciationAmortisationAndImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLoss', N'Depreciation, amortisation and impairment loss (reversal of impairment loss) recognised in profit or loss',N'The amount of depreciation expense, amortisation expense and impairment loss (reversal of impairment loss) recognised in profit or loss. [Refer: Depreciation and amortisation expense; Impairment loss (reversal of impairment loss) recognised in profit or loss]')
  INSERT INTO @AT VALUES(211101551,0,0,'211101551', '/2/1/1/1/1/5/5/1/', N'ChangesInExpenseByNatureExtension',N'DepreciationAndAmortisationExpense', N'Depreciation and amortisation expense',N'The amount of depreciation and amortisation expense. Depreciation and amortisation are the systematic allocations of depreciable amounts of assets over their useful lives.')
  INSERT INTO @AT VALUES(2111015511,0,0,'2111015511', '/2/1/1/1/1/5/5/1/1/', N'ChangesInExpenseByNatureExtension',N'DepreciationExpense', N'Depreciation expense',N'The amount of depreciation expense. Depreciation is the systematic allocation of depreciable amounts of tangible assets over their useful lives.')
  INSERT INTO @AT VALUES(2111015512,0,0,'2111015512', '/2/1/1/1/1/5/5/1/2/', N'ChangesInExpenseByNatureExtension',N'AmortisationExpense', N'Amortisation expense',N'The amount of amortisation expense. Amortisation is the systematic allocation of depreciable amounts of intangible assets over their useful lives.')
  INSERT INTO @AT VALUES(211101552,0,0,'211101552', '/2/1/1/1/1/5/5/2/', N'ChangesInExpenseByNatureExtension',N'ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLoss', N'Reversal of impairment loss (impairment loss) recognised in profit or loss',N'The amount of impairment loss or reversal of impairment loss recognised in profit or loss. [Refer: Impairment loss recognised in profit or loss; Reversal of impairment loss recognised in profit or loss]')
  INSERT INTO @AT VALUES(2111015521,0,0,'2111015521', '/2/1/1/1/1/5/5/2/1/', N'ChangesInExpenseByNatureExtension',N'WritedownsReversalsOfInventories', N'Write-downs (reversals of write-downs) of inventories',N'The amount recognised resulting from the write-down of inventories to net realisable value or reversals of those write-downs. [Refer: Inventories]')
  INSERT INTO @AT VALUES(2111015522,0,0,'2111015522', '/2/1/1/1/1/5/5/2/2/', N'ChangesInExpenseByNatureExtension',N'WritedownsReversalsOfPropertyPlantAndEquipment', N'Write-downs (reversals of write-downs) of property, plant and equipment',N'The amount recognised resulting from the write-down of property, plant and equipment to its recoverable amount or reversals of those write-downs. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(2111015523,0,0,'2111015523', '/2/1/1/1/1/5/5/2/3/', N'ChangesInExpenseByNatureExtension',N'ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLossTradeReceivables', N'Impairment loss (reversal of impairment loss) recognised in profit or loss, trade receivables',N'The amount of impairment loss or reversal of impairment loss recognised in profit or loss for trade receivables. [Refer: Impairment loss recognised in profit or loss; Reversal of impairment loss recognised in profit or loss; Trade receivables]')
  INSERT INTO @AT VALUES(2111015524,0,0,'2111015524', '/2/1/1/1/1/5/5/2/4/', N'ChangesInExpenseByNatureExtension',N'ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLossLoansAndAdvances', N'Impairment loss (reversal of impairment loss) recognised in profit or loss, loans and advances',N'The amount of impairment loss or reversal of impairment loss recognised in profit or loss for loans and advances. [Refer: Impairment loss recognised in profit or loss; Reversal of impairment loss recognised in profit or loss]')
  INSERT INTO @AT VALUES(211101553,0,0,'211101553', '/2/1/1/1/1/5/5/3/', N'ChangesInExpenseByNatureExtension',N'IndirectMachineCostControlExtension', N'Indirect machine cost control',N'')
  INSERT INTO @AT VALUES(21110156,0,0,'21110156', '/2/1/1/1/1/5/6/', N'ChangesInExpenseByNatureExtension',N'TaxExpenseOtherThanIncomeTaxExpense', N'Tax expense other than income tax expense',N'The amount of tax expense exclusive of income tax expense.')
  INSERT INTO @AT VALUES(21110158,0,0,'21110158', '/2/1/1/1/1/5/8/', N'ChangesInExpenseByNatureExtension',N'OtherExpenseByNature', N'Other expenses',N'The amount of expenses that the entity does not separately disclose in the same statement or note when the entity uses the ''nature of expense'' form for its analysis of expenses. [Refer: Expenses, by nature]')
  INSERT INTO @AT VALUES(211101581,0,0,'211101581', '/2/1/1/1/1/5/8/1/', N'ChangesInExpenseByNatureExtension',N'ExpenseOfRestructuringActivities', N'Expense of restructuring activities',N'The amount of expense relating to restructuring. Restructuring is a programme that is planned and controlled by management and materially changes either the scope of a business undertaken by an entity or the manner in which that business is conducted. Such programmes include: (a) the sale or termination of a line of business; (b) closure of business locations in a country or region or the relocation of activities from one country or region to another; (c) changes in management structure; and (d) fundamental reorganisations that have a material effect on the nature and focus of the entity''s operations.')
  INSERT INTO @AT VALUES(211101582,0,0,'211101582', '/2/1/1/1/1/5/8/2/', N'ChangesInExpenseByNatureExtension',N'DonationsAndSubsidiesExpense', N'Donations and subsidies expense',N'The amount of expense arising from donations and subsidies.')
  INSERT INTO @AT VALUES(211101583,0,0,'211101583', '/2/1/1/1/1/5/8/3/', N'ChangesInExpenseByNatureExtension',N'DirectorsRemunerationExpense', N'Directors'' remuneration expense',N'The amount of remuneration paid or payable to the entity''s directors.')
  INSERT INTO @AT VALUES(2111016,0,0,'2111016', '/2/1/1/1/1/6/', N'ChangesInExpenseByNatureExtension',N'ReallocatedExpensesExtension', N'Reallocated expenses',N'')
  INSERT INTO @AT VALUES(2111017,0,0,'2111017', '/2/1/1/1/1/7/', NULL,N'OtherGainsLosses', N'Other gains (losses)',N'The gains (losses) that the entity does not separately disclose in the same statement or note.')
  INSERT INTO @AT VALUES(21110172,1,0,'21110172', '/2/1/1/1/1/7/2/', NULL,N'GainsLossesOnDisposalsOfPropertyPlantAndEquipment', N'Gain (loss) on disposal of property, plant and equipment',N'The gains (losses) on disposals of property, plant and equipment. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(211101721,1,0,'211101721', '/2/1/1/1/1/7/2/1/', NULL,N'GainsOnDisposalsOfPropertyPlantAndEquipment', N'Gains on disposals of property, plant and equipment',N'The gain on the disposal of property, plant and equipment. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(211101722,1,0,'211101722', '/2/1/1/1/1/7/2/2/', NULL,N'LossesOnDisposalsOfPropertyPlantAndEquipment', N'Losses on disposals of property, plant and equipment',N'The losses on the disposal of property, plant and equipment. [Refer: Property, plant and equipment]')
  INSERT INTO @AT VALUES(21110173,1,0,'21110173', '/2/1/1/1/1/7/3/', NULL,N'GainsLossesOnDisposalsOfInvestmentProperties', N'Gains (losses) on disposals of investment properties',N'The gains (losses) on disposals of investment properties. [Refer: Investment property]')
  INSERT INTO @AT VALUES(211101731,1,0,'211101731', '/2/1/1/1/1/7/3/1/', NULL,N'GainsOnDisposalsOfInvestmentProperties', N'Gains on disposals of investment properties',N'The gain on disposals of investment properties. [Refer: Investment property]')
  INSERT INTO @AT VALUES(211101732,1,0,'211101732', '/2/1/1/1/1/7/3/2/', NULL,N'LossesOnDisposalsOfInvestmentProperties', N'Losses on disposals of investment properties',N'The losses on disposals of investment properties. [Refer: Investment property]')
  INSERT INTO @AT VALUES(21110174,0,0,'21110174', '/2/1/1/1/1/7/4/', NULL,N'GainsLossesOnDisposalsOfInvestments', N'The gains (losses) on disposals of investments.',N'The gains (losses) on disposals of investments.')
  INSERT INTO @AT VALUES(211101741,0,0,'211101741', '/2/1/1/1/1/7/4/1/', NULL,N'GainsOnDisposalsOfInvestments', N'Gains on disposals of investments',N'The gain on the disposal of investments.')
  INSERT INTO @AT VALUES(211101742,0,0,'211101742', '/2/1/1/1/1/7/4/2/', NULL,N'LossesOnDisposalsOfInvestments', N'Losses on disposals of investments',N'The losses on the disposal of investments.')
  INSERT INTO @AT VALUES(21110175,0,0,'21110175', '/2/1/1/1/1/7/5/', NULL,N'GainsLossesOnExchangeDifferencesOnTranslationRecognisedInProfitOrLoss', N'Foreign exchange gain (loss)',N'The amount of exchange differences recognised in profit or loss that arise from foreign currency transactions, excluding those arising on financial instruments measured at fair value through profit or loss in accordance with IFRS 9. [Refer: At fair value [member]; Financial instruments, class [member]]')
  INSERT INTO @AT VALUES(211101751,0,0,'211101751', '/2/1/1/1/1/7/5/1/', NULL,N'NetForeignExchangeGain', N'Net foreign exchange gain',N'The net gain arising from foreign exchange differences. [Refer: Foreign exchange gain (loss)]')
  INSERT INTO @AT VALUES(211101752,0,0,'211101752', '/2/1/1/1/1/7/5/2/', NULL,N'NetForeignExchangeLoss', N'Net foreign exchange loss',N'The net loss arising from foreign exchange differences. [Refer: Foreign exchange gain (loss)]')
  INSERT INTO @AT VALUES(211103,0,0,'211103', '/2/1/1/1/3/', NULL,N'GainsLossesOnNetMonetaryPosition', N'Gains (losses) on net monetary position',N'The gains (losses) representing the difference resulting from the restatement of non-monetary assets, owners'' equity and items in the statement of comprehensive income and the adjustment of index linked assets and liabilities in hyperinflationary reporting.')
  INSERT INTO @AT VALUES(211104,0,0,'211104', '/2/1/1/1/4/', NULL,N'GainLossArisingFromDerecognitionOfFinancialAssetsMeasuredAtAmortisedCost', N'Gain (loss) arising from derecognition of financial assets measured at amortised cost',N'The gain (loss) arising from the derecognition of financial assets measured at amortised cost. [Refer: Financial assets at amortised cost]')
  INSERT INTO @AT VALUES(211105,0,0,'211105', '/2/1/1/1/5/', NULL,N'FinanceIncome', N'Finance income',N'The amount of income associated with interest and other financing activities of the entity.')
  INSERT INTO @AT VALUES(211106,0,0,'211106', '/2/1/1/1/6/', NULL,N'FinanceCosts', N'Finance costs',N'The amount of costs associated with financing activities of the entity.')
  INSERT INTO @AT VALUES(211107,0,0,'211107', '/2/1/1/1/7/', NULL,N'ImpairmentLossImpairmentGainAndReversalOfImpairmentLossDeterminedInAccordanceWithIFRS9', N'Impairment gain and reversal of impairment loss (impairment loss) determined in accordance with IFRS 9',N'The amount of impairment loss, impairment gain or reversal of impairment loss that is recognised in profit or loss in accordance with paragraph 5.5.8 of IFRS 9 and that arises from applying the impairment requirements in Section 5.5 of IFRS 9.')
  INSERT INTO @AT VALUES(211108,0,0,'211108', '/2/1/1/1/8/', NULL,N'ShareOfProfitLossOfAssociatesAndJointVenturesAccountedForUsingEquityMethod', N'Share of profit (loss) of associates and joint ventures accounted for using equity method',N'The entity''s share of the profit (loss) of associates and joint ventures accounted for using the equity method. [Refer: Associates [member]; Investments accounted for using equity method; Joint ventures [member]; Profit (loss)]')
  INSERT INTO @AT VALUES(211109,0,0,'211109', '/2/1/1/1/9/', NULL,N'OtherIncomeExpenseFromSubsidiariesJointlyControlledEntitiesAndAssociates', N'Other income (expense) from subsidiaries, jointly controlled entities and associates',N'The amount of income or expense from subsidiaries, jointly controlled entities and associates that the entity does not separately disclose in the same statement or note. [Refer: Associates [member]; Subsidiaries [member]]')
  INSERT INTO @AT VALUES(211110,0,0,'211110', '/2/1/1/1/10/', NULL,N'GainsLossesArisingFromDifferenceBetweenPreviousCarryingAmountAndFairValueOfFinancialAssetsReclassifiedAsMeasuredAtFairValue', N'Gains (losses) arising from difference between previous amortised cost and fair value of financial assets reclassified out of amortised cost into fair value through profit or loss measurement category',N'The gains (losses) arising from the difference between the previous amortised cost and the fair value of financial assets reclassified out of the amortised cost into the fair value through profit or loss measurement category. [Refer: At fair value [member]; Financial assets at amortised cost]')
  INSERT INTO @AT VALUES(211111,0,0,'211111', '/2/1/1/1/11/', NULL,N'CumulativeGainLossPreviouslyRecognisedInOtherComprehensiveIncomeArisingFromReclassificationOfFinancialAssetsOutOfFairValueThroughOtherComprehensiveIncomeIntoFairValueThroughProfitOrLossMeasurementCategory', N'Cumulative gain (loss) previously recognised in other comprehensive income arising from reclassification of financial assets out of fair value through other comprehensive income into fair value through profit or loss measurement category',N'The cumulative gain (loss) previously recognised in other comprehensive income arising from the reclassification of financial assets out of the fair value through other comprehensive income into the fair value through profit or loss measurement category. [Refer: Financial assets measured at fair value through other comprehensive income; Financial assets at fair value through profit or loss; Other comprehensive income]')
  INSERT INTO @AT VALUES(211112,0,0,'211112', '/2/1/1/1/12/', NULL,N'HedgingGainsLossesForHedgeOfGroupOfItemsWithOffsettingRiskPositions', N'Hedging gains (losses) for hedge of group of items with offsetting risk positions',N'The hedging gains (losses) for hedge of group of items with offsetting risk positions.')
  INSERT INTO @AT VALUES(2112,0,0,'2112', '/2/1/1/2/', NULL,N'IncomeTaxExpenseContinuingOperations', N'Tax income (expense)',N'The aggregate amount included in the determination of profit (loss) for the period in respect of current tax and deferred tax. [Refer: Current tax expense (income); Deferred tax expense (income)]')
  INSERT INTO @AT VALUES(212,0,0,'212', '/2/1/2/', NULL,N'ProfitLossFromDiscontinuedOperations', N'Profit (loss) from discontinued operations',N'The profit (loss) from discontinued operations. [Refer: Discontinued operations [member]; Profit (loss)]')
  INSERT INTO @AT VALUES(3,0,0,'3', '/3/', NULL,N'OtherComprehensiveIncome', N'Other comprehensive income',N'')
  INSERT INTO @AT VALUES(31,0,0,'31', '/3/1/', NULL,N'ComponentsOfOtherComprehensiveIncomeThatWillNotBeReclassifiedToProfitOrLossBeforeTax', N'Components of other comprehensive income that will not be reclassified to profit or loss, before tax [abstract]',N'The amount of other comprehensive income that will not be reclassified to profit or loss, before tax. [Refer: Other comprehensive income]')
  INSERT INTO @AT VALUES(311,0,0,'311', '/3/1/1/', NULL,N'OtherComprehensiveIncomeBeforeTaxGainsLossesFromInvestmentsInEquityInstruments', N'Other comprehensive income, before tax, gains (losses) from investments in equity instruments',N'The amount of other comprehensive income, before tax, related to gains (losses) from changes in the fair value of investments in equity instruments that the entity has designated at fair value through other comprehensive income. [Refer: Other comprehensive income, before tax]')
  INSERT INTO @AT VALUES(312,0,0,'312', '/3/1/2/', NULL,N'OtherComprehensiveIncomeBeforeTaxGainsLossesOnRevaluation', N'Other comprehensive income, before tax, gains (losses) on revaluation',N'The amount of other comprehensive income, before tax, related to gains (losses) in relation to changes in the revaluation surplus. [Refer: Other comprehensive income, before tax; Revaluation surplus]')
  INSERT INTO @AT VALUES(313,0,0,'313', '/3/1/3/', NULL,N'OtherComprehensiveIncomeBeforeTaxGainsLossesOnRemeasurementsOfDefinedBenefitPlans', N'Other comprehensive income, before tax, gains (losses) on remeasurements of defined benefit plans',N'The amount of other comprehensive income, before tax, related to gains (losses) on remeasurements of defined benefit plans, which comprise actuarial gains and losses; the return on plan assets, excluding amounts included in net interest on the net defined benefit liability (asset); and any change in the effect of the asset ceiling, excluding amounts included in net interest on the net defined benefit liability (asset). [Refer: Other comprehensive income, before tax; Defined benefit plans [member]; Plan assets [member]; Net defined benefit liability (asset)]')
  INSERT INTO @AT VALUES(314,0,0,'314', '/3/1/4/', NULL,N'OtherComprehensiveIncomeBeforeTaxChangeInFairValueOfFinancialLiabilityAttributableToChangeInCreditRiskOfLiability', N'Other comprehensive income, before tax, change in fair value of financial liability attributable to change in credit risk of liability',N'The amount of other comprehensive income, before tax, related to change in the fair value of financial liability attributable to change in the credit risk of the liability. [Refer: Other comprehensive income, before tax; Credit risk [member]]')
  INSERT INTO @AT VALUES(315,0,0,'315', '/3/1/5/', NULL,N'OtherComprehensiveIncomeBeforeTaxGainsLossesOnHedgingInstrumentsThatHedgeInvestmentsInEquityInstruments', N'Other comprehensive income, before tax, gains (losses) on hedging instruments that hedge investments in equity instruments',N'The amount of other comprehensive income, before tax, related to gains (losses) on hedging instruments that hedge investments in equity instruments that the entity has designated at fair value through other comprehensive income. [Refer: Other comprehensive income, before tax]')
  INSERT INTO @AT VALUES(316,0,0,'316', '/3/1/6/', NULL,N'OtherComprehensiveIncomeBeforeTaxInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillNotBeReclassifiedToProfitOrLoss', N'Other comprehensive income, before tax, insurance finance income (expenses) from insurance contracts issued excluded from profit or loss that will not be reclassified to profit or loss',N'The amount of other comprehensive income, before tax, related to insurance finance income (expenses) from insurance contracts issued that will not be reclassified subsequently to profit or loss. [Refer: Insurance finance income (expenses); Insurance contracts issued [member]]')
  INSERT INTO @AT VALUES(317,0,0,'317', '/3/1/7/', NULL,N'ShareOfOtherComprehensiveIncomeOfAssociatesAndJointVenturesAccountedForUsingEquityMethodThatWillNotBeReclassifiedToProfitOrLossBeforeTax', N'Share of other comprehensive income of associates and joint ventures accounted for using equity method that will not be reclassified to profit or loss, before tax',N'Share of the other comprehensive income of associates and joint ventures accounted for using the equity method that will not be reclassified to profit or loss, before tax.')
  INSERT INTO @AT VALUES(32,0,0,'32', '/3/2/', NULL,N'ComponentsOfOtherComprehensiveIncomeThatWillBeReclassifiedToProfitOrLossBeforeTax', N'Components of other comprehensive income that will be reclassified to profit or loss, before tax [abstract]',N'The amount of other comprehensive income that will be reclassified to profit or loss, before tax. [Refer: Other comprehensive income]')
  INSERT INTO @AT VALUES(321,0,0,'321', '/3/2/1/', NULL,N'OtherComprehensiveIncomeBeforeTaxExchangeDifferencesOnTranslation', N'Exchange differences on translation',N'The amount of other comprehensive income, before tax, related to exchange differences on translation of financial statements of foreign operations. [Refer: Other comprehensive income, before tax]')
  INSERT INTO @AT VALUES(3211,0,0,'3211', '/3/2/1/1/', NULL,N'GainsLossesOnExchangeDifferencesOnTranslationBeforeTax', N'Gains (losses) on exchange differences on translation, before tax',N'The gains (losses) recognised in other comprehensive income on exchange differences on the translation of financial statements of foreign operations, before tax. [Refer: Other comprehensive income]')
  INSERT INTO @AT VALUES(3212,0,0,'3212', '/3/2/1/2/', NULL,N'ReclassificationAdjustmentsOnExchangeDifferencesOnTranslationBeforeTax', N'Reclassification adjustments on exchange differences on translation, before tax',N'The amount of reclassification adjustments related to exchange differences when the financial statements of foreign operations are translated, before tax. Reclassification adjustments are amounts reclassified to profit (loss) in the current period that were recognised in other comprehensive income in the current or previous periods. [Refer: Other comprehensive income]')
  INSERT INTO @AT VALUES(322,0,0,'322', '/3/2/2/', NULL,N'OtherComprehensiveIncomeBeforeTaxAvailableforsaleFinancialAssets', N'Available-for-sale financial assets',N'The amount of other comprehensive income, before tax, related to available-for-sale financial assets. [Refer: Financial assets available-for-sale; Other comprehensive income, before tax]')
  INSERT INTO @AT VALUES(3221,0,0,'3221', '/3/2/2/1/', NULL,N'GainsLossesOnRemeasuringAvailableforsaleFinancialAssetsBeforeTax', N'Gains (losses) on remeasuring available-for-sale financial assets, before tax',N'The gains (losses) recognised in other comprehensive income on remeasuring available-for-sale financial assets, before tax. [Refer: Financial assets available-for-sale]')
  INSERT INTO @AT VALUES(3222,0,0,'3222', '/3/2/2/2/', NULL,N'ReclassificationAdjustmentsOnAvailableforsaleFinancialAssetsBeforeTax', N'Reclassification adjustments on available-for-sale financial assets, before tax',N'The amount of reclassification adjustments related to available-for-sale financial assets, before tax. Reclassification adjustments are amounts reclassified to profit (loss) in the current period that were recognised in other comprehensive income in the current or previous periods. [Refer: Financial assets available-for-sale; Other comprehensive income]')
  INSERT INTO @AT VALUES(4,0,0,'4', '/4/', NULL,N'ControlAccountsExtension', N'Control accounts',N'')
  INSERT INTO @AT VALUES(41,0,0,'41', '/4/1/', N'ChangesInTradersControlExtension',N'PerformanceObligationsControlExtension', N'Performance obligations control',N'')
  INSERT INTO @AT VALUES(411,0,0,'411', '/4/1/1/', N'ChangesInTradersControlExtension',N'PerformanceObligationsAtAPointInTimeControlExtension', N'Performance obligations at a point in time control',N'')
  INSERT INTO @AT VALUES(4112,0,0,'4112', '/4/1/1/2/', N'ChangesInTradersControlExtension',N'SupplierPerformanceObligationsAtAPointInTimeControlExtension', N'Supplier performance obligations at a point in time control',N'')
  INSERT INTO @AT VALUES(4113,0,0,'4113', '/4/1/1/3/', N'ChangesInTradersControlExtension',N'CustomerPerformanceObligationsAtAPointInTimeControlExtension', N'Customer performance obligations at a point in time control',N'')
  INSERT INTO @AT VALUES(412,0,0,'412', '/4/1/2/', N'ChangesInTradersControlExtension',N'PerformanceObligationsOverAPeriodOfTimeControlExtension', N'Performance obligations over a period of time control',N'')
  INSERT INTO @AT VALUES(4122,0,0,'4122', '/4/1/2/2/', N'ChangesInTradersControlExtension',N'SupplierPerformanceObligationsOverAPeriodOfTimeControlExtension', N'Supplier performance obligations over a period of time control',N'')
  INSERT INTO @AT VALUES(4123,0,0,'4123', '/4/1/2/3/', N'ChangesInTradersControlExtension',N'CustomerPerformanceObligationsOverAPeriodOfTimeControlExtension', N'Customer performance obligations over a period of time control',N'')
  INSERT INTO @AT VALUES(4124,0,1,'4124', '/4/1/2/4/', N'ChangesInTradersControlExtension',N'EmployeePerformanceObligationsOverAPeriodOfTimeControlExtension', N'Employee performance obligations over a period of time control',N'')
  INSERT INTO @AT VALUES(42,0,0,'42', '/4/2/', N'ChangesInTradersControlExtension',N'OthersAccountsControlExtension', N'Others control accounts',N'')
  INSERT INTO @AT VALUES(421,0,1,'421', '/4/2/1/', N'ChangesInTradersControlExtension',N'PaymentControlExtension', N'Payment control',N'')
  INSERT INTO @AT VALUES(4211,0,1,'4211', '/4/2/1/1/', N'ChangesInTradersControlExtension',N'SupplierPaymentControlExtension', N'Supplier payment control',N'')
  INSERT INTO @AT VALUES(4212,0,1,'4212', '/4/2/1/2/', N'ChangesInTradersControlExtension',N'EmployeePaymentControlExtension', N'Employee payment control',N'')
  INSERT INTO @AT VALUES(4213,0,1,'4213', '/4/2/1/3/', N'ChangesInTradersControlExtension',N'CustomerPaymentControlExtension', N'Customer payment control',N'')
  INSERT INTO @AT VALUES(4219,0,1,'4219', '/4/2/1/9/', N'ChangesInTradersControlExtension',N'OtherPaymentControlExtension', N'Other payment control',N'')
  INSERT INTO @AT VALUES(5,0,1,'5', '/5/', NULL,N'StatisticalAccountsExtension', N'Statistical accounts',N'')
  INSERT INTO @AT VALUES(51,0,1,'51', '/5/1/', NULL,N'GuaranteesExtension', N'Guarantees',N'')
  INSERT INTO @AT VALUES(52,0,0,'52', '/5/2/', NULL,N'PayrollExtension', N'Payroll',N'')
  INSERT INTO @AT VALUES(53,0,0,'53', '/5/3/', NULL,N'HRExtension', N'HR',N'')
  INSERT INTO @AT VALUES(54,0,0,'54', '/5/4/', NULL,N'CRMExtension', N'CRM',N'')
  INSERT INTO @AT VALUES(55,0,0,'55', '/5/5/', NULL,N'ProductionExtension', N'Production',N'')
  INSERT INTO @AT VALUES(9,0,1,'9', '/9/', NULL,N'MigrationAccountsExtension', N'Migration accounts',N'')
  INSERT INTO @AccountTypes ([Index], [Id], [Code], [Concept], [Name], [ParentIndex], [StandardAndPure], [IsMonetary],
  		[EntryTypeParentId], [Description])
  SELECT RC.[Index], 0, RC.[Code], RC.[Concept], RC.[Name], (SELECT [Index] FROM @AT WHERE [Node] = RC.[Node].GetAncestor(1)) AS ParentIndex, [StandardAndPure], [IsMonetary],
  		(SELECT [Id] FROM dbo.EntryTypes WHERE [Concept] = RC.EntryTypeParentConcept), [Description]
  FROM @AT RC;
  UPDATE @AccountTypes SET IsAssignable = 1
  WHERE [Index] NOT IN (SELECT [ParentIndex] FROM @AccountTypes WHERE [ParentIndex] IS NOT NULL)
  UPDATE @AccountTypes SET IsAssignable = 0
  WHERE [Index] IN (SELECT [ParentIndex] FROM @AccountTypes WHERE [ParentIndex] IS NOT NULL)
  
  UPDATE  @AccountTypes
  	SET [Time1Label] = N'From Date', Time2Label = N'To Date'
  	--SET [Time1Label] = N'Depreciation Starts', Time2Label = N'Depreciation Ends'
  WHERE [Concept] IN (
  	N'Land',
  	N'Buildings',
  	N'Machinery',
  	N'Ships',
  	N'Aircraft',
  	N'MotorVehicles',
  	N'FixturesAndFittings',
  	N'OfficeEquipment',
  	N'BearerPlants',
  	N'TangibleExplorationAndEvaluationAssets',
  	N'MiningAssets',
  	N'OilAndGasAssets',
  	N'ConstructionInProgress', -- no depreciation
  	N'OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModel',
  	N'OtherPropertyPlantAndEquipment',
  	N'InvestmentPropertyCompleted',
  	N'InvestmentPropertyUnderConstructionOrDevelopment', -- no depreciation
  	N'BrandNames', -- amortizations
  	N'IntangibleExplorationAndEvaluationAssets',
  	N'MastheadsAndPublishingTitles',
  	N'ComputerSoftware',
  	N'LicencesAndFranchises',
  	N'CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights',
  	N'RecipesFormulaeModelsDesignsAndPrototypes',
  	N'IntangibleAssetsUnderDevelopment',
  	N'OtherIntangibleAssets',
  	N'NoncurrentBiologicalAssets',
  	N'RevenueFromRenderingOfPeriodOfTimeServices',-- service starts, service ends
  	N'InsuranceExpense', -- 
  	N'UtilitiesExpense',
  	N'DepreciationExpense', -- depreciation starts, ends (if time based)
  	N'AmortisationExpense', -- amortizations
  	N'TaxExpenseOtherThanIncomeTaxExpense',
  	N'CustomerPerformanceObligationsOverAPeriodOfTimeControlExtension',
  	N'EmployeePerformanceObligationsOverAPeriodOfTimeControlExtension',
  	N'HRMExtension'
  );
  
  UPDATE  @AccountTypes
  	SET [NotedDateLabel] = N'Period Ending'
  WHERE [Concept] IN (
  	N'ShorttermEmployeeBenefitsAccruals',
  	N'RetainedEarnings',
  	N'CurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTax',
  	N'CurrentValueAddedTaxPayables',
  	N'CurrentExciseTaxPayables',
  	N'OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension', -- Needed?
  	N'WagesAndSalaries',
  	N'SocialSecurityContributions',
  	N'OtherShorttermEmployeeBenefits',
  	N'OtherLongtermBenefits',
  	N'PaidLeavesExtension'
  );
  
  UPDATE  @AccountTypes
  	SET [NotedDateLabel] = N'Expiry Date'
  WHERE [Concept] IN (
  	N'LongtermWarrantyProvision',
  	N'ShorttermWarrantyProvision'
  );
  
  UPDATE  @AccountTypes SET [ExternalReferenceLabel] = N'External Ref #', [InternalReferenceLabel] = N'Internal Ref #'
  WHERE [Concept] IN (N'CashOnHand', N'BalancesWithBanks');
  
  UPDATE  @AccountTypes SET [ExternalReferenceLabel] = N'Invoice #'
  WHERE [Concept] IN (
  	N'NoncurrentValueAddedTaxReceivables',
  	N'CurrentValueAddedTaxReceivables'
  );
  
  UPDATE  @AccountTypes SET [InternalReferenceLabel] = N'Invoice #'
  WHERE [Concept] IN (
  	N'NoncurrentValueAddedTaxPayables',
  	N'CurrentValueAddedTaxPayables',
  	N'RevenueFromSaleOfGoods',
  	N'RevenueFromSaleOfCopper',
  	N'RevenueFromSaleOfGold',
  	N'RevenueFromSaleOfSilver',
  	N'RevenueFromSaleOfOilAndGasProducts',
  	N'RevenueFromSaleOfCrudeOil',
  	N'RevenueFromSaleOfAgriculturalProduce',
  	N'RevenueFromSaleOfFoodAndBeverage',
  	N'DeferredIncomeClassifiedAsCurrent',
  	N'RentDeferredIncomeClassifiedAsCurrent',
  	N'RevenueFromRenderingOfServices',
  	N'RevenueFromRenderingOfPointOfTimeServices',
  	N'RevenueFromRenderingOfPeriodOfTimeServices',
  	N'RevenueFromConstructionContracts',
  	N'RevenueFromRoyalties',
  	N'LicenceFeeIncome',
  	N'FranchiseFeeIncome',
  	N'RevenueFromInterest',
  	N'RevenueFromDividends',
  	N'OtherIncome',
  	N'OtherRevenue',
  	N'CostOfMerchandiseSold'
  );
  
  UPDATE  @AccountTypes
  	SET [NotedAgentNameLabel] = N'Issuer (Recipient)'
  WHERE [Concept] IN (
  	N'Merchandise',
  	N'CurrentFoodAndBeverage',
  	N'CurrentAgriculturalProduce',
  	N'FinishedGoods',
  	N'PropertyIntendedForSaleInOrdinaryCourseOfBusiness',
  	N'WorkInProgress',
  	N'RawMaterials',
  	N'ProductionSupplies',
  	N'CurrentPackagingAndStorageMaterials',
  	N'SpareParts',
  	N'CurrentFuel',
  	N'OtherInventories',
  	N'CurrentInventoriesInTransit',
  	N'CashOnHand',
  	N'BalancesWithBanks'
  );
  
  UPDATE  @AccountTypes
  	SET [NotedAmountLabel] = N'Taxable Amount'
  WHERE [Concept] IN (
  	N'NoncurrentValueAddedTaxReceivables',
  	N'CurrentValueAddedTaxReceivables',
  	N'CurrentTaxAssetsCurrent',
  	N'NoncurrentValueAddedTaxPayables',
  	N'CurrentValueAddedTaxPayables',
  	N'CurrentExciseTaxPayables',
  	N'OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension'
  );
  
  UPDATE  @AccountTypes
  	SET [NotedAmountLabel] = N'Amount Subject to Zakat'
  WHERE [Concept] IN (
  	N'CurrentZakatPayablesExtension'
  );
  	--[Time1Label], [Time1Label2], [Time1Label3],
  	--[Time2Label], [Time2Label2], [Time2Label3],
  	--[ExternalReferenceLabel], [ExternalReferenceLabel2], [ExternalReferenceLabel3], 
  	--[InternalReferenceLabel], [InternalReferenceLabel2], [InternalReferenceLabel3],
  	--[NotedAgentNameLabel], [NotedAgentNameLabel2], [NotedAgentNameLabel3],
  	--[NotedAmountLabel], [NotedAmountLabel2], [NotedAmountLabel3],
  	--[NotedDateLabel], [NotedDateLabel2], [NotedDateLabel3]
  
  
  INSERT INTO @ValidationErrors
  EXEC [api].[AccountTypes__Save]
  	@Entities = @AccountTypes,
  	@AccountTypeResourceDefinitions = @AccountTypeResourceDefinitions,
  	@ReturnIds = 0,
  	@UserId = @AdminUserId;
  
  IF EXISTS (SELECT [Key] FROM @ValidationErrors)
  BEGIN
  	Print 'Account Types: Error Provisioning'
  	GOTO Err_Label;
  END;
  
  IF (1=1) -- Declarations
  BEGIN
  --Declarations
  DECLARE @StatementOfFinancialPositionAbstract INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'StatementOfFinancialPositionAbstract');
  DECLARE @Assets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Assets');
  DECLARE @NoncurrentAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentAssets');
  DECLARE @PropertyPlantAndEquipment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PropertyPlantAndEquipment');
  DECLARE @LandAndBuildings INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LandAndBuildings');
  DECLARE @Land INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Land');
  DECLARE @Buildings INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Buildings');
  DECLARE @Machinery INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Machinery');
  DECLARE @Vehicles INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Vehicles');
  DECLARE @Ships INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Ships');
  DECLARE @Aircraft INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Aircraft');
  DECLARE @MotorVehicles INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'MotorVehicles');
  DECLARE @FixturesAndFittings INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'FixturesAndFittings');
  DECLARE @OfficeEquipment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OfficeEquipment');
  DECLARE @BearerPlants INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'BearerPlants');
  DECLARE @TangibleExplorationAndEvaluationAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TangibleExplorationAndEvaluationAssets');
  DECLARE @MiningAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'MiningAssets');
  DECLARE @OilAndGasAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OilAndGasAssets');
  DECLARE @ConstructionInProgress INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ConstructionInProgress');
  DECLARE @OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModel INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModel');
  DECLARE @OtherPropertyPlantAndEquipment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherPropertyPlantAndEquipment');
  DECLARE @InvestmentProperty INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentProperty');
  DECLARE @InvestmentPropertyCompleted INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentPropertyCompleted');
  DECLARE @InvestmentPropertyUnderConstructionOrDevelopment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentPropertyUnderConstructionOrDevelopment');
  DECLARE @Goodwill INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Goodwill');
  DECLARE @IntangibleAssetsOtherThanGoodwill INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'IntangibleAssetsOtherThanGoodwill');
  DECLARE @BrandNames INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'BrandNames');
  DECLARE @IntangibleExplorationAndEvaluationAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'IntangibleExplorationAndEvaluationAssets');
  DECLARE @MastheadsAndPublishingTitles INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'MastheadsAndPublishingTitles');
  DECLARE @ComputerSoftware INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ComputerSoftware');
  DECLARE @LicencesAndFranchises INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LicencesAndFranchises');
  DECLARE @CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights');
  DECLARE @RecipesFormulaeModelsDesignsAndPrototypes INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RecipesFormulaeModelsDesignsAndPrototypes');
  DECLARE @IntangibleAssetsUnderDevelopment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'IntangibleAssetsUnderDevelopment');
  DECLARE @OtherIntangibleAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherIntangibleAssets');
  DECLARE @InvestmentAccountedForUsingEquityMethod INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentAccountedForUsingEquityMethod');
  DECLARE @InvestmentsInAssociatesAccountedForUsingEquityMethod INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentsInAssociatesAccountedForUsingEquityMethod');
  DECLARE @InvestmentsInJointVenturesAccountedForUsingEquityMethod INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentsInJointVenturesAccountedForUsingEquityMethod');
  DECLARE @InvestmentsInSubsidiariesJointVenturesAndAssociates INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentsInSubsidiariesJointVenturesAndAssociates');
  DECLARE @InvestmentsInSubsidiaries INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentsInSubsidiaries');
  DECLARE @InvestmentsInJointVentures INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentsInJointVentures');
  DECLARE @InvestmentsInAssociates INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InvestmentsInAssociates');
  DECLARE @NoncurrentBiologicalAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentBiologicalAssets');
  DECLARE @NoncurrentReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentReceivables');
  DECLARE @NoncurrentTradeReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentTradeReceivables');
  DECLARE @NoncurrentReceivablesDueFromRelatedParties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentReceivablesDueFromRelatedParties');
  DECLARE @NoncurrentPrepaymentsAndNoncurrentAccruedIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentPrepaymentsAndNoncurrentAccruedIncome');
  DECLARE @NoncurrentPrepayments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentPrepayments');
  DECLARE @NoncurrentAccruedIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentAccruedIncome');
  DECLARE @NoncurrentReceivablesFromTaxesOtherThanIncomeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentReceivablesFromTaxesOtherThanIncomeTax');
  DECLARE @NoncurrentValueAddedTaxReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentValueAddedTaxReceivables');
  DECLARE @NoncurrentReceivablesFromSaleOfProperties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentReceivablesFromSaleOfProperties');
  DECLARE @NoncurrentReceivablesFromRentalOfProperties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentReceivablesFromRentalOfProperties');
  DECLARE @OtherNoncurrentReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherNoncurrentReceivables');
  DECLARE @NoncurrentInventories INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentInventories');
  DECLARE @DeferredTaxAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DeferredTaxAssets');
  DECLARE @CurrentTaxAssetsNoncurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentTaxAssetsNoncurrent');
  DECLARE @OtherNoncurrentFinancialAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherNoncurrentFinancialAssets');
  DECLARE @NoncurrentFinancialAssetsAtFairValueThroughProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLoss');
  DECLARE @NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition');
  DECLARE @NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForRepurchaseOfOwnFinancialLiabil INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForRepurchaseOfOwnFinancialLiabilities');
  DECLARE @NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForReacquisitionOfOwnEquityInstru INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForReacquisitionOfOwnEquityInstruments');
  DECLARE @NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading');
  DECLARE @NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMandatorilyMeasuredAtFairValue INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAtFairValueThroughProfitOrLossMandatorilyMeasuredAtFairValue');
  DECLARE @NoncurrentFinancialAssetsAvailableforsale INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAvailableforsale');
  DECLARE @NoncurrentHeldtomaturityInvestments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentHeldtomaturityInvestments');
  DECLARE @NoncurrentLoansAndReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentLoansAndReceivables');
  DECLARE @NoncurrentFinancialAssetsAtFairValueThroughOtherComprehensiveIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAtFairValueThroughOtherComprehensiveIncome');
  DECLARE @NoncurrentFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome');
  DECLARE @NoncurrentInvestmentsInEquityInstrumentsDesignatedAtFairValueThroughOtherComprehensiveIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentInvestmentsInEquityInstrumentsDesignatedAtFairValueThroughOtherComprehensiveIncome');
  DECLARE @NoncurrentFinancialAssetsAtAmortisedCost INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialAssetsAtAmortisedCost');
  DECLARE @OtherNoncurrentNonfinancialAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherNoncurrentNonfinancialAssets');
  DECLARE @NoncurrentNoncashAssetsPledgedAsCollateralForWhichTransfereeHasRightByContractOrCustomToSellOrRepledgeCollateral INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentNoncashAssetsPledgedAsCollateralForWhichTransfereeHasRightByContractOrCustomToSellOrRepledgeCollateral');
  DECLARE @CurrentAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentAssets');
  DECLARE @CurrentAssetsOtherThanAssetsOrDisposalGroupsClassifiedAsHeldForSaleOrAsHeldForDistributionToOwners INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentAssetsOtherThanAssetsOrDisposalGroupsClassifiedAsHeldForSaleOrAsHeldForDistributionToOwners');
  DECLARE @Inventories INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Inventories');
  DECLARE @CurrentInventoriesHeldForSale INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentInventoriesHeldForSale');
  DECLARE @Merchandise INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Merchandise');
  DECLARE @CurrentFoodAndBeverage INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFoodAndBeverage');
  DECLARE @CurrentAgriculturalProduce INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentAgriculturalProduce');
  DECLARE @FinishedGoods INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'FinishedGoods');
  DECLARE @PropertyIntendedForSaleInOrdinaryCourseOfBusiness INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PropertyIntendedForSaleInOrdinaryCourseOfBusiness');
  DECLARE @WorkInProgress INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'WorkInProgress');
  DECLARE @CurrentMaterialsAndSuppliesToBeConsumedInProductionProcessOrRenderingServices INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentMaterialsAndSuppliesToBeConsumedInProductionProcessOrRenderingServices');
  DECLARE @CurrentRawMaterialsAndCurrentProductionSupplies INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentRawMaterialsAndCurrentProductionSupplies');
  DECLARE @RawMaterials INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RawMaterials');
  DECLARE @ProductionSupplies INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ProductionSupplies');
  DECLARE @CurrentPackagingAndStorageMaterials INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentPackagingAndStorageMaterials');
  DECLARE @SpareParts INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'SpareParts');
  DECLARE @CurrentFuel INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFuel');
  DECLARE @CurrentInventoriesInTransit INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentInventoriesInTransit');
  DECLARE @OtherInventories INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherInventories');
  DECLARE @TradeAndOtherCurrentReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TradeAndOtherCurrentReceivables');
  DECLARE @CurrentTradeReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentTradeReceivables');
  DECLARE @TradeAndOtherCurrentReceivablesDueFromRelatedParties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TradeAndOtherCurrentReceivablesDueFromRelatedParties');
  DECLARE @CurrentPrepaymentsAndCurrentAccruedIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentPrepaymentsAndCurrentAccruedIncome');
  DECLARE @CurrentPrepayments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentPrepayments');
  DECLARE @CurrentAdvancesToSuppliers INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentAdvancesToSuppliers');
  DECLARE @CurrentPrepaidExpenses INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentPrepaidExpenses');
  DECLARE @CurrentAccruedIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentAccruedIncome');
  DECLARE @CurrentBilledNotReceivedFromSuppliersExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentBilledNotReceivedFromSuppliersExtension');
  DECLARE @CurrentReceivablesFromTaxesOtherThanIncomeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentReceivablesFromTaxesOtherThanIncomeTax');
  DECLARE @CurrentValueAddedTaxReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentValueAddedTaxReceivables');
  DECLARE @CurrentReceivablesFromRentalOfProperties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentReceivablesFromRentalOfProperties');
  DECLARE @OtherCurrentReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherCurrentReceivables');
  DECLARE @CurrentTaxAssetsCurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentTaxAssetsCurrent');
  DECLARE @CurrentBiologicalAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentBiologicalAssets');
  DECLARE @OtherCurrentFinancialAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherCurrentFinancialAssets');
  DECLARE @CurrentFinancialAssetsAtFairValueThroughProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAtFairValueThroughProfitOrLoss');
  DECLARE @CurrentFinancialAssetsAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition');
  DECLARE @CurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForRepurchaseOfOwnFinancialLiabiliti INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForRepurchaseOfOwnFinancialLiabilities');
  DECLARE @CurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForReacquisitionOfOwnEquityInstrumen INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossMeasuredAsSuchInAccordanceWithExemptionForReacquisitionOfOwnEquityInstruments');
  DECLARE @CurrentFinancialAssetsAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading');
  DECLARE @CurrentFinancialAssetsAtFairValueThroughProfitOrLossMandatorilyMeasuredAtFairValue INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAtFairValueThroughProfitOrLossMandatorilyMeasuredAtFairValue');
  DECLARE @CurrentFinancialAssetsAvailableforsale INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAvailableforsale');
  DECLARE @CurrentHeldtomaturityInvestments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentHeldtomaturityInvestments');
  DECLARE @CurrentLoansAndReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentLoansAndReceivables');
  DECLARE @CurrentFinancialAssetsAtFairValueThroughOtherComprehensiveIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAtFairValueThroughOtherComprehensiveIncome');
  DECLARE @CurrentFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome');
  DECLARE @CurrentInvestmentsInEquityInstrumentsDesignatedAtFairValueThroughOtherComprehensiveIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentInvestmentsInEquityInstrumentsDesignatedAtFairValueThroughOtherComprehensiveIncome');
  DECLARE @CurrentFinancialAssetsAtAmortisedCost INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialAssetsAtAmortisedCost');
  DECLARE @OtherCurrentNonfinancialAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherCurrentNonfinancialAssets');
  DECLARE @CashAndCashEquivalents INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CashAndCashEquivalents');
  DECLARE @Cash INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Cash');
  DECLARE @CashOnHand INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CashOnHand');
  DECLARE @BalancesWithBanks INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'BalancesWithBanks');
  DECLARE @CashEquivalents INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CashEquivalents');
  DECLARE @ShorttermDepositsClassifiedAsCashEquivalents INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermDepositsClassifiedAsCashEquivalents');
  DECLARE @ShorttermInvestmentsClassifiedAsCashEquivalents INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermInvestmentsClassifiedAsCashEquivalents');
  DECLARE @BankingArrangementsClassifiedAsCashEquivalents INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'BankingArrangementsClassifiedAsCashEquivalents');
  DECLARE @OtherCashAndCashEquivalents INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherCashAndCashEquivalents');
  DECLARE @CurrentNoncashAssetsPledgedAsCollateralForWhichTransfereeHasRightByContractOrCustomToSellOrRepledgeCollateral INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentNoncashAssetsPledgedAsCollateralForWhichTransfereeHasRightByContractOrCustomToSellOrRepledgeCollateral');
  DECLARE @NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForSaleOrAsHeldForDistributionToOwners INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForSaleOrAsHeldForDistributionToOwners');
  DECLARE @NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForSale INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForSale');
  DECLARE @NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForDistributionToOwners INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentAssetsOrDisposalGroupsClassifiedAsHeldForDistributionToOwners');
  DECLARE @EquityAndLiabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'EquityAndLiabilities');
  DECLARE @Equity INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Equity');
  DECLARE @IssuedCapital INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'IssuedCapital');
  DECLARE @RetainedEarnings INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RetainedEarnings');
  DECLARE @SharePremium INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'SharePremium');
  DECLARE @TreasuryShares INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TreasuryShares');
  DECLARE @OtherEquityInterest INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherEquityInterest');
  DECLARE @OtherReserves INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherReserves');
  DECLARE @RevaluationSurplus INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevaluationSurplus');
  DECLARE @ReserveOfExchangeDifferencesOnTranslation INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfExchangeDifferencesOnTranslation');
  DECLARE @ReserveOfCashFlowHedges INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfCashFlowHedges');
  DECLARE @ReserveOfGainsAndLossesOnHedgingInstrumentsThatHedgeInvestmentsInEquityInstruments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfGainsAndLossesOnHedgingInstrumentsThatHedgeInvestmentsInEquityInstruments');
  DECLARE @ReserveOfChangeInValueOfTimeValueOfOptions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfChangeInValueOfTimeValueOfOptions');
  DECLARE @ReserveOfChangeInValueOfForwardElementsOfForwardContracts INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfChangeInValueOfForwardElementsOfForwardContracts');
  DECLARE @ReserveOfChangeInValueOfForeignCurrencyBasisSpreads INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfChangeInValueOfForeignCurrencyBasisSpreads');
  DECLARE @ReserveOfGainsAndLossesOnFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfGainsAndLossesOnFinancialAssetsMeasuredAtFairValueThroughOtherComprehensiveIncome');
  DECLARE @ReserveOfInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillBeReclassifiedToProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillBeReclassifiedToProfitOrLoss');
  DECLARE @ReserveOfInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillNotBeReclassifiedToProfitOrL INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillNotBeReclassifiedToProfitOrLoss');
  DECLARE @ReserveOfFinanceIncomeExpensesFromReinsuranceContractsHeldExcludedFromProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfFinanceIncomeExpensesFromReinsuranceContractsHeldExcludedFromProfitOrLoss');
  DECLARE @ReserveOfGainsAndLossesOnRemeasuringAvailableforsaleFinancialAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfGainsAndLossesOnRemeasuringAvailableforsaleFinancialAssets');
  DECLARE @ReserveOfSharebasedPayments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfSharebasedPayments');
  DECLARE @ReserveOfRemeasurementsOfDefinedBenefitPlans INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfRemeasurementsOfDefinedBenefitPlans');
  DECLARE @AmountRecognisedInOtherComprehensiveIncomeAndAccumulatedInEquityRelatingToNoncurrentAssetsOrDisposalGroupsHeldForSale INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'AmountRecognisedInOtherComprehensiveIncomeAndAccumulatedInEquityRelatingToNoncurrentAssetsOrDisposalGroupsHeldForSale');
  DECLARE @ReserveOfGainsAndLossesFromInvestmentsInEquityInstruments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfGainsAndLossesFromInvestmentsInEquityInstruments');
  DECLARE @ReserveOfChangeInFairValueOfFinancialLiabilityAttributableToChangeInCreditRiskOfLiability INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfChangeInFairValueOfFinancialLiabilityAttributableToChangeInCreditRiskOfLiability');
  DECLARE @ReserveForCatastrophe INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveForCatastrophe');
  DECLARE @ReserveForEqualisation INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveForEqualisation');
  DECLARE @ReserveOfDiscretionaryParticipationFeatures INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfDiscretionaryParticipationFeatures');
  DECLARE @ReserveOfEquityComponentOfConvertibleInstruments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReserveOfEquityComponentOfConvertibleInstruments');
  DECLARE @CapitalRedemptionReserve INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CapitalRedemptionReserve');
  DECLARE @MergerReserve INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'MergerReserve');
  DECLARE @StatutoryReserve INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'StatutoryReserve');
  DECLARE @Liabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Liabilities');
  DECLARE @NoncurrentLiabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentLiabilities');
  DECLARE @NoncurrentProvisions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentProvisions');
  DECLARE @NoncurrentProvisionsForEmployeeBenefits INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentProvisionsForEmployeeBenefits');
  DECLARE @OtherLongtermProvisions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherLongtermProvisions');
  DECLARE @LongtermWarrantyProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LongtermWarrantyProvision');
  DECLARE @LongtermRestructuringProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LongtermRestructuringProvision');
  DECLARE @LongtermLegalProceedingsProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LongtermLegalProceedingsProvision');
  DECLARE @NoncurrentRefundsProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentRefundsProvision');
  DECLARE @LongtermOnerousContractsProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LongtermOnerousContractsProvision');
  DECLARE @LongtermProvisionForDecommissioningRestorationAndRehabilitationCosts INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LongtermProvisionForDecommissioningRestorationAndRehabilitationCosts');
  DECLARE @LongtermMiscellaneousOtherProvisions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LongtermMiscellaneousOtherProvisions');
  DECLARE @NoncurrentPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentPayables');
  DECLARE @NoncurrentPayablesToTradeSuppliers INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentPayablesToTradeSuppliers');
  DECLARE @NoncurrentPayablesToRelatedParties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentPayablesToRelatedParties');
  DECLARE @AccrualsAndDeferredIncomeClassifiedAsNoncurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'AccrualsAndDeferredIncomeClassifiedAsNoncurrent');
  DECLARE @DeferredIncomeClassifiedAsNoncurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DeferredIncomeClassifiedAsNoncurrent');
  DECLARE @RentDeferredIncomeClassifiedAsNoncurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RentDeferredIncomeClassifiedAsNoncurrent');
  DECLARE @AccrualsClassifiedAsNoncurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'AccrualsClassifiedAsNoncurrent');
  DECLARE @NoncurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTax');
  DECLARE @NoncurrentValueAddedTaxPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentValueAddedTaxPayables');
  DECLARE @NoncurrentExciseTaxPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentExciseTaxPayables');
  DECLARE @NoncurrentRetentionPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentRetentionPayables');
  DECLARE @OtherNoncurrentPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherNoncurrentPayables');
  DECLARE @DeferredTaxLiabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DeferredTaxLiabilities');
  DECLARE @CurrentTaxLiabilitiesNoncurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentTaxLiabilitiesNoncurrent');
  DECLARE @OtherNoncurrentFinancialLiabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherNoncurrentFinancialLiabilities');
  DECLARE @NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLoss');
  DECLARE @NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading');
  DECLARE @NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition');
  DECLARE @NoncurrentFinancialLiabilitiesAtAmortisedCost INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NoncurrentFinancialLiabilitiesAtAmortisedCost');
  DECLARE @OtherNoncurrentNonfinancialLiabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherNoncurrentNonfinancialLiabilities');
  DECLARE @CurrentLiabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentLiabilities');
  DECLARE @CurrentProvisions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentProvisions');
  DECLARE @CurrentProvisionsForEmployeeBenefits INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentProvisionsForEmployeeBenefits');
  DECLARE @OtherShorttermProvisions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherShorttermProvisions');
  DECLARE @ShorttermWarrantyProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermWarrantyProvision');
  DECLARE @ShorttermRestructuringProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermRestructuringProvision');
  DECLARE @ShorttermLegalProceedingsProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermLegalProceedingsProvision');
  DECLARE @CurrentRefundsProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentRefundsProvision');
  DECLARE @ShorttermOnerousContractsProvision INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermOnerousContractsProvision');
  DECLARE @ShorttermProvisionForDecommissioningRestorationAndRehabilitationCosts INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermProvisionForDecommissioningRestorationAndRehabilitationCosts');
  DECLARE @ShorttermMiscellaneousOtherProvisions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermMiscellaneousOtherProvisions');
  DECLARE @TradeAndOtherCurrentPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TradeAndOtherCurrentPayables');
  DECLARE @TradeAndOtherCurrentPayablesToTradeSuppliers INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TradeAndOtherCurrentPayablesToTradeSuppliers');
  DECLARE @TradeAndOtherCurrentPayablesToRelatedParties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TradeAndOtherCurrentPayablesToRelatedParties');
  DECLARE @AccrualsAndDeferredIncomeClassifiedAsCurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'AccrualsAndDeferredIncomeClassifiedAsCurrent');
  DECLARE @DeferredIncomeClassifiedAsCurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DeferredIncomeClassifiedAsCurrent');
  DECLARE @RentDeferredIncomeClassifiedAsCurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RentDeferredIncomeClassifiedAsCurrent');
  DECLARE @AccrualsClassifiedAsCurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'AccrualsClassifiedAsCurrent');
  DECLARE @ShorttermEmployeeBenefitsAccruals INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermEmployeeBenefitsAccruals');
  DECLARE @CurrentAdvancesFromCustomersExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentAdvancesFromCustomersExtension');
  DECLARE @CurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTax');
  DECLARE @CurrentValueAddedTaxPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentValueAddedTaxPayables');
  DECLARE @CurrentExciseTaxPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentExciseTaxPayables');
  DECLARE @OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension');
  DECLARE @CurrentRetentionPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentRetentionPayables');
  DECLARE @OtherCurrentPayables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherCurrentPayables');
  DECLARE @CurrentTaxLiabilitiesCurrent INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentTaxLiabilitiesCurrent');
  DECLARE @OtherCurrentFinancialLiabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherCurrentFinancialLiabilities');
  DECLARE @CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossAbstract INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossAbstract');
  DECLARE @CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossClassifiedAsHeldForTrading');
  DECLARE @CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialLiabilitiesAtFairValueThroughProfitOrLossDesignatedUponInitialRecognition');
  DECLARE @CurrentFinancialLiabilitiesAtAmortisedCost INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CurrentFinancialLiabilitiesAtAmortisedCost');
  DECLARE @OtherCurrentNonfinancialLiabilities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherCurrentNonfinancialLiabilities');
  DECLARE @LiabilitiesIncludedInDisposalGroupsClassifiedAsHeldForSale INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LiabilitiesIncludedInDisposalGroupsClassifiedAsHeldForSale');
  
  DECLARE @IncomeStatementAbstract INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'IncomeStatementAbstract');
  DECLARE @ProfitLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ProfitLoss');
  DECLARE @ProfitLossFromContinuingOperations INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ProfitLossFromContinuingOperations');
  DECLARE @ProfitLossBeforeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ProfitLossBeforeTax');
  DECLARE @ProfitLossFromOperatingActivities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ProfitLossFromOperatingActivities');
  DECLARE @Revenue INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'Revenue');
  DECLARE @RevenueFromSaleOfGoods INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromSaleOfGoods');
  DECLARE @RevenueFromSaleOfCopper INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromSaleOfCopper');
  DECLARE @RevenueFromSaleOfGold INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromSaleOfGold');
  DECLARE @RevenueFromSaleOfSilver INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromSaleOfSilver');
  DECLARE @RevenueFromSaleOfOilAndGasProducts INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromSaleOfOilAndGasProducts');
  DECLARE @RevenueFromSaleOfCrudeOil INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromSaleOfCrudeOil');
  DECLARE @RevenueFromSaleOfAgriculturalProduce INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromSaleOfAgriculturalProduce');
  DECLARE @RevenueFromSaleOfFoodAndBeverage INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromSaleOfFoodAndBeverage');
  DECLARE @RevenueFromRenderingOfServices INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRenderingOfServices');
  DECLARE @RevenueFromRenderingOfTelecommunicationServices INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRenderingOfTelecommunicationServices');
  DECLARE @RevenueFromRenderingOfTransportServices INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRenderingOfTransportServices');
  DECLARE @RevenueFromRenderingOfInformationTechnologyServices INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRenderingOfInformationTechnologyServices');
  DECLARE @RevenueFromRenderingOfInformationTechnologyMaintenanceAndSupportServices INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRenderingOfInformationTechnologyMaintenanceAndSupportServices');
  DECLARE @RevenueFromRenderingOfInformationTechnologyConsultingServices INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRenderingOfInformationTechnologyConsultingServices');
  DECLARE @RevenueFromHotelOperations INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromHotelOperations');
  DECLARE @RevenueFromRoomOccupancyServices INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRoomOccupancyServices');
  DECLARE @RevenueFromRenderingOfOtherPointOfTimeServicesExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRenderingOfOtherPointOfTimeServicesExtension');
  DECLARE @RevenueFromRenderingOfOtherPeriodOfTimeServicesExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRenderingOfOtherPeriodOfTimeServicesExtension');
  DECLARE @RevenueFromConstructionContracts INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromConstructionContracts');
  DECLARE @RevenueFromRoyalties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromRoyalties');
  DECLARE @LicenceFeeIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LicenceFeeIncome');
  DECLARE @FranchiseFeeIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'FranchiseFeeIncome');
  DECLARE @RevenueFromInterest INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromInterest');
  DECLARE @RevenueFromDividends INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RevenueFromDividends');
  DECLARE @OtherRevenue INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherRevenue');
  DECLARE @OtherIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherIncome');
  DECLARE @ChangesInInventoriesOfFinishedGoodsAndWorkInProgress INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ChangesInInventoriesOfFinishedGoodsAndWorkInProgress');
  DECLARE @OtherWorkPerformedByEntityAndCapitalised INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherWorkPerformedByEntityAndCapitalised');
  DECLARE @ExpenseByNature INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ExpenseByNature');
  DECLARE @RawMaterialsAndConsumablesUsed INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RawMaterialsAndConsumablesUsed');
  DECLARE @FuelExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'FuelExpense');
  DECLARE @CostOfMerchandiseSold INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CostOfMerchandiseSold');
  DECLARE @ServicesExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ServicesExpense');
  DECLARE @InsuranceExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'InsuranceExpense');
  DECLARE @ProfessionalFeesExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ProfessionalFeesExpense');
  DECLARE @RepairsAndMaintenanceExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RepairsAndMaintenanceExpense');
  DECLARE @TransportationExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TransportationExpense');
  DECLARE @BankAndSimilarCharges INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'BankAndSimilarCharges');
  DECLARE @TravelExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TravelExpense');
  DECLARE @CommunicationExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CommunicationExpense');
  DECLARE @UtilitiesExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'UtilitiesExpense');
  DECLARE @AdvertisingExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'AdvertisingExpense');
  DECLARE @RentalExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'RentalExpense');
  DECLARE @EmployeeBenefitsExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'EmployeeBenefitsExpense');
  DECLARE @ShorttermEmployeeBenefitsExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShorttermEmployeeBenefitsExpense');
  DECLARE @WagesAndSalaries INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'WagesAndSalaries');
  DECLARE @SocialSecurityContributions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'SocialSecurityContributions');
  DECLARE @OtherShorttermEmployeeBenefits INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherShorttermEmployeeBenefits');
  DECLARE @PostemploymentBenefitExpenseDefinedContributionPlans INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PostemploymentBenefitExpenseDefinedContributionPlans');
  DECLARE @PostemploymentBenefitExpenseDefinedBenefitPlans INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PostemploymentBenefitExpenseDefinedBenefitPlans');
  DECLARE @TerminationBenefitsExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TerminationBenefitsExpense');
  DECLARE @OtherLongtermBenefits INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherLongtermBenefits');
  DECLARE @OtherEmployeeExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherEmployeeExpense');
  DECLARE @IndirectLaborCostControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'IndirectLaborCostControlExtension');
  DECLARE @DepreciationAmortisationAndImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DepreciationAmortisationAndImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLoss');
  DECLARE @DepreciationAndAmortisationExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DepreciationAndAmortisationExpense');
  DECLARE @DepreciationExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DepreciationExpense');
  DECLARE @AmortisationExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'AmortisationExpense');
  DECLARE @ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLoss');
  DECLARE @WritedownsReversalsOfInventories INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'WritedownsReversalsOfInventories');
  DECLARE @WritedownsReversalsOfPropertyPlantAndEquipment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'WritedownsReversalsOfPropertyPlantAndEquipment');
  DECLARE @ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLossTradeReceivables INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLossTradeReceivables');
  DECLARE @ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLossLoansAndAdvances INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ImpairmentLossReversalOfImpairmentLossRecognisedInProfitOrLossLoansAndAdvances');
  DECLARE @IndirectMachineCostControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'IndirectMachineCostControlExtension');
  DECLARE @TaxExpenseOtherThanIncomeTaxExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'TaxExpenseOtherThanIncomeTaxExpense');
  DECLARE @OtherExpenseByNature INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherExpenseByNature');
  DECLARE @ExpenseOfRestructuringActivities INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ExpenseOfRestructuringActivities');
  DECLARE @DonationsAndSubsidiesExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DonationsAndSubsidiesExpense');
  DECLARE @DirectorsRemunerationExpense INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'DirectorsRemunerationExpense');
  DECLARE @ReallocatedExpensesExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReallocatedExpensesExtension');
  DECLARE @OtherGainsLosses INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherGainsLosses');
  DECLARE @GainsLossesOnDisposalsOfPropertyPlantAndEquipment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsLossesOnDisposalsOfPropertyPlantAndEquipment');
  DECLARE @GainsOnDisposalsOfPropertyPlantAndEquipment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsOnDisposalsOfPropertyPlantAndEquipment');
  DECLARE @LossesOnDisposalsOfPropertyPlantAndEquipment INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LossesOnDisposalsOfPropertyPlantAndEquipment');
  DECLARE @GainsLossesOnDisposalsOfInvestmentProperties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsLossesOnDisposalsOfInvestmentProperties');
  DECLARE @GainsOnDisposalsOfInvestmentProperties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsOnDisposalsOfInvestmentProperties');
  DECLARE @LossesOnDisposalsOfInvestmentProperties INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LossesOnDisposalsOfInvestmentProperties');
  DECLARE @GainsLossesOnDisposalsOfInvestments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsLossesOnDisposalsOfInvestments');
  DECLARE @GainsOnDisposalsOfInvestments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsOnDisposalsOfInvestments');
  DECLARE @LossesOnDisposalsOfInvestments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'LossesOnDisposalsOfInvestments');
  DECLARE @GainsLossesOnExchangeDifferencesOnTranslationRecognisedInProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsLossesOnExchangeDifferencesOnTranslationRecognisedInProfitOrLoss');
  DECLARE @NetForeignExchangeGain INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NetForeignExchangeGain');
  DECLARE @NetForeignExchangeLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'NetForeignExchangeLoss');
  DECLARE @GainsLossesOnNetMonetaryPosition INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsLossesOnNetMonetaryPosition');
  DECLARE @GainLossArisingFromDerecognitionOfFinancialAssetsMeasuredAtAmortisedCost INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainLossArisingFromDerecognitionOfFinancialAssetsMeasuredAtAmortisedCost');
  DECLARE @FinanceIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'FinanceIncome');
  DECLARE @FinanceCosts INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'FinanceCosts');
  DECLARE @ImpairmentLossImpairmentGainAndReversalOfImpairmentLossDeterminedInAccordanceWithIFRS9 INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ImpairmentLossImpairmentGainAndReversalOfImpairmentLossDeterminedInAccordanceWithIFRS9');
  DECLARE @ShareOfProfitLossOfAssociatesAndJointVenturesAccountedForUsingEquityMethod INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShareOfProfitLossOfAssociatesAndJointVenturesAccountedForUsingEquityMethod');
  DECLARE @OtherIncomeExpenseFromSubsidiariesJointlyControlledEntitiesAndAssociates INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherIncomeExpenseFromSubsidiariesJointlyControlledEntitiesAndAssociates');
  DECLARE @GainsLossesArisingFromDifferenceBetweenPreviousCarryingAmountAndFairValueOfFinancialAssetsReclassifiedAsMeasuredAtFairValue INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsLossesArisingFromDifferenceBetweenPreviousCarryingAmountAndFairValueOfFinancialAssetsReclassifiedAsMeasuredAtFairValue');
  DECLARE @CumulativeGainLossPreviouslyRecognisedInOtherComprehensiveIncomeArisingFromReclassificationOfFinancialAssetsOutOfFairValueThrou INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CumulativeGainLossPreviouslyRecognisedInOtherComprehensiveIncomeArisingFromReclassificationOfFinancialAssetsOutOfFairValueThroughOtherComprehensiveIncomeIntoFairValueThroughProfitOrLossMeasurementCategory');
  DECLARE @HedgingGainsLossesForHedgeOfGroupOfItemsWithOffsettingRiskPositions INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'HedgingGainsLossesForHedgeOfGroupOfItemsWithOffsettingRiskPositions');
  DECLARE @IncomeTaxExpenseContinuingOperations INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'IncomeTaxExpenseContinuingOperations');
  DECLARE @ProfitLossFromDiscontinuedOperations INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ProfitLossFromDiscontinuedOperations');
  DECLARE @OtherComprehensiveIncome INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncome');
  DECLARE @ComponentsOfOtherComprehensiveIncomeThatWillNotBeReclassifiedToProfitOrLossBeforeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ComponentsOfOtherComprehensiveIncomeThatWillNotBeReclassifiedToProfitOrLossBeforeTax');
  DECLARE @OtherComprehensiveIncomeBeforeTaxGainsLossesFromInvestmentsInEquityInstruments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncomeBeforeTaxGainsLossesFromInvestmentsInEquityInstruments');
  DECLARE @OtherComprehensiveIncomeBeforeTaxGainsLossesOnRevaluation INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncomeBeforeTaxGainsLossesOnRevaluation');
  DECLARE @OtherComprehensiveIncomeBeforeTaxGainsLossesOnRemeasurementsOfDefinedBenefitPlans INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncomeBeforeTaxGainsLossesOnRemeasurementsOfDefinedBenefitPlans');
  DECLARE @OtherComprehensiveIncomeBeforeTaxChangeInFairValueOfFinancialLiabilityAttributableToChangeInCreditRiskOfLiability INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncomeBeforeTaxChangeInFairValueOfFinancialLiabilityAttributableToChangeInCreditRiskOfLiability');
  DECLARE @OtherComprehensiveIncomeBeforeTaxGainsLossesOnHedgingInstrumentsThatHedgeInvestmentsInEquityInstruments INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncomeBeforeTaxGainsLossesOnHedgingInstrumentsThatHedgeInvestmentsInEquityInstruments');
  DECLARE @OtherComprehensiveIncomeBeforeTaxInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillNotB INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncomeBeforeTaxInsuranceFinanceIncomeExpensesFromInsuranceContractsIssuedExcludedFromProfitOrLossThatWillNotBeReclassifiedToProfitOrLoss');
  DECLARE @ShareOfOtherComprehensiveIncomeOfAssociatesAndJointVenturesAccountedForUsingEquityMethodThatWillNotBeReclassifiedToProfitOrLoss INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ShareOfOtherComprehensiveIncomeOfAssociatesAndJointVenturesAccountedForUsingEquityMethodThatWillNotBeReclassifiedToProfitOrLossBeforeTax');
  DECLARE @ComponentsOfOtherComprehensiveIncomeThatWillBeReclassifiedToProfitOrLossBeforeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ComponentsOfOtherComprehensiveIncomeThatWillBeReclassifiedToProfitOrLossBeforeTax');
  DECLARE @OtherComprehensiveIncomeBeforeTaxExchangeDifferencesOnTranslation INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncomeBeforeTaxExchangeDifferencesOnTranslation');
  DECLARE @GainsLossesOnExchangeDifferencesOnTranslationBeforeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsLossesOnExchangeDifferencesOnTranslationBeforeTax');
  DECLARE @ReclassificationAdjustmentsOnExchangeDifferencesOnTranslationBeforeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReclassificationAdjustmentsOnExchangeDifferencesOnTranslationBeforeTax');
  DECLARE @OtherComprehensiveIncomeBeforeTaxAvailableforsaleFinancialAssets INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherComprehensiveIncomeBeforeTaxAvailableforsaleFinancialAssets');
  DECLARE @GainsLossesOnRemeasuringAvailableforsaleFinancialAssetsBeforeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GainsLossesOnRemeasuringAvailableforsaleFinancialAssetsBeforeTax');
  DECLARE @ReclassificationAdjustmentsOnAvailableforsaleFinancialAssetsBeforeTax INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ReclassificationAdjustmentsOnAvailableforsaleFinancialAssetsBeforeTax');
  DECLARE @ControlAccountsExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ControlAccountsExtension');
  DECLARE @PerformanceObligationsControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PerformanceObligationsControlExtension');
  DECLARE @PerformanceObligationsAtAPointInTimeControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PerformanceObligationsAtAPointInTimeControlExtension');
  DECLARE @SupplierPerformanceObligationsAtAPointInTimeControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'SupplierPerformanceObligationsAtAPointInTimeControlExtension');
  DECLARE @CustomerPerformanceObligationsAtAPointInTimeControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CustomerPerformanceObligationsAtAPointInTimeControlExtension');
  DECLARE @PerformanceObligationsOverAPeriodOfTimeControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PerformanceObligationsOverAPeriodOfTimeControlExtension');
  DECLARE @SupplierPerformanceObligationsOverAPeriodOfTimeControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'SupplierPerformanceObligationsOverAPeriodOfTimeControlExtension');
  DECLARE @CustomerPerformanceObligationsOverAPeriodOfTimeControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CustomerPerformanceObligationsOverAPeriodOfTimeControlExtension');
  DECLARE @EmployeePerformanceObligationsOverAPeriodOfTimeControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'EmployeePerformanceObligationsOverAPeriodOfTimeControlExtension');
  DECLARE @OthersAccountsControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OthersAccountsControlExtension');
  DECLARE @PaymentControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PaymentControlExtension');
  DECLARE @SupplierPaymentControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'SupplierPaymentControlExtension');
  DECLARE @EmployeePaymentControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'EmployeePaymentControlExtension');
  DECLARE @CustomerPaymentControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CustomerPaymentControlExtension');
  DECLARE @OtherPaymentControlExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'OtherPaymentControlExtension');
  DECLARE @StatisticalAccountsExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'StatisticalAccountsExtension');
  DECLARE @GuaranteesExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'GuaranteesExtension');
  DECLARE @PayrollExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'PayrollExtension');
  DECLARE @HRExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'HRExtension');
  DECLARE @CRMExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'CRMExtension');
  DECLARE @ProductionExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'ProductionExtension');
  DECLARE @MigrationAccountsExtension INT = (SELECT [Id] FROM dbo.AccountTypes WHERE [Concept] = N'MigrationAccountsExtension');
  END
  
  DELETE FROM @AccountTypes
  INSERT INTO @AccountTypes(
  	[Index], [ParentIndex], [Id], [ParentId],
  	[Code],
  	[Concept],
  	[Name], [Name2], [Name3],
  	[Description], [Description2], [Description3], 
  	[IsMonetary],
  	[IsAssignable],
  	[StandardAndPure],
  	[EntryTypeParentId],
  	[Time1Label], [Time1Label2], [Time1Label3],
  	[Time2Label], [Time2Label2], [Time2Label3],
  	[ExternalReferenceLabel], [ExternalReferenceLabel2], [ExternalReferenceLabel3], 
  	[InternalReferenceLabel], [InternalReferenceLabel2], [InternalReferenceLabel3],
  	[NotedAgentNameLabel], [NotedAgentNameLabel2], [NotedAgentNameLabel3],
  	[NotedAmountLabel], [NotedAmountLabel2], [NotedAmountLabel3],
  	[NotedDateLabel], [NotedDateLabel2], [NotedDateLabel3]
  )
  SELECT
  	[Id], [ParentId], [Id], [ParentId],
  	[Code],
  	[Concept],
  	[Name], [Name2], [Name3],
  	[Description], [Description2], [Description3], 
  	[IsMonetary],
  	[IsAssignable],
  	[StandardAndPure],
  	[EntryTypeParentId],
  	[Time1Label], [Time1Label2], [Time1Label3],
  	[Time2Label], [Time2Label2], [Time2Label3],
  	[ExternalReferenceLabel], [ExternalReferenceLabel2], [ExternalReferenceLabel3], 
  	[InternalReferenceLabel], [InternalReferenceLabel2], [InternalReferenceLabel3],
  	[NotedAgentNameLabel], [NotedAgentNameLabel2], [NotedAgentNameLabel3],
  	[NotedAmountLabel], [NotedAmountLabel2], [NotedAmountLabel3],
  	[NotedDateLabel], [NotedDateLabel2], [NotedDateLabel3]
  FROM dbo.AccountTypes
  
  INSERT INTO @AccountTypeAgentDefinitions([Index],
  [HeaderIndex],											[AgentDefinitionId]) VALUES
  (5,@Land,@LandMemberAD),
  (10,@Buildings,@BuildingsMemberAD),
  (15,@Machinery,@MachineryMemberAD),
  (20,@Ships,@ShipsMemberAD),
  (25,@Aircraft,@AircraftMemberAD),
  (30,@MotorVehicles,@MotorVehiclesMemberAD),
  (35,@FixturesAndFittings,@FixturesAndFittingsMemberAD),
  (36,@FixturesAndFittings,@NetworkInfrastructureMemberAD),
  (37,@FixturesAndFittings,@LeaseholdImprovementsMemberAD),
  (40,@OfficeEquipment,@OfficeEquipmentMemberAD),
  (41,@OfficeEquipment,@ComputerEquipmentMemberAD),
  (42,@OfficeEquipment,@CommunicationAndNetworkEquipmentMemberAD),
  (45,@BearerPlants,@BearerPlantsMemberAD),
  (50,@TangibleExplorationAndEvaluationAssets,@TangibleExplorationAndEvaluationAssetsMemberAD),
  (55,@MiningAssets,@MiningAssetsMemberAD),
  (60,@OilAndGasAssets,@OilAndGasAssetsMemberAD),
  (65,@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModel,@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModelMemberAD),
  (70,@OtherPropertyPlantAndEquipment,@OtherPropertyPlantAndEquipmentMemberAD),
  --(75,@IntangibleAssetsOtherThanGoodwill,@IntangibleAssetsOtherThanGoodwillMemberAD),
  (75, @InvestmentPropertyCompleted, @InvestmentPropertyCompletedMemberAD),
  (76, @InvestmentPropertyUnderConstructionOrDevelopment, @InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  (80,@BrandNames,@BrandNamesMemberAD),
  (85,@IntangibleExplorationAndEvaluationAssets,@IntangibleExplorationAndEvaluationAssetsMemberAD),
  (90,@MastheadsAndPublishingTitles,@MastheadsAndPublishingTitlesMemberAD),
  (95,@ComputerSoftware,@ComputerSoftwareMemberAD),
  (100,@LicencesAndFranchises,@GSMLicencesMemberAD),
  (101,@LicencesAndFranchises,@UMTSLicencesMemberAD),
  (102,@LicencesAndFranchises,@LTELicencesMemberAD),
  (103,@LicencesAndFranchises,@GamingLicencesMemberAD),
  (104,@LicencesAndFranchises,@FranchisesMemberAD),
  (105,@CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights,@AirportLandingRightsMemberAD),
  (106,@CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights,@MiningRightsMemberAD),
  (107,@CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights,@BroadcastingRightsMemberAD),
  (108,@CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights,@ServiceConcessionRightsMemberAD),
  (110,@RecipesFormulaeModelsDesignsAndPrototypes,@RecipesFormulaeModelsDesignsAndPrototypesMemberAD),
  (115,@IntangibleAssetsUnderDevelopment,@IntangibleAssetsUnderDevelopmentMemberAD),
  (120,@OtherIntangibleAssets,@OtherIntangibleAssetsMemberAD),
  (125,@NoncurrentTradeReceivables,@CustomerAD),
  (126,@NoncurrentTradeReceivables,@SalesOrderAD),
  (130,@NoncurrentReceivablesDueFromRelatedParties,@CustomerAD),
  (131,@NoncurrentReceivablesDueFromRelatedParties,@SalesOrderAD),
  (132,@NoncurrentReceivablesDueFromRelatedParties,@RentalCustomerAD),
  (135,@NoncurrentPrepayments,@SupplierAD),
  (136,@NoncurrentPrepayments,@PurchaseOrderAD),
  (140,@NoncurrentAccruedIncome,@CustomerAD),
  (141,@NoncurrentAccruedIncome,@SalesOrderAD),
  (145,@NoncurrentReceivablesFromTaxesOtherThanIncomeTax,@TaxDepartmentAD),
  (150,@NoncurrentValueAddedTaxReceivables,@TaxDepartmentAD),
  (155,@NoncurrentReceivablesFromSaleOfProperties,@CustomerAD),
  (156,@NoncurrentReceivablesFromSaleOfProperties,@SalesOrderAD),
  (160,@NoncurrentReceivablesFromRentalOfProperties,@CustomerAD),
  (161,@NoncurrentReceivablesFromRentalOfProperties,@RentalCustomerAD),
  (165,@Merchandise,@WarehouseAD),
  (166,@Merchandise,@AisleBinShelfAD),
  (170,@CurrentFoodAndBeverage,@WarehouseAD),
  (171,@CurrentFoodAndBeverage,@AisleBinShelfAD),
  (175,@CurrentAgriculturalProduce,@WarehouseAD),
  (176,@CurrentAgriculturalProduce,@AisleBinShelfAD),
  (180,@FinishedGoods,@WarehouseAD),
  (181,@FinishedGoods,@AisleBinShelfAD),
  (185,@WorkInProgress,@ProductionOrderAD),
  (186,@WorkInProgress,@AisleBinShelfAD),
  (190,@RawMaterials,@WarehouseAD),
  (191,@RawMaterials,@AisleBinShelfAD),
  (195,@ProductionSupplies,@WarehouseAD),
  (196,@ProductionSupplies,@AisleBinShelfAD),
  (200,@CurrentPackagingAndStorageMaterials,@WarehouseAD),
  (201,@CurrentPackagingAndStorageMaterials,@AisleBinShelfAD),
  (205,@SpareParts,@WarehouseAD),
  (206,@SpareParts,@AisleBinShelfAD),
  (210,@CurrentFuel,@WarehouseAD),
  (211,@CurrentFuel,@AisleBinShelfAD),
  (215,@CurrentInventoriesInTransit,@IncomingShipmentAD),
  (220,@OtherInventories,@WarehouseAD),
  (221,@OtherInventories,@AisleBinShelfAD),
  (225,@CurrentTradeReceivables,@CustomerAD),
  (226,@CurrentTradeReceivables,@SalesOrderAD),
  (230,@TradeAndOtherCurrentReceivablesDueFromRelatedParties,@CustomerAD),
  (231,@TradeAndOtherCurrentReceivablesDueFromRelatedParties,@SalesOrderAD),
  (232,@TradeAndOtherCurrentReceivablesDueFromRelatedParties,@SupplierAD),
  (233,@TradeAndOtherCurrentReceivablesDueFromRelatedParties,@PurchaseOrderAD),
  (235,@CurrentAdvancesToSuppliers,@SupplierAD),
  (236,@CurrentAdvancesToSuppliers,@PurchaseOrderAD),
  (240,@CurrentPrepaidExpenses,@SupplierAD),
  (241,@CurrentPrepaidExpenses,@PurchaseOrderAD),
  (265,@CurrentAccruedIncome,@CustomerAD),
  (266,@CurrentAccruedIncome,@SalesOrderAD),
  (270,@CurrentBilledNotReceivedFromSuppliersExtension,@SupplierAD),
  (271,@CurrentBilledNotReceivedFromSuppliersExtension,@PurchaseOrderAD),
  (280,@CurrentValueAddedTaxReceivables,@TaxDepartmentAD),
  (285,@CurrentReceivablesFromRentalOfProperties,@CustomerAD),
  (286,@CurrentReceivablesFromRentalOfProperties,@RentalCustomerAD),
  --(287,@CurrentReceivablesFromRentalOfProperties,@RentalContractAD),
  (290,@CurrentTaxAssetsCurrent,@TaxDepartmentAD),
  (295,@CurrentBiologicalAssets,@FarmAD),
  (300,@CurrentLoansAndReceivables,@EmployeeAD),
  (301,@CurrentLoansAndReceivables,@EmployeeLoanAD),
  (310,@CashOnHand,@CashOnHandAccountAD),
  (311,@CashOnHand,@EmployeeAD),
  (315,@BalancesWithBanks,@BankAccountAD),
  (316,@BalancesWithBanks,@BankAD),
  -- Provision estimate is probabilistic, no point specifying the customer
  --(318,@LongtermWarrantyProvision,@CustomerAD),
  --(319,@LongtermWarrantyProvision,@SalesOrderAD),
  (320,@NoncurrentPayablesToTradeSuppliers,@SupplierAD),
  (321,@NoncurrentPayablesToTradeSuppliers,@PurchaseOrderAD),
  (325,@NoncurrentPayablesToRelatedParties,@SupplierAD),
  (326,@NoncurrentPayablesToRelatedParties,@PurchaseOrderAD),
  (330,@DeferredIncomeClassifiedAsNoncurrent,@CustomerAD),
  (331,@DeferredIncomeClassifiedAsNoncurrent,@SalesOrderAD),
  (335,@RentDeferredIncomeClassifiedAsNoncurrent,@CustomerAD),
  (336,@RentDeferredIncomeClassifiedAsNoncurrent,@RentalCustomerAD),
  (340,@AccrualsClassifiedAsNoncurrent,@SupplierAD),
  (341,@AccrualsClassifiedAsNoncurrent,@PurchaseOrderAD),
  (345,@NoncurrentValueAddedTaxPayables,@TaxDepartmentAD),
  (346,@NoncurrentExciseTaxPayables,@TaxDepartmentAD),
  (350,@NoncurrentRetentionPayables,@SupplierAD),
  (351,@NoncurrentRetentionPayables,@PurchaseOrderAD),
  (353,@NoncurrentFinancialLiabilitiesAtAmortisedCost, @CreditorAD),
  --(355,@ShorttermWarrantyProvision,@CustomerAD),
  --(356,@ShorttermWarrantyProvision,@SalesOrderAD),
  (360,@TradeAndOtherCurrentPayablesToTradeSuppliers,@SupplierAD),
  (361,@TradeAndOtherCurrentPayablesToTradeSuppliers,@PurchaseOrderAD),
  (365,@TradeAndOtherCurrentPayablesToRelatedParties,@SupplierAD),
  (366,@TradeAndOtherCurrentPayablesToRelatedParties,@PurchaseOrderAD),
  (370,@DeferredIncomeClassifiedAsCurrent,@CustomerAD),
  (371,@DeferredIncomeClassifiedAsCurrent,@SalesOrderAD),
  (375,@RentDeferredIncomeClassifiedAsCurrent,@CustomerAD),
  (376,@RentDeferredIncomeClassifiedAsCurrent,@RentalCustomerAD),
  (380,@AccrualsClassifiedAsCurrent, @SupplierAD),
  (381,@AccrualsClassifiedAsCurrent, @PurchaseOrderAD),
  (385,@ShorttermEmployeeBenefitsAccruals,@EmployeeAD),
  (390,@CurrentAdvancesFromCustomersExtension,@CustomerAD),
  (395,@CurrentValueAddedTaxPayables,@TaxDepartmentAD),	
  (400,@CurrentExciseTaxPayables,@TaxDepartmentAD),
  (405,@OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension,@TaxDepartmentAD),
  (445,@CurrentRetentionPayables,@SupplierAD),
  (446,@CurrentRetentionPayables,@PurchaseOrderAD),
  (450,@OtherCurrentPayables,@SupplierAD),
  (451,@OtherCurrentPayables,@EmployeeAD),
  (452,@OtherCurrentPayables,@CustomerAD),
  (453,@CurrentFinancialLiabilitiesAtAmortisedCost, @CreditorAD),
  (455,@CurrentTaxLiabilitiesCurrent,@TaxDepartmentAD), -- Business Profit Tax
  --(460,@RevenueFromSaleOfGoods,@CustomerAD),
  --(461,@RevenueFromSaleOfGoods,@SalesOrderAD),
  --(463,@RevenueFromSaleOfCopper,@CustomerAD),
  --(464,@RevenueFromSaleOfCopper,@SalesOrderAD),
  --(467,@RevenueFromSaleOfGold,@CustomerAD),
  --(468,@RevenueFromSaleOfGold,@SalesOrderAD),
  --(471,@RevenueFromSaleOfSilver,@CustomerAD),
  --(472,@RevenueFromSaleOfSilver,@SalesOrderAD),
  --(475,@RevenueFromSaleOfOilAndGasProducts,@CustomerAD),
  --(476,@RevenueFromSaleOfOilAndGasProducts,@SalesOrderAD),
  --(479,@RevenueFromSaleOfCrudeOil,@CustomerAD),
  --(480,@RevenueFromSaleOfCrudeOil,@SalesOrderAD),
  --(483,@RevenueFromSaleOfAgriculturalProduce,@CustomerAD),
  --(484,@RevenueFromSaleOfAgriculturalProduce,@SalesOrderAD),
  --(487,@RevenueFromSaleOfFoodAndBeverage,@CustomerAD),
  --(488,@RevenueFromSaleOfFoodAndBeverage,@SalesOrderAD),
  --(491,@RevenueFromRenderingOfServices,@CustomerAD),
  --(492,@RevenueFromRenderingOfServices,@SalesOrderAD),
  --(495,@RevenueFromRenderingOfTelecommunicationServices,@CustomerAD),
  --(496,@RevenueFromRenderingOfTelecommunicationServices,@SalesOrderAD),
  --(499,@RevenueFromRenderingOfTransportServices,@CustomerAD),
  --(500,@RevenueFromRenderingOfTransportServices,@SalesOrderAD),
  --(503,@RevenueFromRenderingOfInformationTechnologyMaintenanceAndSupportServices,@CustomerAD),
  --(504,@RevenueFromRenderingOfInformationTechnologyMaintenanceAndSupportServices,@SalesOrderAD),
  --(507,@RevenueFromRenderingOfInformationTechnologyConsultingServices,@CustomerAD),
  --(508,@RevenueFromRenderingOfInformationTechnologyConsultingServices,@SalesOrderAD),
  --(511,@RevenueFromHotelOperations,@CustomerAD),
  --(512,@RevenueFromHotelOperations,@SalesOrderAD),
  --(515,@RevenueFromRoomOccupancyServices,@CustomerAD),
  --(516,@RevenueFromRoomOccupancyServices,@SalesOrderAD),
  --(519,@RevenueFromRenderingOfOtherPointOfTimeServicesExtension,@CustomerAD),
  --(520,@RevenueFromRenderingOfOtherPointOfTimeServicesExtension,@SalesOrderAD),
  --(523,@RevenueFromRenderingOfOtherPeriodOfTimeServicesExtension,@CustomerAD),
  --(524,@RevenueFromRenderingOfOtherPeriodOfTimeServicesExtension,@SalesOrderAD),
  --(527,@RevenueFromConstructionContracts,@CustomerAD),
  --(528,@RevenueFromConstructionContracts,@SalesOrderAD),
  --(537,@OtherRevenue,@CustomerAD),
  --(538,@OtherRevenue,@SalesOrderAD),
  
  (540,@RawMaterialsAndConsumablesUsed,@LandMemberAD),
  (541,@RawMaterialsAndConsumablesUsed,@BuildingsMemberAD),
  (542,@RawMaterialsAndConsumablesUsed,@MachineryMemberAD),
  (543,@RawMaterialsAndConsumablesUsed,@PowerGeneratingAssetsMemberAD),
  (544,@RawMaterialsAndConsumablesUsed,@ShipsMemberAD),
  (545,@RawMaterialsAndConsumablesUsed,@AircraftMemberAD),
  (546,@RawMaterialsAndConsumablesUsed,@MotorVehiclesMemberAD),
  (547,@RawMaterialsAndConsumablesUsed,@FixturesAndFittingsMemberAD),
  (548,@RawMaterialsAndConsumablesUsed,@NetworkInfrastructureMemberAD),
  (549,@RawMaterialsAndConsumablesUsed,@LeaseholdImprovementsMemberAD),
  (550,@RawMaterialsAndConsumablesUsed,@OfficeEquipmentMemberAD),
  (551,@RawMaterialsAndConsumablesUsed,@ComputerEquipmentMemberAD),
  (552,@RawMaterialsAndConsumablesUsed,@CommunicationAndNetworkEquipmentMemberAD),
  (553,@RawMaterialsAndConsumablesUsed,@BearerPlantsMemberAD),
  (554,@RawMaterialsAndConsumablesUsed,@TangibleExplorationAndEvaluationAssetsMemberAD),
  (555,@RawMaterialsAndConsumablesUsed,@MiningAssetsMemberAD),
  (556,@RawMaterialsAndConsumablesUsed,@OilAndGasAssetsMemberAD),
  (557,@RawMaterialsAndConsumablesUsed,@ConstructionInProgressMemberAD),
  (558,@RawMaterialsAndConsumablesUsed,@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModelMemberAD),
  (559,@RawMaterialsAndConsumablesUsed,@OtherPropertyPlantAndEquipmentMemberAD),
  --
  (560,@RawMaterialsAndConsumablesUsed,@InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  (561,@RawMaterialsAndConsumablesUsed,@ProductionOrderAD),
  (562,@RawMaterialsAndConsumablesUsed,@IncomingShipmentAD),
  --
  (590,@FuelExpense,@BuildingsMemberAD),
  (591,@FuelExpense,@MachineryMemberAD),
  (592,@FuelExpense,@PowerGeneratingAssetsMemberAD),
  (593,@FuelExpense,@ShipsMemberAD),
  (594,@FuelExpense,@AircraftMemberAD),
  (595,@FuelExpense,@MotorVehiclesMemberAD),
  (596,@FuelExpense,@OfficeEquipmentMemberAD),
  (597,@FuelExpense,@TangibleExplorationAndEvaluationAssetsMemberAD),
  (598,@FuelExpense,@MiningAssetsMemberAD),
  (599,@FuelExpense,@ConstructionInProgressMemberAD),
  (600,@FuelExpense,@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModelMemberAD),
  (601,@FuelExpense,@MotorVehiclesMemberAD),
  --
  (605,@CostOfMerchandiseSold,@CustomerAD),
  (606,@CostOfMerchandiseSold,@SalesOrderAD),
  --
  (611,@InsuranceExpense,@BuildingsMemberAD),
  (616,@InsuranceExpense,@MotorVehiclesMemberAD),
  (630,@InsuranceExpense,@IncomingShipmentAD),
  
  (640,@ProfessionalFeesExpense,@LandMemberAD),
  (641,@ProfessionalFeesExpense,@BuildingsMemberAD),
  (642,@ProfessionalFeesExpense,@MachineryMemberAD),
  (643,@ProfessionalFeesExpense,@PowerGeneratingAssetsMemberAD),
  (644,@ProfessionalFeesExpense,@ShipsMemberAD),
  (645,@ProfessionalFeesExpense,@AircraftMemberAD),
  (646,@ProfessionalFeesExpense,@MotorVehiclesMemberAD),
  (647,@ProfessionalFeesExpense,@FixturesAndFittingsMemberAD),
  (648,@ProfessionalFeesExpense,@NetworkInfrastructureMemberAD),
  (649,@ProfessionalFeesExpense,@LeaseholdImprovementsMemberAD),
  (650,@ProfessionalFeesExpense,@OfficeEquipmentMemberAD),
  (651,@ProfessionalFeesExpense,@ComputerEquipmentMemberAD),
  (652,@ProfessionalFeesExpense,@CommunicationAndNetworkEquipmentMemberAD),
  (653,@ProfessionalFeesExpense,@BearerPlantsMemberAD),
  (654,@ProfessionalFeesExpense,@TangibleExplorationAndEvaluationAssetsMemberAD),
  (655,@ProfessionalFeesExpense,@MiningAssetsMemberAD),
  (656,@ProfessionalFeesExpense,@OilAndGasAssetsMemberAD),
  (657,@ProfessionalFeesExpense,@ConstructionInProgressMemberAD),
  (658,@ProfessionalFeesExpense,@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModelMemberAD),
  (659,@ProfessionalFeesExpense,@OtherPropertyPlantAndEquipmentMemberAD),
  --
  (760,@ProfessionalFeesExpense,@InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  (761,@ProfessionalFeesExpense,@ProductionOrderAD),
  (762,@ProfessionalFeesExpense,@IncomingShipmentAD),
  (763,@ProfessionalFeesExpense,@CustomerAD),
  (764,@ProfessionalFeesExpense,@SalesOrderAD),
  (765,@ProfessionalFeesExpense,@EmployeeAD),
  
  (840,@RepairsAndMaintenanceExpense,@LandMemberAD),
  (841,@RepairsAndMaintenanceExpense,@BuildingsMemberAD),
  (842,@RepairsAndMaintenanceExpense,@MachineryMemberAD),
  (843,@RepairsAndMaintenanceExpense,@PowerGeneratingAssetsMemberAD),
  (844,@RepairsAndMaintenanceExpense,@ShipsMemberAD),
  (845,@RepairsAndMaintenanceExpense,@AircraftMemberAD),
  (846,@RepairsAndMaintenanceExpense,@MotorVehiclesMemberAD),
  (847,@RepairsAndMaintenanceExpense,@FixturesAndFittingsMemberAD),
  (848,@RepairsAndMaintenanceExpense,@NetworkInfrastructureMemberAD),
  (849,@RepairsAndMaintenanceExpense,@LeaseholdImprovementsMemberAD),
  (850,@RepairsAndMaintenanceExpense,@OfficeEquipmentMemberAD),
  (851,@RepairsAndMaintenanceExpense,@ComputerEquipmentMemberAD),
  (852,@RepairsAndMaintenanceExpense,@CommunicationAndNetworkEquipmentMemberAD),
  (853,@RepairsAndMaintenanceExpense,@BearerPlantsMemberAD),
  (854,@RepairsAndMaintenanceExpense,@TangibleExplorationAndEvaluationAssetsMemberAD),
  (855,@RepairsAndMaintenanceExpense,@MiningAssetsMemberAD),
  (856,@RepairsAndMaintenanceExpense,@OilAndGasAssetsMemberAD),
  (857,@RepairsAndMaintenanceExpense,@ConstructionInProgressMemberAD),
  (858,@RepairsAndMaintenanceExpense,@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModelMemberAD),
  (859,@RepairsAndMaintenanceExpense,@OtherPropertyPlantAndEquipmentMemberAD),
  
  (860,@TransportationExpense,@InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  (861,@TransportationExpense,@ProductionOrderAD),
  (862,@TransportationExpense,@IncomingShipmentAD),
  (863,@TransportationExpense,@CustomerAD),
  (864,@TransportationExpense,@SalesOrderAD),
  (865,@TransportationExpense,@EmployeeAD),
  
  (962,@BankAndSimilarCharges,@IncomingShipmentAD),
  (963,@BankAndSimilarCharges,@CustomerAD),
  (964,@BankAndSimilarCharges,@SalesOrderAD),
  
  (1060,@TravelExpense,@InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  (1061,@TravelExpense,@ProductionOrderAD),
  (1062,@TravelExpense,@IncomingShipmentAD),
  (1063,@TravelExpense,@CustomerAD),
  (1064,@TravelExpense,@SalesOrderAD),
  (1065,@TravelExpense,@EmployeeAD),
  
  
  (1160,@CommunicationExpense,@InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  (1161,@CommunicationExpense,@ProductionOrderAD),
  (1162,@CommunicationExpense,@IncomingShipmentAD),
  (1163,@CommunicationExpense,@CustomerAD),
  (1164,@CommunicationExpense,@SalesOrderAD),
  (1165,@CommunicationExpense,@EmployeeAD),
  
  (1260,@UtilitiesExpense,@InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  (1261,@UtilitiesExpense,@ProductionOrderAD),
  --(1262,@UtilitiesExpense,@IncomingShipmentAD),
  --(1263,@UtilitiesExpense,@CustomerAD),
  --(1264,@UtilitiesExpense,@SalesOrderAD),
  (1265,@UtilitiesExpense,@EmployeeAD),
  
  (1360,@AdvertisingExpense,@InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  --(1361,@AdvertisingExpense,@ProductionOrderAD),
  --(1362,@AdvertisingExpense,@IncomingShipmentAD),
  (1363,@AdvertisingExpense,@CustomerAD),
  --(1364,@AdvertisingExpense,@SalesOrderAD),
  --(1365,@AdvertisingExpense,@EmployeeAD),
  
  (1460,@RentalExpense,@InvestmentPropertyUnderConstructionOrDevelopmentMemberAD),
  (1461,@RentalExpense,@ProductionOrderAD),
  (1462,@RentalExpense,@IncomingShipmentAD),
  (1463,@RentalExpense,@CustomerAD),
  (1464,@RentalExpense,@SalesOrderAD),
  (1465,@RentalExpense,@EmployeeAD),
  
  --EmployeeBenefitsExpense
  (1565,@WagesAndSalaries,								@EmployeeAD),
  (1570,@SocialSecurityContributions,						@EmployeeAD),
  (1575,@OtherShorttermEmployeeBenefits,					@EmployeeAD),
  (1580,@PostemploymentBenefitExpenseDefinedContributionPlans,
  														@EmployeeAD),
  (1585,@PostemploymentBenefitExpenseDefinedBenefitPlans,	@EmployeeAD),
  (1590,@TerminationBenefitsExpense,						@EmployeeAD),
  (1595,@OtherLongtermBenefits,							@EmployeeAD),
  (1600,@OtherEmployeeExpense,							@EmployeeAD),
  (1605,@IndirectLaborCostControlExtension,				@EmployeeAD),
  
  (1640,@DepreciationExpense,								@LandMemberAD),
  (1657,@DepreciationExpense,								@BuildingsMemberAD),
  (1658,@DepreciationExpense,								@MachineryMemberAD), 
  (1659,@DepreciationExpense,								@PowerGeneratingAssetsMemberAD),
  (1660,@DepreciationExpense,								@ShipsMemberAD),
  (1661,@DepreciationExpense,								@AircraftMemberAD),
  (1662,@DepreciationExpense,								@MotorVehiclesMemberAD),
  (1663,@DepreciationExpense,								@FixturesAndFittingsMemberAD),
  (1664,@DepreciationExpense,								@NetworkInfrastructureMemberAD),
  (1665,@DepreciationExpense,								@LeaseholdImprovementsMemberAD),
  (1666,@DepreciationExpense,								@OfficeEquipmentMemberAD),
  (1667,@DepreciationExpense,								@ComputerEquipmentMemberAD),
  (1668,@DepreciationExpense,								@CommunicationAndNetworkEquipmentMemberAD),
  (1669,@DepreciationExpense,								@BearerPlantsMemberAD),
  (1670,@DepreciationExpense,								@TangibleExplorationAndEvaluationAssetsMemberAD),
  (1671,@DepreciationExpense,								@MiningAssetsMemberAD),
  (1672,@DepreciationExpense,								@OilAndGasAssetsMemberAD),
  (1673,@DepreciationExpense,								@ConstructionInProgressMemberAD),
  (1674,@DepreciationExpense,								@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModelMemberAD),
  (1675,@DepreciationExpense,								@OtherPropertyPlantAndEquipmentMemberAD),
  
  (1740,@AmortisationExpense,								@BrandNamesMemberAD),
  (1757,@AmortisationExpense,								@IntangibleExplorationAndEvaluationAssetsMemberAD),
  (1758,@AmortisationExpense,								@MastheadsAndPublishingTitlesMemberAD), 
  (1759,@AmortisationExpense,								@ComputerSoftwareMemberAD),
  (1760,@AmortisationExpense,								@LicencesMemberAD),
  (1761,@AmortisationExpense,								@GSMLicencesMemberAD),
  (1762,@AmortisationExpense,								@UMTSLicencesMemberAD),
  (1763,@AmortisationExpense,								@LTELicencesMemberAD),
  (1764,@AmortisationExpense,								@GamingLicencesMemberAD),
  (1765,@AmortisationExpense,								@FranchisesMemberAD),
  (1766,@AmortisationExpense,								@CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRightsMemberAD),
  (1767,@AmortisationExpense,								@AirportLandingRightsMemberAD),
  (1768,@AmortisationExpense,								@MiningRightsMemberAD),
  (1769,@AmortisationExpense,								@BroadcastingRightsMemberAD),
  (1770,@AmortisationExpense,								@ServiceConcessionRightsMemberAD),
  (1771,@AmortisationExpense,								@RecipesFormulaeModelsDesignsAndPrototypesMemberAD),
  
  
  (1772,@AmortisationExpense,								@CustomerrelatedIntangibleAssetsMemberAD),
  (1773,@AmortisationExpense,								@ValueOfBusinessAcquiredMemberAD),
  (1774,@AmortisationExpense,								@CapitalisedDevelopmentExpenditureMemberAD),
  (1775,@AmortisationExpense,								@TechnologybasedIntangibleAssetsMemberAD),
  (1780,@AmortisationExpense,								@IntangibleAssetsUnderDevelopmentMemberAD),
  (1785,@AmortisationExpense,								@OtherIntangibleAssetsMemberAD),
  (1801,@DonationsAndSubsidiesExpense,@SupplierAD),
  (1802,@DonationsAndSubsidiesExpense,@CustomerAD),
  -- PPE, PUC, IPUCD, WIP, IIT ConstructionInProgressMemberAD, Customer, Sales Order, Employee,
  --(1876,@DepreciationExpense,							@InvestmentPropertyCompletedMemberAD),
  (1965,@GuaranteesExtension,								@EmployeeAD),
  (1966,@GuaranteesExtension,								@CashOnHandAccountAD),
  (1985,@HRExtension,										@EmployeeAD),
  (1990,@CRMExtension,									@ProspectAD),
  (1991,@CRMExtension,									@CustomerAD),
  (1700,@ProductionExtension,								@ProductionOrderAD);
  
  INSERT INTO @AccountTypeResourceDefinitions([Index],
  [HeaderIndex],											[ResourceDefinitionId]) VALUES
  (5,@Land,												@DepreciationBasesRD),
  (10,@Buildings,											@DepreciationBasesRD),
  (15,@Machinery,											@DepreciationBasesRD),
  (20,@Ships,												@DepreciationBasesRD),
  (25,@Aircraft,											@DepreciationBasesRD),
  (30,@MotorVehicles,										@DepreciationBasesRD),
  (35,@FixturesAndFittings,								@DepreciationBasesRD),
  (40,@OfficeEquipment,									@DepreciationBasesRD),
  (45,@BearerPlants,										@DepreciationBasesRD),
  (50,@TangibleExplorationAndEvaluationAssets,			@DepreciationBasesRD),
  (55,@MiningAssets,										@DepreciationBasesRD),
  (60,@OilAndGasAssets,									@DepreciationBasesRD),
  (65,@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModel,
  														@DepreciationBasesRD),
  (70,@OtherPropertyPlantAndEquipment,					@DepreciationBasesRD),
  (75, @InvestmentPropertyCompleted,						@DepreciationBasesRD),
  
  (80,@BrandNames,										@AmortizationBasesRD),
  (85,@IntangibleExplorationAndEvaluationAssets,			@AmortizationBasesRD),
  (90,@MastheadsAndPublishingTitles,						@AmortizationBasesRD),
  (95,@ComputerSoftware,									@AmortizationBasesRD),
  (100,@LicencesAndFranchises,							@AmortizationBasesRD),
  (105,@CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights,
  														@AmortizationBasesRD),
  (110,@RecipesFormulaeModelsDesignsAndPrototypes,		@AmortizationBasesRD),
  (115,@IntangibleAssetsUnderDevelopment,					@AmortizationBasesRD),
  (120,@OtherIntangibleAssets,							@AmortizationBasesRD),
  
  (125,@InvestmentsInAssociatesAccountedForUsingEquityMethod,
  														@OrdinarySharesMemberRD),
  (130,@InvestmentsInJointVenturesAccountedForUsingEquityMethod,
  														@OrdinarySharesMemberRD),
  (135,@InvestmentsInSubsidiaries,						@OrdinarySharesMemberRD),
  (140,@InvestmentsInJointVentures,						@OrdinarySharesMemberRD),
  (145,@InvestmentsInAssociates,							@OrdinarySharesMemberRD),
  (150,@NoncurrentBiologicalAssets,						@LivingAnimalsMemberRD), 													
  (151,@NoncurrentBiologicalAssets,						@PlantsMemberRD),
  (160,@Merchandise,										@MerchandiseRD),
  (165,@CurrentFoodAndBeverage,							@CurrentFoodAndBeverageRD),
  (166,@CurrentAgriculturalProduce,						@CurrentAgriculturalProduceRD),
  (170,@FinishedGoods,									@FinishedGoodsRD),
  (180,@PropertyIntendedForSaleInOrdinaryCourseOfBusiness,@PropertyIntendedForSaleInOrdinaryCourseOfBusinessRD),
  (185,@WorkInProgress,									@WorkInProgressRD),
  (190,@RawMaterials,										@RawMaterialsRD),
  (195,@ProductionSupplies,								@ProductionSuppliesRD),
  (200,@CurrentPackagingAndStorageMaterials,				@CurrentPackagingAndStorageMaterialsRD),
  (205,@SpareParts,										@SparePartsRD),
  (210,@CurrentFuel,										@CurrentFuelRD),
  (215,@CurrentInventoriesInTransit,						@MerchandiseRD),
  (216,@CurrentInventoriesInTransit,						@RawMaterialsRD),
  (250,@OtherInventories,									@OtherInventoriesRD),
  (260,@CurrentAccruedIncome,								@CustomerOtherPointOfTimeServicesRD),-- e.g., @SoftwareConsultancyRD
  (261,@CurrentAccruedIncome,								@CustomerOtherPeriodOfTimeServicesRD),  -- e.g., @SoftwareComponentRD
  
  -- while this is accurate, people are lazy to track this level of details
  --(270,@CurrentBilledNotReceivedFromSuppliersExtension,	@SupplierOtherPeriodOfTimeServicesRD),
  --(271,@CurrentBilledNotReceivedFromSuppliersExtension,	@SupplierOtherPeriodOfTimeServicesRD),
  (280,@CurrentBiologicalAssets,							@LivingAnimalsFlockRD),
  
  (340,@OtherCashAndCashEquivalents,						@ChecksReceivedRD), -- for checks ready to deposit
  
  (360,@IssuedCapital,									@OrdinarySharesMemberRD),
  (361,@IssuedCapital,									@PreferenceSharesMemberRD),
  
  (400,@DeferredIncomeClassifiedAsCurrent,				@CustomerOtherPointOfTimeServicesRD),
  (401,@RentDeferredIncomeClassifiedAsCurrent,			@CustomerOtherPeriodOfTimeServicesRD),
  
  --(410,@AccrualsClassifiedAsCurrent,						@SupplierOtherPeriodOfTimeServicesRD),
  --(411,@AccrualsClassifiedAsCurrent,						@SupplierOtherPeriodOfTimeServicesRD),
  (555,@RevenueFromSaleOfGoods,							@MerchandiseRD),
  (575,@RevenueFromSaleOfGoods,							@FinishedGoodsRD),
  (600,@RevenueFromSaleOfGoods,							@PropertyIntendedForSaleInOrdinaryCourseOfBusinessRD),
  
  (601,@RevenueFromSaleOfCopper,							@MerchandiseRD),
  (602,@RevenueFromSaleOfGold,							@MerchandiseRD),
  (603,@RevenueFromSaleOfSilver,							@MerchandiseRD),
  (604,@RevenueFromSaleOfOilAndGasProducts,				@MerchandiseRD),
  (605,@RevenueFromSaleOfCrudeOil,						@MerchandiseRD),
  
  (608,@RevenueFromSaleOfAgriculturalProduce,				@CurrentAgriculturalProduceRD),
  (610,@RevenueFromSaleOfFoodAndBeverage,					@CurrentFoodAndBeverageRD),
  (615,@RevenueFromRenderingOfTelecommunicationServices,	@TelecommunicationServicesRD),
  (620,@RevenueFromRenderingOfTransportServices,			@TransportServicesRD),
  (625,@RevenueFromRenderingOfInformationTechnologyMaintenanceAndSupportServices,
  														@InformationTechnologyMaintenanceAndSupportServicesRD),
  (630,@RevenueFromRenderingOfInformationTechnologyConsultingServices,
  														@InformationTechnologyConsultingServicesRD),
  (635,@RevenueFromRoomOccupancyServices,					@RoomOccupancyServicesRD),
  (615,@RevenueFromRenderingOfOtherPointOfTimeServicesExtension,
  														@CustomerOtherPointOfTimeServicesRD),
  (620,@RevenueFromRenderingOfOtherPeriodOfTimeServicesExtension,
  														@CustomerOtherPeriodOfTimeServicesRD),
  (620,@RevenueFromConstructionContracts,					@PerformanceObligationsRD),
  
  
  (645,@RawMaterialsAndConsumablesUsed,					@RawMaterialsRD),
  (665,@RawMaterialsAndConsumablesUsed,					@CurrentPackagingAndStorageMaterialsRD),
  (666,@RawMaterialsAndConsumablesUsed,					@ProductionSuppliesRD),
  (670,@CostOfMerchandiseSold,							@CurrentAgriculturalProduceRD),
  (675,@CostOfMerchandiseSold,							@CurrentFoodAndBeverageRD),
  (680,@CostOfMerchandiseSold,							@FinishedGoodsRD),
  (700,@CostOfMerchandiseSold,							@MerchandiseRD),
  (705,@CostOfMerchandiseSold,							@PropertyIntendedForSaleInOrdinaryCourseOfBusinessRD),
  
  (710,@FuelExpense,										@CurrentFuelRD),
  
  (735,@WagesAndSalaries,									@EmployeeBenefitsRD),
  (744,@WagesAndSalaries,									@OvertimeBenefitsRD),
  (746,@WagesAndSalaries,									@EmployeeDeductionsRD), 
  
  (740,@SocialSecurityContributions,						@SocialSecurityBenefitsRD),
  (745,@OtherShorttermEmployeeBenefits,					@EmployeeBenefitsRD), 
  (750,@PostemploymentBenefitExpenseDefinedContributionPlans,	
  														@EmployeeBenefitsRD),
  (755,@PostemploymentBenefitExpenseDefinedBenefitPlans,	@EmployeeBenefitsRD), 
  (760,@TerminationBenefitsExpense,						@EmployeeBenefitsRD),
  (765,@OtherLongtermBenefits,							@EmployeeBenefitsRD), 
  (770,@OtherEmployeeExpense,								@EmployeeBenefitsRD),
  
  (840,@DepreciationExpense,								@DepreciationBasesRD),
  --(857,@DepreciationExpense,							@DepreciationBasesRD),
  --(858,@DepreciationExpense,							@DepreciationBasesRD), 
  --(859,@DepreciationExpense,							@DepreciationBasesRD),
  --(860,@DepreciationExpense,							@DepreciationBasesRD),
  --(861,@DepreciationExpense,							@DepreciationBasesRD),
  --(862,@DepreciationExpense,							@DepreciationBasesRD),
  --(863,@DepreciationExpense,							@DepreciationBasesRD),
  --(864,@DepreciationExpense,							@DepreciationBasesRD),
  --(865,@DepreciationExpense,							@DepreciationBasesRD),
  --(866,@DepreciationExpense,							@DepreciationBasesRD),
  --(867,@DepreciationExpense,							@DepreciationBasesRD),
  --(868,@DepreciationExpense,							@DepreciationBasesRD),
  --(869,@DepreciationExpense,							@DepreciationBasesRD),
  --(870,@DepreciationExpense,							@DepreciationBasesRD),
  --(871,@DepreciationExpense,							@DepreciationBasesRD),
  --(872,@DepreciationExpense,							@DepreciationBasesRD),
  --(873,@DepreciationExpense,							@DepreciationBasesRD),
  --(874,@DepreciationExpense,							@DepreciationBasesRD),
  --(875,@DepreciationExpense,							@DepreciationBasesRD),
  (876,@AmortisationExpense,								@AmortizationBasesRD),
  (877,@WritedownsReversalsOfInventories,					@MerchandiseRD),
  (878,@WritedownsReversalsOfInventories,					@RawMaterialsRD),
  (879,@WritedownsReversalsOfInventories,					@FinishedGoodsRD),
  (880,@GuaranteesExtension,								@ChecksReceivedRD), -- for checks received as guarantee
  (881,@OtherCashAndCashEquivalents,						@FinancialGuaranteesRD), -- for LGs and the like
  
  --(890,@PayrollExtension,								@LeaveTypesRD),  -- Yearly vacation, sick leave
  (891,@PayrollExtension,									@AcademicDegreesRD),
  (892,@PayrollExtension,									@ProfessionalCertificationsRD), 
  (893,@PayrollExtension,									@FamilyRelationshipsRD), -- Wife, Child
  --(894,@PayrollExtension,								@LicensesPermitsIdsRD), 
  (895,@PayrollExtension,									@TransportationMeansRD),
  (896,@PayrollExtension,									@HousingMeansRD),
  (897,@PayrollExtension,									@JobsRD), -- Secretary, accountant, manager
  (898,@PayrollExtension,									@BreachesRD),
  
  (900,@HRExtension,										@LeaveTypesRD),  -- Yearly vacation, sick leave
  (901,@HRExtension,										@AcademicDegreesRD),
  (902,@HRExtension,										@ProfessionalCertificationsRD), 
  (903,@HRExtension,										@FamilyRelationshipsRD), -- Wife, Child
  (904,@HRExtension,										@LicensesPermitsIdsRD), 
  (905,@HRExtension,										@TransportationMeansRD),
  (906,@HRExtension,										@HousingMeansRD),
  (907,@HRExtension,										@JobsRD), -- Secretary, accountant, manager
  (908,@HRExtension,										@BreachesRD),
  --To be added to Resources for HR: academic level, certification, Cars, especially if they affect salary
  (1000,@CRMExtension,									@MarketingActivitiesRD);
  
  
  INSERT INTO @AccountTypeNotedAgentDefinitions([Index],
  [HeaderIndex], [NotedAgentDefinitionId]) VALUES
  
  (5,@Land,@SupplierAD),
  (10,@Buildings,@SupplierAD),
  (15,@Machinery,@SupplierAD),
  (20,@Ships,@SupplierAD),
  (25,@Aircraft,@SupplierAD),
  (30,@MotorVehicles,@SupplierAD),
  (35,@FixturesAndFittings,@SupplierAD),
  (40,@OfficeEquipment,@SupplierAD),
  (45,@BearerPlants,@SupplierAD),
  (50,@TangibleExplorationAndEvaluationAssets,@SupplierAD),
  (55,@MiningAssets,@SupplierAD),
  (60,@OilAndGasAssets,@SupplierAD),
  (65,@OwneroccupiedPropertyMeasuredUsingInvestmentPropertyFairValueModel,@SupplierAD),
  (70,@OtherPropertyPlantAndEquipment,@SupplierAD),
  
  (80,@BrandNames,@SupplierAD),
  (85,@IntangibleExplorationAndEvaluationAssets,@SupplierAD),
  (90,@MastheadsAndPublishingTitles,@SupplierAD),
  (95,@ComputerSoftware,@SupplierAD),
  (100,@LicencesAndFranchises,@SupplierAD),
  (105,@CopyrightsPatentsAndOtherIndustrialPropertyRightsServiceAndOperatingRights,@SupplierAD),
  (110,@RecipesFormulaeModelsDesignsAndPrototypes,@SupplierAD),
  (115,@IntangibleAssetsUnderDevelopment,@SupplierAD),
  (120,@OtherIntangibleAssets,@SupplierAD),
  
  (165,@Merchandise,@SupplierAD),
  (170,@CurrentFoodAndBeverage,@SupplierAD),
  (185,@PropertyIntendedForSaleInOrdinaryCourseOfBusiness,@SupplierAD),
  (190,@RawMaterials,@SupplierAD),
  (195,@ProductionSupplies,@SupplierAD),
  (200,@CurrentPackagingAndStorageMaterials,@SupplierAD),
  (205,@SpareParts,@SupplierAD),
  (210,@CurrentFuel,@SupplierAD),
  (215,@CurrentInventoriesInTransit,@SupplierAD),
  (220,@OtherInventories,@SupplierAD),
  
  (1005,@NoncurrentValueAddedTaxReceivables,@SupplierAD),
  (1010,@CurrentValueAddedTaxReceivables,@SupplierAD),
  (1015,@CurrentTaxAssetsCurrent,@CustomerAD),
  (1020,@NoncurrentValueAddedTaxPayables,@CustomerAD),
  (1025,@CurrentValueAddedTaxPayables,@CustomerAD),
  (1030,@OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension,@EmployeeAD),
  (1055,@OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension,@SupplierAD),
  (1065,@OtherCurrentPayablesOnSocialSecurityAndTaxesOtherThanIncomeTaxExtension,@PartnerAD),
  
  (1070,@RevenueFromSaleOfGoods,@CustomerAD),
  (1073,@RevenueFromSaleOfCopper,@CustomerAD),
  (1076,@RevenueFromSaleOfGold,@CustomerAD),
  (1079,@RevenueFromSaleOfSilver,@CustomerAD),
  (1082,@RevenueFromSaleOfOilAndGasProducts,@CustomerAD),
  (1085,@RevenueFromSaleOfCrudeOil,@CustomerAD),
  (1088,@RevenueFromSaleOfAgriculturalProduce,@CustomerAD),
  (1091,@RevenueFromSaleOfFoodAndBeverage,@CustomerAD),
  (1094,@RevenueFromRenderingOfTelecommunicationServices,@CustomerAD),
  (1097,@RevenueFromRenderingOfTransportServices,@CustomerAD),
  (1100,@RevenueFromRenderingOfInformationTechnologyMaintenanceAndSupportServices,@CustomerAD),
  (1103,@RevenueFromRenderingOfInformationTechnologyConsultingServices,@CustomerAD),
  (1106,@RevenueFromHotelOperations,@CustomerAD),
  (1109,@RevenueFromRoomOccupancyServices,@CustomerAD),
  (1112,@RevenueFromRenderingOfOtherPointOfTimeServicesExtension,@CustomerAD),
  (1115,@RevenueFromRenderingOfOtherPeriodOfTimeServicesExtension,@CustomerAD),
  (1118,@RevenueFromConstructionContracts,@CustomerAD),
  (1121,@OtherRevenue,@CustomerAD),
  (1124,@RawMaterialsAndConsumablesUsed,@SupplierAD),
  (1127,@FuelExpense,@SupplierAD),
  (1130,@CostOfMerchandiseSold,@SupplierAD), -- for drop shipment
  (1133,@InsuranceExpense,@SupplierAD),
  (1135,@ProfessionalFeesExpense,@SupplierAD),
  (1140,@RepairsAndMaintenanceExpense,@SupplierAD),
  (1145,@TransportationExpense,@SupplierAD),
  (1150,@BankAndSimilarCharges,@SupplierAD),
  (1155,@TravelExpense,@SupplierAD),
  (1160,@CommunicationExpense,@SupplierAD),
  (1165,@UtilitiesExpense,@SupplierAD),
  (1170,@AdvertisingExpense,@SupplierAD),
  (1173,@RentalExpense,@SupplierAD),							
  (1175,@WagesAndSalaries,@EmployeeAD),
  (1180,@SocialSecurityContributions,@EmployeeAD),
  (1185,@OtherShorttermEmployeeBenefits,@SupplierAD),
  (1186,@OtherShorttermEmployeeBenefits,@EmployeeAD),
  (1190,@PostemploymentBenefitExpenseDefinedContributionPlans,@EmployeeAD),
  (1195,@PostemploymentBenefitExpenseDefinedBenefitPlans,@EmployeeAD),
  (1200,@TerminationBenefitsExpense,@EmployeeAD),
  (1201,@TerminationBenefitsExpense,@SupplierAD),
  (1205,@OtherLongtermBenefits,@EmployeeAD),
  (1206,@OtherLongtermBenefits,@SupplierAD),
  (1210,@OtherEmployeeExpense,@EmployeeAD),
  (1211,@OtherEmployeeExpense,@SupplierAD),
  (1220,@SupplierPerformanceObligationsAtAPointInTimeControlExtension,@SupplierAD),
  (1225,@CustomerPerformanceObligationsAtAPointInTimeControlExtension,@CustomerAD),
  (1230,@SupplierPerformanceObligationsOverAPeriodOfTimeControlExtension,@SupplierAD),
  (1235,@CustomerPerformanceObligationsOverAPeriodOfTimeControlExtension,@CustomerAD),
  (1240,@EmployeePerformanceObligationsOverAPeriodOfTimeControlExtension,@EmployeeAD),
  (1245,@SupplierPaymentControlExtension,@SupplierAD),
  (1250,@EmployeePaymentControlExtension,@EmployeeAD),
  (1255,@CustomerPaymentControlExtension,@CustomerAD),
  (1260,@OtherPaymentControlExtension,@OtherAD),
  (1261,@OtherPaymentControlExtension,@CreditorAD),
  (1701,@GuaranteesExtension, @EmployeeAD),
  (1702,@GuaranteesExtension, @CustomerAD),
  (1901,@HRExtension, @FamilyMemberAD),
  (1902,@HRExtension, @UniversityAD);
  
  INSERT INTO @ValidationErrors
  EXEC [api].[AccountTypes__Save]
  	@Entities = @AccountTypes,
  	@AccountTypeAgentDefinitions = @AccountTypeAgentDefinitions,
  	@AccountTypeResourceDefinitions = @AccountTypeResourceDefinitions,
  	@AccountTypeNotedAgentDefinitions = @AccountTypeNotedAgentDefinitions,
  	@ReturnIds = 0,
  	@UserId = @AdminUserId;
  
  IF EXISTS (SELECT [Key] FROM @ValidationErrors)
  BEGIN
  	Print 'Account Types: Error Provisioning with weak entities'
  	GOTO Err_Label;
  END;
  
  
  DECLARE @ServicesExpenseNode HIERARCHYID = (SELECT [Node] FROM dbo.AccountTypes WHERE [Id] = @ServicesExpense);
  UPDATE dbo.[AccountTypes] SET IsSystem = 1 WHERE [Node].IsDescendantOf(@ServicesExpenseNode) = 0;
  
  
  END