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 | ||||
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. |
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 |