Each row in this table represents a fulfillment
center.
Column Descriptions:
| Name | Type | Description |
| FFMCENTER_ID | INTEGER NOT NULL | Generated unique key. |
| MEMBER_ID | BIGINT NOT NULL | The owner of the fulfillment center. |
| NAME | VARCHAR (254) | A string that, along with the owner, uniquely
identifies this fulfillment center. |
| DEFAULTSHIPOFFSET | INTEGER NOT NULL DEFAULT 86400 | An estimate of the number seconds it takes for an
item to be shipped from this fulfillment center. This value can be
overridden in the STORITMFFC table. |
| MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates whether the fulfillment center should
be deleted as follows:
0 = do not delete.
1 = delete if no longer in use.
Refer to the Database Cleanup utility. |
| EXTFFMSTORENUM | VARCHAR (128) | A reference number that can be used to locate a
store or external fulfillment system. Shopping carts 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. Then it will add items from orders released to this
fulfillment center to a shopping cart (an order with status P) in
the specified store. |
| INVENTORYOPFLAGS | INTEGER NOT NULL DEFAULT 0 | Contains bit flags indicating how to perform
inventory operations. Enter an integer that is the sum of the
number of the flags that you want to turn on. Example: Enter "3" to
turn on flags 1 and 2.
1 = multiItem - operations accept multiple order items.
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). |
| MAXNUMPICK | SMALLINT NOT NULL DEFAULT 25 | The maximum number of the releases per pick
batch |
| PICKDELAYINMIN | SMALLINT NOT NULL DEFAULT 5 | The delay in minutes from the time an order is
placed until one of its releases can be included. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| DROPSHIP | CHAR (1) NOT NULL DEFAULT 'N' | Indicates whether the fulfillment center is a
drop-ship fulfillment center. Y means that it is. N indicates that
it is not. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | FFMCENTER_ID | Primary Key |
| I0000101 | MEMBER_ID+NAME | Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_317 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1092 | FFMCENTER_ID | ORDRELEASE | FFMCENTER_ID | Cascade |
| F_316 | FFMCENTER_ID | FFMCENTDS | FFMCENTER_ID | Cascade |
| F_3579 | FFMCENTER_ID | STLFFMREL | 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 |