pur.quotations
| Documentation | Procurement |
| Schema | pur |
| Name | quotations |
| Module | RFQs & Quotations |
Table holds quotation headers. Together with quitation_lines create a quotation document.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Sensitive | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | quotation_id | int | Identity | Quotation header id | |||||
| Quotation header id Identity |
|||||||||
| 2 | supplier_id | int | pur.suppliers | Supplier quotation was received from | |||||
| Supplier quotation was received from References: pur.suppliers |
|||||||||
| 3 | quotation_date | date | Date on quotation | ||||||
| Date on quotation |
|||||||||
| 4 | quotation_ref | nvarchar(50) | Supplier refrence number | ||||||
| Supplier refrence number |
|||||||||
| 5 | comments | nvarchar(4000) | Buyer comments | ||||||
| Buyer comments |
|||||||||
| 6 | received_date | date | Date quotation was received | ||||||
| Date quotation was received |
|||||||||
| 7 | supplier_contact | nvarchar(50) | Name of supplier contact person | Y | |||||
| Name of supplier contact person Sensitive: Y |
|||||||||
| 8 | supplier_contact_email | nvarchar(50) | Email of supplier contact | Y | |||||
| Email of supplier contact Sensitive: Y |
|||||||||
| 9 | supplier_contact_phone | nvarchar(50) | Supplier contact phone no | Y | |||||
| Supplier contact phone no Sensitive: Y |
|||||||||
| 10 | employee | nvarchar(50) | Buyer (employee) login | Y | |||||
| Buyer (employee) login Sensitive: Y |
|||||||||
| 11 | delivery_cost | numeric(18, 0) | Delivery cost for quotation in USD | ||||||
| Delivery cost for quotation in USD |
|||||||||
| 12 | promised_delivery_date | date | Delivery date binding by order by | ||||||
| Delivery date binding by order by |
|||||||||
| 13 | order_by | date | Order by date as on quote | ||||||
| Order by date as on quote |
|||||||||
| 14 | payment_terms | nvarchar(50) | Free hand text for payment terms | ||||||
| Free hand text for payment terms |
|||||||||
| 15 | rfq_id | int | pur.rfqs (RFQs) | Linked request for quotation | |||||
| Linked request for quotation References: pur.rfqs (RFQs) |
|||||||||
| 16 | attribute1 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 17 | attribute2 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 18 | attribute3 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 19 | attribute4 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 20 | attribute5 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| pur.quotations | pur.rfqs (RFQs) | pur.quotations.rfq_id = pur.rfqs.rfq_id | FK_quotations_rfqs |
|
|
pur.quotations.rfq_id = pur.rfqs.rfq_id Name: FK_quotations_rfqs |
||||
| pur.quotations | pur.suppliers | pur.quotations.supplier_id = pur.suppliers.supplier_id | FK_quotations_suppliers |
|
|
pur.quotations.supplier_id = pur.suppliers.supplier_id Name: FK_quotations_suppliers |
||||
| pur.purchase_orders | pur.quotations | pur.purchase_orders.quotation_id = pur.quotations.quotation_id | FK_purchase_orders_quotations |
|
|
pur.purchase_orders.quotation_id = pur.quotations.quotation_id Name: FK_purchase_orders_quotations |
||||
| pur.quotation_lines | pur.quotations | pur.quotation_lines.quotation_id = pur.quotations.quotation_id | FK_quotation_lines_quotations |
|
|
pur.quotation_lines.quotation_id = pur.quotations.quotation_id Name: FK_quotation_lines_quotations |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_quotations | quotation_id | ||
Uses
| Name |
|---|
|
pur.quotations
|
Used by
| Name |
|---|
|
pur.quotations
|
Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:11