Token

Field nameField typeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD
INSTITUTION_IDNUMBER(18,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API
PAYMENT_INSTRUMENT_IDNUMBER(18,0)YesForeign key to Card dimension. “CardId” in API calls.
TOKEN_IDNUMBER(18,0)YesEnfuce payment platform generated Token ID
TOKEN_NUMBERVARCHAR2(255)Truncated token number. First 6 and last 4 digits.
TOKEN_STATUSVARCHAR2(1)YesPossible values: Inactive, Active, Deactivated, Suspended
TOKEN_TYPEVARCHAR2(32)Visa assigns all merchants a unique token requester ID, please see this Wiki page for details. Possible values:
103 = MDES Apple Pay
40010030273 = VDEP Apple Pay
216 = MDES Google Pay
40010075001 = VDEP Google Pay
327 = MDES Merchants such as Netflix/Amazon/etc
TOKEN_CREATED_DATE_TIMEDATE_TIMEYYYY-MM-DD HH:MI:SS
TOKEN_ACTIVATION_DATE_TIMEDATE_TIMEYYYY-MM-DD HH:MI:SS
TOKEN_MODIFIED_DATE_TIMEDATE_TIMEYYYY-MM-DD HH:MI:SS
TOKEN_EXPIRATION_DATE_TIMEDATE_TIMEYYYY-MM-DD HH:MI:SS
DEVICE_TYPEVARCHAR2(255)Value is controlled by the Wallet provider and Schemes, and may vary. Possible values include:
03 = MDES/VDEP Wearable
13 = MDES Tablet
21 = MDES Smartphone
25 = MDES Laptop
01 = VDEP, Apple Pay, Smartphone
02 = VDEP, Tablet
04 = VDEP, Google Pay, Smartphone/Tablet
DEVICE_NAMEVARCHAR2(255)Name defined on the device itself. Not always visible.