Trade Compliance Menu Options > Batch DPL Data Scrub > Output File Content
  
Output File Content
Depending on the value of the Result Type field in the CSV input file, the contents of the data scrub output file are in either a brief or complete format. Both versions of the output file include the contents of the input file, but the complete version contains extra columns. Batch Data Scrub Output File Contents: Complete Version lists the columns that appear in the complete version of the output file. When your system is configured to display the brief version of the output file, you do not see the last five columns.

Batch Data Scrub Output File Contents: Complete Version
 
Column
Explanation
Reference
This field matches the Reference field in the corresponding row in the input file.
Name
This field matches the Name field in the corresponding row in the input file.
Street
This field matches the Street field in the corresponding row in the input file.
City
This field matches the City field in the corresponding row in the input file.
State/Province
This field matches the State/Province field in the corresponding row in the input file.
Zip/Postal Code
This field matches the Zip/Postal Code field in the corresponding row in the input file.
Country
This field matches the Country field in the corresponding row in the input file.
Compliance Status
The result of the compliance check.
Possible values:
WARNING
FAIL
PASS
Results URL
The URL for the page that contains the compliance check results.
Match Category
The category in which the party details match a DPL entry; for example, name or address.
% Match
The percentage match between the party details and the DPL entry that it matches. For example, if this column is 75, and the Match Category column is NAME, there is a 75% match between the party name and a name entry in the DPL.
Source List
The organization that supplied the matching entry in the DPL list.
Name as it appears on the DPL
The name in the matching entry in the DPL list.
Address as it appears on the DPL
The address in the matching entry in the DPL list.
Note: If a field in the input file is blank, then the corresponding row is omitted from the output file. For example, if there is no address in the ReplyTo line of the input file, there is no ReplyTo row in the output file.