inv.transaction_types - Inventory - Inventory

Box Inc - Enterprise Data Catalog

Documentation	Inventory
Schema	inv
Name	transaction_types
Module	Inventory

Transaction can be categor

List of transaction types

Class - generic, built in class of transaction: Receive, Release, Movement
Type - Specific configurable type of transaction
Transaction - specifict transaction: warehouse, material, time, quantity

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		transaction_type_id	int				Transaction type ID
Transaction type ID
	2		transaction_type_code	nvarchar(10)				Transaction type text code
Transaction type text code
	3		name	nvarchar(150)				User firendly transaction type name
User firendly transaction type name
	4		transaction_class	nvarchar(50)				RCV - receive, REL - release
RCV - receive, REL - release

Relations

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

Unique keys

	Key name	Columns	Description
	PK_transaction_types	transaction_type_id

	IX_transaction_types	transaction_type_code

Used by

Name
inv.transaction_types
inv.transactions

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