I_FINANCIALTRANSACTION
Financial Transaction
I_FINANCIALTRANSACTION is a CDS View in S/4HANA. Financial Transaction. It contains 64 fields. 24 CDS views read from this table.
CDS Views using this table (24)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CmmdtyHdgCnstltnTransOvw | view_entity | inner | COMPOSITE | Commodity Hedge Constellation Overview |
| I_FinancialTransactionDEX | view_entity | from | COMPOSITE | Financial Transaction |
| I_FinancialTransactionStdVH | view | from | COMPOSITE | FinancialTransaction |
| I_FinancialTransactionVH | view | from | COMPOSITE | Financial Transaction Value Help |
| I_FinTransActivityCategory | view | from | BASIC | Financial Transaction Activity Category |
| I_FinTransAdditionalAttribute | view | from | COMPOSITE | Financial Trans Additional Attribute |
| I_FinTransAttribute | view | from | COMPOSITE | Financial Transaction Attribute |
| I_FinTransCurrentActivity | view | inner | COMPOSITE | Financial Transaction Current Activity |
| I_FinTransFlowAcctgPaytInfo | view_entity | from | COMPOSITE | Main acctg payt info of a flow |
| I_FinTransOverallView | view | from | COMPOSITE | Financial Transaction Overall |
| I_Ftr_Cl_Key_Date_Utilization | view | inner | COMPOSITE | Facility Utilization by Key Date |
| I_Ftr_Cl_Utilize | view | inner | COMPOSITE | Facility Utilization With Contract Info |
| P_CmmdtyHedgeSwapCounterDeal | view | from | BASIC | Commodity Hedging Financial Transaction CD |
| P_CommodityHedgeSwap | view | from | COMPOSITE | Commodity Hedging Financial Transaction |
| P_FinancialTransactionManage | view | from | COMPOSITE | Manage Financial Transactions |
| P_FinTransFinancialObjectData | view | from | COMPOSITE | Financial Transaction - Financial Object Data |
| P_FINTRANSINTCOND | view | left_outer | COMPOSITE | Interest Condition for Financial Transactions |
| P_FinTransIntrstRateInstr | view | from | COMPOSITE | Fin Transaction Interest Rate Instrment |
| P_FinTransOpenFlowBusVol | view | inner | COMPOSITE | The Business Volume for Open Trans Flow |
| P_FXOptionTransBusVol | view | inner | COMPOSITE | Business Vol for FX Option Transaction |
| P_TFTRANSCASHFLOW | view | from | COMPOSITE | Nominal and Fee Flow for Trade Finance Transaction |
| P_TFTRANSFEECOND | view | left_outer | COMPOSITE | Fee Condition for Trade Finance Transactions |
| R_FinTransSecurityPaytFlow | view | inner | BASIC | Fin Trans Security Payment Flow |
| R_FinTransSecurityQuantityFlow | view | inner | BASIC | Fin Trans Security Quantity Flow |
Fields (64)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 8 |
| KEY | Counterparty | Counterparty | 8 |
| KEY | FinancialTransaction | FinancialTransaction | 8 |
| BusinessPlace | BusinessPlace | 2 | |
| ClassificationOfFinInstr | ClassificationOfFinInstr | 3 | |
| CostCenter | CostCenter | 2 | |
| CreatedByUser | CreatedByUser | 1 | |
| FinancialInstrCharacteristic | FinancialInstrCharacteristic | 2 | |
| FinancialInstrProductCategory | FinancialInstrProductCategory | 10 | |
| FinancialInstrTransactionType | FinancialInstrTransactionType | 9 | |
| FinancialInstrumentAssignment | FinancialInstrumentAssignment | 2 | |
| FinancialInstrumentGuarantor | FinancialInstrumentGuarantor | 2 | |
| FinancialInstrumentProductType | FinancialInstrumentProductType | 10 | |
| FinancialInstrumentReference | FinancialInstrumentReference | 2 | |
| FinancialInstrumentStatus | FinancialInstrumentStatus | 3 | |
| FinInstrLastActiveActivity | FinInstrLastActiveActivity | 1 | |
| FinInstrTransactionCategory | FinInstrTransactionCategory | 2 | |
| FinInstrumentIncomingCurrency | FinInstrumentIncomingCurrency | 2 | |
| FinInstrumentLastChangedTime | FinInstrumentLastChangedTime | 2 | |
| FinInstrumentOutgoingCurrency | FinInstrumentOutgoingCurrency | 2 | |
| FinTransAuthorizationGroup | FinTransAuthorizationGroup | 2 | |
| FinTransCreationDate | FinTransCreationDate | 2 | |
| FinTransCreationTime | FinTransCreationTime | 2 | |
| FinTransFactoryCalendar1 | FinTransFactoryCalendar1 | 1 | |
| FinTransFactoryCalendar2 | FinTransFactoryCalendar2 | 1 | |
| FinTransGeneralValuationClass | FinTransGeneralValuationClass | 2 | |
| FinTransIsRiskMitigating | FinTransIsRiskMitigating | 2 | |
| FinTransNoticePeriod | FinTransNoticePeriod | 2 | |
| FinTransNoticePeriodUnit | FinTransNoticePeriodUnit | 2 | |
| FinTransOptionNumber | FinTransOptionNumber | 1 | |
| FinTransReleaseStatus | FinTransReleaseStatus | 1 | |
| FinTransRoundingCategory | FinTransRoundingCategory | 2 | |
| FunctionalArea | FunctionalArea | 2 | |
| Fund | Fund | 2 | |
| GrantID | GrantID | 2 | |
| HedgeRequestIdentifier | HedgeRequestIdentifier | 1 | |
| HedgingClassification | HedgingClassification | 1 | |
| InternationalSecuritiesIdnNmbr | InternationalSecuritiesIdnNmbr | 2 | |
| LastChangeDate | LastChangeDate | 2 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| MarketIdentifierCode | MarketIdentifierCode | 2 | |
| OnBehalfOfCompany | OnBehalfOfCompany | 1 | |
| Portfolio | Portfolio | 6 | |
| ProfitCenter | ProfitCenter | 2 | |
| ReportTrackingNumber | ReportTrackingNumber | 2 | |
| SecurityAccount | SecurityAccount | 2 | |
| SecurityClass | SecurityClass | 1 | |
| Segment | Segment | 1 | |
| TermStartDate | TermStartDate | 3 | |
| TradedCurrency | TradedCurrency | 1 | |
| TransactionCurrency | TransactionCurrency | 4 | |
| TreasuryContractType | TreasuryContractType | 1 | |
| TreasuryFacility | TreasuryFacility | 2 | |
| TreasuryFacilityCompanyCode | TreasuryFacilityCompanyCode | 2 | |
| TreasuryFinanceProject | TreasuryFinanceProject | 2 | |
| TreasuryFinancialObject | TreasuryFinancialObject | 2 | |
| TrsyPosCustomDiffntnTerm1 | TrsyPosCustomDiffntnTerm1 | 2 | |
| TrsyPosCustomDiffntnTerm2 | TrsyPosCustomDiffntnTerm2 | 2 | |
| TrsyPosCustomDiffntnTerm3 | TrsyPosCustomDiffntnTerm3 | 2 | |
| TrsyPosCustomDiffntnTerm4 | TrsyPosCustomDiffntnTerm4 | 2 | |
| TrsyPosCustomDiffntnTerm5 | TrsyPosCustomDiffntnTerm5 | 2 | |
| TrsyTradedAmountBuySellCode | TrsyTradedAmountBuySellCode | 1 | |
| UniqueProductIdentifier | UniqueProductIdentifier | 2 | |
| WBSElementInternalID | WBSElementInternalID | 3 |
// harmonized annotations
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IFINTRAN'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION /* dataExtraction.enabled: true} */
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction'
@ObjectModel.representativeKey: 'FinancialTransaction'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true // For C1-Release
@VDM.viewType: #BASIC
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]
define view I_FinancialTransaction
as select from vtbfha as FinancialTransactionTable
// dimensions, containing for example text fields
association [1..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_TreasuryContractType as _ContractType on $projection.TreasuryContractType = _ContractType.TreasuryContractType
association [0..1] to I_FinancialInstrProdCat as _FinancialInstrProdCat on $projection.FinancialInstrProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory
association [0..1] to I_FinancialinstrProductType as _FinancialInstrProdType on $projection.FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType
association [0..1] to I_FinInstrTransCat as _FinInstrTransCat on $projection.FinancialInstrProductCategory = _FinInstrTransCat.FinancialInstrProductCategory
and $projection.FinInstrTransactionCategory = _FinInstrTransCat.FinInstrTransactionCategory
association [1..1] to I_FinancialInstrTransType as _FinancialInstrTransType on $projection.FinancialInstrTransactionType = _FinancialInstrTransType.FinancialInstrTransactionType
and $projection.FinancialInstrumentProductType = _FinancialInstrTransType.FinancialInstrumentProductType
association [0..1] to I_FinTransProcgCategory as _ProcessingCategory on $projection.FinancialInstrProductCategory = _ProcessingCategory.FinancialInstrProductCategory
and $projection.FinInstrTransactionCategory = _ProcessingCategory.FinInstrTransactionCategory
and $projection.FinTransProcessingCategory = _ProcessingCategory.FinTransProcessingCategory
association [0..1] to I_FinTransNoticePeriodUnit as _NoticePeriodUnit on $projection.FinTransNoticePeriodUnit = _NoticePeriodUnit.FinTransNoticePeriodUnit
association [0..1] to I_FactoryCalendar as _Calendar on $projection.FinTransFactoryCalendar1 = _Calendar.FactoryCalendar
association [0..1] to I_FactoryCalendar as _Calendar2 on $projection.FinTransFactoryCalendar2 = _Calendar2.FactoryCalendar
association [1..1] to I_BusinessPartner as _Counterparty on $projection.Counterparty = _Counterparty.BusinessPartner
association [0..1] to I_BusinessPartner as _Guarantor on $projection.FinancialInstrumentGuarantor = _Guarantor.BusinessPartner
association [0..1] to I_TreasuryPortfolio as _Portfolio on $projection.CompanyCode = _Portfolio.CompanyCode
and $projection.Portfolio = _Portfolio.Portfolio
association [0..1] to I_FinancialInstrAssignment as _Assignment on $projection.FinancialInstrumentAssignment = _Assignment.FinancialInstrumentAssignment
association [0..1] to I_FinancialInstrReference as _Reference on $projection.FinancialInstrumentReference = _Reference.FinancialInstrumentReference
association [0..1] to I_FinancialInstrCharacteristic as _Characteristics on $projection.FinancialInstrCharacteristic = _Characteristics.FinancialInstrCharacteristic
association [0..1] to I_Financialinstrvaluationclass as _ValuationClass on $projection.TreasuryValuationClass = _ValuationClass.FinancialInstrValuationClass
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..*] to I_CostCenter as _CostCenter on $projection.CompanyCode = _CostCenter.ControllingArea
and $projection.CostCenter = _CostCenter.CostCenter
association [0..*] to I_CostCenter as _CostCenter_2 on $projection.ControllingArea = _CostCenter_2.ControllingArea
and $projection.CostCenter = _CostCenter_2.CostCenter
association [0..1] to I_TreasuryHedgingClassfctn as _TreasuryHedgingClassfctn on $projection.HedgingClassification = _TreasuryHedgingClassfctn.HedgingClassification
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.CompanyCode = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
association [0..*] to I_ProfitCenter as _ProfitCenter_2 on $projection.ControllingArea = _ProfitCenter_2.ControllingArea
and $projection.ProfitCenter = _ProfitCenter_2.ProfitCenter
association [0..1] to I_WBSElementBasicData as _WBSElement on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
// view not C1-released
// association to I_WBSElement as _WBSElement on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
association [0..1] to I_CompanyCode as _FacilityCompanyCode on $projection.TreasuryFacilityCompanyCode = _FacilityCompanyCode.CompanyCode
association [0..1] to I_FinInstrumentStatus as _Status on $projection.FinancialInstrumentStatus = _Status.FinancialInstrumentStatus
association [0..1] to I_FinTransReleaseStatus as _ReleaseStatus on $projection.FinTransReleaseStatus = _ReleaseStatus.FinTransReleaseStatus
association [0..1] to I_Currency as _Currency on $projection.TransactionCurrency = _Currency.Currency
association [0..1] to I_Currency as _OutgoingCurrency on $projection.FinInstrumentOutgoingCurrency = _OutgoingCurrency.Currency
association [0..1] to I_Currency as _IncomingCurrency on $projection.FinInstrumentIncomingCurrency = _IncomingCurrency.Currency
association [0..1] to I_Currency as _TradedCurrency on $projection.TradedCurrency = _TradedCurrency.Currency
association [0..1] to I_SecurityClass as _SecurityClass on $projection.SecurityClass = _SecurityClass.SecurityClass
association [0..1] to I_SecurityAccount as _SecurityAccount on $projection.SecurityAccount = _SecurityAccount.SecurityAccount
and $projection.CompanyCode = _SecurityAccount.CompanyCode
association [0..1] to I_TreasuryPositionAccount as _FuturesAccount on $projection.CompanyCode = _FuturesAccount.CompanyCode
and $projection.FuturesAccount = _FuturesAccount.TreasuryPositionAccount
association [0..1] to I_FinTransCntrlClrgOption as _CentralClearingOption on $projection.FinTransCentralClearingOption = _CentralClearingOption.FinTransCentralClearingOption
association [0..1] to I_FinTransCntrlClrgStatus as _CentralClearingStatus on $projection.FinTransCentralClearingStatus = _CentralClearingStatus.FinTransCentralClearingStatus
association [0..*] to I_CentralClearingAccount as _CentralClearingAccount on $projection.CompanyCode = _CentralClearingAccount.CompanyCode
and $projection.CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount
// associations according to VDM
association [0..*] to I_FinTransContractActivity as _ContractActivity on $projection.CompanyCode = _ContractActivity.CompanyCode
and $projection.FinancialTransaction = _ContractActivity.FinancialTransaction
//for performance reason instead of using I_FinTransCurrentActivity directly access to I_FinTransActivity
association [0..1] to I_FinTransActivity as _CurrentActivity on $projection.CompanyCode = _CurrentActivity.CompanyCode
and $projection.FinancialTransaction = _CurrentActivity.FinancialTransaction
and $projection.FinInstrLastActiveActivity = _CurrentActivity.FinancialInstrumentActivity
association [0..1] to I_FinTransSecurity as _Security on $projection.CompanyCode = _Security.CompanyCode
and $projection.FinancialTransaction = _Security.FinancialTransaction
association [0..*] to I_FinTransInterest as _Interest on $projection.CompanyCode = _Interest.CompanyCode
and $projection.FinancialTransaction = _Interest.FinancialTransaction
association [0..*] to I_FinTransNominal as _Nominal on $projection.CompanyCode = _Nominal.CompanyCode
and $projection.FinancialTransaction = _Nominal.FinancialTransaction
association [0..*] to I_FinTransActivity as _TabActivity on $projection.CompanyCode = _TabActivity.CompanyCode
and $projection.FinancialTransaction = _TabActivity.FinancialTransaction
association [0..*] to I_FinTransFlow as _TabFlow on $projection.CompanyCode = _TabFlow.CompanyCode
and $projection.FinancialTransaction = _TabFlow.FinancialTransaction
association [0..*] to I_FinTransCondition as _TabCondition on $projection.CompanyCode = _TabCondition.CompanyCode
and $projection.FinancialTransaction = _TabCondition.FinancialTransaction
// should be not used anymore, instead use _CurrentActivity
association [0..1] to I_LetterOfCredit as _LetterOfCredit on $projection.CompanyCode = _LetterOfCredit.CompanyCode
and $projection.FinancialTransaction = _LetterOfCredit.FinancialTransaction
and $projection.FinInstrLastActiveActivity = _LetterOfCredit.FinancialInstrumentActivity
association [0..*] to I_TreasuryReferenceItem as _ReferenceItem on $projection.TreasuryFinancialObject = _ReferenceItem.TreasuryFinancialObject
and (
(
_ReferenceItem.TreasuryReferenceStatus = '0'
and(
_ReferenceItem.TreasuryReferenceItemStatus = '0'
or _ReferenceItem.TreasuryReferenceItemStatus = '8'
)
)
or(
_ReferenceItem.TreasuryReferenceCategory = 'OFF'
and _ReferenceItem.TreasuryReferenceItemStatus = '0'
and _ReferenceItem.TreasuryReferenceStatus = '4'
)
)
{
// Exposed fields
//--[ GENERATED:012:GlBfhyJl7kY4pGd}um{aL0
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CompanyCodeStdVH',
element: 'CompanyCode' }
}]
// ]--GENERATED
@ObjectModel.foreignKey.association: '_CompanyCode'
key FinancialTransactionTable.bukrs as CompanyCode,
key FinancialTransactionTable.rfha as FinancialTransaction,
FinancialTransactionTable.objnr as TreasuryFinancialObject,
FinancialTransactionTable.cruser as CreatedByUser,
cast( FinancialTransactionTable.dcrdat as ftr_creation_date preserving type ) as FinTransCreationDate,
FinancialTransactionTable.tcrtim as FinTransCreationTime,
cast(FinancialTransactionTable.upuser as vdm_lastchangedbyuserid preserving type) as LastChangedByUser,
FinancialTransactionTable.dupdat as LastChangeDate,
FinancialTransactionTable.tuptim as FinInstrumentLastChangedTime,
@ObjectModel.foreignKey.association: '_ContractType'
FinancialTransactionTable.rantyp as TreasuryContractType,
@ObjectModel.foreignKey.association: '_FinancialInstrProdCat'
cast(FinancialTransactionTable.sanlf as ftr_gen_fin_instr_prod_categ preserving type) as FinancialInstrProductCategory,
@ObjectModel.foreignKey.association: '_FinancialInstrProdType'
FinancialTransactionTable.sgsart as FinancialInstrumentProductType,
@ObjectModel.foreignKey.association: '_FinInstrTransCat'
FinancialTransactionTable.sfgtyp as FinInstrTransactionCategory,
@ObjectModel.foreignKey.association: '_FinancialInstrTransType'
cast(FinancialTransactionTable.sfhaart as ftr_gen_transaction_type preserving type) as FinancialInstrTransactionType,
@ObjectModel.foreignKey.association: '_ProcessingCategory'
FinancialTransactionTable.abwtyp as FinTransProcessingCategory,
FinancialTransactionTable.dblfz as TermStartDate,
cast(FinancialTransactionTable.sinclbe as abap_boolean preserving type ) as TermStartDateIsInclusive,
FinancialTransactionTable.akuend as FinTransNoticePeriod,
@ObjectModel.foreignKey.association: '_NoticePeriodUnit'
FinancialTransactionTable.skuend as FinTransNoticePeriodUnit,
@ObjectModel.foreignKey.association: '_Calendar'
FinancialTransactionTable.skalid as FinTransFactoryCalendar1,
@EndUserText.label: 'Calendar 2'
@EndUserText.quickInfo: 'Calendar 2'
@ObjectModel.foreignKey.association: '_Calendar2'
FinancialTransactionTable.skalid2 as FinTransFactoryCalendar2,
@ObjectModel.foreignKey.association: '_Counterparty'
cast(FinancialTransactionTable.kontrh as rkontrah_new preserving type) as Counterparty,
@ObjectModel.foreignKey.association: '_Guarantor'
FinancialTransactionTable.rgarant as FinancialInstrumentGuarantor,
@ObjectModel.foreignKey.association: '_Portfolio'
FinancialTransactionTable.rportb as Portfolio,
FinancialTransactionTable.zuonr as TreasuryFinanceProject,
@ObjectModel.foreignKey.association: '_Assignment'
cast(FinancialTransactionTable.zuond as ftr_gen_fin_instr_assignment preserving type) as FinancialInstrumentAssignment,
@ObjectModel.foreignKey.association: '_Reference'
cast(FinancialTransactionTable.refer as ftr_gen_fin_instr_internal_ref preserving type) as FinancialInstrumentReference,
@ObjectModel.foreignKey.association: '_Characteristics'
cast(FinancialTransactionTable.merkm as ftr_gen_fin_instr_char preserving type) as FinancialInstrCharacteristic,
@ObjectModel.foreignKey.association: '_ValuationClass'
FinancialTransactionTable.rcomvalcl as TreasuryValuationClass,
@ObjectModel.foreignKey.association: '_BusinessArea'
FinancialTransactionTable.rbusa as BusinessArea,
@ObjectModel.foreignKey.association: '_ControllingArea'
_CompanyCode.ControllingArea as ControllingArea,
@ObjectModel.foreignKey.association: '_CostCenter_2'
FinancialTransactionTable.rcntr as CostCenter,
@ObjectModel.foreignKey.association: '_TreasuryHedgingClassfctn'
FinancialTransactionTable.hedge_class as HedgingClassification,
cast( FinancialTransactionTable.hedge_request_id as hedge_request_identifier preserving type ) as HedgeRequestIdentifier,
@ObjectModel.foreignKey.association: '_ProfitCenter_2'
FinancialTransactionTable.prctr as ProfitCenter,
@ObjectModel.foreignKey.association: '_WBSElement'
cast(FinancialTransactionTable.ps_posid as ps_s4_pspnr preserving type ) as WBSElementInternalID,
@ObjectModel.foreignKey.association: '_FacilityCompanyCode'
FinancialTransactionTable.facilitybukrs as TreasuryFacilityCompanyCode,
FinancialTransactionTable.facilitynr as TreasuryFacility,
@ObjectModel.foreignKey.association: '_Status'
FinancialTransactionTable.saktiv as FinancialInstrumentStatus,
@ObjectModel.foreignKey.association: '_ReleaseStatus'
FinancialTransactionTable.sfrgzust as FinTransReleaseStatus,
@ObjectModel.foreignKey.association: '_Currency'
@Semantics.currencyCode: true
FinancialTransactionTable.wgschft as TransactionCurrency,
@ObjectModel.foreignKey.association: '_OutgoingCurrency'
@Semantics.currencyCode: true
FinancialTransactionTable.wgschft1 as FinInstrumentOutgoingCurrency,
@ObjectModel.foreignKey.association: '_IncomingCurrency'
@Semantics.currencyCode: true
FinancialTransactionTable.wgschft2 as FinInstrumentIncomingCurrency,
@ObjectModel.foreignKey.association: '_TradedCurrency'
@Semantics.currencyCode: true
FinancialTransactionTable.traded_currency as TradedCurrency,
@ObjectModel.foreignKey.association: '_SecurityClass'
cast(FinancialTransactionTable.ranl as ftr_gen_security_class preserving type) as SecurityClass,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'InternationalSecuritiesIdnNmbr'
FinancialTransactionTable.isin as SecurityClassIntlScrtyIdnNmbr,
FinancialTransactionTable.cfi_code as ClassificationOfFinInstr,
@ObjectModel.foreignKey.association: '_SecurityAccount'
cast(FinancialTransactionTable.rldepo as ftr_gen_security_account preserving type) as SecurityAccount,
@ObjectModel.foreignKey.association: '_FuturesAccount'
FinancialTransactionTable.posacc as FuturesAccount,
@ObjectModel.foreignKey.association: '_CentralClearingOption'
FinancialTransactionTable.clearing_option as FinTransCentralClearingOption,
@ObjectModel.foreignKey.association: '_CentralClearingStatus'
FinancialTransactionTable.clearing_status as FinTransCentralClearingStatus,
FinancialTransactionTable.clearing_date as FinTransCentralClearingDate,
FinancialTransactionTable.clear_date_act as FinTransCntrlClrgActualDate,
//foreign key association cannot be used as central clearing account has key UUID
//@ObjectModel.foreignKey.association: '_CentralClearingAccount'
FinancialTransactionTable.ext_account as CentralClearingAccount,
FinancialTransactionTable.risk_mitigating as FinTransIsRiskMitigating,
//field should be not provided, this should be part of activities
cast(FinancialTransactionTable.rfhazul as ftr_gen_fin_instr_last_act_act preserving type) as FinInstrLastActiveActivity,
//field should be not provided, this is filled inconsistent; alternative provide end date of last activity
FinancialTransactionTable.delfz as TermEndDate,
case FinancialTransactionTable.amtinput
when '1' then cast ('S' as ttm_fx_buy_sell)
when '2' then cast ('B' as ttm_fx_buy_sell)
end as TrsyTradedAmountBuySellCode,
FinancialTransactionTable.fb_segment as Segment,
FinancialTransactionTable.behalf_of_company as OnBehalfOfCompany,
FinancialTransactionTable.mic as MarketIdentifierCode,
FinancialTransactionTable.srndng as FinTransRoundingCategory,
FinancialTransactionTable.rcomvalcl as FinTransGeneralValuationClass,
FinancialTransactionTable.fund as Fund,
FinancialTransactionTable.grant_nbr as GrantID,
FinancialTransactionTable.tbegru as FinTransAuthorizationGroup,
FinancialTransactionTable.bupla as BusinessPlace,
FinancialTransactionTable.fkber as FunctionalArea,
FinancialTransactionTable.custom_diff_term_1 as TrsyPosCustomDiffntnTerm1,
FinancialTransactionTable.custom_diff_term_2 as TrsyPosCustomDiffntnTerm2,
FinancialTransactionTable.custom_diff_term_3 as TrsyPosCustomDiffntnTerm3,
FinancialTransactionTable.custom_diff_term_4 as TrsyPosCustomDiffntnTerm4,
FinancialTransactionTable.custom_diff_term_5 as TrsyPosCustomDiffntnTerm5,
FinancialTransactionTable.upi as UniqueProductIdentifier,
FinancialTransactionTable.isin as InternationalSecuritiesIdnNmbr,
FinancialTransactionTable.rtn as ReportTrackingNumber,
FinancialTransactionTable.rgatt as FinTransOptionNumber,
//exposed dimensions, containing for example text fields
_CompanyCode,
_ContractType,
_FinancialInstrProdCat,
_FinancialInstrProdType,
_FinInstrTransCat,
_FinancialInstrTransType,
_ProcessingCategory,
_NoticePeriodUnit,
_Calendar,
_Calendar2,
_Counterparty,
_Guarantor,
_Portfolio,
_Assignment,
_Reference,
_Characteristics,
_ValuationClass,
_ControllingArea,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_CostCenter_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_CostCenter_2'
_CostCenter,
_CostCenter_2,
_BusinessArea,
_TreasuryHedgingClassfctn,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ProfitCenter_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_ProfitCenter_2'
_ProfitCenter,
_ProfitCenter_2,
_WBSElement,
_FacilityCompanyCode,
_Status,
_ReleaseStatus,
_Currency,
_OutgoingCurrency,
_IncomingCurrency,
_TradedCurrency,
_SecurityClass,
_SecurityAccount,
_FuturesAccount,
_CentralClearingOption,
_CentralClearingStatus,
_CentralClearingAccount,
//exposed associations for VDM
_ContractActivity,
_CurrentActivity,
_Security,
_Interest,
_Nominal,
_TabActivity,
_TabFlow,
_TabCondition,
//should not be used anymore, instead use _CurrentActivity
_LetterOfCredit,
_ReferenceItem
}