A filing whose fields carry different deadlines should be stored as one record per field, each with its own due date, source and version, rather than as one row per shipment.

Why one deadline per shipment record breaks

The naive model attaches a single transmit-by timestamp to the shipment and treats the filing as a document that goes out once. The Importer Security Filing does not work that way. Under 19 CFR 149.2(b), the seller, buyer, importer of record number and consignee number are due no later than 24 hours before the cargo is loaded aboard the vessel at the foreign port. The same 24-hour pre-lading anchor covers the manufacturer or supplier, the party being shipped to, the origin country and the classification line. Container stuffing location and consolidator are different.…