pur.rfq_lines (RFQ lines)
| Documentation | Procurement |
| Schema | pur |
| Name | rfq_lines |
| Title | RFQ lines |
| Module | RFQs & Quotations |
Table holds RFQ lines. Together with rfqs create a RFQ document.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | rfq_line_id | int | Identity | RFQ line id | ||||
| RFQ line id Identity |
||||||||
| 2 | rfq_id | int | pur.rfqs (RFQs) | RFQ header id | ||||
| RFQ header id References: pur.rfqs (RFQs) |
||||||||
| 3 | line_no | nchar(10) | Line # | |||||
| Line # |
||||||||
| 4 | item_id | int | pur.items | Item | ||||
| Item References: pur.items |
||||||||
| 5 | requisition_line_id | int | pur.requisition_lines (Line) | Linked requisition line | ||||
| Linked requisition line References: pur.requisition_lines (Line) |
||||||||
| 6 | item_internal_code | nvarchar(20) | Item internal code | |||||
| Item internal code |
||||||||
| 7 | supplier_code | nvarchar(20) | Supplier item code | |||||
| Supplier item code |
||||||||
| 8 | quotation_item_title | nvarchar(50) | If item name was to be overridden for RFQ it is held in this field as a free text | |||||
| If item name was to be overridden for RFQ it is held in this field as a free text |
||||||||
| 9 | quantity | numeric(18, 0) | Quantity requested | |||||
| Quantity requested |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| pur.rfq_lines (RFQ lines) | pur.items | pur.rfq_lines.item_id = pur.items.item_id | FK_rfq_lines_items |
|
|
pur.rfq_lines.item_id = pur.items.item_id Name: FK_rfq_lines_items |
||||
| pur.rfq_lines (RFQ lines) | pur.requisition_lines (Line) | pur.rfq_lines.requisition_line_id = pur.requisition_lines.requisition_line_id | FK_rfq_lines_requisition_lines |
|
|
pur.rfq_lines.requisition_line_id = pur.requisition_lines.requisition_line_id Name: FK_rfq_lines_requisition_lines |
||||
| 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 |
||||
| pur.quotation_lines | pur.rfq_lines (RFQ lines) | pur.quotation_lines.rfq_line_id = pur.rfq_lines.rfq_line_id | FK_quotation_lines_rfq_lines |
|
|
pur.quotation_lines.rfq_line_id = pur.rfq_lines.rfq_line_id Name: FK_quotation_lines_rfq_lines |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_rfq_lines | rfq_line_id | ||
Uses
| Name |
|---|
|
pur.rfq_lines (RFQ lines)
|
Used by
| Name |
|---|
|
pur.rfq_lines (RFQ lines)
|
Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:11