Specs of Deliveries Table 7. Deliveries Table
Purpose: To track all equipment deliveries to site.
Columns:
Delivery ID (Text, Unique ID, could be a Coda ID)
PO ID (Lookup - from the Purchase Orders Table)
Actual Delivery Date (Date)
Equipment (Lookup - from the Equipment table)
Supplier Name (Lookup - from the Suppliers Table)
Delivery Location (Text)
Delivery Status (Select – “Delivered”, “Partial Delivery”, “Delayed”)
Notes (Text - issues, damages, etc.)
Formulas:
Can have a formula to calculate the delivery lead time.
Can have a formula to compare the Delivery Date with the Planned Delivery Date.