Cashflow-Metadata_OPICS-MM

{"stream":"OpicsMMToCfMetadata","streamId":"05d582ab-b583-4587-b8d3-b32c60d3d4c2","sink":"CashFlowMetadata","sinkId":"42c7c794-a06b-45cf-b4d5-52721fc20ec6","source":"OPICS-MM","sourceId":"61e97eae-c6f0-4562-b999-b306c1398d6a","sourcePayload":{"TIME_SK":"20190831","CFN1":"NOMURA SINGAPORE LIMITED           ","BASIS":"A360","CCY":"USD","CCYAMT":31586.42,"CNO":"1401126940","DEALNO":"6305979 ","INTPAYCYCLE":"M","INTRATE":0.0192,"MDATE":"2025-01-14T00:00:00","PRODTYPE":"CL","PRODUCT":"IP    ","VDATE":"2018-12-14T00:00:00","ACCROUTST":45.48,"ACCRUED_INTEREST":null,"OUTSTANDING_AMOUNT":null,"SPOTRATE_8":null,"TIME_SK_TODATE":"2019-08-31T00:00:00","INTSTRTDTE":"2019-08-05T00:00:00","INTENDDTE":"2019-09-03T00:00:00","RATECODE":"FIXED","FLOAT_RATE":0.0192,"CASHFLOW_TYPE":"BULLET","INTEREST_REPAYMENTDATE":14.0,"INTEREST_REPAYMENTDAYTYPE":"SPECIFIC DATE","INTEREST_REPAYMENTFREQ":"M","INTEREST_REPAYMENTFREQNUM":1.0,"INTEREST_REPAYMENT_SCHEDULE":"FIXED","CURRENCY_INDICATOR":2.0,"STATUS":"ACTIVE","GAS_ACCOUNTING":"TREASURY"},"sinkPayload":{"contractId":{"trace":{"transformation":{"type":"ContractId","namespaceId":"8e713dab-7fbc-434a-99bb-89ff36390b2f","namespaceCode":"Contract","name":"20190831|||","contractIdTransformList":[{"transformation":{"result":"20190831","type":"Map","fromProperty":{"name":"TIME_SK","value":"20190831"}}},{"transformation":{"type":"Map","fromProperty":{"name":"CIFNO"},"errors":{"error":"The property: CIFNO is not found."}}},{"transformation":{"type":"Map","fromProperty":{"name":"ACCTNO"},"errors":{"error":"The property: ACCTNO is not found."}}}],"errors":{"error":"One of more transformation(s) return errors."}}}},"repaymentType":{"value":"Bullet","trace":{"transformation":{"result":"Bullet","type":"FixedValue","fromValue":"Bullet"}}},"creditConversionFactor":{"trace":{"transformation":{"type":"Null"}}},"interestScheduleType":{"value":"Fixed","trace":{"transformation":{"result":"Fixed","type":"FixedValue","fromValue":"Fixed"}}},"interestSchedulePeriod":{"value":"1","trace":{"transformation":{"result":"1","type":"If","expression":"INTPAYCYCLE = 'M'","expressionResult":true,"variables":[{"name":"INTPAYCYCLE","value":"M"}],"trace":{"transformation":{"result":"1","type":"FixedValue","fromValue":"1"}}}}},"interestScheduleTimeUnit":{"value":"M","trace":{"transformation":{"result":"M","type":"FixedValue","fromValue":"M"}}},"interestSchedulePaymentDay":{"value":"FollowMaturity","trace":{"transformation":{"result":"FollowMaturity","type":"FixedValue","fromValue":"FollowMaturity"}}},"interestScheduleDay":{"trace":{"transformation":{"type":"Null"}}},"principalScheduleType":{"trace":{"transformation":{"type":"Null"}}},"principalSchedulePeriod":{"trace":{"transformation":{"type":"Null"}}},"principalScheduleTimeUnit":{"trace":{"transformation":{"type":"Null"}}},"principalSchedulePaymentDay":{"trace":{"transformation":{"type":"Null"}}},"principalScheduleDay":{"trace":{"transformation":{"type":"Null"}}},"equalInstallmentScheduleType":{"trace":{"transformation":{"type":"Null"}}},"equalInstallmentSchedulePeriod":{"trace":{"transformation":{"type":"Null"}}},"equalInstallmentScheduleTimeUnit":{"trace":{"transformation":{"type":"Null"}}},"equalInstallmentSchedulePaymentDay":{"trace":{"transformation":{"type":"Null"}}},"equalInstallmentScheduleDay":{"trace":{"transformation":{"type":"Null"}}},"interestDayCountConvention":{"value":"Actual360","trace":{"transformation":{"result":"Actual360","type":"If","expression":"BASIS = 'A365' || BASIS = 'ACT365'","expressionResult":false,"variables":[{"name":"BASIS","value":"A360"}],"trace":{"transformation":{"result":"Actual360","type":"If","expression":"BASIS = 'A360'","expressionResult":true,"variables":[{"name":"BASIS","value":"A360"}],"trace":{"transformation":{"result":"Actual360","type":"FixedValue","fromValue":"Actual360"}}}}}}},"maturityType":{"value":"PayOff","trace":{"transformation":{"result":"PayOff","type":"FixedValue","fromValue":"PayOff"}}},"maturedType":{"value":"Extend","trace":{"transformation":{"result":"Extend","type":"FixedValue","fromValue":"Extend"}}},"maturedExtensionPeriod":{"value":"12","trace":{"transformation":{"result":"12","type":"FixedValue","fromValue":"12"}}},"maturedExtensionTimeUnit":{"value":"M","trace":{"transformation":{"result":"M","type":"FixedValue","fromValue":"M"}}},"maturedInterestType":{"value":"None","trace":{"transformation":{"result":"None","type":"FixedValue","fromValue":"None"}}},"installmentAmount":{"trace":{"transformation":{"type":"Null"}}},"interestRepaymentAmount":{"trace":{"transformation":{"type":"Null"}}},"principalRepaymentAmount":{"trace":{"transformation":{"type":"Null"}}},"installments":{"trace":{"transformation":{"type":"None"}}}},"messageId":"67be35e9-0012-423f-bb93-9ee48dc75bac","messageType":"TitaniumStream","quality":{"qualityIndex":5}}