| Title: | ACE Extract Reference File Query (FQ) fixes Deployed to CERTIFICATION |
|---|---|
| Date: | 2017-03-24 |
| To: | abi,air,newace,ocean,rail,truck |
| Links: | previous, original, next |
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