Task #19281: House Bill of Lading (HBL) Repository – Ocean Freight - FFA - Redmine

Actions

Copy link

Task #19281

open

Task #19245: Sprint Planning for 19/01/2026 - 30/01/2026

House Bill of Lading (HBL) Repository – Ocean Freight

Added by Redmine Admin 8 months ago. Updated 3 months ago.

Status:

New

Priority:

Normal

Assignee:

Start date:

01/14/2026

Due date:

01/14/2026 (about 8 months late)

% Done:

100%

Estimated time:

40:00 h

Spent time:

137:00 h

GitLab ID:

3695

GitLab Milestone:

GitLab Ticket Number:

1128

GitLab Time Logged:

493200

Lock Timeline Date:

gitlab project trace:

Sprint Planning for 19/01/2026 - 30/01/2026

Description

House Repo ocean.xlsx - Proposed Template

The Operations officer wants a centralized repository to view, search, and manage House Bills of Lading (HBL) for ocean shipments, so that they can efficiently track shipments, verify shipment parties, understand routing, link to Master Bills of Lading (MBLs), and rely on accurate, up-to-date data for operational and audit purposes.

Acceptance Criteria

1. Repository View

The system displays a tabular list of all HBL records for ocean shipments.
Each record shows:

(a) HBL Reference

(b) MBL Reference

(d) Consignee

(e) Port of Loading

(f) Port of Destination

The list loads by default when the repository screen is opened.

2. Search Functionality

Users can search by:
A search field is available on the repository screen.

(a) HBL Reference

(b) MBL Reference
Matching results are displayed in real-time or upon search action.
If no records are found, an appropriate message is displayed.

3. Shipment Parties & Routing

Shipper and Consignee names are displayed for each HBL record, in a readable, non-truncated format.
Port of Loading and Port of Destination are displayed as separate columns, following standardized port naming conventions.
Data for parties and ports matches the linked HBL and shipment records.

4. Linkage to Master Bill of Lading

Each HBL displays its corresponding MBL reference.
Multiple HBLs can share the same MBL reference, accurately reflecting consolidation (LCL) scenarios.

5. Access to Detailed HBL Records

Clicking an HBL reference opens the detailed HBL screen in view mode.
The correct HBL data is loaded for further review or management.

6. Data Accuracy & Maintenance

Only valid and active HBL records for ocean shipments are displayed.
Data updates are reflected in real-time or after a refresh.
Deleted HBLs are excluded from the repository.

GitLab Sync Log

[{"id": "40996", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-03-25T11:36:02.823Z", "log_date": "2026-03-25", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-03-25T11:36:02.823Z: 7h-(7.0)h spend at: 2026-03-25", "status": "active", "deleted_by": "", "redmine_entry_id": 12754}, {"id": "41366", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-03-31T11:56:18.820Z", "log_date": "2026-03-30", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-03-31T11:56:18.820Z: 7h-(7.0)h spend at: 2026-03-30", "status": "active", "deleted_by": "", "redmine_entry_id": 12852}, {"id": "41365", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-03-31T11:56:09.576Z", "log_date": "2026-03-29", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-03-31T11:56:09.576Z: 7h-(7.0)h spend at: 2026-03-29", "status": "active", "deleted_by": "", "redmine_entry_id": 12853}, {"id": "41412", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-02T05:12:53.741Z", "log_date": "2026-03-31", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-02T05:12:53.741Z: 7h-(7.0)h spend at: 2026-03-31", "status": "active", "deleted_by": "", "redmine_entry_id": 12877}, {"id": "41572", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-03T10:44:14.221Z", "log_date": "2026-04-01", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-03T10:44:14.221Z: 7h-(7.0)h spend at: 2026-04-01", "status": "active", "deleted_by": "", "redmine_entry_id": 12896}, {"id": "41576", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-06T06:03:46.113Z", "log_date": "2026-04-05", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-06T06:03:46.113Z: 7h-(7.0)h spend at: 2026-04-05", "status": "active", "deleted_by": "", "redmine_entry_id": 12897}, {"id": "41575", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-06T06:02:05.471Z", "log_date": "2026-04-02", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-06T06:02:05.471Z: 7h-(7.0)h spend at: 2026-04-02", "status": "active", "deleted_by": "", "redmine_entry_id": 12898}, {"id": "41784", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-09T08:01:03.407Z", "log_date": "2026-04-07", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-09T08:01:03.407Z: 7h-(7.0)h spend at: 2026-04-07", "status": "active", "deleted_by": "", "redmine_entry_id": 12946}, {"id": "41783", "author": "Vishesh Jodhoa", "hours": 3.0, "created": "2026-04-09T08:00:53.994Z", "log_date": "2026-04-06", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-09T08:00:53.994Z: 3h-(3.0)h spend at: 2026-04-06", "status": "active", "deleted_by": "", "redmine_entry_id": 12947}, {"id": "42052", "author": "Vishesh Jodhoa", "hours": 3.0, "created": "2026-04-13T04:46:36.540Z", "log_date": "2026-04-08", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-13T04:46:36.540Z: 3h-(3.0)h spend at: 2026-04-08", "status": "active", "deleted_by": "", "redmine_entry_id": 13050}, {"id": "42455", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-20T04:25:32.919Z", "log_date": "2026-04-16", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-20T04:25:32.919Z: 7h-(7.0)h spend at: 2026-04-16", "status": "active", "deleted_by": "", "redmine_entry_id": 13142}, {"id": "42454", "author": "Vishesh Jodhoa", "hours": 6.0, "created": "2026-04-20T04:25:20.797Z", "log_date": "2026-04-15", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-20T04:25:20.797Z: 6h-(6.0)h spend at: 2026-04-15", "status": "active", "deleted_by": "", "redmine_entry_id": 13143}, {"id": "42453", "author": "Vishesh Jodhoa", "hours": 3.0, "created": "2026-04-20T04:25:09.639Z", "log_date": "2026-04-14", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-20T04:25:09.639Z: 3h-(3.0)h spend at: 2026-04-14", "status": "active", "deleted_by": "", "redmine_entry_id": 13144}, {"id": "42452", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-20T04:24:58.308Z", "log_date": "2026-04-13", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-20T04:24:58.308Z: 7h-(7.0)h spend at: 2026-04-13", "status": "active", "deleted_by": "", "redmine_entry_id": 13145}, {"id": "42451", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-20T04:24:46.983Z", "log_date": "2026-04-12", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-20T04:24:46.983Z: 7h-(7.0)h spend at: 2026-04-12", "status": "active", "deleted_by": "", "redmine_entry_id": 13146}, {"id": "43487", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-30T10:31:29.399Z", "log_date": "2026-04-29", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-30T10:31:29.399Z: 7h-(7.0)h spend at: 2026-04-29", "status": "active", "deleted_by": "", "redmine_entry_id": 13398}, {"id": "43486", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-30T10:31:12.136Z", "log_date": "2026-04-28", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-30T10:31:12.136Z: 7h-(7.0)h spend at: 2026-04-28", "status": "active", "deleted_by": "", "redmine_entry_id": 13399}, {"id": "43485", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-04-30T10:30:59.226Z", "log_date": "2026-04-27", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-04-30T10:30:59.226Z: 7h-(7.0)h spend at: 2026-04-27", "status": "active", "deleted_by": "", "redmine_entry_id": 13400}, {"id": "44035", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-05-11T07:44:44.602Z", "log_date": "2026-05-06", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-05-11T07:44:44.602Z: 7h-(7.0)h spend at: 2026-05-06", "status": "active", "deleted_by": "", "redmine_entry_id": 13511}, {"id": "44237", "author": "Vishesh Jodhoa", "hours": 7.0, "created": "2026-05-13T05:41:05.654Z", "log_date": "2026-05-11", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-05-13T05:41:05.654Z: 7h-(7.0)h spend at: 2026-05-11", "status": "active", "deleted_by": "", "redmine_entry_id": 13563}, {"id": "44236", "author": "Vishesh Jodhoa", "hours": 4.0, "created": "2026-05-13T05:40:56.374Z", "log_date": "2026-05-10", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-05-13T05:40:56.374Z: 4h-(4.0)h spend at: 2026-05-10", "status": "active", "deleted_by": "", "redmine_entry_id": 13564}, {"id": "45149", "author": "Vishesh Jodhoa", "hours": 3.0, "created": "2026-05-28T11:43:44.214Z", "log_date": "2026-05-26", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-05-28T11:43:44.214Z: 3h-(3.0)h spend at: 2026-05-26", "status": "active", "deleted_by": "", "redmine_entry_id": 13784}, {"id": "45137", "author": "Vishesh Jodhoa", "hours": 3.0, "created": "2026-05-28T11:38:38.698Z", "log_date": "2026-05-25", "comment": "Imported from GitLab by @Vishesh Jodhoa on 2026-05-28T11:38:38.698Z: 3h-(3.0)h spend at: 2026-05-25", "status": "active", "deleted_by": "", "redmine_entry_id": 13785}]