Enfuce offers charge card customers two data export files where customers can view invoice lifecycle events, such as invoice payments and invoice statuses. More information about the contents of these files can be found in the tables below.

Invoice

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.
INVOICE_IDNUMBER(18,0)YesInvoice ID for the given invoice.
ACCOUNT_IDNUMBER(18,0)YesEnfuce payment platform generated contract ID, accountId in API calls.
PAYMENT_REFERENCEVARCHAR2(255)NoThe reference number used for the payment.
AMOUNTNUMBER(28,10)YesThe total amount of the invoice.
CURRENCYVARCHAR2(3)YesISO 4217 Number.
PAID_AMOUNTNUMBER(28,10)YesThe total amount paid for the invoice.
STATUSVARCHAR2(32)YesInvoice status, available options:
1. OPEN
2. OVERDUE
3. PAID
4. PAID_PARTIALLY
5. WRITE-OFF
CREATION_DATEDATEYesYYYY-MM-DDThh:mm:ss. The date and time when the invoice was created.
DUE_DATEDATEYesYYYY-MM-DD. The date when the invoice is due.
INVOICE_NUMBERNUMBER(18,0)YesInvoice number for the given invoice.

Invoice payments

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.
ACCOUNT_IDNUMBER(18,0)YesEnfuce payment platform generated contract ID, accountId in API calls.
INVOICE_IDNUMBER(18,0)YesInvoice ID for the given invoice.
PAYMENT_TYPEVARCHAR2(32)YesPayment type, either payment (PT) or collection payment (CPT).
AMOUNTNUMBER(28,10)YesThe total amount of the invoice.
CURRENCYVARCHAR2(3)YesISO 4217 Number.
TRANSACTION_IDNUMBER(18,0)YesUnique transaction ID.