VENDORDESC

Language-specific information about Vendors.

Column Descriptions:

Name	Type	Description
VENDOR_ID	BIGINT NOT NULL	Unique identifier for the Vendor.
LANGUAGE_ID	INTEGER NOT NULL	Language ID for this description. For a list of language components, see the LANGUAGE table.
STADDRESS_ID	INTEGER NOT NULL	Refers to address information for this Vendor in the STADDRESS table.
DESCRIPTION	VARCHAR (254)	Language specific descriptive information about the Vendor.
LASTUPDATE	TIMESTAMP	Timestamp of last update.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	VENDOR_ID+LANGUAGE_ID	Primary Key
I0000829	STADDRESS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_902	STADDRESS_ID	STADDRESS	STADDRESS_ID	Cascade
F_903	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_904	VENDOR_ID	VENDOR	VENDOR_ID	Cascade

Related reference
Vendor data model