pur.item_suppliers (Item suppliers)
| Documentation | Procurement |
| Schema | pur |
| Name | item_suppliers |
| Title | Item suppliers |
| Module | Suppliers |
This is n-n relation table that links suppliers and products. It specifies which suppliers
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | item_supplier_id | int | Identity | Internal row id | ||||
| Internal row id Identity |
||||||||
| 2 | item_id | int | pur.items Inventory.inv.items |
Item | ||||
| Item References: pur.items ,Inventory.inv.items |
||||||||
| 3 | supplier_id | int | pur.suppliers | Supplier of the item | ||||
| Supplier of the item References: pur.suppliers |
||||||||
| 4 | crated_date | date | Date a row was entered to the system | |||||
| Date a row was entered to the system |
||||||||
| 5 | created_by | nvarchar(50) | Login of user who created row | |||||
| Login of user who created row |
||||||||
| 6 | approval_status | nvarchar(10) | PENDING, APPROVED, CANCELLED | |||||
| PENDING, APPROVED, CANCELLED |
||||||||
| 7 | approved_flag | bit | Default: 0 | 1 when approved, 0 otherwise | ||||
| 1 when approved, 0 otherwise Default: 0 |
||||||||
| 8 | approved_date | date | Date when supplier of the item was approved | |||||
| Date when supplier of the item was approved |
||||||||
| 9 | price | decimal(18, 0) | Basic price in currency | |||||
| Basic price in currency |
||||||||
| 10 | currency | nvarchar(50) | Supplier bsase currency | |||||
| Supplier bsase currency |
||||||||
| 11 | price_usd | decimal(18, 0) | Price converted to USD | |||||
| Price converted to USD |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| 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.item_suppliers (Item suppliers) | Inventory.inv.items | pur.item_suppliers.item_id = Inventory.inv.items.item_id | User-defined relation |
|
|
pur.item_suppliers.item_id = Inventory.inv.items.item_id Name: User-defined relation |
||||
| pur.item_suppliers (Item suppliers) | pur.suppliers | pur.item_suppliers.supplier_id = pur.suppliers.supplier_id | FK_item_suppliers_suppliers |
|
|
pur.item_suppliers.supplier_id = pur.suppliers.supplier_id Name: FK_item_suppliers_suppliers |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_item_suppliers | item_supplier_id | ||
Uses
| Name |
|---|
|
pur.item_suppliers (Item suppliers)
|
Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:11