WSH_SHIPPING_PARAMETERS
WSH_SHIPPING_PARAMETERS has parameters defined for each inventory organization.
Details
-
Schema: FUSION
-
Object owner: WSH
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
WSH_SHIPPING_PARAMETERS_PK |
ORGANIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | 18 | Yes | Primary key for the table. Organization identifier | Active | ||
| AUTOSHIP_ON_FD_APPROVAL | VARCHAR2 | 1 | Auto ship confirm the shipment on fiscal document approval. | ||||
| GROUP_BY_SOLD_CUST_FLAG | VARCHAR2 | 1 | Auto-create delivery option -Sold to Customer | Active | |||
| WEIGHT_UOM_CLASS | VARCHAR2 | 10 | Yes | UOM Class used for weight validation | Active | ||
| VOLUME_UOM_CLASS | VARCHAR2 | 10 | Yes | UOM Class used for volume validation | Active | ||
| PERCENT_FILL_BASIS_FLAG | VARCHAR2 | 1 | Yes | Determines how to calculate fill percentages: Q- by quantity, V - by volume, W - by weight | Active | ||
| DELIVERY_REPORT_SET_ID | NUMBER | 18 | Default report set for ship confirm | Active | |||
| PICK_SEQUENCE_RULE_ID | NUMBER | 18 | Yes | Foreign key to WSH_PICK_SEQUENCE_RULES table | Active | ||
| PICK_GROUPING_RULE_ID | NUMBER | 18 | Yes | Foreign key to WSH_PICK_SEQUENCE_RULES table | Active | ||
| PRINT_PICK_SLIP_MODE | VARCHAR2 | 1 | Yes | Indicates when pick slips get printed during pick release: I - immediate, E - end | Active | ||
| PICK_RELEASE_REPORT_SET_ID | NUMBER | 18 | Defaults report set in Pick Release form | Active | |||
| AUTOCREATE_DEL_ORDERS_FLAG | VARCHAR2 | 1 | Indicates whether auto-create delivery (when Pick Releasing) groups lines by orders: Y - means each delivery cannot have lines belonging to multiple orders | Active | |||
| DEFAULT_STAGE_SUBINVENTORY | VARCHAR2 | 10 | Yes | Defaults the stage Sub-inventory field in Pick Release form | Active | ||
| DEFAULT_STAGE_LOCATOR_ID | NUMBER | 18 | Defaults the stage Locator field in Create Pick Wave UI | Active | |||
| AUTODETAIL_PR_FLAG | VARCHAR2 | 1 | Yes | Indicates whether to detail automatically - Y - auto-detail | Active | ||
| ENFORCE_PACKING_FLAG | VARCHAR2 | 1 | Checks that all lines are packed at Ship Confirm time | Active | |||
| GROUP_BY_FOB_FLAG | VARCHAR2 | 1 | Yes | Auto-create delivery option - group by FOB code | Active | ||
| GROUP_BY_FREIGHT_TERMS_FLAG | VARCHAR2 | 1 | Yes | Auto-create delivery option - group by Freight Terms code | Active | ||
| GROUP_BY_SHIP_METHOD_FLAG | VARCHAR2 | 1 | Yes | Auto-create delivery option - group by Ship Method | Active | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
| APPENDING_LIMIT | VARCHAR2 | 1 | Appending limit for Delivery Consolidation (N = Not Applicable, S = Start of Staging, E = End of Staging, A = Start of packing, W = Start of Shipping) | Active | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
| PICK_SLIP_LINES | NUMBER | Maximum number of lines to print on a pick slip | Active | ||||
| CARRIER_MANIFEST_FLAG | VARCHAR2 | 1 | checks carrier manifesting flag | Active | |||
| GU_CURRENCY_UOM | VARCHAR2 | 3 | This parameter gives the currency name. | Active | |||
| CONSOLIDATE_BO_LINES | VARCHAR2 | 1 | checks for consolidation of back order lines | Active | |||
| AUTOCREATE_DELIVERIES_FLAG | VARCHAR2 | 1 | Defaults the auto-create delivery flag in Pick Release form. | Active | |||
| ENFORCE_SHIP_SET_AND_SMC | VARCHAR2 | 1 | Enforce Ship Set and Ship Model Complete | Active | |||
| DEFER_INTERFACE | VARCHAR2 | 1 | Default value of defer interface at ship confirm | Active | |||
| ENFORCE_SHIP_METHOD | VARCHAR2 | 1 | Enforce shipping method at ship confirm | Active | |||
| CHECK_ON_HAND | VARCHAR2 | 1 | This flag sets check for on-hand -- not used. | Active | |||
| ALLOW_FUTURE_SHIP_DATE | VARCHAR2 | 1 | Allow future shipment at ship confirm | Active | |||
| SHIP_CONFIRM_RULE_ID | NUMBER | 18 | This identifies the default Auto Ship Confirm Rule. | Active | |||
| AUTOPACK_LEVEL | NUMBER | This is the default autopacking level. | Active | ||||
| ORGANIZATION_CODE | VARCHAR2 | 20 | Alternate key for the table required for setup. | Active | |||
| INV_INTERFACE_BATCH_SIZE | NUMBER | This sets the batch size for inventory interface. | Active | ||||
| SHIP_GOODS_VERIFICATION_FLAG | VARCHAR2 | 1 | Indicates whether verification is required before confirming shipment on the Mobile Ship Goods page. | ||||
| DEFER_INV_PROCESS_ONLINE | VARCHAR2 | 1 | Defer inventory process online. | Active | |||
| PICK_RELEASE_CHILD_PROCESS_NUM | NUMBER | Number of pick release child process. | Active | ||||
| PICK_RELEASE_BATCH_SIZE | NUMBER | This sets the batch size for pick release. | Active | ||||
| OVERPICK_ENABLED | VARCHAR2 | 1 | Flag to enable overpicking -- not used | Active | |||
| EXPRESS_PICK | VARCHAR2 | 1 | This flags sets whether express pick is allowed. | Active | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipping Parameter (WSH_SHIPPING_PARAMETERS) | ||||
| SHIP_SET_BREAKING_OPTION | VARCHAR2 | 30 | This column indicates the behavior of the system when ship set has to be broken during the ship confirm action. An "Error" option prevents the user from performing the action. A "Warning" option provides the user a warning message with a Yes/No option. An "Information" option just informs the user about the situation. | ||||
| PACKING_SLIP_STATUS_REQUIRED | VARCHAR2 | 1 | This flag indicates that it is mandatory to populate and print Packing Slip Status on Packing Slip Print report. | ||||
| SHIPMENT_DESCRIPTION_REQUIRED | VARCHAR2 | 1 | This flag indicates that it is mandatory to populate and print Shipment Description on Packing Slip Print report. | ||||
| TRANSPORTATION_REASON_REQUIRED | VARCHAR2 | 1 | This flag indicates that it is mandatory to populate and print Transportation Reason on Packing Slip Print report. | ||||
| PACK_DOC_SEQ_CATEGORY_CODE | VARCHAR2 | 30 | This field contains value of Packing Slip Document Sequence Category Code associated to inventory organization. | ||||
| TRADE_COMPLIANCE_METHOD | VARCHAR2 | 30 | Method determining when the line to be screened for trade compliance. | ||||
| BOL_DOC_SEQ_CATEGORY_CODE | VARCHAR2 | 30 | This code identifies the document sequence category to generate bill of lading numbers. | ||||
| INVOICE_DOC_SEQ_CATEGORY_CODE | VARCHAR2 | 30 | This code identifies the document sequence category to generate commercial invoice numbers. | ||||
| PUBLISH_TRANSACTIONAL_EVENTS | VARCHAR2 | 1 | Publish shipping transactional events. | ||||
| PT_OPT_IN_FLAG | VARCHAR2 | 1 | This flag determines whether Portugal functionality has been opted in; NULL means that it is not. Only the valid value 'Y' will enable Portugal functionality. | ||||
| QS_ENABLED_FLAG | VARCHAR2 | 1 | This flag determines whether Quick Ship is enabled; NULL means that it is not. Only the valid value 'Y' will enable Quick Ship functionality. | ||||
| QS_DEFAULT_PICK_FROM_SUBINV | VARCHAR2 | 10 | Default subinventory to consume the material for quick ship. | ||||
| QS_DEFAULT_PICK_FROM_LOCATOR | NUMBER | 18 | Default locator to consume the material for quick ship. | ||||
| SHIPPING_TOLERANCE_BEHAVIOR | VARCHAR2 | 30 | Tolerance behavior while shipping the fulfillment lines. | ||||
| SHIP_TOLERANCE_ABOVE | NUMBER | Over tolerance while shipping fulfilment lines. | |||||
| SHIP_TOLERANCE_BELOW | NUMBER | Under tolerance while shipping fullfilment lines. | |||||
| WMS_RESERVATION_FLAG | VARCHAR2 | 30 | Behavior for interfacing reserved shipment lines to external systems. | ||||
| WMS_ITEM_SUBSTITUTION_FLAG | VARCHAR2 | 1 | This flag indicates if item substitution is allowed while sending the lines to external system. | ||||
| PROCESS_GSR_IMMEDIATE | VARCHAR2 | 1 | Indicates if shipment lines should be selected, assigned to a picking batch, and their integration status set to interfaced before publishing the event. | ||||
| STAGED_RETURN_TO_WMS | VARCHAR2 | 1 | Indicates whether the shipment lines created for returning goods to vendor or customer should be interfaced with an external execution system. | ||||
| AUTO_SHIP_ON_PICK_CONFIRM_FLAG | VARCHAR2 | 1 | Auto ship confirm goods that are manually pick confirmed. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| WSH_SHIPPING_PARAMETERS | inv_org_parameters | ORGANIZATION_ID |
| WSH_SHIPPING_PARAMETERS | wsh_pick_sequence_rules_b | PICK_SEQUENCE_RULE_ID |
| WSH_SHIPPING_PARAMETERS | inv_pick_grouping_rules_b | PICK_GROUPING_RULE_ID |
| WSH_SHIPPING_PARAMETERS | wsh_ship_confirm_rules | SHIP_CONFIRM_RULE_ID |
| WSH_SHIPPING_PARAMETERS | inv_item_locations | DEFAULT_STAGE_LOCATOR_ID |
| wsh_shipping_parameter_values | wsh_shipping_parameters | ORGANIZATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WSH_SHIPPING_PARAMETERS_U1 | Unique | FUSION_TS_SEED | ORGANIZATION_ID |