1. Tables and Views for SCM
  2. WSH_NEW_DELIVERIES

WSH_NEW_DELIVERIES

WSH_NEW_DELIVERIES has the delivery records.

Details

  • Schema: FUSION

  • Object owner: WSH

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

WSH_NEW_DELIVERIES_PK

DELIVERY_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
DELIVERY_ID NUMBER 18 Yes Primary Key to identify delivery Active
DELIVERY_NAME VARCHAR2 30 Yes This is the name of the shipment. Active
PLANNED_FLAG VARCHAR2 1 Yes Planned flag (N = unplanned; Y = planned) Active
STATUS_CODE VARCHAR2 2 Yes Delivery shipping status ,e.g., OP for Open delivery Active
INITIAL_PICKUP_DATE DATE Date on which the delivery is first picked up Active
INITIAL_PICKUP_LOCATION_ID NUMBER 18 Yes Initial Pick-up location of delivery Active
ULTIMATE_DROPOFF_LOCATION_ID NUMBER 18 Yes Final Drop-off location of delivery Active
ULTIMATE_DROPOFF_DATE DATE Date on which the delivery is finally dropped off Active
POOLED_SHIP_TO_LOCATION_ID NUMBER 18 (Auto) Pooled ship-to location of delivery Active
FREIGHT_TERMS_CODE VARCHAR2 30 Code that identifies the freight terms. Active
FOB_CODE VARCHAR2 30 Code that determines freight on board. Active
FOB_LOCATION_ID NUMBER 18 This identifies the freight on board location. Active
WAYBILL VARCHAR2 30 This may be the tracking number. Active
ACCEPTANCE_FLAG VARCHAR2 1 Flag determines whether Y-goods are accepted. Active
ACCEPTED_BY VARCHAR2 150 Name of party accepting the goods Active
ACCEPTED_DATE DATE Date on which the goods were accepted Active
ACKNOWLEDGED_BY VARCHAR2 150 Name of party acknowledging the goods Active
CONFIRMED_BY VARCHAR2 150 Name of the shipper of the goods. Active
ASN_DATE_SENT DATE Date the advance shipment notice was sent. Active
ASN_SEQ_NUMBER NUMBER Sequence number of the advance shipment notice. Active
ASN_STATUS_CODE VARCHAR2 15 ASN status code (could be PENDING, SENT or CANCELED) Active
REASON_OF_TRANSPORT VARCHAR2 30 Reason of transport for the shipment. Active
DESCRIPTION VARCHAR2 240 External aspect of this shipment. Active
GROSS_WEIGHT NUMBER This is the gross weight of the shipment. Active
NET_WEIGHT NUMBER This is the net weight of the shipment. Active
WEIGHT_UOM_CODE VARCHAR2 3 This code identifies the unit of measure for weight. Active
VOLUME NUMBER This is the volume of the shipment. Active
VOLUME_UOM_CODE VARCHAR2 3 This code identifies the unit of measure for volume. Active
ADDITIONAL_SHIPMENT_INFO VARCHAR2 500 Additional Shipment Information Active
PORT_OF_DISCHARGE VARCHAR2 150 Port of discharge for the shipment. Active
BOOKING_NUMBER VARCHAR2 30 Carrier booking number for this shipment. Active
COD_AMOUNT NUMBER This is the amount for Cash on Delivery. Active
COD_CURRENCY_CODE VARCHAR2 15 This is the currency code for COD amount. Active
SERVICE_CONTRACT VARCHAR2 30 Carrier service contract for the shipment. Active
COD_REMIT_TO VARCHAR2 150 Person to remit to for COD Amount Active
COD_CHARGE_PAID_BY VARCHAR2 150 The name of entity who paid COD charge. Active
PROBLEM_CONTACT_REFERENCE VARCHAR2 500 Problem Contact Reference person Active
BILL_FREIGHT_TO VARCHAR2 1000 This is the name to bill freight. Active
CARRIED_BY VARCHAR2 150 This names the person carrying goods. Active
PORT_OF_LOADING VARCHAR2 150 Port of loading for the shipment. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES) 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
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
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
CONFIRM_DATE DATE Date the delivery was confirmed Active
SHIP_METHOD_CODE VARCHAR2 30 Code that identifies the shipping method. Active
DOCK_CODE VARCHAR2 30 This is the customer dock code. Active
DELIVERY_TYPE VARCHAR2 30 Yes Type of delivery - STANDARD, CONSOLIDATED Active
CARRIER_ID NUMBER 18 This identifies the freight carrier. Active
CURRENCY_CODE VARCHAR2 15 Currency code for freight costs Active
ORGANIZATION_ID NUMBER 18 This identifies the inventory organization. Active
LOADING_SEQUENCE NUMBER Sequence with which it is loaded in truck Active
LOADING_ORDER_FLAG VARCHAR2 2 Sequence in which delivery details are to be loaded within delivery Active
NUMBER_OF_LPN NUMBER Number of packing units in this shipment. Active
BATCH_ID NUMBER 18 Foreign key to WSH_PICKING_BATCHES that processed this shipment. Active
SOURCE_HEADER_ID NUMBER 18 Header Id of the Order lines associated to this delivery Active
HASH_VALUE NUMBER Hash Value of the Delivery Grouping Attributes Active
FTZ_NUMBER VARCHAR2 35 This is the Foreign Trade Zone number. Active
ROUTED_EXPORT_TXN VARCHAR2 1 Export Transaction is routed or not. Active
ENTRY_NUMBER VARCHAR2 35 This is the entry number for the shipment. Active
ROUTING_INSTRUCTIONS VARCHAR2 120 Routing Instructions for Delivery Active
IN_BOND_CODE VARCHAR2 35 This is the in bond code for the shipment. Active
SHIPPING_MARKS VARCHAR2 100 Shipping marks for the shipment. Active
SERVICE_LEVEL VARCHAR2 30 This is the service level, part of the shipping method. Active
MODE_OF_TRANSPORT VARCHAR2 30 Mode of Transport for Ship Method Active
AUTO_SC_EXCLUDE_FLAG VARCHAR2 1 Y - exclude this record from Automated Ship Confirm Active
AUTO_AP_EXCLUDE_FLAG VARCHAR2 1 Y - exclude this record from Automated Autopack Active
AP_BATCH_ID NUMBER 18 Foreign key to WSH_PICKING_BATCHES for autopack batch Active
EARLIEST_PICKUP_DATE DATE Date on which this delivery is to be first picked up Active
LATEST_PICKUP_DATE DATE Latest date on which this delivery can be picked up Active
EARLIEST_DROPOFF_DATE DATE Earliest date on which the package needs to be delivered Active
LATEST_DROPOFF_DATE DATE Latest date at which this delivery is to be delivered to customer Active
WV_FROZEN_FLAG VARCHAR2 1 Y' if the W/V is entered manually. 'N' if the W/V is automatically computed by system
HASH_STRING VARCHAR2 1000 Hash String of the Delivery Grouping Attributes Active
DELIVERED_DATE DATE Date the shipment was delivered to customer. 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
SHIP_TO_PARTY_ID NUMBER 18 This identifies the ship-to party. Active
SOLD_TO_PARTY_ID NUMBER 18 This identifies the sold-to party. Active
OUTSOURCER_PARTY_ID NUMBER 18 Party identifier of the outsourcer associated with the shipment Active
SEAL_CODE VARCHAR2 30 This is the seal code for this shipment. Active
VEHICLE_ITEM_ID NUMBER 18 This identifies the item used as equipment type. Active
VEHICLE_NUMBER VARCHAR2 35 This is the equipment type number (like license plate). Active
ACTUAL_SHIP_DATE DATE This date is when the shipment was actually shipped. Active
CLOSE_BATCH_ID NUMBER 18 Batch ID for Close Delivery batch program Active
INTERFACE_BATCH_ID NUMBER 18 Batch ID for Interface Delivery batch program Active
PENDING_INTERFACE_FLAG VARCHAR2 1 Y' indicates that this delivery has the lines to be interfaced to Inventory.
BILL_OF_LADING_NUMBER VARCHAR2 50 This is the bill of lading number. Active
PACKING_SLIP_NUMBER VARCHAR2 50 This is the packing slip number. Active
COMMERCIAL_INVOICE_NUMBER VARCHAR2 50 This is the commercial invoice number.
GROSS_AMOUNT NUMBER This is the gross amount (e.g., in Euro).
NET_AMOUNT NUMBER This is the net amount (e.g., in functional currency).
CERTIFICATE_NUMBER VARCHAR2 80 This is the certificate number.
KEY_VERSION NUMBER 18 This is the key version for certificate number.
PACKING_SLIP_SIGNATURE VARCHAR2 240 This is the hash signature for packing slip.
BILL_OF_LADING_SIGNATURE VARCHAR2 240 This is the hash signature for bill of lading.
COMMERCIAL_INVOICE_SIGNATURE VARCHAR2 240 This is the hash signature for commerical invoice.
PACKING_SLIP_SEQ_ID NUMBER 18 This identifies the document sequence assignment used for packing slip.
BILL_OF_LADING_SEQ_ID NUMBER 18 This identifies the document sequence assignment used for bill of lading.
COMMERCIAL_INVOICE_SEQ_ID NUMBER 18 This identifies the document sequence assignment used for commercial invoice.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Shipment (WSH_NEW_DELIVERIES)
SOURCE_LINE_TYPE VARCHAR2 30 Identifies the line types that cab be assigned the delivery.
SHIP_TO_LOCATION_TYPE VARCHAR2 1 Defines the ship to location type.
PACKING_SLIP_STATUS VARCHAR2 1 Defines Packing Slip Status (F = Final, D = Draft, C = Canceled)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 2000 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 2000 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 2000 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 2000 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 2000 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TP_SHIPMENT_NUMBER VARCHAR2 101 A shipment planned by the transportation management system.
RCV_SHIPMENT_HEADER_ID NUMBER 18 This column stores the receiving shipment header unique identifier. Used to join to the RCV_SHIPMENT_HEADERS table.
RCV_SHIPMENT_NUM VARCHAR2 30 RCV Shipment Number assigned by the receiving shipment's source. Corresponds to the Inbound ASN Number.
JOB_SET_NAME VARCHAR2 4000 Enterprise Service Scheduler: indicates the name of jobset.
JOB_SET_PACKAGE_NAME VARCHAR2 800 Enterprise Service Scheduler: indicates the package name of jobset.
JOB_SET_PROCESS_ID NUMBER 18 Enterprise Scheduler Process Id for the jobset.
E_RECORD_ID NUMBER 18 This column stores electronic record ID when signatures are captured.
FD_PROCESSING_STATUS VARCHAR2 30 Fiscal document processing status associated with the shipment, such as in process, approved, cancelled.
EXTERNAL_SYS_TXN_REFERENCE VARCHAR2 300 This column is used to store the link to the transaction references passed by external WMS or 3PL systems.
PACKING_SLIP_QR_CODE_TEXT VARCHAR2 4000 Quick Response code text for packing slip.
BILL_OF_LADING_QR_CODE_TEXT VARCHAR2 4000 Quick Response code text for bill of lading.
COMMERCIAL_INV_QR_CODE_TEXT VARCHAR2 4000 Quick Response code text for commercial invoice.
PACKING_SLIP_ATCUD VARCHAR2 70 ATCUD code for Portugal packing slip.
BILL_OF_LADING_ATCUD VARCHAR2 70 ATCUD code for Portugal bill of lading.
COMMERCIAL_INV_ATCUD VARCHAR2 70 ATCUD code for Portugal commercial invoice.
SIGNATURE_REQUEST_ID NUMBER 18 Indicates request ID of Generate E-Signature on Shipping Documents job that generated the signature.
LINES_CANCELLED VARCHAR2 1 Indicates if any lines are cancelled during ship confirm. Holds Y or N.
ACTUAL_DELIVERY_DATE DATE The date when the shipment was delivered to the recipient.
DELIVERY_RECIPIENT VARCHAR2 240 Free form text field to capture the name of the person who received the delivery.
ERES_PROCESSING_STATUS VARCHAR2 50 Indicates the status of the signing process associated with the shipment.
LOAD_ID NUMBER 18 Identifier for outbound load for the shipment.
SOURCE_NAME VARCHAR2 50 The source from which the request is performed.
ACTION_SOURCE_NAME VARCHAR2 50 This column stores the source of the action and the action performed.
UDD_FROZEN_FLAG VARCHAR2 1 Indicates whether the ultimate dropoff date should be automatically recalculated. When the ultimate dropoff date is manually updated, the value is set to 'Y', indicating that it shouldn’t be recalculated. When set to 'N' or null, the ultimate dropoff date is automatically recalculated.

Foreign Keys

Table Foreign Table Foreign Key Column
WSH_NEW_DELIVERIES hz_parties SHIP_TO_PARTY_ID
WSH_NEW_DELIVERIES hz_parties SOLD_TO_PARTY_ID
wsh_exceptions_purge_bkp wsh_new_deliveries DELIVERY_ID
wsh_delivery_assignments wsh_new_deliveries DELIVERY_ID
wsh_delivery_assignments wsh_new_deliveries PARENT_DELIVERY_ID
wsh_picking_batches wsh_new_deliveries DELIVERY_ID
wsh_freight_costs wsh_new_deliveries DELIVERY_ID
wsh_prorated_freight_costs wsh_new_deliveries DELIVERY_ID
wsh_exceptions wsh_new_deliveries DELIVERY_ID
wsh_ship_confirm_options wsh_new_deliveries DELIVERY_ID

Indexes

Index Uniqueness Tablespace Columns
WSH_NEW_DELIVERIES_N1 Non Unique FUSION_TS_TX_IDX STATUS_CODE
WSH_NEW_DELIVERIES_N10 Non Unique FUSION_TS_TX_IDX PENDING_INTERFACE_FLAG
WSH_NEW_DELIVERIES_N11 Non Unique FUSION_TS_TX_IDX SOLD_TO_PARTY_ID
WSH_NEW_DELIVERIES_N12 Non Unique FUSION_TS_TX_IDX OUTSOURCER_PARTY_ID
WSH_NEW_DELIVERIES_N13 Non Unique FUSION_TS_TX_IDX SHIP_TO_PARTY_ID, SOLD_TO_PARTY_ID, HASH_VALUE
WSH_NEW_DELIVERIES_N14 Non Unique FUSION_TS_TX_IDX CARRIER_ID
WSH_NEW_DELIVERIES_N15 Non Unique FUSION_TS_TX_IDX VEHICLE_ITEM_ID
WSH_NEW_DELIVERIES_N16 Non Unique Default UPPER("DELIVERY_NAME")
WSH_NEW_DELIVERIES_N17 Non Unique Default ACTUAL_SHIP_DATE
WSH_NEW_DELIVERIES_N18 Non Unique Default EXTERNAL_SYS_TXN_REFERENCE
WSH_NEW_DELIVERIES_N19 Non Unique FUSION_TS_TX_IDX BILL_OF_LADING_NUMBER
WSH_NEW_DELIVERIES_N2 Non Unique FUSION_TS_TX_IDX INTERFACE_BATCH_ID
WSH_NEW_DELIVERIES_N20 Non Unique FUSION_TS_TX_IDX PACKING_SLIP_NUMBER
WSH_NEW_DELIVERIES_N3 Non Unique FUSION_TS_TX_IDX CLOSE_BATCH_ID
WSH_NEW_DELIVERIES_N4 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID
WSH_NEW_DELIVERIES_N5 Non Unique FUSION_TS_TX_IDX SHIP_METHOD_CODE
WSH_NEW_DELIVERIES_N6 Non Unique FUSION_TS_TX_IDX SHIP_TO_PARTY_ID, HASH_VALUE
WSH_NEW_DELIVERIES_N7 Non Unique FUSION_TS_TX_IDX INITIAL_PICKUP_DATE
WSH_NEW_DELIVERIES_N8 Non Unique FUSION_TS_TX_IDX BATCH_ID, HASH_VALUE
WSH_NEW_DELIVERIES_N9 Non Unique FUSION_TS_TX_IDX AP_BATCH_ID
WSH_NEW_DELIVERIES_U1 Unique FUSION_TS_TX_IDX DELIVERY_ID
WSH_NEW_DELIVERIES_U2 Unique FUSION_TS_TX_IDX DELIVERY_NAME
WSH_NEW_DELIVERIES_U3 Unique FUSION_TS_TX_IDX E_RECORD_ID