La Porte Pool Reconciliation

Reconciles Edge data against Blume. The pool-location sections identify pool entries needing container numbers, and reservations not found in Blume or with invalid statuses/customers. Unmatched Containers reports containers in Edge with no Blume match, and Blume containers with no Edge match. Unmatched Reservations reports Blume reservations in Reserved status (valid shippers, LA/Inland Empire metro) that can't be found by reservation number in the Edge Recon.

Analyzes the WC Report in two passes. Pass 1 (Outbound Closed): checks containers against Edge shipments and pool entries to flag those needing rail billing, or unable to be found in Edge. Pass 2 (Outbound Loading & Empty Trailers): checks containers against pool entries, then Blume (EMHU/UMXU) or the COFC Report (CFQU) to flag missing pool entries. Items already caught in previous checks are excluded.

Compares containers from the Burlington (BRLWCT) Report against the Edge Recon pool entries. Only containers beginning with C, U, or E are included. Containers not found in the pool are also checked against the Edge Recon shipments. CFQU containers still not found are checked against the COFC Container Report for origin, destination, BCO, per diem, and building code details. EMHU and UMXU containers still not found are flagged separately. Items already caught in previous checks are excluded.