NoC Report by ACH Return Date

This NoC Report by ACH Return Date is an Dynamic Payout report containing NoC data detailing changes in Sub-merchants accounts discovered during funds transfer operations. 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:

SubMerchantIBFundingNOC_${organizationId}_${TargetDay}

where

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

Report Structure

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
Return Date	Date (mm/dd/yyyy)	10	The date the issuing bank processed the funding instruction.
Original Date	Date (mm/dd/yyyy)	10	The original date of the transaction (i.e., Batch post date).
Attempted Funds Transfer Date	Date (mm/dd/yyyy)	10	The date that Bank attempted to settled funds to your Sub-merchant's bank.
Sub Merchant Business Name	Alphanumeric	50	The business name of the Sub-merchant for which the funding instruction failed.
Funding Sub Merchant ID	Alphanumeric	32	The identifier for the Sub-merchant (usually the assigned Merchant Id).
Funds Transfer Request ID	Alphanumeric	36	The Payment Facilitator assigned identifier associated with the funds transfer instruction.
Vantiv Payment ID	Numeric (with preceding apostrophe)	20	The unique identifier automatically assigned to each transaction by Worldpay and associated with the transaction.
Txn Type	Alphanumeric	6	The type of transaction. 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
Funds Transfer Amount	Signed Decimal (17,2)	17	The dollar amount of the failed funds transfer.
NOC Reason Code	Alphanumeric	3	The response code indicating the reason for the funds transfer failure. For additional information see Sections A-8 and A-9 of the Worldpay eComm cnpAPI Reference Guide.
NOC Reason Message	Alphanumeric	29	The message describing the reason for the funds transfer failure. For additional information see Sections A-8 and A-9 of the Worldpay eComm cnpAPI Reference Guide.
Old Routing Number	Number	9	The old routing number of the Sub-merchant account.
Old Account Number	Number	17	The old account number of the Sub-merchant account.
Old Account Name	Alphanumeric	22	The old name of the Sub-merchant account.
New Routing Number	Number	9	The new routing number of the Sub-merchant account.
New Account Number	Number	17	The new account number of the Sub-merchant account.
New Account Name	Alphanumeric	22	The new name of the Sub-merchant account.