FINS Credit Card 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
creditcards-patch-payloadCreate Card Mapping for MDM System Maps Bankspec Credit Card to payload which is used as input parameter in the update query of CREDIT_CARD table. The fields in both CIM and MDM are identical. PATCH payload is created by validating the Input Request payload with DB Record Payload.
creditcards-post-payloadCreate Cards Mapping for Credit Cards System API.

creditcards-patch-payload

Create Card Mapping for MDM System
Maps Bankspec Credit Card to payload which is used as input parameter in the update query of CREDIT_CARD table.
The fields in both CIM and MDM are identical.
PATCH payload is created by validating the Input Request payload with DB Record Payload.

Source: ./src/main/resources/dwl/creditcards-patch-payload.dwl

Variables

var mdmCreditCardId

payloadRecordfromDB is the existing Financial Card record in MDM system

Mapping Tables

Maps Banking Spec CREDIT Cards to JSON which is used by stored procedure - sp_CreditCard_Upsert

Banking Spec FieldFINS DB FieldDescription
idIDcredit card id
nameNAMEname of credit card
cardTypeCARD_TYPEtype of card - credit
cardHolderNameCARD_HOLDER_NAMEname of the person holding the credit card
cardNumberCARD_NUMBER16 digit number displayed on the credit card.
cardPinCARD_PINpin of the credit card
cardStatusCARD_STATUSstatus as activeinactivelocked
cardStatusChangedDateCARD_STATUS_CHANGED_DATEDate and time of the last change in card status
expiryMonthEXPIRY_MONTHexpiry month of the credit card
expiryYearEXPIRY_YEARexpiry year of the credit card
replacedCardIdREPLACED_CARD_IDIdentifier of the card this one replaces
replacedCardReasonREPLACED_CARD_REASONIndicates why this card was issued in place of a previous one
maskedNumberMASKED_NUMBERmasked number on the credit card
cardTokenCARD_TOKENtoken issued for the credit card
numberLastDigitsNUMBER_LAST_DIGITSlast 4 digits on the card
securityCodeSECURITY_CODEsecurity code on the credit card
creditCardTypeCREDIT_CARD_TYPEcredit card type AMEXDISCOVERMASTERCARDVISA
cardOwnerIdCARD_OWNER_IDIdentifier of the individual this card is owned by
globalAccountIdGLOBAL_ACCOUNT_IDGlobal MDM Identifier of the associated account
globalCreditCardIdGLOBAL_CREDITCARD_IDGlobal MDM Identifier of the credit card
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

(back to top)

creditcards-post-payload

Create Cards Mapping for Credit Cards System API.

Source: ./src/main/resources/dwl/creditcards-post-payload.dwl

Mapping Tables

Maps Banking Spec CREDIT Cards to JSON which is used by stored procedure - sp_CreditCard_Upsert

Banking Spec FieldFINS DB FieldDescription
nameNAMEname of credit card
cardTypeCARD_TYPEtype of card - creditdebit
cardHolderNameCARD_HOLDER_NAMEname of the person holding the credit card
cardNumberCARD_NUMBER16 digit number displayed on the credit card.
cardPinCARD_PINpin of the credit card
cardStatusCARD_STATUSstatus as activeinactivelocked
cardStatusChangedDateCARD_STATUS_CHANGED_DATEDate and time of the last change in card status
expiryMonthEXPIRY_MONTHexpiry month of the credit card
expiryYearEXPIRY_YEARexpiry year of the credit card
replacedCardIdREPLACED_CARD_IDIdentifier of the card this one replaces
replacedCardReasonREPLACED_CARD_REASONIndicates why this card was issued in place of a previous one
maskedNumberMASKED_NUMBERmasked number on the credit card
cardTokenCARD_TOKENtoken issued for the credit card
numberLastDigitsNUMBER_LAST_DIGITSlast 4 digits on the card
securityCodeSECURITY_CODEsecurity code on the credit card
creditCardTypeCREDIT_CARD_TYPEcredit card type AMEXDISCOVERMASTERCARDVISA
cardOwnerIdCARD_OWNER_IDIdentifier of the individual this card is owned by
globalAccountIdGLOBAL_ACCOUNT_IDGlobal MDM Identifier of the associated account
globalCreditCardIdGLOBAL_CREDITCARD_IDGlobal MDM Identifier of the credit card
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

(back to top)


Reviews

TypeTemplate
OrganizationMulesoft
Published by
MuleSoft Organization
Published onDec 13, 2023
Asset overview

Asset versions for 1.5.x

Asset versions
VersionActions
1.5.2