FINS Credit Card System API - Implementation Template
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.
Module | Description |
---|---|
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. |
creditcards-post-payload | Create 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 Field | FINS DB Field | Description | |||
---|---|---|---|---|---|
id | ID | credit card id | |||
name | NAME | name of credit card | |||
cardType | CARD_TYPE | type of card - credit | |||
cardHolderName | CARD_HOLDER_NAME | name of the person holding the credit card | |||
cardNumber | CARD_NUMBER | 16 digit number displayed on the credit card. | |||
cardPin | CARD_PIN | pin of the credit card | |||
cardStatus | CARD_STATUS | status as active | inactive | locked | |
cardStatusChangedDate | CARD_STATUS_CHANGED_DATE | Date and time of the last change in card status | |||
expiryMonth | EXPIRY_MONTH | expiry month of the credit card | |||
expiryYear | EXPIRY_YEAR | expiry year of the credit card | |||
replacedCardId | REPLACED_CARD_ID | Identifier of the card this one replaces | |||
replacedCardReason | REPLACED_CARD_REASON | Indicates why this card was issued in place of a previous one | |||
maskedNumber | MASKED_NUMBER | masked number on the credit card | |||
cardToken | CARD_TOKEN | token issued for the credit card | |||
numberLastDigits | NUMBER_LAST_DIGITS | last 4 digits on the card | |||
securityCode | SECURITY_CODE | security code on the credit card | |||
creditCardType | CREDIT_CARD_TYPE | credit card type AMEX | DISCOVER | MASTERCARD | VISA |
cardOwnerId | CARD_OWNER_ID | Identifier of the individual this card is owned by | |||
globalAccountId | GLOBAL_ACCOUNT_ID | Global MDM Identifier of the associated account | |||
globalCreditCardId | GLOBAL_CREDITCARD_ID | Global MDM Identifier of the credit card | |||
auditInfo.createdBy | CREATED_BY | Identifies the system or user which created the entity | |||
auditInfo.createdDate | CREATED_DATETimestamp of when the entity was created - default as current timestamp | ||||
auditInfo.updatedBy | UPDATED_BY | Identifies the system or user which last updated the entity | |||
auditInfo.updatedDate | UPDATED_DATE | Timestamp of when the entity was last updated |
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 Field | FINS DB Field | Description | |||
---|---|---|---|---|---|
name | NAME | name of credit card | |||
cardType | CARD_TYPE | type of card - credit | debit | ||
cardHolderName | CARD_HOLDER_NAME | name of the person holding the credit card | |||
cardNumber | CARD_NUMBER | 16 digit number displayed on the credit card. | |||
cardPin | CARD_PIN | pin of the credit card | |||
cardStatus | CARD_STATUS | status as active | inactive | locked | |
cardStatusChangedDate | CARD_STATUS_CHANGED_DATE | Date and time of the last change in card status | |||
expiryMonth | EXPIRY_MONTH | expiry month of the credit card | |||
expiryYear | EXPIRY_YEAR | expiry year of the credit card | |||
replacedCardId | REPLACED_CARD_ID | Identifier of the card this one replaces | |||
replacedCardReason | REPLACED_CARD_REASON | Indicates why this card was issued in place of a previous one | |||
maskedNumber | MASKED_NUMBER | masked number on the credit card | |||
cardToken | CARD_TOKEN | token issued for the credit card | |||
numberLastDigits | NUMBER_LAST_DIGITS | last 4 digits on the card | |||
securityCode | SECURITY_CODE | security code on the credit card | |||
creditCardType | CREDIT_CARD_TYPE | credit card type AMEX | DISCOVER | MASTERCARD | VISA |
cardOwnerId | CARD_OWNER_ID | Identifier of the individual this card is owned by | |||
globalAccountId | GLOBAL_ACCOUNT_ID | Global MDM Identifier of the associated account | |||
globalCreditCardId | GLOBAL_CREDITCARD_ID | Global MDM Identifier of the credit card | |||
auditInfo.createdBy | CREATED_BY | Identifies the system or user which created the entity | |||
auditInfo.createdDate | CREATED_DATETimestamp of when the entity was created - default as current timestamp | ||||
auditInfo.updatedBy | UPDATED_BY | Identifies the system or user which last updated the entity | |||
auditInfo.updatedDate | UPDATED_DATE | Timestamp of when the entity was last updated |