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.

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_N2 Non Unique FUSION_TS_TX_IDX INTERFACE_BATCH_ID
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