FFMCENTDS

Each row of this table contains Language-dependent information about a FulfillmentCenter.

Column Descriptions:

NameTypeDescription
FFMCENTER_IDINTEGER NOT NULLThe FulfillmentCenter.
LANGUAGE_IDINTEGER NOT NULLThe language for this information. For a list of language components, see the LANGUAGE table.
STADDRESS_IDINTEGERThe physical location of the FulfillmentCenter.
DESCRIPTIONVARCHAR (4000)A description of the FulfillmentCenter, suitable for display to a customer.
DISPLAYNAMEVARCHAR (254)The name of the FulfillmentCenter, suitable for display to a customer.
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>FFMCENTER_ID+LANGUAGE_IDPrimary Key
I0000570STADDRESS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_314STADDRESS_IDSTADDRESSSTADDRESS_IDCascade
F_315LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_316FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade