inv.warehouse_transfers - Inventory

Box Inc - Enterprise Data Catalog

Documentation	Inventory
Schema	inv
Name	warehouse_transfers
Module	Inventory

Transfers of materials between warehouses. Each transfer is a pair of transactions - source and destination.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		transfer_id	int				Transfer ID
Transfer ID
	2		date	date				Transaction date and time
Transaction date and time
	3		src_transaction_id	int			inv.transactions	Source transaction
Source transaction References: inv.transactions
	4		dest_transaction_id	int			inv.transactions	Destination transaction
Destination transaction References: inv.transactions

Relations

Foreign table		Primary table	Join	Title / Name / Description
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
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

Unique keys

	Key name	Columns	Description
	PK_warehouse_transfers	transfer_id

Uses

Name
inv.warehouse_transfers
inv.transactions
inv.transactions

Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:31