STLFFMREL

This table holds relationships between store location and fulfillment center.

Column Descriptions:

NameTypeDescription
STLFFMREL_IDINTEGER NOT NULLUnique ID and primary key
STLOC_IDINTEGER NOT NULLThe identifier to physical store.
FFMCENTER_IDINTEGER NOT NULLThe reference number for the fulfillment center that represents the fulfillment for the specified store
ADDRESS_IDBIGINT NOT NULLThe address of the physical store as stored in the Address table. This is typically used as the shipping address for items that are for in-store pickup.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>STLFFMREL_IDPrimary Key
I0001220STLOC_ID+FFMCENTER_IDUnique Index
I0001221FFMCENTER_IDNon-Unique Index
I0001222ADDRESS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3578STLOC_IDSTLOCSTLOC_IDCascade
F_3579FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_3580ADDRESS_IDADDRESSADDRESS_IDCascade