Database Table: FFMCENTER

Each row in this table represents a FulfillmentCenter.

Column Name Column Type Column Description
DEFAULTSHIPOFFSET INTEGER
NOT NULL, DEFAULT 86400
An estimate of the number seconds it takes for an item to be shipped from this FulfillmentCenter. This value can be overridden in the STORITMFFC table.
EXTFFMSTORENUM VARCHAR (128)
NULL
A reference number that can be used to locate a Store or external fulfillment system where shopcarts or orders can be placed to fulfill items in OrderRelease objects through this fulfillment center.

If the default implementation of the ReleaseToSpecifiedFulfillmentCenter controller command finds a valid StoreId (primary key value for the Store table) in this column, it will add items from Orders released to this fulfillment center to a shopcart (an Order with status P) in the specified Store.
FFMCENTER_ID INTEGER
NOT NULL
Generated unique key.
INVENTORYOPFLAGS INTEGER
NOT NULL, DEFAULT 0
Contains bit flags indicating how to perform inventory operations.

1 = multiItem - operations accept multiple OrderItems.

2 = noCheck - inventory is never checked (the check operation always appears to succeed).

4 = noAllocation - the allocate operation checks inventory, but does not actually allocate it (the allocate operation appears to succeed if the check succeeds).

8 = noBackorder - inventory is never backordered (the backorder operation always fails).
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
Indicates whether the FulfillmentCenter should be deleted as follows:
0 = do not delete.
1 = delete if no longer in use.
Refer to the Database Cleanup utility.
MEMBER_ID BIGINT
NOT NULL
The owner of the FulfillmentCenter.
NAME VARCHAR (254)
NULL
A string that, along with the owner, uniquely identifies this FulfillmentCenter.
Indexes:
Index Name Indexed Column Names Index Type
I0000101 MEMBER_ID, NAME Unique Index
SQL030416034928070 FFMCENTER_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_317 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_316 FFMCENTER_ID FFMCENTDS FFMCENTER_ID Cascade
F_396 FFMCENTER_ID INVENTORY FFMCENTER_ID Cascade
F_404 FFMCENTER_ID ITEMFFMCTR FFMCENTER_ID Cascade
F_500 FFMCENTER_ID ORDERITEMS ALLOCFFMC_ID Cascade
F_508 FFMCENTER_ID ORDERITEMS FFMCENTER_ID Cascade
F_586 FFMCENTER_ID PICKBATCH FFMCENTER_ID Cascade
F_655 FFMCENTER_ID RADETAIL FFMCENTER_ID Cascade
F_663 FFMCENTER_ID RECEIPT FFMCENTER_ID Cascade
F_699 FFMCENTER_ID RMA FFMCENTER_ID Cascade
F_750 FFMCENTER_ID SHPARRANGE FFMCENTER_ID Cascade
F_754 FFMCENTER_ID SHPJCRULE FFMCENTER_ID Cascade
F_772 FFMCENTER_ID STORE RTNFFMCTR_ID Cascade
F_776 FFMCENTER_ID STORE FFMCENTER_ID Cascade
F_806 FFMCENTER_ID STORITMFFC FFMCENTER_ID Cascade
F_821 FFMCENTER_ID TAXJCRULE FFMCENTER_ID Cascade
F_84 FFMCENTER_ID AUCTION FFMCENTER_ID Cascade
F_89 FFMCENTER_ID AUCTIONLOG FFMCENTER_ID Cascade