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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000101 | MEMBER_ID, NAME | Unique Index |
SQL030416034928070 | FFMCENTER_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_317 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
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 |