VENDOR

Each row defines a Vendor who has a relationship with a Store, or all the Stores in a StoreGroup, generally to provide inventory.

Column Descriptions:

Name	Type	Description
VENDOR_ID	BIGINT NOT NULL	Generated unique identifier.
STOREENT_ID	INTEGER NOT NULL	The Vendor has a relationship with this Store, or all the Stores in this StoreGroup.
LASTUPDATE	TIMESTAMP	The time this row was most recently updated.
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	Indicates if this Vendor has been marked for deletion: 0 = No. 1 = Yes, this Vendor and its associated values may be deleted from the system.
VENDORNAME	CHAR (30) NOT NULL	Uniquely identifies the Vendor for this StoreEntity.
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	Primary Key
I0000263	STOREENT_ID+VENDORNAME	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_901	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_651	VENDOR_ID	RA	VENDOR_ID	Cascade
F_664	VENDOR_ID	RECEIPT	VENDOR_ID	Cascade
F_904	VENDOR_ID	VENDORDESC	VENDOR_ID	Cascade

Related reference
ATP expected inventory data model
Receipt data model
Vendor data model