US flag Official website of the Department of Homeland Security

ACE Reports Information Notice

U.S. Customs and Border Protection (CBP) has enhanced ACE Reports to support the transition of Automated Commercial System (ACS) core trade processing capabilities to the Automated Commercial Environment (ACE). As detailed in this Information Notice, the reports capabilities will follow each of the releases for Deployment G to include:

Deployment G, Release 2

On September 16, 2017, CBP successfully deployed Deployment G, Release 2, followed by corresponding ACE Reports capabilities on October 7th.

A new Entry Summary (ES) universe and several new ACE canned reports were deployed to consolidate data found in the legacy Account Management and ESM-10002 Entry Summary universes. The new universe which consists of a set of standard reports will now provide users the ability to query a more robust set of data elements that have been normalized for both ACS and ACE sourced entry summaries.

While the new Entry Summary universe that was released on October 7th, ultimately replaced the existing universes containing entry summary data, certain functionality will be unavailable until the final release of Deployment G on February 24, 2018. As such, all legacy universes will remain intact until further notice, with the earliest date of discontinuation being 30 days after the February 2018 deployment. Data maintained in these universes will not go stale as originally planned, so ACE report users can continue to save legacy ACE reports to the My Documents panel from the Documents tab or run any saved reports from their My Favorites folders that use the legacy universes to pull data into ACE Reports.

Please review the table below for a list of the new Entry Summary (ES) universe standardized reports available in ACE Reports as of October 7, 2017.

Entry Summary Standard Reports

Number

Name

Description

Default Data Objects

ES-001

Entry Summary Header Details

This report provides standard information captured at the entry summary header level. It is meant to serve as a replacement for the legacy AM-068 and ESM-7068 reports, as well as to provide additional enhancements allowing users to report on a more robust set of data elements that have been normalized for both ACS and ACE sourced entry summaries.

Entry Summary Number, Entry Type Code, Port of Entry Code, Port of Entry Name, Entry Date, Entry Summary Date, Entry Summary Create Date, Surety Code, Importer Number, Importer Name, Control Team Number, Control Team CEE, Bond Type Code, Bond Number, Liquidation Status, Mode of Transportation Code, Mode of Transportation, Total Goods Value Amount, Number of Entry Summary Lines

ES-002

Entry Summary Line Details

This report provides standard information captured at the entry summary line level. It is meant to serve as a replacement for the legacy AM-064 report, as well as to provide additional enhancements allowing users to report on a more robust set of data elements that have been normalized for both ACS and ACE sourced entry summaries.

Entry Summary Number, Entry Type Code, Entry Summary Line Number, Review Team Number, Country of Origin Code, Country of Export Code, Manufacturer ID, Manufacturer Name, Foreign Exporter ID, Foreign Exporter Name, Line SPI Code, Line SPI, Reconciliation (FTA) Status, Reconciliation (Other) Status, Line Goods Value Amount, Line Duty Amount, Line MPF Amount

ES-003

Entry Summary Line Tariff Details

This report provides standard information captured at the entry summary line tariff level. It is meant to serve as a replacement for the legacy AM-001, AM-003, AM-007, AM-008, and ESM-7068 reports, as well as to provide additional enhancements allowing users to report on a more robust set of data elements that have been normalized for both ACS and ACE sourced entry summaries.

Entry Summary Number, Entry Type Code, Importer Number, Port of Entry Code, Entry Date, Entry Summary Date, Entry Summary Create Date, Entry Summary Line Number, Review Team Number, Country of Origin Code, Country of Export Code, Manufacturer ID, Foreign Exporter ID, Line SPI Code, Standard Visa Number, Textile Category Code, Textile Category, Tariff Ordinal Number, HTS Number - Full, Line Tariff Quantity (1), Line Tariff UOM (1) Code, Line Tariff Quantity (2), Line Tariff UOM (2) Code, Line Tariff Quantity (3), Line Tariff UOM (3) Code, Line Tariff Duty Amount, Line Tariff Goods Value Amount

ES-004

Rejected and Cancelled Entry Summaries

This report provides a list of all cancelled and rejected entry summaries based on the parameters input by the user running the report. It is intended to replace the legacy ESM-7024 report.

Entry Summary Number, Entry Type Code, Port of Entry Code, Control Team Number, Control Team CEE, Importer Number, Importer Name, Control Status, Entry Summary Cancellation Date, Entry Summary Rejection Date, Entry Summary Status

ES-005

Late Filed Entry Summaries

This report provides a list of all late filed entry summaries based on the parameters input by the user running the report. This report does not provide a list of entries filed in ACE Cargo Release that have been released and are still pending a follow-up 7501 entry summary filing, but rather the entry summaries that were eventually filed but designated as late.

Entry Summary Number, Entry Type Code, Port of Entry Code, Control Team Number, Release Date, Entry Summary Date, Control Team CEE, Importer Number, Importer Name, Control Status, Late Filing Status Code, Late Filing Status, Entry Summary Status

ES-006

Entry Summary Dimensions by Value

This report provides an aggregate summary of the number of entry summaries, number of entry summary lines, total value, and total duty broken out by manufacturer, importer, filer, and HTS Number. These breakouts are on 4 separate tabs in the same report: Summary by Manufacturer, Summary by Importer, Summary by Filer, and Summary by HTS Number. It is intended to replace the legacy AM-009, AM-010, AM-015, and AM-019 reports.

Summary by Manufacturer: Manufacturer ID, Manufacturer Name, Number of Entry Summary Lines, Number of Entry Summaries, Line Tariff Duty Amount, Line Tariff Goods Value Amount

Summary by Importer: Importer Number, Importer Name, Number of Entry Summary Lines, Number of Entry Summaries, Line Tariff Duty Amount, Line Tariff Goods Value Amount

Summary by Filer: Filer Code, Filer Name, Number of Entry Summary Lines, Number of Entry Summaries, Line Tariff Duty Amount, Line Tariff Goods Value Amount

Summary by HTS Number: HTS Number - Full, HTS Short Description, Number of Entry Summary Lines, Number of Entry Summaries, Line Tariff Duty Amount, Line Tariff Goods Value Amount,

Standard Reports being Replaced (October 7th, 2017)

The table below displays a list of current legacy reports and their replacement ACE reports. Reports that are not being replaced at this time are marked as “Will remain until February”.

Report

Replacement ACE Report(s)

AM-001 Entry Summary Lines by HTS Number Report

ES-003 Entry Summary Line Tariff Details

AM-003 Entry Summary Lines by Filer Code Report

ES-003 Entry Summary Line Tariff Details

AM-007 Entry Summary Lines by Mfr Code Report

ES-003 Entry Summary Line Tariff Details

AM-008 Entry Summary Line Detail Report

ES-003 Entry Summary Line Tariff Details

AM-009 Summary of Mfr Code by Value Report

ES-006 Entry Summary Dimensions by Value

AM-010 Summary of HTS Nbrs by Value Report

ES-006 Entry Summary Dimensions by Value

AM-015 Summary of IR Nbrs by Value Report

ES-006 Entry Summary Dimensions by Value

AM-019 Summary of Filer Codes by Value Report

ES-006 Entry Summary Dimensions by Value

AM-064 Entry Summary Line by Entry Nbr Report

ES-002 Entry Summary Line Details

AM-068 Entry Summary Report

ES-001 Entry Summary Header Details

AM-100 Courtesy Notice of Liquidation

Will remain until February

ESM-7001 Entry Summary Census Warning Report

Will remain until February

ESM-7008 Entry Summary Line Detail Report

ES-003 Entry Summary Line Tariff Details

ESM-7024 ACE Reject Report

ES-004 Rejected and Cancelled Entry Summaries

ESM-7025 CBP Form 28, 29, 4647 Status Report

Will remain until February

ESM-7068 Entry Summary Report

ES-001 Entry Summary Header Details

Deployment G, Release 3A (December 9, 2017)

New ACE Statement Reports REV-101, REV-102, REV-103 and REV-104 were made available in the ACE Production environment as of December 9, 2017. The new REV-102 and REV-103 reports can now be modified to include regular non-periodic daily statement data in ACE Reports.

For validation purposes, both the new ACE Statement reports and the legacy ACE Account Revenue reports were made available to all members of the trade community via the ACE Reports production environment as of December 9, 2017. From December 9, 2017 through January 6, 2018, the new ACE Statement reports were solely for trade validation/testing.

To perform this validation, users are recommended to utilize the reports found under the main Importer and Broker workspaces which are located under the Statements sub-tab (this tab contains the legacy Statements reports), and compare them to reports found under the sub-tab labeled Parallel Statements *TEST* (which contains the new Statements reports). The Parallel Statements *TEST* sub-tab includes four new reports (REV-101, REV-102, REV-103 and REV-104), as well as copies of the 2 legacy reports (AR-006, AR-007) refactored using the new ACE data source for direct comparison.

Please review and be aware of the below table which consists of a universe of new and existing standardized Statement reports. As of December 9, 2017, these reports were made available in ACE Reports.

Universe

Workspace

Sub-tab

Report Name

Statements

Broker/Importer

Statements

REV-101 Monthly Statement Overview

Statements

Broker/Importer

Statements

REV-102 Daily Statement Overview

Statements

Broker/Importer

Statements

REV-103 Daily Statement Entry Summaries

Statements

Broker/Importer

Statements

REV-104 Daily Statement Entry Summary Amounts

Statements

Broker/Importer

Statements

AR-006 Sub-ledger Report

Statements

Broker/Importer

Statements

AR-007 Periodic Statement Detail

Statements

Broker/Importer

Statements

AR-007 Periodic Statement Quickview – Brk/Imp

Deployment G, Release 3B (January 6, 2018)

As of January 6, 2018, CBP delivered ACE Deployment G, Release 3B. As a result of this deployment, ACE is now the system of record for all statements with the exception of Reconciliation statements*.

*CBP will deliver Statements for Reconciliations as part of ACE Deployment G, Release 4 on February 24, 2018.

Additional ACE Reports Capabilities Available as of January 13, 2018

No later than January 13, 2018, CBP will deploy ACE Statement reports with the Statements universe, which replaces the Account Revenue universe. The new ACE Statements reports will be available under the Statements tab found in the applicable trade account workspace. In addition, two existing “quickview” reports for brokers and importers (AR-007) will remain available in ACE.

Furthermore, and no later than January 13, 2018, CBP will deploy a new ADCVD universe that will be made available in parallel with the current ADCVD universe for a period of one month.

During this time-frame, the trade community will be provided the opportunity to gain an understanding of the new universe and to become comfortable using these enhancements. The new universe enhancements involves technical upgrades, and the addition of a number of new data objects. The ACE Reports ADCVD Universe Object Mapping table at the bottom of this notice has been provided for reference and maps the previous ADCVD object names to the names in the new universe.

If you have created and saved any Ad-Hoc reports for the current universe, please re-create them for use in this new universe before February 13, 2018. 

This new universe will be available to brokers and importers. Users should select either the Broker or Importer workspace in ACE Reports, navigate to Entry Summary, and click on the tab labeled “ADCVD NEW.” This tab will be renamed “ADCVD,” and will replace the current tab labeled “ADCVD” on February 13, 2018.

Deployment G, Release 4

A new Reconciliation universe, a Drawback universe, and a Liquidation universe are planned to be deployed on March 17, 2018, three weeks after the February 24, 2018 delivery of reconciliation, liquidation, drawback (core and TFTEA) and ASI with Deployment G, Release 4. Detailed information regarding the new universes and any replacement/standard reports will be forthcoming.

Additional Items:

At this time, CBP does not have plans to develop new ACE Reports for Foreign Trade Zone (FTZ) e214 admissions transactions and ISF.

Authorized Data Extracts

The Authorized Data Extracts Reports will be retired on March 17, 2018, in conjunction with the retirement of the legacy ESM-10002 Entry Summary and Account Management universes. At that point, all reporting capabilities will be provided by ACE Reports.

More information about ACE Reports can be found by visiting the ACE Training and Reference Guides page of CBP.gov/ACE. The ACE Reports Data Dictionary will also be updated with information concerning the new ACE data universes and reports. For more questions on ACE Reports, please contact the ACE Account Service Desk at 1-866-530-4172 or ACE.Support@cbp.dhs.gov.


ACE Reports ADCVD Universe Object Mapping

ACE Reports ADCVD Universe Object Mapping
CURRENT ADCVD OBJECT NAMES NEW ADCVD OBJECT NAMES
Number of Entry Summaries Number of Entry Summaries
Number of Entry Summary Lines Number of Entry Summary Lines
Total ADD Amount Antidumping Goods Value Amount
Total CVD Amount Countervailing Goods Value Amount
Total Line Value Line Goods Value Amount
Calendar Entry Year Month Entry Date - Year Month (Calendar)
Consignee Name Ultimate Consignee Name
Consignee Number Ultimate Consignee Number
DOC File Location ID Document File Location ID
Entry Multiple Case Indicator Multiple Case Indicator
Entry Multiple Case (Different Lines) Indicator Multiple Case (Different Lines) Indicator
Entry Number Entry Summary Number
Entry Version Create Date Entry Summary Create Date
Fiscal Entry Year Entry Date - Year (Fiscal)
Liquidation Date Liquidation/Closure Date
Version Number Entry Summary Version Number
BRASS Filer Code Filer BRASS Account ID
Broker Alias Name Filer Alias Name
Broker DBA Name Filer DBA Name
Broker Division Name Filer Division Name
Broker DUNS Number Filer DUNS ID Number
Broker Organizational Structure Filer Organizational Structure
Broker Organizational Structure Code Filer Organizational Structure Code
Broker Taxpayer ID Number Filer Tax ID Number
Broker Taxpayer ID Code Filer Taxpayer ID Code
License Issue Date Filer - License Issue Date
License Number Filer - License Number
License Status Filer - License Status
Broker Mailing Address Line 1 Filer Mailing Address Line 1
Broker Mailing Address Line 2 Filer Mailing Address Line 2
Broker Mailing Address Line 3 Filer Mailing Address Line 3
Broker Mailing Building Number Filer Mailing Building Number
Broker Mailing City Filer Mailing City
Broker Mailing Country Code Filer Mailing Country Code
Broker Mailing Floor Number Filer Mailing Floor Number
Broker Mailing House Number Filer Mailing House Number
Broker Mailing PO Box Number Filer Mailing PO Box Number
Broker Mailing State Filer Mailing State/Province
Broker Mailing State Code Filer Mailing State/Province Code
Broker Mailing Suite/Apartment Number Filer Mailing Suite/Apartment Number
Broker Mailing Zip Code Filer Mailing Zip Code
Broker Physical Address Line 1 Filer Physical Address Line 1
Broker Physical Address Line 2 Filer Physical Address Line 2
Broker Physical Address Line 3 Filer Physical Address Line 3
Broker Physical Building Number Filer Physical Building Number
Broker Physical City Filer Physical City
Broker Physical Country Code Filer Physical Country Code
Broker Physical Floor Number Filer Physical Floor Number
Broker Physical House Number Filer Physical House Number
Broker Physical PO Box Number Filer Physical PO Box Number
Broker Physical State Filer Physical State/Province
Broker Physical State Code Filer Physical State Code/Province
Broker Physical Suite/Apartment Number Filer Physical Suite/Apartment Number
Broker Physical Zip Code Filer Physical Zip Code
Balance Due Indicator Balance Due Indicator
Debit Voucher Indicator Collection Debit Voucher Indicator
Payment Type (Pay Basis form ACS) Payment Type
Payment Type Code (Pay Basis from ACS) Payment Type Code
Periodic Statement Month Number Periodic Statement Month Number
Preliminary Statement Print Date Preliminary Statement Print Date
Statement Client Branch Identifier Statement Client Branch ID
CMC CMC
CMC Code CMC Code
Foreign Port of Lading Code Foreign Port of Lading Code
Foreign Port of Lading Country Code Foreign Port of Lading Country Code
Foreign Port of Lading Country Name Foreign Port of Lading Country Name
Foreign Port of Lading Name Foreign Port of Lading Name
Foreign Port of Lading Qualifier Foreign Port of Lading Qualifier
Foreign Port of Lading Qualifier Code Foreign Port of Lading Qualifier Code
Lading Port Indicator Lading Port Indicator
Port Border Type Code Port Border Type Code
Port Code Port Code
Port Mailing Address Line 1 Port Mailing Address Line 1
Port Mailing Address Line 2 Port Mailing Address Line 2
Port Mailing Address Line 3 Port Mailing Address Line 3
Port Mailing Address City Port Mailing Address City
Port Mailing Address State Port Mailing Address State
Port Mailing Address State Code Port Mailing Address State Code
Port Mailing Address Zip Port Mailing Address Zip
Region Code Region Code
Selectivity Port Indicator Selectivity Port Indicator
Service Port Indicator Service Port Indicator
AD Bond or Cash Claimed Antidumping Bond/Cash Claimed
AD Bond or Cash Claimed Code Antidumping Bond/Cash Claimed Code
AD Non-Reimbursement Blanket Statement Number Antidumping Non-Reimbursement Declaration ID
AD Value Antidumping Goods Value Amount
CV Bond or Cash Claimed Countervailing Bond/Cash Claimed
CV Bond or Cash Claimed Code Countervailing Bond/Cash Claimed Code
CV Non-Reimbursement Blanket Statement Number Countervailing Non-Reimbursement Declaration ID
CV Value Countervailing Goods Value Amount
CVD Paid Amount Total Paid CVD Amount
Entry Line AD Case Number Antidumping Case Number
Entry Line AD Indicator Antidumping Indicator
Entry Line ADD Ad-Valorem Rate Antidumping Ad-Valorem Rate
Entry Line Country of Export Code Country of Export Code
Entry Line Country of Export Code and Name Country of Export Code and Name
Entry Line Country of Export Name Country of Export Name
Entry Line Country of Origin Code Country of Origin Code
Entry Line Country of Origin Code and Name Country of Origin Code and Name
Entry Line Country of Origin Name Country of Origin Name
Export Date Exportation Date
HTS Long Description HTS Long Description
HTS Number - First 2 HTS Number - First 2
HTS Number - First 4 HTS Number - First 4
HTS Number - First 6 HTS Number - First 6
HTS Number - First 8 HTS Number - First 8
HTS Number - Full HTS Number - Full
HTS Short Description HTS Short Description
Line Number Entry Summary Line Number
Manufacturer Code Manufacturer ID
SPI Line SPI
SPI Code Line SPI Code
UOM Line Tariff UOM (1)
UOM Code Line Tariff UOM (1) Code
UOM Quantity Line Tariff Quantity (1)
FAST ID Number FAST Account ID Number
Importer ACE ID Number Importer ACE ID Number
Importer Alias Name Importer Alias Name
Importer DBA Name Importer DBA Name
Importer Division Name Importer Division Name
Importer DUNS Number Importer DUNS ID Number
Importer Name Importer Name
Importer Number Importer Number
Importer Organizational Structure Importer Organizational Structure
Importer Organizational Structure Code Importer Organizational Structure Code
Importer Taxpayer ID Number Importer Tax ID Number
Importer Taxpayer ID Type Code Importer Tax Type Code
Importer Mailing Address Line 1 Importer Mailing Address Line 1
Importer Mailing Address Line 2 Importer Mailing Address Line 2
Importer Mailing Address Line 3 Importer Mailing Address Line 3
Importer Mailing Building Number Importer Mailing Building Number
Importer Mailing City Importer Mailing City
Importer Mailing Country Code Importer Mailing Country Code
Importer Mailing Floor Number Importer Mailing Floor Number
Importer Mailing House Number Importer Mailing House Number
Importer Mailing Phone Extension Importer Mailing Phone Extension
Importer Mailing Phone Number Importer Mailing Phone Number
Importer Mailing PO Box Number Importer Mailing PO Box Number
Importer Mailing State Importer Mailing State/Province
Importer Mailing State Code Importer Mailing State/Province Code
Importer Mailing Suite/Apartment Number Importer Mailing Suite/Apartment Number
Importer Mailing Zip Code Importer Mailing Zip Code
Importer Physical Address Line 1 Importer Physical Address Line 1
Importer Physical Address Line 2 Importer Physical Address Line 2
Importer Physical Address Line 3 Importer Physical Address Line 3
Importer Physical Building Number Importer Physical Building Number
Importer Physical City Importer Physical City
Importer Physical Country Code Importer Physical Country Code
Importer Physical Floor Number Importer Physical Floor Number
Importer Physical House Number Importer Physical House Number
Importer Physical Phone Extension Importer Physical Phone Extension
Importer Physical Phone Number Importer Physical Phone Number
Importer Physical State Importer Physical State/Province
Importer Physical State Code Importer Physical State/Province Code
Importer Physical Suite/Apartment Number Importer Physical Suite/Apartment Number
Importer Physical Zip Code Importer Physical Zip Code
ASI Indicator Surety ASI Indicator
NAIC Number Surety Treasury Circular NAIC Number
Reinsurance Amount Surety Reinsurance Limit Amount
Surety Code Surety Code
Surety DUNS Number Surety DUNS ID Number
Surety Name Surety Name
Surety Organizational Structure Code Surety Organizational Structure Code
Surety Producer Number Surety Producer Number
Surety Status Code Surety Status Code
Surety Status Profile Code Surety Status Profile Code
Surety Taxpayer ID Number Surety Tax ID Number
Surety Taxpayer ID Type Code Surety Tax Type Code
Last published: 
January 11, 2018