Vendor_types

Columns

Name	Type	Length	Precision	Scale	References	In	Description
isinactive	VARCHAR2	3					Item is inactive
name	VARCHAR2	31					Name
parent_id	NUMBER		39	0			Child of
vendor_type_extid	VARCHAR2	255					Vendor type external ID
vendor_type_id	NUMBER		39	0			Vendor type ID

Primary key

PK Column Name
vendor_type_id

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Vendors_vendor_types_fk	vendor_type_id	Vendors	vendor_type_id	1