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
| Column Name
| Column 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
| Reserved for IBM internal use.
|