Skip to content

Customer file descriptions

Customer file

Field Name Field Type Mandatory Details
REPORTING_DATE DATE Yes YYYY-MM-DD.The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_ID NUMBER(6,0) Yes The institution ID setup in Enfuce Payment Platform, “Branch code” in API.
ADD_INFO VARCHAR2(3900) No Additional field which contains miscellaneous data of the customer. Data is marked with tags. Contact Enfuce for tags relevant to you.
ID NUMBER(18,0) No
BRANCH_ID NUMBER(18,0) Yes Foreign key to Customer. Enfuce payment platform generated id for the customer, customerId in API calls
CUSTOMER_REG_NO VARCHAR2(32) No
CUSTOMER_NUMBER VARCHAR2(255) Yes
CUSTOMER_CATEGORY VARCHAR2(16) Yes Possible values:

Private

Corporate

COMPANY_NAME VARCHAR2(255) No
CREATION_DATE DATE Yes YYYY-MM-DD. Date when the customer was created.
DECEASE_DATE DATE No YYYY-MM-DD.
FIRST_NAME VARCHAR2(255) No
LANGUAGE VARCHAR2(32) No ISO 639-2/B
LAST_NAME VARCHAR2(255) No
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
BANK_OFFICER_ID NUMBER No Latest officer that updated the record.

Customer Address

Field Name Field Type Mandatory Details
REPORTING_DATE DATE Yes YYYY-MM-DD.The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_ID NUMBER(6,0) Yes The institution ID setup in Enfuce Payment Platform, “Branch code” in API.
ID VARCHAR2(32) Yes Foreign key to Customer. Enfuce payment platform generated customer ID, customerId in API calls.
BRANCH_ID NUMBER(18,0) Yes Foreign key to Customer. Enfuce payment platform generated id for the customer, customerId in API calls
CUSTOMER_NUMBER VARCHAR2(255) Yes Foreign key to Customer
CUSTOMER_REG_NO VARCHAR2(32) No
NAME VARCHAR2(255) Yes Possible values:

Statement

Base address

Card delivery

PIN Mailer

Temporary

CODE VARCHAR2(32) Yes Possible values:

STMT

BASE

CARD

PIN

TEMP

ADDRESS_LINE_1 VARCHAR2(255) No
ADDRESS_LINE_2 VARCHAR2(255) No
ADDRESS_LINE_3 VARCHAR2(255) No
ADDRESS_LINE_4 VARCHAR2(255) No
ADDRESS_ZIP VARCHAR2(32) No
REGION_CODE VARCHAR2(32) No
STATE VARCHAR2(32) No
CITY VARCHAR2(32) No
COUNTRY VARCHAR2(32) No ISO 3166-1 Alpha-3 code
DATE_FORM DATE No
DATE_TO DATE No
E_MAIL VARCHAR2(255) No
PHONE1 VARCHAR2(32) No
PHONE2 VARCHAR2(32) No
RECORD_DATE_FROM DATE Yes YYYY-MM-DD. Date from which record version is effective
RECORD_DATE_TO DATE No YYYY-MM-DD. Expiry date of record version effective term

Customer Properties

Field Name Field Type Mandatory Details
REPORTING_DATE DATE Yes YYYY-MM-DD.The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_ID NUMBER(6,0) Yes The institution ID setup in Enfuce Payment Platform, “Branch code” in API.
ID VARCHAR2(32) Yes Foreign key to Customer. Enfuce payment platform generated customer ID, customerId in API calls.
CUSTOMER_NUMBER VARCHAR2(255) Yes Foreign key to Customer
CUSTOMER_REG_NO VARCHAR2(32) No Foreign key to Customer
VALUE_DATE_FROM DATE Yes YYYY-MM-DD. Date when the property was applied.
VALUE_DATE_TO DATE Yes YYYY-MM-DD. YYYY-MM-DD. Expiry date of the applied property.
DETAILS VARCHAR2(3900) No Original message received. Can include for example the source (API), timestamp and bank date
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.

Customer properties - names and codes

PROPERTY_TYPE_NAME PROPERTY_TYPE_CODE PROPERTY_VALUE_NAME PROPERTY_VALUE_CODE Description
Client Locale CLIENT_LOCALE As per ISO 639-1 ISO 639-1 and ISO 3166-1 alpha-2 Example_ en_G Indicating the customer locale as set by issuer.
Client Classification CLIENT_CLASS Staff – Regular STAFF – REGULAR Indicating the customer classifier if set by issuer.