pur.items
| Documentation | Procurement |
| Schema | pur |
| Name | items |
| Module | Items |
Catalog of purchased items.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | item_id | int | Identity | Inventory.inv.items | System item id | |||
| System item id Identity References: Inventory.inv.items |
||||||||
| 2 | internal_code (SKU) | nvarchar(30) | Stock keeping unit (SKU) - unique business identifier used within orgranization | |||||
| Stock keeping unit (SKU) - unique business identifier used within orgranization |
||||||||
| 3 | market_code | nvarchar(30) | Unused | |||||
| Unused |
||||||||
| 4 | internal_name | nvarchar(30) | Name used internally in engineering/inventory | |||||
| Name used internally in engineering/inventory |
||||||||
| 5 | market_name | nvarchar(30) | Name used for RFQs | |||||
| Name used for RFQs |
||||||||
| 6 | max_purchase_price | numeric(18, 0) | Maximum price at which item can be purchased as defined by procurement department internal control. | |||||
| Maximum price at which item can be purchased as defined by procurement department internal control. |
||||||||
| 7 | attribute1 | nvarchar(150) | Unused | |||||
| Unused |
||||||||
| 8 | attribute2 | nvarchar(150) | Unused | |||||
| Unused |
||||||||
| 9 | attribute3 | nvarchar(150) | Unused | |||||
| Unused |
||||||||
| 10 | attribute4 | nvarchar(150) | Unused | |||||
| Unused |
||||||||
| 11 | attribute5 | nvarchar(150) | Unused | |||||
| Unused |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| pur.items | Inventory.inv.items | pur.items.item_id = Inventory.inv.items.item_id | Items relation cross DB Items relation |
|
|
pur.items.item_id = Inventory.inv.items.item_id Name: Items relation cross DBItems relation |
||||
| pur.item_suppliers (Item suppliers) | pur.items | pur.item_suppliers.item_id = pur.items.item_id | FK_item_suppliers_items |
|
|
pur.item_suppliers.item_id = pur.items.item_id Name: FK_item_suppliers_items |
||||
| pur.purchase_order_lines | pur.items | pur.purchase_order_lines.po_line_id = pur.items.item_id | FK_purchase_order_lines_items |
|
|
pur.purchase_order_lines.po_line_id = pur.items.item_id Name: FK_purchase_order_lines_items |
||||
| pur.quotation_lines | pur.items | pur.quotation_lines.item_id = pur.items.item_id | FK_quotation_lines_items |
|
|
pur.quotation_lines.item_id = pur.items.item_id Name: FK_quotation_lines_items |
||||
| pur.requisition_lines (Line) | pur.items | pur.requisition_lines.item_id = pur.items.item_id | FK_requisition_lines_items |
|
|
pur.requisition_lines.item_id = pur.items.item_id Name: FK_requisition_lines_items |
||||
| 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.shipment_lines | pur.items | pur.shipment_lines.item_id = pur.items.item_id | FK_shipment_lines_items |
|
|
pur.shipment_lines.item_id = pur.items.item_id Name: FK_shipment_lines_items |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_items | item_id | ||
| UK_items_code | internal_code | ||
Uses
| Name |
|---|
|
pur.items
|
Used by
Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:11