CSMS# 17-000165 - ACE Extract Reference File Query (FQ) fixes Deployed to CERTIFICATION
U.S. Customs and Border Protection sent this bulletin at 03/24/2017 02:57 PM EDTYou are subscribed to Truck Manifest for U.S. Customs and Border Protection. This information has recently been updated, and is now available.
03/24/2017 02:47 PM EDT
Truck Manifest
ACE Extract Reference File Query (FQ) software updates have been deployed to the ACE CERTIFICATION environment for the F106 Air Carrier Extract as follows:
• When returning F106 results for an Air Carrier, return the 2-character Census Abbreviation/IATA airline designator in the SCAC field, instead of the 3-character SCAC.
• Address data will not be returned in the F106 Carrier Query/Extract for Air Carriers.
FQ – Fixes deployed to CERT earlier but not yet in PROD:
-------------------------------------------------------
• When an "Air" MOT account has no Census Abbreviation/IATA code, the corresponding SCAC field will be blanked out (four spaces).
• Air Carrier List output ordered alphabetically by Carrier Name.
• F106 Air Carrier Extract to include Active air carriers only.
• Alphabetical ordering of Country list corrected in F202
• AGOA_CBPTA_BEGN_DT and AGOA_CBPTA_END_DT corrected in F202
ACE Extract Reference File Query (FQ) software updates have been deployed to the ACE CERTIFICATION environment for the F106 Air Carrier Extract as follows:
• When returning F106 results for an Air Carrier, return the 2-character Census Abbreviation/IATA airline designator in the SCAC field, instead of the 3-character SCAC.
• Address data will not be returned in the F106 Carrier Query/Extract for Air Carriers.
FQ – Fixes deployed to CERT earlier but not yet in PROD:
-------------------------------------------------------
• When an "Air" MOT account has no Census Abbreviation/IATA code, the corresponding SCAC field will be blanked out (four spaces).
• Air Carrier List output ordered alphabetically by Carrier Name.
• F106 Air Carrier Extract to include Active air carriers only.
• Alphabetical ordering of Country list corrected in F202
• AGOA_CBPTA_BEGN_DT and AGOA_CBPTA_END_DT corrected in F202