FINS Financial Institutions System API - Implementation Template

(0 reviews)

Data mappings

This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.

ModuleDescription
map-get-institutions-responseQuery Financial Institution Mapping from Core Banking System This dwl file is used by endpoints get:/institution/(institutionid) & get:/institutions
map-create-institutions-payloadCreate Institution Mapping for Core Banking System. Maps Banking Spec Account JSON to JSON which is used by stored procedure sp_FinancialInstitution_Upsert.

map-get-institutions-response

Query Financial Institution Mapping from Core Banking System
This dwl file is used by endpoints get:/institution/(institutionid) & get:/institutions

Source: ./src/main/resources/dwl/map-get-institutions-response.dwl

(back to top)

map-create-institutions-payload

Create Institution Mapping for Core Banking System.
Maps Banking Spec Account JSON to JSON which is used by stored procedure sp_FinancialInstitution_Upsert.

Source: ./src/main/resources/dwl/map-create-institutions-payload.dwl

Mapping Tables

Maps FinancialInstitution spec to JSON which is used by stored procedure - sp_FinancialInstitution_Upsert

Institution Spec FieldCore Banking DB FieldDescription
idIDInstitution id
nameNAMEname related to the institution
institutionTypeDESCRIPTIONdescriptrion about the institution
bankCodeCHECK_NUMBERbank code associated with this institution
headquartersCountryHEADQUARTERS_COUNTRYHeadquarter country of the institution
headquartersRegionHEADQUARTERS_REGIONHeadquarter region of the institution
headquartersCityHEADQUARTERS_CITYHeadquarter city of the institution
globalInstitutionIdGLOBAL_INSTITUTION_IDexternalId of the institution
auditInfo.createdByCREATED_BYIdentifies the system or user which created the entity
auditInfo.createdDateCREATED_DATETimestamp of when the entity was created - default as current timestamp
auditInfo.updatedByUPDATED_BYIdentifies the system or user which last updated the entity
auditInfo.updatedDateUPDATED_DATETimestamp of when the entity was last updated
auditInfo.isDeletedisDeletedIndicates whether or not the entity has been soft-deleted - default as false

(back to top)


Reviews

TypeTemplate
OrganizationMuleSoft
Published by
MuleSoft Solutions
Published onNov 8, 2023
Asset overview

Asset versions for 1.6.x

Asset versions
VersionActions
1.6.2
1.6.1
1.6.0