Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "settings": {
- "enableTrace": "false"
- },
- "mappingRules": [
- {
- "name": "eMasODLoansToContracts",
- "description": "eMasODLoansToContracts",
- "condition": null,
- "sequence": 1,
- "mappings": [
- {
- "toProperty": "ReportingDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyMMdd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "TIME_SK",
- "comment": ""
- }
- }
- ]
- },
- {
- "toProperty": "BaseLgd",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "BasePd",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "BusinessUnit",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "CreditRating",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "CurrentPd",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "InitialPd",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "IsRestructured",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "FALSE"
- }
- ]
- },
- {
- "toProperty": "UndrawnAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "ActualAccruedInterestAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "GASAccounting",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "GASReporting",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "GlNumber",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "GolonganDebitur",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "MarketRate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "MaturityBehaviour",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "PAYOFF",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "WriteOffFlag",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "SecId",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "TypeOfBonds",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "Segment",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "BUNITD1_NM",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "entity",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "",
- "fromValue": "BMRI"
- }
- ]
- },
- {
- "toProperty": "originContractId",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODACCT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "AccruedInterest",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "",
- "fromValue": "0"
- }
- ]
- },
- {
- "toProperty": "originSystemId",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "",
- "fromValue": "EMAS-OD"
- }
- ]
- },
- {
- "toProperty": "CashFlowType",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "",
- "fromValue": "BULLET"
- }
- ]
- },
- {
- "toProperty": "IsSecured",
- "transformations": [
- {
- "type": "FixedValue",
- "comment": "",
- "fromValue": "FALSE"
- }
- ]
- },
- {
- "toProperty": "PresentValue",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCBAL",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "DaysPastDue",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODPDAY",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PrincipalAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCBAL",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PresentValueIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCBAL",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "outstandingAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "OUTSTANDING_AMOUNT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "productType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODTYP",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "productSubtype",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODTYP",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "collectibility",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "BIKOLE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "currency",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCTYP",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "contractId",
- "transformations": [
- {
- "type": "ContractId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "TIME_SK"
- },
- {
- "type": "Map",
- "fromProperty": "ODCIF"
- },
- {
- "type": "Map",
- "fromProperty": "ODACCT"
- }
- ]
- }
- ]
- },
- {
- "toProperty": "counterpartyId",
- "transformations": [
- {
- "type": "CounterpartyId",
- "parameters": [
- {
- "type": "Map",
- "fromProperty": "TIME_SK"
- },
- {
- "type": "Map",
- "fromProperty": "ODCIF"
- }
- ]
- }
- ]
- },
- {
- "toProperty": "DiscountRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODRATE"
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODRATE"
- }
- ]
- },
- {
- "toProperty": "EffectiveInterestRateIncludingFeesAndCosts",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODRATE"
- }
- ]
- },
- {
- "toProperty": "interestRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODRATE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CurrencyIndicator",
- "transformations": [
- {
- "type": "If",
- "expression": "ODCTYP = 'IDR'",
- "whenTrue": {
- "type": "FixedValue",
- "fromValue": "1"
- },
- "whenFalse": {
- "type": "FixedValue",
- "fromValue": "2"
- }
- }
- ]
- },
- {
- "toProperty": "CurrencyRate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "CURRENCY_RATE",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "limitAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODLIMT",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "startDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyddd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "ODOPN7"
- }
- }
- ]
- },
- {
- "toProperty": "maturityDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyddd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "ODMAT7"
- }
- }
- ]
- },
- {
- "toProperty": "actualOutstandingAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCBAL",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "AdditionalFee",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "AdditionalFeeDate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "BranchCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODBR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "BUCode",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "OFFICR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "CounterpartyName",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODSNM",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "OriginCounterpartyId",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCIF"
- }
- ]
- },
- {
- "toProperty": "OriginOutstandingAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCBAL",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PrincipalRepaymentAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCBAL"
- }
- ]
- },
- {
- "toProperty": "principalRepaymentDate",
- "transformations": [
- {
- "type": "Left",
- "length": "2",
- "parameter": {
- "type": "Map",
- "fromProperty": "ODMAT7"
- }
- }
- ]
- },
- {
- "toProperty": "PrincipalRepaymentDayType",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "PrincipalRepaymentFrequency",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "PrincipalRepaymentFrequencyNumber",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "PrincipalScheduleType",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "FIXED",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PsakClassification",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "LAR",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "WriteOffAmount",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCBAL"
- }
- ]
- },
- {
- "toProperty": "WriteOffDate",
- "transformations": [
- {
- "type": "DateConversion",
- "fromFormat": "yyyyddd",
- "toFormat": "yyyy-MM-dd",
- "parameter": {
- "type": "Map",
- "fromProperty": "ODSTS7"
- }
- }
- ]
- },
- {
- "toProperty": "Status",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODSTAT"
- }
- ]
- },
- {
- "toProperty": "InterestSpread",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "InterestCurve",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "BelowMarketFlag",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "IFreq",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "PurposeCode",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "CreditConversionFactor",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "CostAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "ExposureAtDefault",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "ExposureId",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "facilityType",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "FairValue",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "FeeAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "GroupType",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "InitialCreditRating",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "InstallmentAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "InterestRepaymentAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "InterestRepaymentDate",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "ODCYCI"
- }
- ]
- },
- {
- "toProperty": "InterestRepaymentDayType",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "OP2YRB"
- }
- ]
- },
- {
- "toProperty": "InterestRepaymentFrequency",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "InterestRepaymentFrequencyNumber",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "InterestScheduleType",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "LBUForm",
- "transformations": [
- {
- "type": "FixedValue",
- "fromValue": "F11"
- }
- ]
- },
- {
- "toProperty": "LtvRatio",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "MonthlyAccruedInterest",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "ObservationDate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "RecoveryAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "RecoveryDate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "RestructureDate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "RestructureFlag",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "RestructureSignificant",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "UnamortizeFeeSourceSystem",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "DisbursementAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "DisbursementDate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "economicSector",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "BISEK1"
- }
- ]
- },
- {
- "toProperty": "dayCountConvention",
- "transformations": [
- {
- "type": "Map",
- "fromProperty": "OP2YRB",
- "comment": ""
- }
- ]
- },
- {
- "toProperty": "PrepaymentAmount",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- },
- {
- "toProperty": "PrepaymentDate",
- "transformations": [
- {
- "type": "Null"
- }
- ]
- }
- ]
- }
- ]
- }
Add Comment
Please, Sign In to add comment