Sample Deal Extraction Request and Response in the JSON Format
Using the below example, you can extract the deal details of 4235832132 deal ID.
Sample Deal Extraction Request in the JSON Format
{
"C1-DealExtractionWebService":
{
"dealDetails":
{
"dealId" :"4235832132",
}
}
}
Sample Deal Extraction Response in the JSON Format
{
"C1-DealExtractionWebService":
{
"dealDetails":
{
"dealEntityDetails":
{
"personIdentifierType" :"COREG"
"personIdentifier" :"Reg_SRP230520220852"
"personId" :"2003447796"
"division" :"IND"
}
"dealIdentifier" :"Deal_Reg_SRP230520220852_v1",
"dealInformation" :"4235832132,SRP230520220852,IND,05-23-2022,United States Dollars,Contracted Deal-No,(1),Deal_Reg_SRP230520220852_v1 ,Deal_Reg_SRP190520220205_v1 desc,INDIA DIVISION,Tier, ,Business banking,Deal type code for Deal Approval,Fully Orchestrated,Customer,System Default,Template-Yes,RMBK1 ,05-23-2022, ,05-23-2023,Yearly,Yearly,05-23-2022,05-23-2022, ,Skip Reference-Yes,Account,2003447796,Yearly,05-23-2022, ,05-23-2022,04-23-2023,Skip Questionaire-Yes, ,Include Hierarchy-Yes",
"dealId" :"4235832132",
"modelId" :"9284270861",
"dealEntityType" :"EPER",
"customerSegment" :"COMM",
"customerTier" :"T",
"division" :"IND",
"accessGrp" :"***",
"dealEntityId" :"2003447796",
"contractedDealFlag" :"false",
"currency" :"USD",
"dealTypeCode" :"DLAPR",
"startDate" :"2022-05-23",
"simulationTypeFlag" :"CUST",
"reviewFrequency" :"12",
"dealDescription" :"Deal_Reg_SRP190520220205_v1 desc",
"dealVersionDescription" :"Deal_Reg_SRP190520220205_v1 ver",
"dealFrequency" :"12",
"skipReferenceFlag" :"true",
"priceSelectionDate" :"2022-05-23",
"usagePeriod" :"12",
"includeHierarchyFlag" :"true",
"status" :"FORC",
"dealVersionStatus" :"FNAL",
"templateFlag" :"true",
"createdDate" :"2022-05-23",
"acceptanceDate" :"2022-05-23",
"finalizedDate" :"2022-05-23",
"effectiveStartDate" :"2022-05-23",
"reviewedDate" :"2023-05-23",
}
"templateReferenceDetails" :
{
"copyBasicDetailsFlag" :"false",
"copyPricingFlag" :"false",
"copyUsageFlag" :"false",
}
"dealCharacteristics" :
{
{
"effectiveDate" :"2021-01-01",
"characteristicType" :"PROA",
"characteristicValue" :"N",
}
{
"effectiveDate" :"2021-01-01",
"characteristicType" :"PROS1",
"characteristicValue" :"N",
}
}
"dealTermsAndConditionsDetails" :
{
"termsAndConditionsList" :
{
"termsAndCondition" :"DEAL_T&C1",
"description" :"DEAL_T&C1",
"termsAndConditionText" :"DEAL_T&C1",
}
"termsAndConditionsList" :
{
"termsAndCondition" :"DEAL_T&C2",
"description" :"DEAL_T&C2",
"termsAndConditionText" :"DEAL_T&C2",
}
}
"referenceDetails" :
{
"referUsageSw" :"false",
"referPriceSw" :"false",
"includeChildHierarchyFlag" :"false",
}
"dealComments" :
{
{
"sequenceNo" :"2",
"commentsDateTime" :"2022-05-23T12:12:31+10:00",
"user" :"RMBK1",
"dealComments" :"deal accepted 6364316717",
}
{
"sequenceNo" :"1",
"commentsDateTime" :"2022-05-23T11:42:29+10:00",
"user" :"PMBK1",
"dealComments" :"to test weighted commitment",
"reasonCode" :"RETURN",
}
}
"dealSimulationDetails" :
{
"dealFinancialSummaryDetails" :
{
"approvalStatus" :"",
"originalDealFinancialSummary" :
{
"revenue" :"$3,600.00",
"cost" :"$460.00",
"profit" :"$3,140.00",
"profitabilityPercentage" :"87.22",
}
"proposedDealFinancialSummary" :
{
"revenue" :"$38,862.50",
"cost" :"$1,692.00",
"profit" :"$37,170.50",
"profitabilityPercentage" :"95.65",
}
}
}
"hierarchySimulationDetails" :
{
"hierarchyDetails" :
{
"entityType" :"PERS",
"entityId" :"2003447796",
"entityIdentifierTyoe" :"COREG",
"entityIdentifierValue" :"Reg_SRP230520220852",
"entityDivision" :"IND",
"status" :"Approved",
"revenueVariation" :"979.51",
"proposedRevenue" :"$38,862.50",
"proposedCost" :"$1,692.00",
"originalRevenue" :"$3,600.00",
"originalCost" :"$460.00",
}
"hierarchyDetails" :
{
"entityType" :"ACCT",
"entityId" :"2087243494",
"entityIdentifierTyoe" :"C1_F_ANO",
"entityIdentifierValue" :"EAI_SRP230520220852",
"entityDivision" :"IND",
"parentEntityId" :"2003447796",
"parentEntityIdentifierType" :"COREG",
"parentEntityIdentifierValue" :"Reg_SRP230520220852",
"parentEntityDivision" :"IND"
"status" :"Approved",
"revenueVariation" :"208.09",
"proposedRevenue" :"$11,091.14",
"proposedCost" :"$744.76",
"originalRevenue" :"$3,600.00",
"originalCost" :"$460.00",
}
"hierarchyDetails" :
{
"entityType" :"ACCT",
"entityId" :"2087243494",
"entityIdentifierTyoe" :"C1_F_ANO",
"entityIdentifierValue" :"EAI_SRP230520220852",
"entityDivision" :"IND",
"parentEntityId" :"2003447796",
"parentEntityIdentifierType" :"COREG",
"parentEntityIdentifierValue" :"Reg_SRP230520220852",
"parentEntityDivision" :"IND"
"status" :"Approved",
"revenueVariation" :"208.09",
"proposedRevenue" :"$11,091.14",
"proposedCost" :"$744.76",
"originalRevenue" :"$3,600.00",
"originalCost" :"$460.00",
}
}
"dealPricingAndCommitment" :
{
"pricingAndCommitmentsDetails" :
{
"entityId" :"2070828708",
"entityType" :"PERS",
"entityIdentifierTyoe" :"COREG",
"entityIdentifierValue" :"Reg_SRP230520220852_PRSPCH1",
"entityDivision" :"IND",
"pricingDetails" :
{
"priceAsgnId" :"3520032357",
"priceItemCode" :"NPI_023",
"priceItemDescription" :"Price Item NPI_023",
"hierarchyDetails" :"CORPORATE BANKING, ACCOUNT SERVICES",
"pricingStatus" :"ACTV",
"priceCurrencyCode" :"USD",
"rateSchedule" :"DM-RT01",
"startDate" :"2021-01-01",
"isEligible" :"false",
"assignmentLevel" :"Parent Customer Price List",
"paTypeFlag" :"RGLR",
"printIfZero" :"Y",
"txnDailyRatingCrt" :"DNRT",
"ignoreSw" :"N",
"aggregateSw" :"Y",
"scheduleCode" :"MONTHLY",
"priceCompDetails" "
{
"priceCompId" :"3529900005",
"priceCompDesc" :"FLAT",
"valueAmt" :"25.000000000000000000",
"displaySw" :"true",
"rcMapId" :"1705351562",
"tieredFlag" :"FLAT",
"priceCompSequenceNo" :"10",
}
}
"pricingDetails" :
{
"priceAsgnId" :"3520032356",
"priceItemCode" :"NPI_022",
"priceItemDescription" :"Price Item NPI_022",
"hierarchyDetails" :"CORPORATE BANKING, ACCOUNT SERVICES",
"pricingStatus" :"ACTV",
"priceCurrencyCode" :"USD",
"rateSchedule" :"DM-RT01",
"startDate" :"2021-01-01",
"isEligible" :"false",
"assignmentLevel" :"Parent Customer Price List",
"paTypeFlag" :"RGLR",
"printIfZero" :"Y",
"txnDailyRatingCrt" :"DNRT",
"ignoreSw" :"N",
"aggregateSw" :"Y",
"scheduleCode" :"MONTHLY",
"priceCompDetails" "
{
"priceCompId" :"3529900005",
"priceCompDesc" :"FLAT",
"valueAmt" :"25.000000000000000000",
"displaySw" :"true",
"rcMapId" :"1705351562",
"tieredFlag" :"FLAT",
"priceCompSequenceNo" :"10",
}
}
"pricingDetails" :
{
"priceAsgnId" :"3520032355",
"priceItemCode" :"NPI_021",
"priceItemDescription" :"Price Item NPI_021",
"hierarchyDetails" :"CORPORATE BANKING, ACCOUNT SERVICES",
"pricingStatus" :"ACTV",
"priceCurrencyCode" :"USD",
"rateSchedule" :"DM-RT01",
"startDate" :"2021-01-01",
"isEligible" :"false",
"assignmentLevel" :"Parent Customer Price List",
"paTypeFlag" :"RGLR",
"printIfZero" :"Y",
"txnDailyRatingCrt" :"DNRT",
"ignoreSw" :"N",
"aggregateSw" :"Y",
"scheduleCode" :"MONTHLY",
"priceCompDetails" "
{
"priceCompId" :"3529900009",
"priceCompDesc" :"FLAT",
"valueAmt" :"25.000000000000000000",
"displaySw" :"true",
"rcMapId" :"1705351562",
"tieredFlag" :"FLAT",
"priceCompSequenceNo" :"10",
}
}
"commitmentDetails" :
{
"priceItemCode" :"NPI_021",
"priceItemDescription" :"Price Item NPI_021",
"parameterDetails" :
"SQIDetails" :
{
"serviceQuantityIdentifier" :"BK-NBR",
"sqiValue" :"2.800000000000000000",
"sqiTypeFlg" :"PRPD",
}
}
"commitmentDetails" :
{
"priceItemCode" :"NPI_022",
"priceItemDescription" :"Price Item NPI_022",
"parameterDetails" :
"SQIDetails" :
{
"serviceQuantityIdentifier" :"BK-NBR",
"sqiValue" :"2.00000000000000000",
"sqiTypeFlg" :"PRPD",
}
}
"commitmentDetails" :
{
"priceItemCode" :"NPI_023",
"priceItemDescription" :"Price Item NPI_023",
"parameterDetails" :
"SQIDetails" :
{
"serviceQuantityIdentifier" :"BK-NBR",
"sqiValue" :"2.00000000000000000",
"sqiTypeFlg" :"PRPD",
}
}
"termsAndConditionsDetails" :
{
"priceItemCode" :"PI_021",
"priceItemDescription" :"V1-Account Opening Fee",
"termsAndConditionsList" :
{
"termsAndCondition" :"DEAL_T&C3",
"description" :"DEAL_T&C3",
"termsAndConditionText" :"DEAL_T&C3",
}
{
"termsAndCondition" :"DEAL_T&C4",
"description" :"DEAL_T&C4",
"termsAndConditionText" :"DEAL_T&C4",
}
}
{
"priceItemGroupCode" :"ACCOUNT SERVICES",
"priceItemGroupCodeDescription" :"Account Services",
"termsAndConditionsList" :
{
"termsAndCondition" :"DEAL_T&C5",
"description" :"DEAL_T&C5",
"termsAndConditionText" :"DEAL_T&C5",
}
{
"termsAndCondition" :"DEAL_T&C6",
"description" :"DEAL_T&C6",
"termsAndConditionText" :"DEAL_T&C6",
}
}
{
"priceItemGroupCode" :"CORPORATE BANKING",
"priceItemGroupCodeDescription" :"Corporate Banking",
"termsAndConditionsList" :
{
"termsAndCondition" :"DEAL_T&C7",
"description" :"DEAL_T&C7",
"termsAndConditionText" :"DEAL_T&C7",
}
{
"termsAndCondition" :"DEAL_T&C8",
"description" :"DEAL_T&C8",
"termsAndConditionText" :"DEAL_T&C8",
}
}
}
{
"entityId" :"2003447796",
"entityType" :"PERS",
"entityIdentifierTyoe" :"COREG",
"entityIdentifierValue" :"Reg_SRP230520220852",
"entityDivision" :"IND",
"pricingDetails" :
{
"priceAsgnId" :"3520032358",
"priceItemCode" :"NPI_024",
"priceItemDescription" :"Price Item NPI_024",
"hierarchyDetails" :"CORPORATE BANKING, ACCOUNT SERVICES",
"cost" :"$460.00"
"revenue" :"$3,600.00",
"averagePrice" :"$24.00"
"pricingStatus" :"ACTV",
"priceCurrencyCode" :"USD",
"rateSchedule" :"DM-RT01",
"startDate" :"2021-01-01",
"isEligible" :"false",
"assignmentLevel" :"Customer Price List",
"paTypeFlag" :"RGLR",
"printIfZero" :"Y",
"txnDailyRatingCrt" :"DNRT",
"ignoreSw" :"N",
"aggregateSw" :"Y",
"scheduleCode" :"MONTHLY",
"priceCompDetails" "
{
"priceCompId" :"3529900007",
"priceCompDesc" :"FLAT",
"valueAmt" :"25.000000000000000000",
"displaySw" :"true",
"rcMapId" :"1705351562",
"tieredFlag" :"FLAT",
"priceCompSequenceNo" :"10",
}
}
"commitmentDetails" :
{
"priceItemCode" :"NPI_024",
"priceItemDescription" :"Price Item NPI_024",
"parameterDetails" :
"SQIDetails" :
{
"serviceQuantityIdentifier" :"BK-NBR",
"sqiValue" :"175.000000000000000000",
"sqiTypeFlg" :"PRPD",
}
{
"serviceQuantityIdentifier" :"BK-NBR",
"sqiValue" :"150.000000000000000000",
"sqiTypeFlg" :"ACTV",
}
}
"termsAndConditionsDetails" :
{
"priceItemCode" :"PI_024",
"priceItemDescription" :"V1-Account Opening Fee",
"termsAndConditionsList" :
{
"termsAndCondition" :"DEAL_T&C3",
"description" :"DEAL_T&C3",
"termsAndConditionText" :"DEAL_T&C3",
}
{
"termsAndCondition" :"DEAL_T&C4",
"description" :"DEAL_T&C4",
"termsAndConditionText" :"DEAL_T&C4",
}
}
{
"priceItemGroupCode" :"ACCOUNT SERVICES",
"priceItemGroupCodeDescription" :"Account Services",
"termsAndConditionsList" :
{
"termsAndCondition" :"DEAL_T&C5",
"description" :"DEAL_T&C5",
"termsAndConditionText" :"DEAL_T&C5",
}
{
"termsAndCondition" :"DEAL_T&C6",
"description" :"DEAL_T&C6",
"termsAndConditionText" :"DEAL_T&C6",
}
}
{
"priceItemGroupCode" :"CORPORATE BANKING",
"priceItemGroupCodeDescription" :"Corporate Banking",
"termsAndConditionsList" :
{
"termsAndCondition" :"DEAL_T&C7",
"description" :"DEAL_T&C7",
"termsAndConditionText" :"DEAL_T&C7",
}
{
"termsAndCondition" :"DEAL_T&C8",
"description" :"DEAL_T&C8",
"termsAndConditionText" :"DEAL_T&C8",
}
}
}
}
"entitycharacteristics>
{
"entityId" :"NPI_021",
"entityType" :"PRICEITEM",
"entityCharacteristicsList" :
{
"effectiveDate" :"2015-01-01",
"characteristicType" :"PPSEQ",
"characteristicValue" :"10",
}
}
{
"entityId" :"NPI_022",
"entityType" :"PRICEITEM",
"entityCharacteristicsList" :
{
"effectiveDate" :"2015-01-01",
"characteristicType" :"PPSEQ",
"characteristicValue" :"10",
}
}
{
"entityId" :"NPI_022",
"entityType" :"PRICEITEM",
"entityIdentifierType" :"C1_F_ANO",
"entityIdentifierValue" :"EAI_SRP230520220852",
"entityDivision" :"IND",
"entityCharacteristicsList" :
{
"effectiveDate" :"2021-05-05",
"characteristicType" :"C1_F_ANO",
"characteristicValue" :"1298312131",
}
"entityCharacteristicsList" :
{
"effectiveDate" :"2021-05-05",
"characteristicType" :"C1_F_ATY",
"characteristicValue" :"SAVINGS",
}
"entityCharacteristicsList" :
{
"effectiveDate" :"2021-03-03",
"characteristicType" :"VG_STATE",
"characteristicValue" :"MH",
}
}
{
"entityId" :"2003447796",
"entityType" :"PERS",
"entityIdentifierType" :"COREG",
"entityIdentifierValue" :"Reg_SRP230520220852",
"entityDivision" :"IND",
"entityCharacteristicsList" :
{
"effectiveDate" :"2022-03-04",
"characteristicType" :"C1-GENDR",
"characteristicValue" :"MALE",
}
"entityCharacteristicsList" :
{
"effectiveDate" :"2022-03-04",
"characteristicType" :"C1_BRTDT",
"characteristicValue" :"1994-03-20",
}
"entityCharacteristicsList" :
{
"effectiveDate" :"2022-03-04",
"characteristicType" :"PERAGE",
"characteristicValue" :"63",
}
}
{
"entityId" :"2070828708",
"entityType" :"PERS",
"entityIdentifierType" :"COREG",
"entityIdentifierValue" :"Reg_SRP230520220852",
"entityDivision" :"IND",
"entityCharacteristicsList" :
{
"effectiveDate" :"2022-03-04",
"characteristicType" :"C1-GENDR",
"characteristicValue" :"MALE",
}
"entityCharacteristicsList" :
{
"effectiveDate" :"2022-03-04",
"characteristicType" :"C1_BRTDT",
"characteristicValue" :"1994-03-20",
}
"entityCharacteristicsList" :
{
"effectiveDate" :"2022-03-04",
"characteristicType" :"PERAGE",
"characteristicValue" :"63",
}
}
}
Related Topics
For more information on... | See... |
---|---|
Deal extraction request and response attribute/value pairs in the JSON format | Deal Extraction Request and Response - Attribute/Value Pairs in the JSON Format |