Workflow Visualization
What It Does
- Cost Logic Retrieval: Fetches appropriate cost calculation logic based on service type
- Multi-Service Calculation: Processes costs for multiple service requests simultaneously
- Unit-Based Pricing: Calculates costs per unit type (containers, ISO tanks, swap bodies, semi-trailers)
- Route-Specific Pricing: Applies pricing based on rail and truck service routes
- Surplus Calculation: Adds 12% surplus to final total cost
Key Features
Cost Components
- Rail Cost: Based on rail service and unit type
- Truck Cost: Based on door service or truck service ID
- Quantity Multiplier: Automatically multiplies unit prices by quantity
- Cost Breakdown: Detailed breakdown by unit type and service
Pricing Logic
- Fetches pricing from
db_ai-loop_RAIL_COSTcollection - Fetches truck pricing from
db_ai-loop_TRUCK_COSTcollection - Matches unit types with available pricing data
- Calculates subtotals per service and grand total
How to Use
1
Inquiry Received
After quotation management creates an inquiry, the system triggers cost calculation automatically.2
Cost Calculation
The flow fetches pricing data, calculates costs for all units, and applies 12% surplus.3
Status Update
Inquiry status updates to “COST_CALCULATED” with detailed cost summary stored in database.Technical Details
Database:- Cost Logic:
datalake_main.db_ai-loop_Cost_Logic - Rail Pricing:
datalake_main.db_ai-loop_RAIL_COST - Truck Pricing:
datalake_main.db_ai-loop_TRUCK_COST - Inquiries:
datalake_main.db_ai-loop_CRM_Inquiries
- Surplus: 12%
- Unit detection: Size-based and type-based fallback logic
- Empty vs. full pricing differentiation