FFMCENTER
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 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 NOT NULL DEFAULT 0 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
Related reference
ATP inventory data model
ATP inventory adjustment data model
ATP expected inventory data model
ATP inventory fulfillment data model
ATP inventory orders data model
ATP inventory reservations data model
Calculation rule - tax data model
Fulfillment data model
Order management - RMA data model
Order item data model
Order item - allocated data model
Order item - backordered data model
Order release data model
Receipt data model
Shipping data model
Store data model