Items
MVP Prototype
SEG Warehouse Fee Application
Warehouses
Rates
Fee projections
Requirement Summary
- Internal SEG users log in with Cognito email and password.
- Admins maintain warehouses, rates, projection history, and audit records.
- Users can create and edit item master records. Item changes notify all Admin users.
- Warehouse rates are unique by warehouse plus item no.
- Storage fee projections save row-level calculation details and can be downloaded as CSV.
Shared Setup
Item Setup
Upload Item CSV
Create or update multiple items. Item No is unique and duplicate item numbers inside one file are rejected.
| Item No | Description | Category | Subcategory | Code | Units / MC | MC / Pallet | Units / Pallet | Unit Wt lb | Unit L in | Unit H in | Unit D in | MC Wt lb | MC L in | MC H in | MC D in | Status |
|---|
Admin Only
Warehouse Setup
| Warehouse Code | Warehouse Name | Status |
|---|
Admin Only
Admin Rate Setup
Upload Rate CSV
Columns: warehouse, item no, fee type, rate. Duplicate warehouse + item no is rejected.
| Warehouse | Item No | Fee Type | Rate | Updated By | Updated At |
|---|
Admin and User
Warehouse Storage Fee Projection
Upload Inventory CSV
Projection columns: item no, no of units, warehouse. Missing item, warehouse, units, item setup, warehouse setup, or rate is rejected by row.
Calculation Results
0 rows$0.00
Upload inventory CSV to project warehouse storage fees.
| Row | Item No | Warehouse | Units | Charge Qty | Rate | Storage Fee | Unit Fee | Fee Type | Status | Error |
|---|
Admin Only
Upload History
| Upload ID | File Name | Uploaded By | Uploaded At | Total Rows | Error Rows | Total Fee | Status |
|---|