Card

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. Report creation date
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce system, “Branch code” in API.
CARD_IDNUMBER(18,0)YesEnfuce system generated Card ID.
CARD_REFERENCE_NUMBERVARCHAR2(255)YesEnfuce generated unique card identifier.
ADD_INFOVARCHAR2(3900)NoAdditional field which contains miscellaneous data of the card. Data is marked with tags. Contact Enfuce for tags relevant to you.
BANK_OFFICER_IDNUMBER(18,0)NoLast officer that updated the record.
BASE_CURRENCYVARCHAR2(3)YesISO 4217 Number.
BILLING_CYCLE_TYPEVARCHAR2(32)NoType of billing cycle used for with the card. Possible values: Day, Month, Custom.
BRANCH_IDNUMBER(18,0)NoFinancial institution branch identifier.
CUSTOMER_IDNUMBER(18,0)YesForeign key to customer dimension. CustomerId in API calls.
CUSTOMER_REG_NOVARCHAR2(32)YesForeign key to customer dimension. Mandatory if client SSN is agreed to be included in files, otherwise field is always empty.
CUSTOMER_NUMBERVARCHAR2(255)YesForeign key to customer dimension.
CLOSING_DATEDATENoYYYY-MM-DD.
OPENING_DATEDATEYesYYYY-MM-DD. Date when the PAN was originally created. Value is inherited to the new PAN when card is replaced.
EMBOSSING_DATEDATENoYYYY-MM-DD. Date when the card was produced.
EMBOSSED_COMPANY_NAMEVARCHAR2(255)NoCompany name embossed on the card.
EMBOSSED_FIRST_NAMEVARCHAR2(255)NoFirst name embossed on the card.
EMBOSSED_LAST_NAMEVARCHAR2(255)NoLast name embossed on the card.
EXPIRY_DATEDATENoYYYY-MM-DD. Last date of validity for the card.
LOST_CARD_IDVARCHAR2(255)NoCard ID of the previous card when the card is a replacement card.
MAIN_CONTRACT_IDTNoEnfuce generated ID for account to which a card is linked.
MAIN_CONTRACT_NUMBERVARCHAR2(255)NoForeign 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_NUMBERVARCHAR2(255)NoTruncated card number. First 6 and last 4 digits.
PARENT_CONTRACT_NUMBERVARCHAR2(255)NoForeign key to Account dimension referring to parent account.
PLASTIC_STATUSVARCHAR2(1)YesStatus of the card’s plastic. Possible values: Active, Closed, Locked.
SEQUENCE_NUMBERVARCHAR2(32)NoThe sequence number of the card’s plastic.
CARD_PROD_EVENT_NAMEVARCHAR2(255)NoSee possible values in separate card production event documentation.
CARD_PROD_EVENT_CODEVARCHAR2(32)NoSee possible values in separate card production event documentation.
CARD_STATUS_NAMEVARCHAR2(255)YesSee possible values in separate card status documentation.
CARD_STATUS_CODEVARCHAR2(32)YesSee possible values in separate card status documentation.
PLASTIC_TYPE_NAMEVARCHAR2(255)Yes
PLASTIC_TYPE_CODEVARCHAR2(32)Yes
CARD_INTERFACEVARCHAR2(1))NoCard interface (contact, contactless, combined, micro tag).
PRODUCT_NAMEVARCHAR2(255)YesProduct name configured in Enfuce system.
PRODUCT_CODEVARCHAR2(255)YesProduct name configured in Enfuce system.
RECORD_DATE_FROMDATAYesYYYY-MM-DD. Date from which record version is effective.
RECORD_DATE_TODATAYesYYYY-MM-DD. Expiry date of record version effective term.
PRIMARY_APPLET_IDTVARCHAR2(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 NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. Report creation date.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce system,”Branch code” in API.
CARD_IDNUMBER(18,0)YesEnfuce system generated Card ID.
CARD_REFERENCE_NUMBERVARCHAR2(255)YesEnfuce generated unique card identifier.
ADDRESS_TYPE_NAMEVARCHAR2(255))YesType of address used for card entity. Possible values: Card Delivery, PIN Mailer.
ADDRESS_TYPE_CODENUMBER(18,0)YesCode for address type used for card entity. Possible values: CARD, PIN.
ADDRESS_LINE_1VARCHAR2(255)NoFirst address line. Example: Kings street 12.
ADDRESS_LINE_2VARCHAR2(255)NoSecond address line.
ADDRESS_LINE_3VARCHAR2(255)NoThird address line.
ADDRESS_LINE_4VARCHAR2(255)NoFourth address line.
ADDRESS_TYPE_IDNUMBER(3,0))NoIdentifier for address type used. Possible values: 445, 447.
ADDRESS_ZIPVARCHAR2(32)NoPostal code. Example: 22100.
REGION_CODEVARCHAR2(32)No
STATEVARCHAR2(32)NoExample: Äland Islands.
CITYVARCHAR2(255)NoExample: Mariehamn.
COUNTRYVARCHAR2(32)NoA valid ISO-3166-1 alpha-3 country code. Example: FIN.
DATE_FROMDATENoYYYY-MM-DD, Date from which address is effective.
DATE_TODATENoYYYY-MM-DD. Expiry date of address effective term.
E_MAILVARCHAR2(255)NoExample: info@enfuce.com.
FIRST_NAMEVARCHAR2(255)NoExample: Matti
LAST_NAMEVARCHAR2(255)NoExample: Korhonen.
PHONE1VARCHAR2(32)NoLand line phone number to customer, must be full number including country code and starting with + Example: +35821010001..
PHONE2VARCHAR2(32)NoMobile number to customer, must be full number including country code and starting with + Example: +358503065213
RECORD_DATE_FROMDATEYesYYYY-MM-DD. Date from which record version is effective.
RECORD_DATE_TODATEYesYYYY-MM-DD. Expiry date of record version effective term.

Card Properties

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. Report creation date.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce system,”Branch code” in API.
CARD_IDNUMBER(18,0)YesEnfuce system generated Card ID.
CARD_REFERENCE_NUMBERVARCHAR2(255)YesForeign key to Card dimension.
VALUE_DATE_FROMDATEYesYYYY-MM-DD. Date from which record version is effective.
VALUE_DATE_TODATEYesYYYY-MM-DD. Expiry date of record version effective term.
DETAILSVARCHAR2(3900)NoTimestamp (YYYYMMDDHHMISS) and change channel, ie. “20220629020126-API”
PROPERTY_TYPE_NAMEVARCHAR2(255)YesSee possible values and descriptions from below table.
PROPERTY_TYPE_CODEVARCHAR2(32)YesSee possible values and descriptions from below table.
PROPERTY_VALUE_NAMEVARCHAR2(255)YesSee possible values and descriptions from below table.
PROPERTY_VALUE_CODEVARCHAR2(32)YesSee possible values and descriptions from below table.

Card Properties - names and codes

PROPERTY_TYPE_NAMEPROPERTY_TYPE_CODEPROPERTY_VALUE_NAMEPROPERTY_VALUE_CODEDescription
Contract statustCONTR_STATUSCard Blocked5See detailed description per status here.
Suspected Fraud205
Card Closed Due To Fraud4
Card Lost41
Card Stolen43
Card Closed105
Card Invalid43
Card No renewal105
Multi-country CodeMULTICOUNTRYCODECZK_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.
SegmentSEGMENTSegment 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 AllowedALLOW_ECOMNoNE-commerce is blocked for the card.
YesYE-commerce is allowed for the card.
Block AfricaBLOCK_AFRICANoNAfrica is allowed for the card, i.e. card present transactions from Africa are allowed.
YesYAfrica is blocked for the card, i.e. card present transactions from Africa are blocked.
Block AsiaBLOCK_ASIANoNAsia is allowed for the card, i.e. card present transactions from Asia are allowed.
YesYAsia is blocked for the card, i.e. card present transactions from Asia are blocked.
Block EuropeBLOCK_EUROPENoNEurope is allowed for the card, i.e. card present transactions from Europe are allowed.
YesYEurope is blocked for the card, i.e. card present transactions from Europe are blocked.
Block North AmericaBLOCK_NORTH_AMERICANoNNorth America is allowed for the card, i.e. card present transactions from Asia are allowed.
YesYNorth America is blocked for the card, i.e. card present transactions from Asia are blocked.
Block OceaniaBLOCK_OCEANIANoNOceania is allowed for the card, i.e. card present transactions from Asia are allowed.
YesYOceania is blocked for the card, i.e. card present transactions from Asia are blocked.
Block South AmericaBLOCK_SOUTH_AMERICANoNSouth America is allowed for the card, i.e. card present transactions from Asia are allowed.
YesYSouth America is blocked for the card, i.e. card present transactions from Asia are blocked.
Block HomeBLOCK_HOMENoNThe home market of the card is allowed, i.e. card present transactions from card’s home market are allowed.
YesYThe home market of the card is blocked, i.e. card present transactions from home market are blocked.
PhysicalPHYSICALFALSEFALSEThe card is set not to have a physical representation.
TRUETRUEThe card is set to have a physical representation.

Card Tariff Service

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. Report creation date.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce system,”Branch code” in API.
CARD_IDNUMBER(18,0)YesEnfuce system generated Card ID.
CARD_REFERENCE_NUMBERVARCHAR2(255)YesForeign key to Card dimension.
ACTIVE_DATE_FROMDATENoDate from which tariff is included into the product.
ACTIVE_DATE_TODATENoExpiry date of tariff for product effective.
SWITCHED_ONVARCHAR2(1)NoIf tariff is switched on for the contract with its attributes and limits (or balances).
MIN_LIMIT_AMOUNTNUMBER(28,10)NoMinimal limit amount for the contract tariff activation.
MAX_LIMIT_AMOUNTNUMBER(28,10)NoMaximum limit amount for the contract tariff activation.
RECORD_DATE_FROMDATEYesDate from which tariff version is effective.
RECORD_DATE_TODATEYesDate from which tariff version is effective.
ACTIVATION_DATEDATEYesTariff activation date.
FEE_MIN_AMOUNTNUMBER(28,10)NoFee min amount.
FEE_MAX_AMOUNTNUMBER(28,10)NoFee max amount.
FEE_BASE_AMOUNTNUMBER(28,10)NoFee base amount
RATE_VALUENUMBER(28,14)NoRate value
FEE_RATE_VALUENUMBER(28,14)NoFee rate value
CODEVARCHAR2(32)No
NAMEVARCHAR2(255)No
DOMAINVARCHAR2(255)No
ROLEVARCHAR2(255)No
TYPE_CODEVARCHAR2(32)No
TYPE_NAMEVARCHAR2(255)No
PRIORITYNUMBER(9,0)YesDefault:0
CURRENCYVARCHAR2(23)NoTransaction currency the tariff can be applied for.
ATTR_CONDITIONVARCHAR2(32)NoContract attribute for tariff activation.
ATTR_CONDITION_INFOVARCHAR2(3900)NoList of contract attribute values for tariff activation or status description for contract event.
BALANCE_TYPEVARCHAR2(255NoBalance type code for tariff activation.
MIN_BALANCENUMBER(28,10)NoMinimal balance amount for tariff activation.
MAX_BALANCENUMBER(28,10)NoMaximum balance amount for tariff activation.
PREFERENCE_TYPEVARCHAR2(255)NoMPreference type for tariff activation.
PREFERRED_CODEVARCHAR2(32)NoPreferred code for tariff activation.
BASE_TYPE_NAMEVARCHAR2(255)NoBase tariff type.
TARIFF_RULESVARCHAR2(3900)NoTariff Rules.
PLANNED_CHANGE_DATEDATENoPlanned tariff changing date.
PERSONAL_FLAGVARCHAR2(1)NoY = Tariff is defined on account level
N = Tariff is defined on product level

Card Tariff Threshold

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. Report creation date.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce system,”Branch code” in API.
CARD_IDNUMBER(18,0)YesEnfuce system generated Card ID.
CARD_REFERENCE_NUMBERVARCHAR2(255)YesForeign key to Card dimension.
ACTIVE_DATE_FROMDATENoDate from which tariff is included into the product.
ACTIVE_DATE_TODATENoExpiry date of tariff for product effective.
SWITCHED_ONVARCHAR2(1)NoIf tariff is switched on for the contract with its attributes and limits (or balances).
MIN_LIMIT_AMOUNTNUMBER(28,10)NoMinimal limit amount for the contract tariff activation.
MAX_LIMIT_AMOUNTNUMBER(28,10)NoMaximum limit amount for the contract tariff activation.
RECORD_DATE_FROMDATEYesDate from which tariff version is effective.
RECORD_DATE_TODATEYesDate from which tariff version is effective.
ACTIVATION_DATEDATEYesTariff activation date.
AMOUNTNUMBER(28,10)No
PERCENTAGENUMBER(28,14)No
CODEVARCHAR2(32)No
NAMEVARCHAR2(255)No
DOMAINVARCHAR2(255)No
ROLEVARCHAR2(255)No
TYPE_CODEVARCHAR2(32)No
TYPE_NAMEVARCHAR2(255)No
PRIORITYNUMBER(9,0)YesDefault:0
CURRENCYVARCHAR2(23)NoTransaction currency the tariff can be applied for.
ATTR_CONDITIONVARCHAR2(32)NoContract attribute for tariff activation.
ATTR_CONDITION_INFOVARCHAR2(3900)NoList of contract attribute values for tariff activation or status description for contract event.
BALANCE_TYPEVARCHAR2(255NoBalance type code for tariff activation.
MIN_BALANCENUMBER(28,10)NoMinimal balance amount for tariff activation.
MAX_BALANCENUMBER(28,10)NoMaximum balance amount for tariff activation.
PREFERENCE_TYPEVARCHAR2(255)NoMPreference type for tariff activation.
PREFERRED_CODEVARCHAR2(32)NoPreferred code for tariff activation.
BASE_TYPE_NAMEVARCHAR2(255)NoBase tariff type.
TARIFF_RULESVARCHAR2(3900)NoTariff Rules.
PLANNED_CHANGE_DATEDATENoPlanned tariff changing date.
PERSONAL_FLAGVARCHAR2(1)NoY = Tariff is defined on account level
N = Tariff is defined on product level

Token

The Data Export Token file is an incremental file sent to issuers on a daily basis. It contains Token related information, such as newly created tokens, status changes, and what PAN’s each Token is linked to.

This file can be used for reporting purposes and keeping a track of the Token life-cycle.

File name

  • 123456 = Institution ID
  • 2021-04-29 = Date of changes, reporting date
  • 20210430 = File creation date
  • 070002 = File timestamp

File content

The .csv file includes the following information:

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD.
INSTITUTION_IDNUMBER(18,0)YesThe institution ID setup in Enfuce system, “Branchcode” in API.
PAYMENT_INSTRUMENT_IDNUMBER(18,0)YesForeign key to Card dimension. “CardId” in API calls.
TOKEN_IDNUMBER(18,0)YesEnfuce system generated Token ID.
TOKEN_NUMBERVARCHAR2(255)NoTruncated token number. First 6 and last 4 digits.
TOKEN_STATUSVARCHAR2(1)YesEnfuce system generated Token ID.
TOKEN_TYPEVARCHAR2(32)NoCard 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_TIMEDATENoYYYY-MM-DD HH:MI:SS
TOKEN_ACTIVATION_DATE_TIMEDATENoYYYY-MM-DD HH:MI:SS
TOKEN_MODIFIED_DATE_TIMEDATENoYYYY-MM-DD HH:MI:SS
TOKEN_EXPIRATION_DATE_TIMEDATENoYYYY-MM-DD HH:MI:SS
DEVICE_TYPEVARCHAR2(255)NoValue 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_NAMEVARCHAR2(255)NoName defined on the device itself. Not always visible.

NOTE! The .csv file can be completely empty, no headers either, if there hasn’t been any token changes.