dbo.items - Engineering - Engineering

Box Inc - Enterprise Data Catalog

Documentation	Engineering
Schema	dbo
Name	items
Module	Engineering

Items table holds all elements - products, parts, assemblies and raw materials that take part in manufacturing process.

Object	SKU format	Type
Products manufactured by company	PXXX	PRODUCT
Manufactured parts / components	RXX-XXX-XXX	PART
Intermediate assemblies	A-XXXX-XX(X)	ASSEMBLY
Purchased parts / components	Vendor specific	COMPONENT
Raw materials	M-XXXX-XXX-X	MATERIAL

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		item_id	int				Item system identifier
Item system identifier
	2		code	nvarchar(50)			Products.dbo.products
References: Products.dbo.products
	3		name	nvarchar(100)				Name of the item
Name of the item
	4		mfg_name	nvarchar(100)
	5		inventory_name	nvarchar(100)
	6		sku	nvarchar(50)				Stock Keeping Unit. See table description for list of used formats
Stock Keeping Unit. See table description for list of used formats
	7		type	nvarchar(50)				Code of item type: PRODUCT, PART, ASSEMBLY, COMPONENT, MATERIAL
Code of item type: PRODUCT, PART, ASSEMBLY, COMPONENT, MATERIAL
	8		procurement_type	nvarchar(50)
	9		status	nvarchar(50)

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.items		Products.dbo.products	dbo.items.code = Products.dbo.products.product_code	User-defined relation
dbo.items.code = Products.dbo.products.product_code Name: User-defined relation
dbo.assembly_tasks		dbo.items	dbo.assembly_tasks.item_id = dbo.items.item_id	FK_assembly_tasks_items
dbo.assembly_tasks.item_id = dbo.items.item_id Name: FK_assembly_tasks_items
dbo.bill_of_materials		dbo.items	dbo.bill_of_materials.parent_item_id = dbo.items.item_id	Parent FK_bill_of_materials_parent
dbo.bill_of_materials.parent_item_id = dbo.items.item_id Title: Parent Name: FK_bill_of_materials_parent
dbo.bill_of_materials		dbo.items	dbo.bill_of_materials.part_item_id = dbo.items.item_id	Part FK_bill_of_materials_part
dbo.bill_of_materials.part_item_id = dbo.items.item_id Title: Part Name: FK_bill_of_materials_part
dbo.drawings		dbo.items	dbo.drawings.item_id = dbo.items.item_id	FK_drawings_items
dbo.drawings.item_id = dbo.items.item_id Name: FK_drawings_items

Unique keys

	Key name	Columns	Description
	PK_items	item_id

Uses

Name
dbo.items
Products.dbo.products

Used by

Name
dbo.items
dbo.assembly_tasks
dbo.bill_of_materials (Parent)
dbo.bill_of_materials (Part)
dbo.drawings

Exported: 2019-02-04 23:17, Last imported: 2018-03-22 17:01