pur.rfqs (RFQs)
| Documentation | Procurement |
| Schema | pur |
| Name | rfqs |
| Title | RFQs |
| Module | RFQs & Quotations |
Table holds RFQ headers. Together with rfq_lines create a RFQ document.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Sensitive | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | rfq_id | int | Identity | RFQ header id | |||||
| RFQ header id Identity |
|||||||||
| 2 | supplier_id | int | pur.suppliers | Supplier | |||||
| Supplier References: pur.suppliers |
|||||||||
| 3 | created_date | date | Date RFQ was created in the system | ||||||
| Date RFQ was created in the system |
|||||||||
| 4 | comments | nvarchar(4000) | Additional comments sent to supplier | ||||||
| Additional comments sent to supplier |
|||||||||
| 5 | sent_date | date | Date RFQ was sent to supplier | ||||||
| Date RFQ was sent to supplier |
|||||||||
| 6 | employee | nvarchar(50) | Login of employee who entered RFQ to the system | Y | |||||
| Login of employee who entered RFQ to the system Sensitive: Y |
|||||||||
| 7 | approved_flag | bit | Default: 0 | Flag determining if RFQ is approved. 1 - approved, 0 - otherwise | |||||
| Flag determining if RFQ is approved. 1 - approved, 0 - otherwise Default: 0 |
|||||||||
| 8 | supplier_received_flag | bit | Default: 0 | When suppliers confirm receiving of RFQ it is marked against header. 1 - received, 0 - unknown | |||||
| When suppliers confirm receiving of RFQ it is marked against header. 1 - received, 0 - unknown Default: 0 |
|||||||||
| 9 | supplier_rcv_confirmed_date | date | Date of supplier confirmation of receiving the document | ||||||
| Date of supplier confirmation of receiving the document |
|||||||||
| 10 | attribute1 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 11 | attribute2 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 12 | attribute3 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 13 | attribute4 | nvarchar(150) | Unused | ||||||
| Unused |
|||||||||
| 14 | attribute5 | nvarchar(150) | Login of person who approved document. | ||||||
| Login of person who approved document. |
|||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| pur.rfqs (RFQs) | pur.suppliers | pur.rfqs.supplier_id = pur.suppliers.supplier_id | FK_rfqs_suppliers |
|
|
pur.rfqs.supplier_id = pur.suppliers.supplier_id Name: FK_rfqs_suppliers |
||||
| 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.rfq_lines (RFQ lines) | pur.rfqs (RFQs) | pur.rfq_lines.rfq_id = pur.rfqs.rfq_id | FK_rfq_lines_rfqs |
|
|
pur.rfq_lines.rfq_id = pur.rfqs.rfq_id Name: FK_rfq_lines_rfqs |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_rfqs | rfq_id | ||
Uses
| Name |
|---|
|
pur.rfqs (RFQs)
|
Used by
| Name |
|---|
|
pur.rfqs (RFQs)
|
Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:11