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 |