Card
| Field Name | Field Type | Mandatory | Details |
|---|---|---|---|
| REPORTING_DATE | DATE | Yes | YYYY-MM-DD. Report creation date |
| INSTITUTION_ID | NUMBER(6,0) | Yes | The institution ID setup in Enfuce system, “Branch code” in API. |
| CARD_ID | NUMBER(18,0) | Yes | Enfuce system generated Card ID. |
| CARD_REFERENCE_NUMBER | VARCHAR2(255) | Yes | Enfuce generated unique card identifier. |
| ADD_INFO | VARCHAR2(3900) | No | Additional field which contains miscellaneous data of the card. Data is marked with tags. Contact Enfuce for tags relevant to you. |
| BANK_OFFICER_ID | NUMBER(18,0) | No | Last officer that updated the record. |
| BASE_CURRENCY | VARCHAR2(3) | Yes | ISO 4217 Number. |
| BRANCH_ID | NUMBER(18,0) | No | Financial institution branch identifier. |
| CUSTOMER_ID | NUMBER(18,0) | Yes | Foreign key to customer dimension. CustomerId in API calls. |
| CUSTOMER_REG_NO | VARCHAR2(32) | Yes | Foreign key to customer dimension. Mandatory if client SSN is agreed to be included in files, otherwise field is always empty. |
| CUSTOMER_NUMBER | VARCHAR2(255) | Yes | Foreign key to customer dimension. |
| CLOSING_DATE | DATE | No | YYYY-MM-DD. |
| OPENING_DATE | DATE | Yes | YYYY-MM-DD. Date when the PAN was originally created. Value is inherited to the new PAN when card is replaced. |
| EMBOSSING_DATE | DATE | No | YYYY-MM-DD. Date when the card was produced. |
| EMBOSSED_COMPANY_NAME | VARCHAR2(255) | No | Company name embossed on the card. |
| EMBOSSED_FIRST_NAME | VARCHAR2(255) | No | First name embossed on the card. |
| EMBOSSED_LAST_NAME | VARCHAR2(255) | No | Last name embossed on the card. |
| EXPIRY_DATE | DATE | No | YYYY-MM-DD. Last date of validity for the card. |
| LOST_CARD_ID | VARCHAR2(255) | No | Card ID of the previous card when the card is a replacement card. |
| MAIN_CONTRACT_IDT | NUMBER(18,0) | No | Enfuce generated ID for account to which a card is linked. |
| MAIN_CONTRACT_NUMBER | VARCHAR2(255) | No | Foreign key to an account to which a card is linked to. Can be inputted in an application. If not inputted, Enfuce will generate the value. |
| MASKED_CARD_NUMBER | VARCHAR2(255) | No | Truncated card number. First 6 and last 4 digits. |
| PARENT_CONTRACT_IDT | NUMBER(18,0) | No | Enfuce generated ID for parent account. |
| PARENT_CONTRACT_NUMBER | VARCHAR2(255) | No | Foreign key to Account dimension referring to parent account. |
| PLASTIC_STATUS | VARCHAR2(1) | Yes | Status of the card’s plastic. Possible values: Active, Closed, Locked. |
| SEQUENCE_NUMBER | VARCHAR2(32) | No | The sequence number of the card’s plastic. |
| CARD_PROD_EVENT_NAME | VARCHAR2(255) | No | See possible values in separate card production event documentation. |
| CARD_PROD_EVENT_CODE | VARCHAR2(32) | No | See possible values in separate card production event documentation. |
| CARD_STATUS_NAME | VARCHAR2(255) | Yes | See possible values in separate card status documentation. |
| CARD_STATUS_CODE | VARCHAR2(32) | Yes | See possible values in separate card status documentation. |
| PLASTIC_TYPE_NAME | VARCHAR2(255) | Yes | |
| PLASTIC_TYPE_CODE | VARCHAR2(32) | Yes | |
| CARD_INTERFACE | VARCHAR2(1)) | No | Card interface (contact, contactless, combined, micro tag). |
| PRODUCT_NAME | VARCHAR2(255) | Yes | Product name configured in Enfuce system. |
| PRODUCT_CODE | VARCHAR2(255) | Yes | Product name configured in Enfuce system. |
| RECORD_DATE_FROM | DATA | Yes | YYYY-MM-DD. Date from which record version is effective. |
| RECORD_DATE_TO | DATA | Yes | YYYY-MM-DD. Expiry date of record version effective term. |
| PRIMARY_APPLET_IDT | VARCHAR2(255) | Main card ID. Links the All-in-One main card and applet card. Only used for All-in-One cards, for other products ignore. |
Card Address
| Field Name | Field Type | Mandatory | Details |
|---|---|---|---|
| REPORTING_DATE | DATE | Yes | YYYY-MM-DD. Report creation date. |
| INSTITUTION_ID | NUMBER(6,0) | Yes | The institution ID setup in Enfuce system,”Branch code” in API. |
| CARD_ID | NUMBER(18,0) | Yes | Enfuce system generated Card ID. |
| CARD_REFERENCE_NUMBER | VARCHAR2(255) | Yes | Enfuce generated unique card identifier. |
| ADDRESS_TYPE_NAME | VARCHAR2(255)) | Yes | Type of address used for card entity. Possible values: Card Delivery, PIN Mailer. |
| ADDRESS_TYPE_CODE | NUMBER(18,0) | Yes | Code for address type used for card entity. Possible values: CARD, PIN. |
| ADDRESS_LINE_1 | VARCHAR2(255) | No | First address line. Example: Kings street 12. |
| ADDRESS_LINE_2 | VARCHAR2(255) | No | Second address line. |
| ADDRESS_LINE_3 | VARCHAR2(255) | No | Third address line. |
| ADDRESS_LINE_4 | VARCHAR2(255) | No | Fourth address line. |
| ADDRESS_TYPE_ID | NUMBER(3,0)) | No | Identifier for address type used. Possible values: 445, 447. |
| ADDRESS_ZIP | VARCHAR2(32) | No | Postal code. Example: 22100. |
| REGION_CODE | VARCHAR2(32) | No | |
| STATE | VARCHAR2(32) | No | Example: Äland Islands. |
| CITY | VARCHAR2(255) | No | Example: Mariehamn. |
| COUNTRY | VARCHAR2(32) | No | A valid ISO-3166-1 alpha-3 country code. Example: FIN. |
| DATE_FROM | DATE | No | YYYY-MM-DD, Date from which address is effective. |
| DATE_TO | DATE | No | YYYY-MM-DD. Expiry date of address effective term. |
| E_MAIL | VARCHAR2(255) | No | Example: info@enfuce.com. |
| FIRST_NAME | VARCHAR2(255) | No | Example: Matti |
| LAST_NAME | VARCHAR2(255) | No | Example: Korhonen. |
| PHONE1 | VARCHAR2(32) | No | Land line phone number to customer, must be full number including country code and starting with + Example: +35821010001.. |
| PHONE2 | VARCHAR2(32) | No | Mobile number to customer, must be full number including country code and starting with + Example: +358503065213 |
| RECORD_DATE_FROM | DATE | Yes | YYYY-MM-DD. Date from which record version is effective. |
| RECORD_DATE_TO | DATE | Yes | YYYY-MM-DD. Expiry date of record version effective term. |
Card Properties
| Field Name | Field Type | Mandatory | Details |
|---|---|---|---|
| REPORTING_DATE | DATE | Yes | YYYY-MM-DD. Report creation date. |
| INSTITUTION_ID | NUMBER(6,0) | Yes | The institution ID setup in Enfuce system,”Branch code” in API. |
| CARD_ID | NUMBER(18,0) | Yes | Enfuce system generated Card ID. |
| CARD_REFERENCE_NUMBER | VARCHAR2(255) | Yes | Foreign key to Card dimension. |
| VALUE_DATE_FROM | DATE | Yes | YYYY-MM-DD. Date from which record version is effective. |
| VALUE_DATE_TO | DATE | Yes | YYYY-MM-DD. Expiry date of record version effective term. |
| DETAILS | VARCHAR2(3900) | No | Timestamp (YYYYMMDDHHMISS) and change channel, ie. “20220629020126-API” |
| PROPERTY_TYPE_NAME | VARCHAR2(255) | Yes | See possible values and descriptions from below table. |
| PROPERTY_TYPE_CODE | VARCHAR2(32) | Yes | See possible values and descriptions from below table. |
| PROPERTY_VALUE_NAME | VARCHAR2(255) | Yes | See possible values and descriptions from below table. |
| PROPERTY_VALUE_CODE | VARCHAR2(32) | Yes | See possible values and descriptions from below table. |
Card Properties - names and codes
| PROPERTY_TYPE_NAME | PROPERTY_TYPE_CODE | PROPERTY_VALUE_NAME | PROPERTY_VALUE_CODE | Description |
|---|---|---|---|---|
| Contract statust | CONTR_STATUS | Card Blocked | 5 | See detailed description per status here. |
| Suspected Fraud | 205 | |||
| Card Closed Due To Fraud | 4 | |||
| Card Lost | 41 | |||
| Card Stolen | 43 | |||
| Card Closed | 105 | |||
| Card Invalid | 43 | |||
| Card No renewal | 105 | |||
| Multi-country Code | MULTICOUNTRYCODE | CZK_CZ DKK_DK EUR_AU EUR_BE EUR_DE EUR_EE EUR_ES EUR_FI EUR_FR EUR_IE EUR_IT EUR_LT EUR_LU EUR_LV EUR_NL GBP_GB ISK_IS NOK_NO PLN_PL SEK_SE | CZK_CZ DKK_DK EUR_AU EUR_BE EUR_DE EUR_EE EUR_ES EUR_FI EUR_FR EUR_IE EUR_IT EUR_LT EUR_LU EUR_LV EUR_NL GBP_GB ISK_IS NOK_NO PLN_PL SEK_SE | To indicate country and currency for institutions with multi-country product setup. |
| Segment | SEGMENT | Segment A Segment B Segment C Segment D Segment E Segment F | A B C D E F | Card has segment A. Card has segment B. Card has segment C. Card has segment D. Card has segment E. Card has segment F. |
| E-Commerce Allowed | ALLOW_ECOM | No | N | E-commerce is blocked for the card. |
| Yes | Y | E-commerce is allowed for the card. | ||
| Block Africa | BLOCK_AFRICA | No | N | Africa is allowed for the card, i.e. card present transactions from Africa are allowed. |
| Yes | Y | Africa is blocked for the card, i.e. card present transactions from Africa are blocked. | ||
| Block Asia | BLOCK_ASIA | No | N | Asia is allowed for the card, i.e. card present transactions from Asia are allowed. |
| Yes | Y | Asia is blocked for the card, i.e. card present transactions from Asia are blocked. | ||
| Block Europe | BLOCK_EUROPE | No | N | Europe is allowed for the card, i.e. card present transactions from Europe are allowed. |
| Yes | Y | Europe is blocked for the card, i.e. card present transactions from Europe are blocked. | ||
| Block North America | BLOCK_NORTH_AMERICA | No | N | North America is allowed for the card, i.e. card present transactions from Asia are allowed. |
| Yes | Y | North America is blocked for the card, i.e. card present transactions from Asia are blocked. | ||
| Block Oceania | BLOCK_OCEANIA | No | N | Oceania is allowed for the card, i.e. card present transactions from Asia are allowed. |
| Yes | Y | Oceania is blocked for the card, i.e. card present transactions from Asia are blocked. | ||
| Block South America | BLOCK_SOUTH_AMERICA | No | N | South America is allowed for the card, i.e. card present transactions from Asia are allowed. |
| Yes | Y | South America is blocked for the card, i.e. card present transactions from Asia are blocked. | ||
| Block Home | BLOCK_HOME | No | N | The home market of the card is allowed, i.e. card present transactions from card’s home market are allowed. |
| Yes | Y | The home market of the card is blocked, i.e. card present transactions from home market are blocked. | ||
| Physical | PHYSICAL | FALSE | FALSE | The card is set not to have a physical representation. |
| TRUE | TRUE | The card is set to have a physical representation. |
Card Tariff Service
| Field Name | Field Type | Mandatory | Details |
|---|---|---|---|
| REPORTING_DATE | DATE | Yes | YYYY-MM-DD. Report creation date. |
| INSTITUTION_ID | NUMBER(6,0) | Yes | The institution ID setup in Enfuce system,”Branch code” in API. |
| CARD_ID | NUMBER(18,0) | Yes | Enfuce system generated Card ID. |
| CARD_REFERENCE_NUMBER | VARCHAR2(255) | Yes | Foreign key to Card dimension. |
| ACTIVE_DATE_FROM | DATE | No | Date from which tariff is included into the product. |
| ACTIVE_DATE_TO | DATE | No | Expiry date of tariff for product effective. |
| SWITCHED_ON | VARCHAR2(1) | No | If tariff is switched on for the contract with its attributes and limits (or balances). |
| MIN_LIMIT_AMOUNT | NUMBER(28,10) | No | Minimal limit amount for the contract tariff activation. |
| MAX_LIMIT_AMOUNT | NUMBER(28,10) | No | Maximum limit amount for the contract tariff activation. |
| RECORD_DATE_FROM | DATE | Yes | Date from which tariff version is effective. |
| RECORD_DATE_TO | DATE | Yes | Date from which tariff version is effective. |
| ACTIVATION_DATE | DATE | Yes | Tariff activation date. |
| FEE_MIN_AMOUNT | NUMBER(28,10) | No | Fee min amount. |
| FEE_MAX_AMOUNT | NUMBER(28,10) | No | Fee max amount. |
| FEE_BASE_AMOUNT | NUMBER(28,10) | No | Fee base amount |
| RATE_VALUE | NUMBER(28,14) | No | Rate value |
| FEE_RATE_VALUE | NUMBER(28,14) | No | Fee rate value |
| CODE | VARCHAR2(32) | No | |
| NAME | VARCHAR2(255) | No | |
| DOMAIN | VARCHAR2(255) | No | |
| ROLE | VARCHAR2(255) | No | |
| TYPE_CODE | VARCHAR2(32) | No | |
| TYPE_NAME | VARCHAR2(255) | No | |
| PRIORITY | NUMBER(9,0) | Yes | Default:0 |
| CURRENCY | VARCHAR2(23) | No | Transaction currency the tariff can be applied for. |
| ATTR_CONDITION | VARCHAR2(32) | No | Contract attribute for tariff activation. |
| ATTR_CONDITION_INFO | VARCHAR2(3900) | No | List of contract attribute values for tariff activation or status description for contract event. |
| BALANCE_TYPE | VARCHAR2(255 | No | Balance type code for tariff activation. |
| MIN_BALANCE | NUMBER(28,10) | No | Minimal balance amount for tariff activation. |
| MAX_BALANCE | NUMBER(28,10) | No | Maximum balance amount for tariff activation. |
| PREFERENCE_TYPE | VARCHAR2(255) | No | MPreference type for tariff activation. |
| PREFERRED_CODE | VARCHAR2(32) | No | Preferred code for tariff activation. |
| BASE_TYPE_NAME | VARCHAR2(255) | No | Base tariff type. |
| TARIFF_RULES | VARCHAR2(3900) | No | Tariff Rules. |
| PLANNED_CHANGE_DATE | DATE | No | Planned tariff changing date. |
| PERSONAL_FLAG | VARCHAR2(1) | No | Y = Tariff is defined on account level N = Tariff is defined on product level |
Card Tariff Threshold
| Field Name | Field Type | Mandatory | Details |
|---|---|---|---|
| REPORTING_DATE | DATE | Yes | YYYY-MM-DD. Report creation date. |
| INSTITUTION_ID | NUMBER(6,0) | Yes | The institution ID setup in Enfuce system,”Branch code” in API. |
| CARD_ID | NUMBER(18,0) | Yes | Enfuce system generated Card ID. |
| CARD_REFERENCE_NUMBER | VARCHAR2(255) | Yes | Foreign key to Card dimension. |
| ACTIVE_DATE_FROM | DATE | No | Date from which tariff is included into the product. |
| ACTIVE_DATE_TO | DATE | No | Expiry date of tariff for product effective. |
| SWITCHED_ON | VARCHAR2(1) | No | If tariff is switched on for the contract with its attributes and limits (or balances). |
| MIN_LIMIT_AMOUNT | NUMBER(28,10) | No | Minimal limit amount for the contract tariff activation. |
| MAX_LIMIT_AMOUNT | NUMBER(28,10) | No | Maximum limit amount for the contract tariff activation. |
| RECORD_DATE_FROM | DATE | Yes | Date from which tariff version is effective. |
| RECORD_DATE_TO | DATE | Yes | Date from which tariff version is effective. |
| ACTIVATION_DATE | DATE | Yes | Tariff activation date. |
| AMOUNT | NUMBER(28,10) | No | |
| PERCENTAGE | NUMBER(28,14) | No | |
| CODE | VARCHAR2(32) | No | |
| NAME | VARCHAR2(255) | No | |
| DOMAIN | VARCHAR2(255) | No | |
| ROLE | VARCHAR2(255) | No | |
| TYPE_CODE | VARCHAR2(32) | No | |
| TYPE_NAME | VARCHAR2(255) | No | |
| PRIORITY | NUMBER(9,0) | Yes | Default:0 |
| CURRENCY | VARCHAR2(23) | No | Transaction currency the tariff can be applied for. |
| ATTR_CONDITION | VARCHAR2(32) | No | Contract attribute for tariff activation. |
| ATTR_CONDITION_INFO | VARCHAR2(3900) | No | List of contract attribute values for tariff activation or status description for contract event. |
| BALANCE_TYPE | VARCHAR2(255 | No | Balance type code for tariff activation. |
| MIN_BALANCE | NUMBER(28,10) | No | Minimal balance amount for tariff activation. |
| MAX_BALANCE | NUMBER(28,10) | No | Maximum balance amount for tariff activation. |
| PREFERENCE_TYPE | VARCHAR2(255) | No | MPreference type for tariff activation. |
| PREFERRED_CODE | VARCHAR2(32) | No | Preferred code for tariff activation. |
| BASE_TYPE_NAME | VARCHAR2(255) | No | Base tariff type. |
| TARIFF_RULES | VARCHAR2(3900) | No | Tariff Rules. |
| PLANNED_CHANGE_DATE | DATE | No | Planned tariff changing date. |
| PERSONAL_FLAG | VARCHAR2(1) | No | Y = Tariff is defined on account level N = Tariff is defined on product level |