6. Purchase Orders (PO) Table
Purpose: To manage all issued purchase orders.
Columns:
PO ID (Text, Unique ID, could be a Coda ID)
Equipment (Lookup - from the Equipment Table)
Supplier Name (Lookup - from the Suppliers Table)
Bid ID (Lookup - from the Bids Table)
PO Date (Date)
Order Value (Currency)
Currency (Select)
Delivery Address (Text)
Status (Select - “Pending,” “Ordered,” “In Transit,” “Delivered,” “Closed”)
Notes (Text)