Funding Instruction Confirmation Report

The PayFac Funding Instruction Confirmation report is an Dynamic Payout report containing data about all settled funding instructions from the previous day. Worldpay produces the report daily, Monday through Friday, and only applies to Payment Facilitators using the Dynamic Payout solution.

Filename Syntax

The syntax of the report filename is:

PayFacFundingInstructionConfirmationReport_${organizationId}_${targetDay}

where

organizationId is the of the parent merchant organization
targetDay is the date to which the data applies

The table below provides information about the fields included in the report. The report fields are in the order presented in the table.

A data type of Signed Decimal (17,2) with a Max Size of 21 is defined as:
17 digits + decimal point + 2 digits + sign.

Field Name	Data Type	Max Size	Description
Delivery Date	Date (mm/dd/yyyy)	10	The submission date of the funding instruction.
Expected Settlement Date	Date (mm/dd/yyyy)	10	The expected bank settlement date of the funding instruction.
Payment ID (Vantiv Payment ID in Canadian reports)	Numeric	19	The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction.
Transaction Type	Alphanumeric	5	The type of funding instruction. Possible values are: FIPC - Funding Instruction PayFac Credit FIPD - Funding Instruction PayFac Debit FIRC - Funding Instruction Reserve Credit FIRD - Funding Instruction Reserve Debit FISC - Funding Instruction Sub-merchant Credit FISD - Funding Instruction Sub-merchant Debit FIVC - Funding Instruction Vendor Credit FIVD - Funding Instruction Vendor Debit FICC - Funding Instruction Physical Check Credit FICD - Funding Instruction Physical Check Debit FIFA - Funding Instruction Fast Access
Business Name	Alphanumeric	256	The name of the Sub-merchant.
Funding SubMerchant ID	Alphanumeric	50	The funding sub-merchant id.
Funds Transfer ID	Alphanumeric	100	The Payment Facilitator assigned identifier associated with the funds transfer instruction.
Amount	Signed Decimal	19	The dollar amount of the funding instruction.
Create Date	Date (mm/dd/yyyy)	10	The date the transaction was created
Trace Number	Numeric	19	The trace number assigned to the funding instruction by the bank. This field is empty for Canadian Funding Instructions.
Same Day Delivered	Alphanumeric	1	Y or N indicating if the Funding Instruction was Same Day Funded. The feature associated with this column is not yet available.