C_CnsldtnJrnlEntryItemTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CnsldtnJrnlEntryItemTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_CnsldtnJrnlEntryItemTP AS
SELECT
  FiscalYear,
  ConsolidationLedger,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  FiscalYearForEdit,
  ConsolidationUnit1IsUsed,
  ConsolidationDimension,
  GLRecordType,
  ConsolidationVersion,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  Company,
  ConsolidationUnit,
  _ConsolidationUnitText.ConsolidationUnitText AS ConsolidationUnitMdmText,
  ConsolidationChartOfAccounts,
  _CnsldtnCoAText.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  FinancialStatementItem,
  _FSItemText.FinancialStatementItemMdmText AS FinancialStatementItemMdmText,
  PartnerConsolidationUnit,
  _PartnerConsolidationUnitText.ConsolidationUnitText AS PartnerCnsldtnUnitMediumText,
  ConsolidationGroup,
  CompanyCode,
  _CompanyCode[1: Language = $session.system_language].CompanyCodeName AS CompanyCodeName,
  SubItemCategory,
  _SubItemCategory._Text[1:Language = $session.system_language].SubItemCategoryText AS SubItemCategoryText,
  SubItem,
  _SubItem._Text[1:Language = $session.system_language].SubItemMediumText AS SubItemMediumText,
  PostingLevel,
  _PostingLevel._Text[1:Language = $session.system_language].PostingLevelText AS PostingLevelText,
  ConsolidationApportionment,
  _Apportionment._Text[1: Language = $session.system_language].ConsolidationApportionmentText AS ConsolidationApportionmentText,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  _DocumentType._Text[1: Language = $session.system_language].ConsolidationDocumentTypeText AS ConsolidationDocumentTypeText,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  _InvesteeConsolidationUnitText.ConsolidationUnitText AS InvesteeConsolidationUnitText,
  InvestorConsolidationUnit,
  _InvestorConsolidationUnitText.ConsolidationUnitText AS InvestorConsolidationUnitText,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  CurrencyTranslationDate,
  ReferenceFiscalYear,
  RefConsolidationDocumentNumber,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  _InvestmentActivityTypeText.InvestmentActivityType AS InvestmentActivityTypeText,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  PostingDate,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  _CostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  ProfitCenter,
  _ProfitCenter._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  BusinessArea,
  _BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  ControllingArea,
  _ControllingArea._Text[1: Language = $session.system_language].ControllingAreaName AS ControllingAreaName,
  Segment,
  PartnerCostCenter,
  _PartnerCostCenter._Text[1: Language = $session.system_language].CostCenterName AS PartnerCostCenterName,
  PartnerProfitCenter,
  _PartnerProfitCenter._Text[1: Language = $session.system_language].ProfitCenterName AS PartnerProfitCenterName,
  PartnerFunctionalArea,
  _PartnerFunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS PartnerFunctionalAreaName,
  PartnerBusinessArea,
  _PartnerBusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS PartnerBusinessAreaName,
  PartnerCompany,
  _PartnerCompany.CompanyName AS PartnerCompanyName,
  PartnerSegment,
  _PartnerSegment._Text[1:Language = $session.system_language].SegmentName AS PartnerSegmentName,
  OrderID,
  Customer,
  _Customer._Text[1:Language = $session.system_language]. CustomerName AS CustomerName,
  Supplier,
  _Supplier._Text[1: Language = $session.system_language].SupplierName AS SupplierName,
  Material,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  Plant,
  _Plant._Text[1: Language = $session.system_language].PlantName AS PlantName,
  FinancialTransactionType,
  _FinancialTransactionType._Text[1: Language = $session.system_language].FinancialTransactionTypeName AS FinancialTransactionTypeName,
  WBSElementInternalID,
  WBSElementExternalID,
  Project,
  BillingDocumentType,
  _BillingDocumentType._Text[1: Language = $session.system_language].AdditionalMasterDataText AS BillingDocumentTypeName,
  SalesOrganization,
  _SalesOrganization._Text[1: Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannel._Text[1: Language = $session.system_language].DistributionChannelName AS DistributionChannelName,
  OrganizationDivision,
  _OrganizationDivision._Text[1: Language = $session.system_language].DivisionName AS DivisionName,
  SoldMaterial,
  _SoldMaterial._Text[1: Language = $session.system_language].MaterialName AS SoldMaterialName,
  MaterialGroup,
  ProductGroup,
  _SoldProductGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  CustomerGroup,
  _CustomerGroup._Text[1: Language = $session.system_language].CustomerGroupName AS CustomerGroupName,
  CustomerSupplierCountry,
  _Country._Text[1: Language = $session.system_language].CountryName AS CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  _Industry._Text[1: Language = $session.system_language].IndustryName AS CustomerSupplierIndustryName,
  SalesDistrict,
  _SalesDistrict._Text[1: Language = $session.system_language].SalesDistrictName AS SalesDistrictName,
  BillToParty,
  _BillToParty._Text[1: Language = $session.system_language].AdditionalMasterDataText AS BillToPartyName,
  ShipToParty,
  _ShipToParty._Text[1: Language = $session.system_language].AdditionalMasterDataText AS ShipToPartyName,
  CustomerSupplierCorporateGroup,
  ConsolidationUnit3,
  _ConsolidationUnit3Text.ConsolidationUnitText AS CnsldtnUnit3Text,
  PartnerConsolidationUnit3,
  _PartnerConsolidationUnit3Text.ConsolidationUnitText AS PartnerCnsldtnUnit3Text,
  FiscalYearPeriod,
  _FSItemAttribute.CnsldtnFSItemRole AS CnsldtnFSItemRole,
  _FSItemAttribute.CnsldtnFSItemDataCollection AS CnsldtnFSItemDataCollection,
  _FSItemAttribute.CnsldtnFSItemCrcyTranslation AS CnsldtnFSItemCrcyTranslation,
  _FSItemAttribute.CnsldtnFSItemElimination AS CnsldtnFSItemElimination,
  _FSItemAttribute.CnsldtnFSItemCashFlow AS CnsldtnFSItemCashFlow,
  _FSItemAttribute.CnsldtnFSItemScope AS CnsldtnFSItemScope,
  _FSItemAttribute.CnsldtnFSItemCustomerSpecific AS CnsldtnFSItemCustomerSpecific,
  _FSItemAttribute.CnsldtnEliminationTargetFSItem AS CnsldtnEliminationTargetFSItem,
  _FSItemAttribute.CnsldtnNCITargetFSItem AS CnsldtnNCITargetFSItem,
  _FSItemAttribute.CnsldtnPlanningTargetFSItem AS CnsldtnPlanningTargetFSItem,
  FinancialServicesProductGroup,
  _FinancialServicesProductGroup._Text[1:Language = $session.system_language].FinServicesProductGroupName AS FinServicesProductGroupName,
  FinancialServicesBranch,
  _FinancialServicesBranch._Text[1:Language = $session.system_language].FinancialServicesBranchName AS FinancialServicesBranchName,
  FinancialDataSource,
  _FinancialDataSource._Text[1:Language = $session.system_language].FinancialDataSourceName AS FinancialDataSourceName,
  FinancialManagementArea,
  _FinancialManagementArea._Text[1:Language = $session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  Fund,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  GrantID,
  _Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  CnsldtnCashLedgerChartOfAccts,
  _CashLedgerChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS CnsldtnCashLdgrChtOfAcctsText,
  CashLedgerAccount,
  _CashLedgerAccount._Text[1:Language = $session.system_language].GLAccountName AS CashLedgerAccountName,
  PartnerFund,
  _PartnerFund._Text[1:Language = $session.system_language].FundName AS PartnerFundText,
  GHGScope,
  _GHGScope._Text[1:Language = $session.system_language].GHGScopeName AS GHGScopeName,
  GHGCategory,
  _GHGCategory._Text[1:Language = $session.system_language].GHGCategoryName AS GHGCategoryName,
  GHGScope2CalculationMethod,
  _GHGScope2CalculationMethod._Text[1:Language = $session.system_language].GHGScope2CalculationMethodName AS GHGScope2CalculationMethodName,
  GHGScope2ContractualInstrument,
  _GHGScp2ContractualInstrument._Text[1:Language = $session.system_language].GHGScp2CntrctlInstrName AS GHGScp2CntrctlInstrName,
  SustainabilityModeOfTransport,
  _SustainabilityModeOfTransport._Text[1:Language = $session.system_language].SustModeOfTransportName AS SustModeOfTransportName,
  GHGDataQualityCharacteristic,
  _GHGDataQualityCharacteristic._Text[1:Language = $session.system_language].GHGDtaQltyCharacteristicName AS GHGDtaQltyCharacteristicName,
  GHGEnergyClassification,
  _GHGEnergyClassification._Text[1:Language = $session.system_language].GHGEnergyClassificationName AS GHGEnergyClassificationName,
  GHGEnergyMix,
  _GHGEnergyMix._Text[1:Language = $session.system_language].GHGEnergyMixName AS GHGEnergyMixName,
  GHGEnergySourcingType,
  _GHGEnergySourcingType._Text[1:Language = $session.system_language].GHGEnergySourcingTypeName AS GHGEnergySourcingTypeName,
  CnsldtnJrnlEntrDocTypeIsRstrcd
FROM I_CnsldtnJrnlEntryItemTP AS CnsldtnJrnlEntryItemTP
LEFT OUTER JOIN C_CnsldtnJrnlEntryTP AS _Header ON _Header.FiscalYear = FiscalYear AND _Header.ConsolidationLedger = ConsolidationLedger AND _Header.ConsolidationDocumentNumber = ConsolidationDocumentNumber  -- association [1..1]
LEFT OUTER JOIN C_CnsldtnProjectVH AS _CnsldtnProjectVH ON _CnsldtnProjectVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnMaterialGroupVH AS _CnsldtnMaterialGroupVH ON _CnsldtnMaterialGroupVH.MaterialGroup = MaterialGroup  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnMaterialGroupVH AS _CnsldtnProductGroupVH ON _CnsldtnProductGroupVH.MaterialGroup = ProductGroup  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnMaterialVH AS _CnsldtnSoldMaterialVH ON _CnsldtnSoldMaterialVH.Material = SoldMaterial  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnWBSElementVH AS _CnsldtnWBSElementVH ON _CnsldtnWBSElementVH.WBSElementExternalID = WBSElementExternalID AND _CnsldtnWBSElementVH.Project = Project  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnPlantVH AS _CnsldtnPlantVH ON _CnsldtnPlantVH.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnFinTransTypeVH AS _CnsldtnFinTransTypeVH ON _CnsldtnFinTransTypeVH.FinancialTransactionType = FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnBillgTypeVH AS _CnsldtnBillgTypeVH ON _CnsldtnBillgTypeVH.BillingDocumentType = BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnSlsOrgVH AS _CnsldtnSlsOrgVH ON _CnsldtnSlsOrgVH.SalesOrganization = SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnDistrChnlVH AS _CnsldtnDistrChnlVH ON _CnsldtnDistrChnlVH.DistributionChannel = DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnDivnVH AS _CnsldtnDivnVH ON _CnsldtnDivnVH.Division = OrganizationDivision  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnCustGrpVH AS _CnsldtnCustGrpVH ON _CnsldtnCustGrpVH.CustomerGroup = CustomerGroup  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnIndustryVH AS _CnsldtnIndustryVH ON _CnsldtnIndustryVH.Industry = CustomerSupplierIndustry  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnSlsDstrctVH AS _CnsldtnSlsDstrctVH ON _CnsldtnSlsDstrctVH.SalesDistrict = SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCountry AS _CnsldtnCountry ON _CnsldtnCountry.Country = CustomerSupplierCountry  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _ConsolidationUnitText ON ConsolidationUnit = _ConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnPartnerUnitVH AS _PartnerConsolidationUnitText ON PartnerConsolidationUnit = _PartnerConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnInvesteeUnitVH AS _InvesteeConsolidationUnitText ON InvesteeConsolidationUnit = _InvesteeConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _InvestorConsolidationUnitText ON InvestorConsolidationUnit = _InvestorConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnInvmtEquityActyVH AS _InvestmentActivityTypeText ON InvestmentActivityType = _InvestmentActivityTypeText.InvestmentActivityType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _FSItemText ON _FSItemText.FinancialStatementItem = FinancialStatementItem AND _FSItemText.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _FSItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccountsT AS _CnsldtnCoAText ON _CnsldtnCoAText.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _CnsldtnCoAText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _ConsolidationUnit3Text ON ConsolidationUnit = _ConsolidationUnit3Text.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnPartnerUnitVH AS _PartnerConsolidationUnit3Text ON PartnerConsolidationUnit3 = _PartnerConsolidationUnit3Text.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemByTimeVersion AS _FSItemAttribute ON FinancialStatementItem = _FSItemAttribute.CnsldtnFinancialStatementItem AND ConsolidationChartOfAccounts = _FSItemAttribute.ConsolidationChartOfAccounts AND ConsolidationVersion = _FSItemAttribute.ConsolidationVersion AND FiscalYearPeriod >= _FSItemAttribute.FromFiscalYearPeriod AND FiscalYearPeriod <= _FSItemAttribute.ToFiscalYearPeriod  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnPartnerCompanyVH AS _CnsldtnPartnerCompanyVH ON _CnsldtnPartnerCompanyVH.Company = PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentType AS _DocumentType ON ConsolidationDimension = _DocumentType.ConsolidationDimension AND ConsolidationDocumentType = _DocumentType.ConsolidationDocumentType  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnPostingLevel AS _PostingLevel ON PostingLevel = _PostingLevel.PostingLevel  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnCostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnBusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnApportionment AS _Apportionment ON ConsolidationApportionment = _Apportionment.ConsolidationApportionment  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnCustomer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSupplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMaterial AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnPlant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinTransType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCostCenter AS _PartnerCostCenter ON ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnBusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.Company AND _PartnerCompany.CompanyLanguage = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnSegment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnBillingType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDivision AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMaterial AS _SoldMaterial ON SoldMaterial = _SoldMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMaterialGroup AS _SoldProductGroup ON ProductGroup = _SoldProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCountry AS _Country ON CustomerSupplierCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnIndustry AS _Industry ON CustomerSupplierIndustry = _Industry.Industry  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinSrvcsProductGroup AS _FinancialServicesProductGroup ON FinancialServicesProductGroup = _FinancialServicesProductGroup.FinancialServicesProductGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinServicesBranch AS _FinancialServicesBranch ON FinancialServicesBranch = _FinancialServicesBranch.FinancialServicesBranch  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinancialDataSource AS _FinancialDataSource ON FinancialDataSource = _FinancialDataSource.FinancialDataSource  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGrant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLChartOfAccounts AS _CashLedgerChartOfAccounts ON CnsldtnCashLedgerChartOfAccts = _CashLedgerChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLAccount_2 AS _CashLedgerAccount ON CnsldtnCashLedgerChartOfAccts = _CashLedgerAccount.ChartOfAccounts AND CashLedgerAccount = _CashLedgerAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND Fund = _PartnerFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScope AS _GHGScope ON GHGScope = _GHGScope.GHGScope  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGCategory AS _GHGCategory ON GHGCategory = _GHGCategory.GHGCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScp2CalcMethod AS _GHGScope2CalculationMethod ON GHGScope2CalculationMethod = _GHGScope2CalculationMethod.GHGScope2CalculationMethod  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScp2CntrctlInstr AS _GHGScp2ContractualInstrument ON GHGScope2ContractualInstrument = _GHGScp2ContractualInstrument.GHGScope2ContractualInstrument  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSustModeOfTransport AS _SustainabilityModeOfTransport ON SustainabilityModeOfTransport = _SustainabilityModeOfTransport.SustainabilityModeOfTransport  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGDtaQltyCharc AS _GHGDataQualityCharacteristic ON GHGDataQualityCharacteristic = _GHGDataQualityCharacteristic.GHGDataQualityCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGEngyClassification AS _GHGEnergyClassification ON GHGEnergyClassification = _GHGEnergyClassification.GHGEnergyClassification  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGEnergyMix AS _GHGEnergyMix ON GHGEnergyMix = _GHGEnergyMix.GHGEnergyMix  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGEnergySourcingType AS _GHGEnergySourcingType ON GHGEnergySourcingType = _GHGEnergySourcingType.GHGEnergySourcingType  -- association [0..1]
;