Database Table: 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 Name Column Type Column Description
LASTUPDATE TIMESTAMP
NULL
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.
STOREENT_ID INTEGER
NOT NULL
The Vendor has a relationship with this Store, or all the Stores in this StoreGroup.
VENDORNAME CHARACTER (30)
NOT NULL
Uniquely identifies the Vendor for this StoreEntity.
VENDOR_ID BIGINT
NOT NULL
Generated unique identifier.
Indexes:
Index Name Indexed Column Names Index Type
I0000263 STOREENT_ID, VENDORNAME Unique Index
SQL030416035143290 VENDOR_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_901 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint 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