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:

NameTypeDescription
VENDOR_IDBIGINT NOT NULLGenerated unique identifier.
STOREENT_IDINTEGER NOT NULLThe Vendor has a relationship with this Store, or all the Stores in this StoreGroup.
LASTUPDATETIMESTAMPThe time this row was most recently updated.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this Vendor has been marked for deletion: 0 = No. 1 = Yes, this Vendor and its associated values may be deleted from the system.
VENDORNAMECHAR (30) NOT NULLUniquely identifies the Vendor for this StoreEntity.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>VENDOR_IDPrimary Key
I0000263STOREENT_ID+VENDORNAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_901STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_651VENDOR_IDRAVENDOR_IDCascade
F_664VENDOR_IDRECEIPTVENDOR_IDCascade
F_904VENDOR_IDVENDORDESCVENDOR_IDCascade