View External File Transactions

Explanation

Use this activity to view transactions associated with an external load. Possible reasons for doing this could be:

You want to check the current status of a load.
You want to make sure that all file lines in an input file was loaded correctly.
You want to check the data created during the output file process.
You want to check the errors reported during the unpack or pack operation.
You want to in detail examine the origin of the values represented in the file line.

A processing of an external input or output file must have been performed.

N/A

Open the External File Transactions window.
Find the external load by performing Populate or Query.
The first detail window presents available transactions by mainly showing the row number, the associated record type, the file line and the row state. The Row State field can be used to query for all transactions having a specific state.
Click on a line in the first detail window to show value details in the second detail window. This window will show all available columns associated with the file type and the record type. Each column will have a descriptive text and the value associated with each column is displayed. This makes it easy to check what a file line really represents.

It is also possible to do according to the following:

Open the External File Load IDs window.
Perform Populate to retrieve all external loads or use Query to find one or many specific loads.
Mark one or several loads, right-click and then click Details to launch the External File Transactions window where each load can be viewed more in detail.