EWA File Creation Extract Task

AutoAdjust performs adjustments under the following scenarios:
  • Duplicate bundle (DBDL)
  • Rejected bundle (RBDL)
  • Out of balance bundle (ICLD)
  • Non-conforming transaction (NCI)
The enterprise wide adjustments (EWA) file creation extract task extracts the information of all adjustment records from the database and creates a set of files in the Gateway outbound source directory. The files created by the EWA file creation extract task provide details about the following information:
  • Adjustment business date
  • Adjustment identifier number
  • Record type
  • Bank number
  • Sender bank number
  • Adjustment code
  • Amount
  • Account type
  • Sender reference information
  • Reference number
  • Document to follow
  • Batch (ICL) destination routing transit number
  • Batch (ICL) originator routing transit number
  • Entry date
  • Batch (ICL) amount
  • Segment amount
  • Entry number
  • Batch (ICL) sequence number
  • Item before number
  • Item after number
  • Listed amount
  • Expected amount (Should be amount)
  • Drawee bank
  • Operator
  • Processing type
  • Sort type
  • Available date
  • Account number

During task execution, the EWA file creation extract task retrieves complete data and writes records in a data file. For more information about file sets, see File and XML Formats. The activities and details of all tasks that have run can be viewed. The EWA file creation extract task extracts the data and puts it in the configured directories. The user can then view its activity.