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. |
BILLING_CYCLE_TYPE | VARCHAR2(32) | No | Type of billing cycle used for with the card. Possible values: Day, Month, Custom. |
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 | 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_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. |
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. |
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. |
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. |
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 |
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 |
Field Name | Field Type | Mandatory | Details |
---|---|---|---|
REPORTING_DATE | DATE | Yes | YYYY-MM-DD. |
INSTITUTION_ID | NUMBER(18,0) | Yes | The institution ID setup in Enfuce system, “Branchcode” in API. |
PAYMENT_INSTRUMENT_ID | NUMBER(18,0) | Yes | Foreign key to Card dimension. “CardId” in API calls. |
TOKEN_ID | NUMBER(18,0) | Yes | Enfuce system generated Token ID. |
TOKEN_NUMBER | VARCHAR2(255) | No | Truncated token number. First 6 and last 4 digits. |
TOKEN_STATUS | VARCHAR2(1) | Yes | Enfuce system generated Token ID. |
TOKEN_TYPE | VARCHAR2(32) | No | Card scheme assigns all digital wallets and token merchants a unique token requester ID. Possible values: 103 (MC) or 40010030273 (Visa) = Apple Pay 216 (MC) or 40010075001 (Visa) = Google Pay 327 (MC) = General ID for Mastercard merchants such as Netflix/Amazon/etc. Visa has assigned specific numbers to merchants that use tokens. |
TOKEN_CREATED_DATE_TIME | DATE | No | YYYY-MM-DD HH:MI:SS |
TOKEN_ACTIVATION_DATE_TIME | DATE | No | YYYY-MM-DD HH:MI:SS |
TOKEN_MODIFIED_DATE_TIME | DATE | No | YYYY-MM-DD HH:MI:SS |
TOKEN_EXPIRATION_DATE_TIME | DATE | No | YYYY-MM-DD HH:MI:SS |
DEVICE_TYPE | VARCHAR2(255) | No | Value is controlled by the Wallet provider and Schemes, and may vary. Possible values include: 03 = Wearable (Visa & MC) 13 (MC) or 02 (Visa) = Tablet 21 (MC) or 01 (Visa) or 04 (Visa) = Smartphone 25 (MC) = Laptop |
DEVICE_NAME | VARCHAR2(255) | No | Name defined on the device itself. Not always visible. |