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_TreasuryPostingJournal.
-- 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.
-- SQL view name: CTRLPOSTJOURNAL
CREATE VIEW C_TreasuryPostingJournal AS
SELECT
AccItem.TrsyAccountingDocumentUUID AS TrsyAccountingDocumentUUID,
AccItem.AccountingDocumentItemRef AS AccountingDocumentItemRef,
AccItem.TrsyPositionContextUUID AS TrsyPositionContextUUID,
I_FinInstrProductGroup.FinInstrProductGroup AS FinInstrProductGroup,
I_FinInstrProductGroup._FinInstrProductGroupText[1: Language=$session.system_language].FinInstrProductGroupName AS FinInstrProductGroupName,
AccItem._TrsyAcctItemDocument.TreasuryPostingStatus AS TreasuryPostingStatus,
AccItem._TrsyAcctItemDocument._TreasuryPostingStatus._Text[1: Language=$session.system_language].TreasuryPostingStatusName AS TreasuryPostingStatusName,
AccItem.TreasuryUpdateType AS TreasuryUpdateType,
AccItem._TreasuryUpdateType._Text[1: Language=$session.system_language].TreasuryUpdateTypeName AS TreasuryUpdateTypeName,
AccItem.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
AccItem.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
AccItem._TreasuryGLAccountAssignRef._Text[1: Language=$session.system_language].TreasuryGLAccountAssignRefName AS TreasuryGLAccountAssignRefName,
AccItem.TreasuryPostingCategory AS TreasuryPostingCategory,
AccItem._TreasuryPostingCategory._Text[1: Language=$session.system_language].TreasuryPostingCategoryName AS TreasuryPostingCategoryName,
AccItem.TreasuryGLAccountSymbol AS TreasuryGLAccountSymbol,
AccItem._TreasuryGLAccountSymbol._Text[1: Language=$session.system_language].TreasuryGLAccountSymbolName AS TreasuryGLAccountSymbolName,
AccItem.PostingKey AS PostingKey,
AccItem._PostingKey._PostingKeyText[1: Language=$session.system_language].PostingKeyName AS PostingKeyName,
AccItem.GLAccount AS GLAccount,
cast(_GLAccountText[1: Language=$session.system_language].GLAccountLongName as ftr_gen_gl_account_description preserving type ) AS GLAccountLongName,
AccItem.PositionCurrency AS PositionCurrency,
AccItem.AmountInPositionCurrency AS AmountInPositionCurrency,
AccItem.CompanyCodeCurrency AS CompanyCodeCurrency,
AccItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
AccItem.TreasuryTransactionFlow AS TreasuryTransactionFlow,
AccItem.AccountingDocument AS AccountingDocument,
AccItem.ReverseDocument AS ReverseDocument,
AccItem.JournalEntryType AS JournalEntryType,
AccItem._AccountingDocumentType._Text[1: Language=$session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
AccItem.PaymentDate AS PaymentDate,
AccItem.Customer AS Customer,
cast(_Customer.BusinessPartnerName1 as ftr_gen_customer_name) AS CustomerName,
cast(AccItem.Supplier as ftr_gen_supplier) AS Supplier,
cast(_Supplier._AddressDefaultRepresentation.AddresseeName1 as ftr_gen_supplier_name) AS SupplierName,
AccItem.PaymentTerms AS PaymentTerms,
AccItem.PaymentMethod AS PaymentMethod,
AccItem._PaymentMethod.PaymentMethodName AS PaymentMethodName,
AccItem.PaymentMethodSupplement AS PaymentMethodSupplement,
AccItem._Paymentmethodsupplement._Text[1: Language=$session.system_language].PaymentMethodSupplementName AS PaymentMethodSupplementName,
AccItem.PaymentBlockingReason AS PaymentBlockingReason,
cast(AccItem._PaymentBlockingReason._Text[1: Language=$session.system_language].PaymentBlockingReasonName as ftr_gen_pay_block_reason_name preserving type ) AS PaymentBlockingReasonName,
_TreasuryPaymentRequest.PayerPayee AS PayerPayee,
AccItem._PayerPayee.PayerPayeeFullName AS PayerPayeeFullName,
_TreasuryPaymentRequest.BPBankAccountInternalID AS BPBankAccountInternalID,
AccItem.HouseBank AS HouseBank,
cast(_HouseBank._Bank.BankName as ftr_gen_house_bank_name) AS HouseBankName,
AccItem.HouseBankAccount AS HouseBankAccount,
cast(_HouseBankAccountText.HouseBankAccountDescription as ftr_gen_house_bank_acc_descr) AS HouseBankAccountDescription,
_TreasuryPaymentRequest.TreasuryPaymentFlowDirection AS TreasuryPaymentFlowDirection,
AccItem.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
AccItem.SupplyingCountry AS SupplyingCountry,
AccItem._Country.Country AS Country,
AccItem._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
AccItem.AssignmentReference AS AssignmentReference,
AccItem.JournalEntryItemText AS JournalEntryItemText,
AccItem.BusinessArea AS BusinessArea,
AccItem._BusinessArea._Text[1: Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
AccItem.CostCenter AS CostCenter,
cast(_CostCenterText.CostCenterName as ftr_gen_cost_center_name preserving type ) AS CostCenterName,
AccItem.FinancialTransactionType AS FinancialTransactionType,
cast(AccItem._FinancialTransactionType._Text[1: Language=$session.system_language].FinancialTransactionTypeName as ftr_gen_trans_type_fi_name preserving type) AS FinancialTransactionTypeName,
AccItem.PartnerCompany AS PartnerCompany,
AccItem._PartnerCompany.CompanyName AS CompanyName,
AccItem.Counterparty AS Counterparty,
cast(AccItem._CounterpartyName.BusinessPartnerFullName as ftr_gen_counterparty_full_name) AS CounterpartyFullName,
AccItem.Issuer AS Issuer,
cast(AccItem._IssuerName.BusinessPartnerFullName as ftr_gen_issuer_full_name) AS IssuerFullName,
AccItem.SpecialGLCode AS SpecialGLCode,
cast(AccItem._SpecialGLCode._Text[1: Language=$session.system_language].SpecialGLCodeName as ftr_gen_special_gl_code_name) AS SpecialGLCodeName,
AccItem._TrsyAcctItemDocument.TreasuryBusinessTransaction AS TreasuryBusinessTransaction,
Position.TreasuryValuationArea AS TreasuryValuationArea,
Position._TreasuryValuationArea.TreasuryValuationAreaName AS TreasuryValuationAreaName,
AccItem._TrsyAcctItemDocument.ReferenceDocument AS ReferenceDocument,
AccItem._TrsyAcctItemDocument.ReferenceDocumentContext AS ReferenceDocumentContext,
AccItem._TrsyAcctItemDocument.PostingDate AS PostingDate,
AccItem._TrsyAcctItemDocument.PostingFiscalPeriod AS PostingFiscalPeriod,
AccItem._TrsyAcctItemDocument.FiscalYear AS FiscalYear,
AccItem._TrsyAcctItemDocument.ReversalReferenceDocument AS ReversalReferenceDocument,
AccItem._TrsyAcctItemDocument.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
AccItem._TrsyAcctItemDocument.ReverseDocumentPostingDate AS ReverseDocumentPostingDate,
AccItem._TrsyAcctItemDocument.ReverseDocumentFiscalPeriod AS ReverseDocumentFiscalPeriod,
AccItem._TrsyAcctItemDocument.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
AccItem._TrsyAcctItemDocument.DocumentDate AS DocumentDate,
AccItem._TrsyAcctItemDocument.AccountingPrinciple AS AccountingPrinciple,
AccItem._TrsyAcctItemDocument.TreasuryAcctgPostingCategory AS TreasuryAcctgPostingCategory,
AccItem._TrsyAcctItemDocument.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
AccItem._TrsyAcctItemDocument._TreasuryBusTransCategoryText.TreasuryBusTransCategoryName AS TreasuryBusTransCategoryName,
AccItem._TrsyAcctItemDocument.DocumentHeaderText AS DocumentHeaderText,
AccItem._TrsyAcctItemDocument.AccountingDocExternalReference AS AccountingDocExternalReference,
Position.FinancialInstrValuationClass AS FinancialInstrValuationClass,
Position._FinancialInstrValClassText.FinancialInstrValClassName AS FinancialInstrValClassName,
Position.TreasuryValuationClass AS TreasuryValuationClass,
Position._TreasuryValuationClassText.TreasuryValuationClassName AS TreasuryValuationClassName,
Position.CompanyCode AS CompanyCode,
cast(Position._CompanyCode.CompanyCodeName as fis_butxt preserving type) AS CompanyCodeName,
Position._CompanyCode.ChartOfAccounts AS ChartOfAccounts,
Position.FinancialInstrumentProductType AS FinancialInstrumentProductType,
Position._FinancialInstrProdTypeText.FinancialInstrProdTypeName AS FinancialInstrProdTypeName,
Position.SecurityAccount AS SecurityAccount,
Position._SecurityAccount.SecurityAccountName AS SecurityAccountName,
Position.SecurityClass AS SecurityClass,
Position._SecurityClass.SecurityClassName AS SecurityClassName,
Position._SecurityClass.SecurityClassDescription AS SecurityClassDescription,
Position.DifferentiationPortfolio AS DifferentiationPortfolio,
Position._DifferentiationPortfolioText.DifferentiationPortfolioName AS DifferentiationPortfolioName,
Position.SecurityAccountGroup AS SecurityAccountGroup,
Position._SecurityAccountGroup.SecurityAccountGroupName AS SecurityAccountGroupName,
Position.LoanContract AS LoanContract,
Position._LoanContract.LoanContractName AS LoanContractName,
Position.TreasuryPositionAccount AS TreasuryPositionAccount,
Position._TreasuryPositionAccount.TreasuryPositionAccountName AS TreasuryPositionAccountName,
Position.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
Position.Fund AS Fund,
cast(_FundText[1: Language=$session.system_language].FundName as ftr_gen_funds_name preserving type) AS FundName,
Position.GrantID AS GrantID,
Position.WBSElementExternalID AS WBSElementExternalID,
Position.ProfitCenter AS ProfitCenter,
Position.FunctionalArea AS FunctionalArea,
Position.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
_TrsyPosCustomDiffntnTerm1._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm1Name AS TrsyPosCustomDiffntnTerm1Name,
Position.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
_TrsyPosCustomDiffntnTerm2._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm2Name AS TrsyPosCustomDiffntnTerm2Name,
Position.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
_TrsyPosCustomDiffntnTerm3._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm3Name AS TrsyPosCustomDiffntnTerm3Name,
Position.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
_TrsyPosCustomDiffntnTerm4._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm4Name AS TrsyPosCustomDiffntnTerm4Name,
Position.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
_TrsyPosCustomDiffntnTerm5._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm5Name AS TrsyPosCustomDiffntnTerm5Name,
Position.CentralClearingAccount AS CentralClearingAccount,
Position._CentralClearingAccount.CentralClearingAccountName AS CentralClearingAccountName,
AccItem._TrsyAcctItemDocument.ActivityFinancialTransaction AS ActivityFinancialTransaction,
Position.FinancialTransaction AS FinancialTransaction,
_FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
cast(_FinancialTransaction._FinancialInstrTransType._Text[1: Language = $session.system_language].FinancialInstrTransTypeName as ftr_gen_transaction_type_name preserving type) AS FinancialInstrTransTypeName,
_FinancialTransaction.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
_FinancialTransaction.FinancialInstrumentReference AS FinancialInstrumentReference,
_FinancialTransaction.FinancialInstrumentAssignment AS FinancialInstrumentAssignment,
_FinancialTransaction.Portfolio AS Portfolio,
_FinancialTransaction._LetterOfCredit.LetterOfCredit AS LetterOfCredit,
_FinancialTransaction.HedgingClassification AS HedgingClassification,
cast(_FinancialTransaction._TreasuryHedgingClassfctn._Text[1: Language = $session.system_language].HedgingClassificationName as ftr_gen_hedging_class_name preserving type) AS HedgingClassificationName,
_TrgtUserData.CreatedByUser AS CreatedByUser,
_TrgtUserData.CreationDate AS CreationDate,
_TrgtUserData.LastChangedByUser AS LastChangedByUser,
_TreasuryPaymentRequest.PaymentRequest AS PaymentRequest,
_TreasuryPaymentRequest.PaytReqOriglReferenceDocument AS PaytReqOriglReferenceDocument,
_TreasuryPaymentRequest.PaymentCurrency AS PaymentCurrency,
_TreasuryPaymentRequest.AmountInPaymentCurrency AS AmountInPaymentCurrency,
_TreasuryPaymentRequest.TreasuryIndividualPayment AS TreasuryIndividualPayment,
_TreasuryPaymentRequest.TrsyPaytGroupingSameDrctnIsRqd AS TrsyPaytGroupingSameDrctnIsRqd,
_TreasuryPaymentRequest.TreasuryPaymentRequestGrouping AS TreasuryPaymentRequestGrouping,
_TreasuryPaymentRequest.TrsyPaytRequestGroupingName AS TrsyPaytRequestGroupingName,
_TreasuryPaymentRequest.PaymentRequestPaymentGroup AS PaymentRequestPaymentGroup,
_TreasuryPaymentRequest.ConsideredPaymentMethods AS ConsideredPaymentMethods,
_TreasuryPaymentRequest.PaytReqAdditionalInstructions AS PaytReqAdditionalInstructions,
_TreasuryPaymentRequest.PaytReqAddlInstructionsName AS PaytReqAddlInstructionsName,
_TreasuryPaymentRequest.BankClearingGLAccount AS BankClearingGLAccount,
_TreasuryPaymentRequest.TrsyPaytRequestReleaseStatus AS TrsyPaytRequestReleaseStatus,
_TreasuryPaymentRequest.TrsyPaytRequestRelStatusName AS TrsyPaytRequestRelStatusName,
_TreasuryPaymentRequest.PaymentReason AS PaymentReason,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute1 AS TrsyPosFreeDefinedAttribute1,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute2 AS TrsyPosFreeDefinedAttribute2,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute3 AS TrsyPosFreeDefinedAttribute3,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute4 AS TrsyPosFreeDefinedAttribute4,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute5 AS TrsyPosFreeDefinedAttribute5,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute6 AS TrsyPosFreeDefinedAttribute6,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute7 AS TrsyPosFreeDefinedAttribute7,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute8 AS TrsyPosFreeDefinedAttribute8,
_TrltPosAttrib.TrsyPosFreeDefinedAttribute9 AS TrsyPosFreeDefinedAttribute9,
_TrltPosAttrib.TrsyPosFreeDfndAttribute1Name AS TrsyPosFreeDfndAttribute1Name,
_TrltPosAttrib.TrsyPosFreeDfndAttribute2Name AS TrsyPosFreeDfndAttribute2Name,
_TrltPosAttrib.TrsyPosFreeDfndAttribute3Name AS TrsyPosFreeDfndAttribute3Name,
_TrltPosAttrib.TrsyPosFreeDfndAttribute4Name AS TrsyPosFreeDfndAttribute4Name,
_TrltPosAttrib.TrsyPosFreeDfndAttribute5Name AS TrsyPosFreeDfndAttribute5Name,
_TrltPosAttrib.TrsyPosFreeDfndAttribute6Name AS TrsyPosFreeDfndAttribute6Name,
Position.TreasuryAccountingCode AS TreasuryAccountingCode,
Position.FinancialExposureItem AS FinancialExposureItem,
_TrsyFinExpsrItmText.FinancialExposureItemName AS FinancialExposureItemName,
Position.FinancialExposureSubItem AS FinancialExposureSubItem,
_TrsyFinExpsrSubitemText.FinancialExposureSubItemName AS FinancialExposureSubItemName,
AccItem._Country AS _Country,
AccItem._PaymentBlockingReason AS _PaymentBlockingReason,
AccItem._FinancialTransactionType AS _FinancialTransactionType,
AccItem._PostingKey AS _PostingKey,
AccItem._Paymentmethodsupplement AS _Paymentmethodsupplement,
Position._CompanyCode AS _CompanyCode,
Position._TreasuryValuationArea AS _TreasuryValuationArea,
AccItem._TrsyAcctItemDocument._AccountingPrinciple AS _AccountingPrinciple,
Position._SecurityAccountGroup AS _SecurityAccountGroup,
AccItem._TrsyAcctItemDocument AS _TrsyAcctItemDocument,
AccItem._TrsyAcctItemPosContext AS _TrsyAcctItemPosContext
FROM P_TrsyLdgrPosAccountingItem AS AccItem
INNER JOIN P_PositionIdentifierCompCode AS Position ON /* join condition not captured in parsed metadata */
INNER JOIN P_PosIdfrTrsyLdgrTrsyAcctg AS DifsDiff ON /* join condition not captured in parsed metadata */
INNER JOIN I_FinInstrProductGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TrgtUserData AS _TrgtUserData ON AccItem.TreasuryUserStatisticsUUID = _TrgtUserData.TreasuryUserStatisticsUUID -- association [0..1]
LEFT OUTER JOIN I_TreasuryPaymentRequest AS _TreasuryPaymentRequest ON AccItem.TreasuryBusinessTransaction = _TreasuryPaymentRequest.TreasuryBusinessTransaction AND AccItem.TreasuryValuationArea = _TreasuryPaymentRequest.TreasuryValuationArea AND TreasuryTransactionFlow = _TreasuryPaymentRequest.TreasuryTransactionFlow AND GLAccount = _TreasuryPaymentRequest.GLAccount -- association [0..1]
LEFT OUTER JOIN I_TrltPosattrib AS _TrltPosAttrib ON DifsDiff.TrsyLdgrTreasuryPosition = _TrltPosAttrib.TreasuryPosition -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND Position.ChartOfAccounts = _GLAccountText.ChartOfAccounts AND _GLAccountText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON AccItem.CostCenter = _CostCenterText.CostCenter AND Position.ControllingArea = _CostCenterText.ControllingArea AND AccItem.DocumentDate = _CostCenterText.ValidityEndDate AND _CostCenterText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON Position.Fund = _FundText.Fund AND Position.FinancialManagementArea = _FundText.FinancialManagementArea AND _FundText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinancialTransaction ON Position.FinancialTransaction = _FinancialTransaction.FinancialTransaction AND Position.CompanyCode = _FinancialTransaction.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationClass AS _TreasuryValuationClass ON TreasuryValuationClass = _TreasuryValuationClass.TreasuryValuationClass AND TreasuryValuationArea = _TreasuryValuationClass.TreasuryValuationArea -- association [0..1]
LEFT OUTER JOIN I_LoanContract AS _LoanContract ON LoanContract = _LoanContract.LoanContract AND CompanyCode = _LoanContract.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_TreasuryPositionAccount AS _TreasuryPositionAccount ON TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount AND CompanyCode = _TreasuryPositionAccount.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionVH AS _FinancialTransactionVH ON FinancialTransaction = _FinancialTransactionVH.FinancialTransaction AND CompanyCode = _FinancialTransactionVH.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionVH AS _ActivFinancialTransactionVH ON activityfinancialtransaction = _ActivFinancialTransactionVH.FinancialTransaction AND CompanyCode = _ActivFinancialTransactionVH.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND AccItem.HouseBank = _HouseBank.HouseBank -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON CompanyCode = _HouseBankAccountText.CompanyCode AND AccItem.HouseBank = _HouseBankAccountText.HouseBank AND AccItem.HouseBankAccount = _HouseBankAccountText.HouseBankAccount AND _HouseBankAccountText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON AccItem.Supplier = _Supplier.Supplier -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON AccItem.Customer = _Customer.Customer -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountVH AS _HouseBankAccountVH ON CompanyCode = _HouseBankAccountVH.CompanyCode AND HouseBank = _HouseBankAccountVH.HouseBank AND HouseBankAccount = _HouseBankAccountVH.HouseBankAccount -- association [0..1]
LEFT OUTER JOIN I_CentralClearingAccountVH AS _CentralClearingAccountVH ON CompanyCode = _CentralClearingAccountVH.CompanyCode AND CentralClearingAccount = _CentralClearingAccountVH.CentralClearingAccount -- association [0..1]
LEFT OUTER JOIN I_TrsyFinExpsrItmText AS _TrsyFinExpsrItmText ON Position.FinancialExposureItem = _TrsyFinExpsrItmText.FinancialExposureItem -- association [0..1]
LEFT OUTER JOIN I_TrsyFinExpsrSubitemText AS _TrsyFinExpsrSubitemText ON DifsDiff.TrsyLdgrTreasuryPosition = _TrsyFinExpsrSubitemText.TreasuryPosition -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm1 AS _TrsyPosCustomDiffntnTerm1 ON Position.TrsyPosCustomDiffntnTerm1 = _TrsyPosCustomDiffntnTerm1.TrsyPosCustomDiffntnTerm1 -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm2 AS _TrsyPosCustomDiffntnTerm2 ON Position.TrsyPosCustomDiffntnTerm2 = _TrsyPosCustomDiffntnTerm2.TrsyPosCustomDiffntnTerm2 -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm3 AS _TrsyPosCustomDiffntnTerm3 ON Position.TrsyPosCustomDiffntnTerm3 = _TrsyPosCustomDiffntnTerm3.TrsyPosCustomDiffntnTerm3 -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm4 AS _TrsyPosCustomDiffntnTerm4 ON Position.TrsyPosCustomDiffntnTerm4 = _TrsyPosCustomDiffntnTerm4.TrsyPosCustomDiffntnTerm4 -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm5 AS _TrsyPosCustomDiffntnTerm5 ON Position.TrsyPosCustomDiffntnTerm5 = _TrsyPosCustomDiffntnTerm5.TrsyPosCustomDiffntnTerm5 -- association [0..1]
;