Page 141 of 177 Updated 07-2018
ace REPORTS DATA DICTIONARY – TRADE
Reconciliation Data Objects
Reconciliation ES Original HMF
Amount
The total amount of all harbor maintenance fees (HMF) that were originally identified on all
of the underlying 01, 02, and 06 entry summaries that are associated to a particular
reconciliation entry summary.
Reconciliation ES Original Interest
Amount
The total amount of all interest that was originally identified on all of the underlying 01, 02,
and 06 entry summaries that are associated to a particular reconciliation entry summary.
Reconciliation ES Original MPF
Amount
The total amount of all merchandise processing fees (MPF) that were originally identified on
all of the underlying 01, 02, and 06 entry summaries that are associated to a particular
reconciliation entry summary.
Reconciliation ES Original Tax
Amount
The total amount of all Internal Revenue (IR) taxes that were originally identified on all of
the underlying 01, 02, and 06 entry summaries that are associated to a particular
reconciliation entry summary.
Reconciliation ES Paid Change
Recon Duty Amount
For the determined "Reconciliation Change Recon Duty Amount," the amount indicated as
paid by the Collections application.
Reconciliation ES Paid Change
Recon Fee Amount
For the determined "Reconciliation Change Recon Fee Amount," the amount indicated as
paid by the Collections application.
Reconciliation ES Paid Change
Recon Grand Total Amount
For the determined "Reconciliation Change Recon Grand Total Amount," the amount
indicated as paid by the Collections application.
Reconciliation ES Paid Change
Recon HMF Amount
For the determined "Reconciliation Change Recon HMF Amount," the amount indicated as
paid by the Collections application.
Reconciliation ES Paid Change
Recon Interest Amount
For the determined "Reconciliation Change Recon Interest Amount," the amount indicated
as paid by the Collections application.
Reconciliation ES Paid Change
Recon MPF Amount
For the determined "Reconciliation Change Recon MPF Amount," the amount indicated as
paid by the Collections application.
Reconciliation ES Paid Change
Recon Tax Amount
For the determined "Reconciliation Change Recon Tax Amount," the amount indicated as
paid by the Collections application.
Reconciliation ES Payment
Received Date
The month, day, and year (MM/DD/YYYY) indicating the most recent instance in which
payment was received for a particular reconciliation entry summary.
Reconciliation ES Port of Entry
Code
The 4 digit code that represents the district/port where the merchandise entered for a
particular reconciliation entry summary. Possible values include, but are not limited to:
"2704" indicating LOS ANGELES, CA, "2506" indicating OTAY MESA, "2605" indicating
PHOENIX, AZ, "3001" indicating SEATTLE, WA, and "4601" indicating NEW YORK/NEWARK
AREA. Follows the format: "1122" Position 1-2: "11" indicating the district code. Position 3-
4: "22" indicating the port code.
Reconciliation ES Port of Entry
Name
The proper name of the district/port code where the merchandise was entered for a
particular reconciliation entry summary. Possible values include, but are not limited to: "LOS
ANGELES, CA," "OTAY MESA," "PHOENIX, AZ," "SEATTLE, WA," and "NEW YORK/NEWARK
AREA."
Reconciliation ES Port of Unlading
Code
A 4 digit code that represents the district and port at which goods on a particular
reconciliation entry summary are unloaded from the means of transport having been used
for their carriage. The district code is the first two characters and the port code is the last
two characters. Possible values include, but are not limited to: "2704" indicating LOS
ANGELES, CA, "2506" indicating OTAY MESA, "2605" indicating PHOENIX, AZ, "3001"
indicating SEATTLE, WA, and "4601" indicating NEW YORK/NEWARK AREA. Follows the
format: "1122" Position 1-2: "11" indicating the district code. Position 3-4: "22" indicating
the port code.