inv.transactions
| Documentation | Inventory |
| Schema | inv |
| Name | transactions |
| Module | Inventory |
Material transactions - receipts, releaes, movements.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | transaction_id | int | inv.transactions | Transaction row ID | ||||
| Transaction row ID References: inv.transactions |
||||||||
| 2 | transaction_no | int | Transaction system number | |||||
| Transaction system number |
||||||||
| 3 | date | date | Transaction date and time | |||||
| Transaction date and time |
||||||||
| 4 | item_id | int | inv.items | Item | ||||
| Item References: inv.items |
||||||||
| 5 | warehouse_id | int | inv.warehouses | Warehouse of item movement (receipt or release) | ||||
| Warehouse of item movement (receipt or release) References: inv.warehouses |
||||||||
| 6 | transaction_type_id | int | inv.transaction_types | Type of transaction from the dictionary | ||||
| Type of transaction from the dictionary References: inv.transaction_types |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| inv.transactions | inv.items | inv.transactions.item_id = inv.items.item_id | User-defined relation |
|
|
inv.transactions.item_id = inv.items.item_id Name: User-defined relation |
||||
| inv.transactions | inv.transaction_types | inv.transactions.transaction_type_id = inv.transaction_types.transaction_type_id | User-defined relation |
|
|
inv.transactions.transaction_type_id = inv.transaction_types.transaction_type_id Name: User-defined relation |
||||
| inv.transactions | inv.transactions | inv.transactions.transaction_id = inv.transactions.transaction_id | FK_transactions_transactions |
|
|
inv.transactions.transaction_id = inv.transactions.transaction_id Name: FK_transactions_transactions |
||||
| inv.transactions | inv.warehouses | inv.transactions.warehouse_id = inv.warehouses.warehouse_id | User-defined relation |
|
|
inv.transactions.warehouse_id = inv.warehouses.warehouse_id Name: User-defined relation |
||||
| inv.transactions | inv.transactions | inv.transactions.transaction_id = inv.transactions.transaction_id | FK_transactions_transactions |
|
|
inv.transactions.transaction_id = inv.transactions.transaction_id Name: FK_transactions_transactions |
||||
| inv.warehouse_transfers | inv.transactions | inv.warehouse_transfers.dest_transaction_id = inv.transactions.transaction_id | User-defined relation |
|
|
inv.warehouse_transfers.dest_transaction_id = inv.transactions.transaction_id Name: User-defined relation |
||||
| inv.warehouse_transfers | inv.transactions | inv.warehouse_transfers.src_transaction_id = inv.transactions.transaction_id | User-defined relation |
|
|
inv.warehouse_transfers.src_transaction_id = inv.transactions.transaction_id Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_transactions | transaction_id | ||
| IX_transactions | transaction_no | ||
Uses
| Name |
|---|
|
inv.transactions
|
|
inv.transactions
|
Used by
| Name |
|---|
|
inv.transactions
|
|
inv.transactions
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:31