query(" SELECT eq.EquivalenceID, sl.ShippingLineName, cc.CustomsDescription, n4.N4Description, eq.EffectiveDate, eq.IsActive FROM equivalence_catalog eq JOIN shipping_lines sl ON eq.ShippingLineCode = sl.ShippingLineCode JOIN customs_container_types cc ON eq.CustomsKeyFK = cc.CustomsKey JOIN n4_container_types n4 ON eq.N4KeyFK = n4.N4Key ORDER BY sl.ShippingLineName, eq.EffectiveDate DESC "); $equivalences = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { // For now, just show a simple error. die("Could not fetch data: " . $e->getMessage()); } ?> Container Equivalence Catalog

Shipping Line Equivalence Catalog

Shipping Line Customs Description N4 Description Effective Date Status Actions
No equivalence records found. The database might be empty.
Active Inactive
Displaying records.