Account

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD.The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
CONTRACT_NAMEVARCHAR2(255)NoName of the account in Enfuce Payment Platform.
ADD_INFOVARCHAR2(3900)NoAdditional field which contains miscellaneous data of the customer. Data is marked with tags. Contact Enfuce for tags relevant to you.
ALTERNATE_IDNVARCHAR2(255)NoSecondary account number (“RBS” number).
BANK_OFFICER_IDNUMBER(18,0)NoLatest officer that updated the record.
BASE_CURRENCYVARCHAR2(3)YesCurrency. ISO 4217 Number
BILLING_CYCLE_TYPEVARCHAR2(32)NoPossible values: Day, Month, Custom
BRANCH_IDNUMBER(18,0)NoFinancial institution branch identifier. Not used in current configuration.
CUSTOMER_IDNUMBER(18,0)YesForeign key to Client dimension. customerId in API calls.
CUSTOMER_REG_NOVARCHAR2(32)Yes
CUSTOMER_NUMBERVARCHAR2(255)YesForeign key to Client dimension. Update of this field alone doesn’t reflect in incremental Account file.
IDNUMBER(18,0)YesEnfuce payment platform generated contract ID, accountId in API calls.
CONTRACT_NUMBERVARCHAR2(255)YesCan be inputted by issuer. If not provided in an application, will be generated by Enfuce. Can also be updated and changed later by the issuer.
DATE_CLOSEDATENoYYYY-MM-DD. Date when the account was closed.
DATE_OPENDATEYesYYYY-MM-DD. Date when the account was created.
EFFECTIVE_INT_RATENUMBER(15,8)NoInterest Rate
PARENT_CONTRACT_NUMBERVARCHAR2(255)No
PARENT_LINK_TYPEVARCHAR2(32)No
REFERENCE_NUMBERVARCHAR2(255)No
PRODUCT_NAMEVARCHAR2(255)YesProduct name configured in Enfuce payment platform – Prepaid, debit, credit, fleet etc.
PRODUCT_CODEVARCHAR2(255)YesYYYY-MM-DD. Date from which record version is effective
RECORD_DATE_FROMDATEYesYYYY-MM-DD. Date from which record version is effective
RECORD_DATE_TODATEYesYYYY-MM-DD. Expiry date of record version effective term
VALIDITY_PERIODNUMBER(18,0)NoContract validity period
CREDIT_LIMITNUMBER(28,10)NoAccount credit limit. Not to be confused with available limit.
STATUS_NAMEVARCHAR2(255)YesAccount status on reporting date.
STATUS_CODEVARCHAR2(32)YesAccount status code.
PARENT_ACCOUNT_IDNUMBER(18,0)No

Account Address

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD.
The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)Yes
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account dimension
ADDRESS_TYPE_NAMEVARCHAR2(255)YesPossible values: Statement
ADDRESS_TYPE_CODEVARCHAR2(32)YesPossible values: STMT
ADDRESS_LINE_1VARCHAR2(255)No
ADDRESS_LINE_2VARCHAR2(255)No
ADDRESS_LINE_3VARCHAR2(255)No
ADDRESS_LINE_4VARCHAR2(255)No
ADDRESS_ZIPVARCHAR2(32)No
REGION_CODEVARCHAR2(32)No
STATEVARCHAR2(32)No
CITYVARCHAR2(32)No
COUNTRYVARCHAR2(32)NoISO 3166-1 Alpha-3 code
DATE_FORMDATENo
DATE_TODATENo
EMAILVARCHAR2(255)No
PHONE1VARCHAR2(32)No
PHONE2VARCHAR2(32)No
RECORD_DATE_FROMDATEYesYYYY-MM-DD. Date from which record version is effective
RECORD_DATE_TODATENoYYYY-MM-DD. Expiry date of record version effective term

Account Balance

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD.The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)Yes
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account dimension
BANKING_DATEDATEYes
ACCOUNT_NAMEVARCHAR2(255)YesAvailable account names for CREDIT product:

CH Current/Credits
Dispute
Loan Cash Billed
Loan Cash Current
Loan Cash Grace
Loan Fee Billed
Loan Fee Current
Loan Fee Grace
Loan Interest Billed – Credit
Loan Interest Billed
Loan Retail Billed
Loan Retail Current
Loan Retail Grace
MTP Cash Billed
MTP Cash Grace
MTP Cash Overdue
MTP Fee Billed
MTP Fee Grace
MTP Fee Overdue
MTP Int
MTP Int Overdue
MTP OVD Int
MTP OVD Int Overdue
MTP Retail Billed
MTP Retail Grace
MTP Retail Overdue
OVD Int Billed
Shadow Deposit
Shadow Due
Shadow OVD 120
Shadow OVD 150
Shadow OVD 180
Shadow OVD 30
Shadow OVD 60
Shadow OVD 90

Available account names for DEBIT product:

CH Current/Credits
Dispute

Available account names for Fuel Card product:

CH Current/Credits
Cl OVD
Dispute
Fee Current Cycle
Interest Overdue
Interest Payment Due
Interest Prev Cycle
Payment Due
Retail Current Cycle
Shadow Deposit

Available account names for PREPAID product:

CH Current/Credits
Dispute
Overdraft
CURRENCYVARCHAR2(3)YesISO 4217 Code
AMOUNTNUMBER(28,10)Yes
INTEREST_RATENUMBER(15,8)No
PREDICTED_INTERESTNUMBER(28,10)No
BILLING_PERIOD_START_DATEDATENo
BILLING_PERIOD_END_DATEDATENo

Account Balance Type

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD.
The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)Yes
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account dimension
BANKING_DATEDATEYes
TYPE_CODEVARCHAR2(32)YesShows types of balances that the account balance consists of.
Possible values:
AVAILABLE
TOTAL_BALANCE
STMT_BALANCE
DUE
OVD_01
OVD_02
OVD_03
OVD_04
OVD_05
OVD_06
PAST_DUE
TOTAL_DUE
See Balance types and segregation of balances service description for additional information about the balance types
CURRENCYVARCHAR2(3)YesCurrency as ISO 4217 Code
AMOUNTNUMBER(28,10)YesAmount of the balance.
ADD_INFOVARCHAR2(3900)No

Account Properties

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD.The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)Yes
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account dimension
ATTR_DATE_FROMDATEYesYYYY-MM-DD. Date when the property was applied.
ATTR_DATE_TODATENoYYYY-MM-DD. Expiry date of the applied property.
DETAILSVARCHAR2(3900)NoAdditional information. Original message received from customer. Can include for example the source (API), timestamp and bank date.
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.

Account Properties - names and codes

PROPERTY_TYPE_NAMEPROPERTY_TYPE_CODEPROPERTY_VALUE_NAMEPROPERTY_VALUE_CODEDescription
Account Card BlockINV_CARD_BLOCKNO

YES
N

Y
Indicating if the cards are blocked on the account level due to reminder process
Card Hard BlockCARD_HARDBLOCKNO

YES
N

Y
Indicating if the cards are hard blocked on the account level due to collection sending
Closure ReasonCLOSURE_REASONClosure Reason 1CLOSED1Indicating the closure reason why the account was closed. The issuer can decide on the use case for these closure reasons.
Closure Reason 2CLOSED2
Closure Reason 3CLOSED3
Closure Reason 4CLOSED4
Closure Reason 5CLOSED5
CL. Collection StCL_COLL_STNone

Sent

Waiting
N

S

W
Indicating the status of sending the account to collection. This property is relevant only for credit products.
CL. Reminder1 StCL_REM1_STNoneNIndicating the status of first reminder during the reminder process. This property is relevant only for credit products.
SentS
WaitingW
CL. Reminder2 StCL_REM2_STNoneNIndicating the status of second reminder during the reminder process. This property is relevant only for credit products.
SentS
WaitingW
CL. Write-off StatusCL_WO_STNoneNIndicating the status of the write-off process. This property is relevant only for credit products.
SentS
WaitingW
CL. Under ThresholdCL_UNDER_THRESHOLDNoneNIndicating if reminder process didn’t proceed due to thresholds. This property is relevant for credit and fleet product.
YesY
Contract statusCONTR_STATUSAccount OK0See detailed Account description per status here
Account Blocked5
Account To Close54
Auto-Closed114
Account in Collection99
Account Closed14
Delinquency LevelDLQ_LEVELNo Debts0Account has no debts. This property is relevant only for credit products.
Due1Account has a balance that is due to be paid on the due date. This property is relevant only for credit products.
Past Due 0-302Account has balance that is overdue 1-30 days. This property is relevant only for credit products.
Past Due 31-603Account has balance that is overdue 31-60 days. This property is relevant only for credit products.
Past Due 61-904Account has balance that is overdue 61-90 days. This property is relevant only for credit products.
Past Due 91-1205Account has balance that is overdue 91-120 days. This property is relevant only for credit products.
Past Due 121-1506Account has balance that is overdue 121-150 days. This property is relevant only for credit products.
Past Due 151-1807Account has balance that is overdue 151-180 days. This property is relevant only for credit products.
Past Due 181-2108Account has balance that is overdue 181-210 days. This property is relevant only for credit products.
Past Due 211-2409Account has balance that is overdue for 211 or more. This property is relevant only for credit products.
Multi-country CodeMULTICOUNTRYCODECZK_CZCZK_CZTo indicate country and currency for institutions with multi-country product setup.
DKK_DKDKK_DK
EUR_AUEUR_AU
EUR_BEEUR_BE
EUR_DEEUR_DE
EUR_EEEUR_EE
EUR_ESEUR_ES
EUR_FIEUR_FI
EUR_FREUR_FR
EUR_IEEUR_IE
EUR_ITEUR_IT
EUR_LTEUR_LT
EUR_LUEUR_LU
EUR_LVEUR_LV
EUR_NLEUR_NL
GBP_GBGBP_GB
ISK_ISISK_IS
NOK_NONOK_NO
PLN_PLPLN_PL
SEK_SESEK_SE
Overlimit IndicatorOVERLIMIT_INDICATORNoNAccount is not overlimit.
YesYAccount is overlimit.
Reminder Process StatusREM_CL_STATUSNoneNIndicating the account reminder status for credit product
Reminder 11
Reminder 22
Reminder 33
Reminder 44
Reminder 55
Reminder 66
Reminder 77
CollectionCollection
SegmentSEGMENTSegment AAAccount has segment A.
Segment BBAccount has segment B.
Segment CCAccount has segment C.
Segment DDAccount has segment D.
Segment EEAccount has segment E.
Segment FFAccount has segment F.
Statement DeliverySTMT_DELIVERY_TYPECustom 11Account has statement delivery type marked as “Custom 1”. This property is relevant only for credit products.
Custom 22Account has statement delivery type marked as “Custom 2”. This property is relevant only for credit products.
Custom 33Account has statement delivery type marked as “Custom 3”. This property is relevant only for credit products.
Custom 44Account has statement delivery type marked as “Custom 4”. This property is relevant only for credit products.
Custom 55Account has statement delivery type marked as “Custom 5”. This property is relevant only for credit products.
E-invoice6Account has statement delivery type marked as “E-invoice”. This property is relevant only for credit products.
E-mail7Account has statement delivery type marked as “E-mail”. This property is relevant only for credit products.
Paper8Account has statement delivery type marked as “Paper”. This property is relevant only for credit products.
Statement Payment MethodSTMT_PAYMENT_METHODDirectDebit1Account has statement payment method marked as “DirectDebit”. This property is relevant only for credit products.
PlusGirot2Account has statement payment method marked as “PlusGirot”. This property is relevant only for credit products.
BankGirot3Account has statement payment method marked as “BankGirot”. This property is relevant only for credit products.
CL. Under ThresholdCL_THRESHNone

Yes
N

Y
This will appear as “Y” on the date when the dunning event would have been triggered if the amounts were below the threshold. This will be reset to “N” on the next day.

Account Tariff Ageing

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)YesEnfuce payment platform generated contract ID, accountId in API calls.
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account 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_TODATEYesExpiry date of tariff version effective term
ACTIVATION_DATEDATEYesTariff activation date
FEE_MIN_AMOUNTNUMBER(28,10)No
FEE_MAX_AMOUNTNUMBER(28,10)No
FEE_BASE_AMOUNTNUMBER(28,10)No
RATE_VALUENUMBER(28,14)No
FEE_RATE_VALUENUMBER(28,14)No
CODEVARCHAR2(32)No
NAMEVARCHAR2(255)No
DOMAINVARCHAR2(255)No
ROLEVARCHAR2(32)No
TYPE_CODEVARCHAR2(32)No
TYPE_NAMEVARCHAR2(255)No
PRIORITYNUMBER(9,0)YesDefault: 0
CURRENCYVARCHAR2(3)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
BALANCE_TYPEVARCHAR2(255)NoBalance 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)NoPreference 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

Account Tariff Interest

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)YesEnfuce payment platform generated contract ID, accountId in API calls.
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account dimension
ACTIVE_DATE_FROMDATENoDate from which tariff is included into the product
ACTIVE_DATE_TODATENo
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_TODATEYesExpiry date of tariff version effective term
ACTIVATION_DATEDATEYesTariff activation date
RATE_VALUENUMBER(28,14)No
RATE_FEE_VALUENUMBER(28,14)No
CODEVARCHAR2(32)No
NAMEVARCHAR2(255)No
DOMAINVARCHAR2(255)No
ROLEVARCHAR2(32)No
TYPE_CODEVARCHAR2(32)No
TYPE_NAMEVARCHAR2(255)No
PRIORITYNUMBER(9,0)YesDefault: 0
CURRENCYVARCHAR2(3)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
BALANCE_TYPEVARCHAR2(255)NoBalance 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)NoPreference 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

Account Tariff Service

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)YesEnfuce payment platform generated contract ID, accountId in API calls.
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account 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_TODATEYesExpiry date of tariff version effective term
ACTIVATION_DATEDATEYesTariff activation date
FEE_MIN_AMOUNTNUMBER(28,10)No
FEE_MAX_AMOUNTNUMBER(28,10)No
FEE_BASE_AMOUNTNUMBER(28,10)No
RATE_VALUENUMBER(28,14)No
FEE_RATE_VALUENUMBER(28,14)No
CODEVARCHAR2(32)No
NAMEVARCHAR2(255)No
DOMAINVARCHAR2(255)No
ROLEVARCHAR2(32)No
TYPE_CODEVARCHAR2(32)No
TYPE_NAMEVARCHAR2(255)No
PRIORITYNUMBER(9,0)YesDefault: 0
CURRENCYVARCHAR2(3)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
BALANCE_TYPEVARCHAR2(255)NoBalance 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)NoPreference 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

Account Tariff Threshold

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD. The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)YesEnfuce payment platform generated contract ID, accountId in API calls.
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account dimension
ACTIVE_DATE_FROMDATENoDate from which tariff is included into the product
ACTIVE_DATE_TODATENo
SWITCHED_ONVARCHAR2(1)No
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_TODATEYesExpiry date of tariff version effective term
ACTIVATION_DATEDATEYesTariff activation date
AMOUNTNUMBER(28,10)No
PERCENTAGENUMBER(28,14)No
CODEVARCHAR2(32)No
NAMEVARCHAR2(255)No
DOMAINVARCHAR2(255)No
ROLEVARCHAR2(32)No
TYPE_CODEVARCHAR2(32)No
TYPE_NAMEVARCHAR2(255)No
PRIORITYNUMBER(9,0)YesDefault: 0
CURRENCYVARCHAR2(3)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
BALANCE_TYPEVARCHAR2(255)NoBalance 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)NoPreference 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

Account Billing

Field NameField TypeMandatoryDetails
REPORTING_DATEDATEYesYYYY-MM-DD.
The data has been extracted end of day of this date. Files are provided next day.
INSTITUTION_IDNUMBER(6,0)YesThe institution ID setup in Enfuce Payment Platform, “Branch code” in API.
IDNUMBER(18,0)YesEnfuce payment platform generated contract ID, accountId in API calls.
CONTRACT_NUMBERVARCHAR2(255)YesForeign key to Account dimension
BANKING_DATEDATEYes
DUE_DATEDATEYes
GRACE_DATEDATEYes
FULL_PAYMENT_DATEDATEYes
PERIOD_START_DATEDATEYes
CYCLE_NUMBERVARCHAR2(32)Yes
ADD_INFOVARCHAR2(3900)No