Import Inland Arrival Notices - Discharge/Clearance Port Logic

The import department has requested a review of the logic necessary to send inland arrival notices. We have developed a new set of criteria which should simply the process significantly.

The new logic follows below, and relies significantly on the comparison between the discharge and the clearance port (this is a new field in our ACMain table).

1. If Discharge/Clearance match, then send notice when container gates in or off-rails at delivery location.
2. If Discharge/Clearance do not match.
• Send notice when container gates in or off-rails at clearance port
• Send notice when container gates in or off-rails at delivery location

Here are the objects adjusted to enable the change in logic, most of this was done to accommodate the new criteria of Discharge/Clearance match.

1. Tables
1. ACMain –
• DischargeClearanceMatchGroup field added
• Adjusted Process Steps 70, 71, 72 to hold new filters
• Deleted Process Steps 73, 74, and 75 which are no longer necessary
2. ACDischargeClearanceMatchGroups – new table
3. ACDischargeClearanceMatchValues – new table
2. Views
1. ACShipmentDataView – added joins and field (DischargeClearanceMatch)
2. ACProcessingView – added joins and field for new logic
3. Stored Procedures
1. ACShipmentDataSproc – This is the main stored procedure, which needed new variables to hold the discharge/clearance field
2. ACLogicSproc – This stored procedure compares the activity to the ACMain logic table.