Task #15824: Billing - Extract List for Jan/Feb/Mar/Apr 2025 - level-3-support - Redmine

Actions

Copy link

Task #15824

closed

Billing - Extract List for Jan/Feb/Mar/Apr 2025

Added by Redmine Admin 7 months ago. Updated about 2 hours ago.

Status:

Closed

Priority:

High

Assignee:

Start date:

05/15/2025

Due date:

05/15/2025

% Done:

100%

Estimated time:

0:00 h

Spent time:

32:00 h

GitLab ID:

2569

GitLab Milestone:

GitLab Ticket Number:

507

GitLab Time Logged:

115200

Lock Timeline Date:

gitlab project trace:

Description

Modules :

Ocean Master BL IMP

Ocean House BL IMP

Air Master AWB IMP

Air Courier 3

Air Courier 4

Ocean Master Manifest

Air Master Manifest

Need to extract list to be billed for above and discrepancy list, if any per client.

Need also to extract NB Billing from CCS_BILLING tables for Customer Care/Business Dev to compare with.

GitLab Sync Log

[{"id": "23601", "author": "Nirmal Shibchurn", "hours": 8.0, "created": "2025-05-22T05:14:50.498Z", "log_date": "2025-05-18", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-22T05:14:50.498Z: 1d-(8.0)h spend at: 2025-05-18", "status": "active", "deleted_by": "", "redmine_entry_id": 7642}, {"id": "23600", "author": "Nirmal Shibchurn", "hours": 8.0, "created": "2025-05-22T05:14:43.839Z", "log_date": "2025-05-19", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-22T05:14:43.839Z: 1d-(8.0)h spend at: 2025-05-19", "status": "active", "deleted_by": "", "redmine_entry_id": 7643}, {"id": "23599", "author": "Nirmal Shibchurn", "hours": 7.0, "created": "2025-05-22T05:14:34.102Z", "log_date": "2025-05-20", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-22T05:14:34.102Z: 7h-(7.0)h spend at: 2025-05-20", "status": "active", "deleted_by": "", "redmine_entry_id": 7644}, {"id": "23598", "author": "Nirmal Shibchurn", "hours": 1.0, "created": "2025-05-22T05:14:25.889Z", "log_date": "2025-05-20", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-22T05:14:25.889Z: 1h-(1.0)h spend at: 2025-05-20", "status": "active", "deleted_by": "", "redmine_entry_id": 7645}, {"id": "23136", "author": "Nirmal Shibchurn", "hours": 8.0, "created": "2025-05-15T05:13:19.806Z", "log_date": "2025-05-13", "comment": "Imported from GitLab by @Nirmal Shibchurn on 2025-05-15T05:13:19.806Z: 1d-(8.0)h spend at: 2025-05-13", "status": "active", "deleted_by": "", "redmine_entry_id": 7646}]