1. Tables and Views for SCM
  2. WSH_NEW_DEL_INTERFACE

WSH_NEW_DEL_INTERFACE

WSH_NEW_DEL_INTERFACE is the interface table for deliveries.

Details

  • Schema: FUSION

  • Object owner: WSH

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

WSH_NEW_DEL_INTERFACE_PK

DELIVERY_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DELIVERY_INTERFACE_ID NUMBER 18 Yes This identifies the candidate shipment. Active
LOAD_REQUEST_ID NUMBER 18 Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
DELIVERY_ID NUMBER 18 This identifies the shipment in WSH_NEW_DELIVERIES. Active
DELIVERY_NAME VARCHAR2 30 This is the name of the shipment. Active
PLANNED_FLAG VARCHAR2 1 Yes Flag indicates if the shipment is planned: 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 Initial Pick-up location of delivery Active
ULTIMATE_DROPOFF_LOCATION_ID NUMBER 18 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
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
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. 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
CURRENCY_CODE VARCHAR2 15 Currency code for freight costs Active
DELIVERY_TYPE VARCHAR2 30 Yes Type of delivery - STANDARD, CONSOLIDATED Active
ORGANIZATION_ID NUMBER 18 This identifies the inventory organization. Active
CARRIER_ID NUMBER 18 This identifies the freight carrier. Active
SHIP_METHOD_CODE VARCHAR2 30 Code that identifies the shipping method. Active
DOCK_CODE VARCHAR2 30 This is the customer dock code. Active
CONFIRM_DATE DATE Date on which delivery was confirmed Active
BATCH_ID NUMBER 18 Foreign key to WSH_PICKING_BATCHES that processed this shipment. Active
BILL_FREIGHT_TO VARCHAR2 1000 This is the name to bill freight. Active
BOOKING_NUMBER VARCHAR2 30 Carrier booking number for this shipment. Active
CARRIED_BY VARCHAR2 150 Name of the entity carrying this shipment. Active
COD_AMOUNT NUMBER This is the amount for Cash on Delivery. Active
COD_CHARGE_PAID_BY VARCHAR2 150 The name of entity who paid COD charge. Active
COD_CURRENCY_CODE VARCHAR2 15 This is the currency code for COD amount. Active
COD_REMIT_TO VARCHAR2 150 The name of the entity to remit COD to. Active
DESCRIPTION VARCHAR2 240 External aspect of this shipment. Active
ENTRY_NUMBER VARCHAR2 35 This is the entry number for the shipment. Active
FTZ_NUMBER VARCHAR2 35 This is the Foreign Trade Zone number. Active
HASH_VALUE NUMBER Hash value for grouping attributes Active
IN_BOND_CODE VARCHAR2 35 This is the in bond code for the shipment. Active
LOADING_ORDER_FLAG VARCHAR2 2 Flag that determines the order of loading a shipment's items. Active
LOADING_SEQUENCE NUMBER Sequence with which the shipment is loaded in truck. Active
NUMBER_OF_LPN NUMBER Number of packing units in this shipment. Active
PORT_OF_DISCHARGE VARCHAR2 150 Port of discharge for the shipment. Active
PORT_OF_LOADING VARCHAR2 150 Port of loading for the shipment. Active
PROBLEM_CONTACT_REFERENCE VARCHAR2 500 Problem contact reference person. Active
REASON_OF_TRANSPORT VARCHAR2 30 Reason of transport for the shipment. Active
TRANSPORTATION_REASON_NAME VARCHAR2 80 Name for the Shipments Reason of Transport
ROUTED_EXPORT_TXN VARCHAR2 1 Routed export transaction for the shipment. Active
ROUTING_INSTRUCTIONS VARCHAR2 120 Instructions for routing the shipment. Active
SERVICE_CONTRACT VARCHAR2 30 Carrier service contract for the shipment. Active
SHIPPING_MARKS VARCHAR2 100 Shipping marks for the shipment. Active
SOURCE_HEADER_ID NUMBER 18 This identifies the order header associated with this shipment. Active
FOB_LOCATION_CODE VARCHAR2 240 This code identifies the freight on board location. Active
INITIAL_PICKUP_LOCATION_CODE VARCHAR2 240 This code identifies the ship from location. Active
ORGANIZATION_CODE VARCHAR2 240 This code identifies the inventory organization. Active
POOLED_SHIP_TO_LOCATION_CODE VARCHAR2 240 (Auto) Pooled ship to location code. Active
ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2 240 This code identifies the ship-to location. Active
SERVICE_LEVEL VARCHAR2 30 This is the service level, part of the shipping method. Active
MODE_OF_TRANSPORT VARCHAR2 30 This is the mode of transport, part of the shipping method. Active
EARLIEST_PICKUP_DATE DATE Earliest date on which the shipment needs to be picked up. Active
LATEST_PICKUP_DATE DATE Latest date on which the shipment needs to be picked up. Active
EARLIEST_DROPOFF_DATE DATE Earliest date on which the shipment needs to be delivered. Active
LATEST_DROPOFF_DATE DATE Latest date on which the shipment needs to be delivered. Active
HASH_STRING VARCHAR2 1000 Hash string for grouping attributes Active
WV_FROZEN_FLAG VARCHAR2 1 N' if W/V is System calculated. 'Y'(or null) if W/V is manually entered
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
SHIP_TO_PARTY_NAME VARCHAR2 360 This is the ship-to party name. Active
SOLD_TO_PARTY_NAME VARCHAR2 360 This is the sold-to party name. Active
SHIP_TO_PARTY_NUMBER VARCHAR2 30 This is the ship-to party number. Active
SOLD_TO_PARTY_NUMBER VARCHAR2 30 This is the sold-to party number. Active
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.
VEHICLE_ITEM_NAME VARCHAR2 40 Name of the item used as equipment type. Active
VEHICLE_ITEM_NUMBER VARCHAR2 300 Number of the item used as equipment type. Active
VEHICLE_ITEM_ID NUMBER 18 This identifies the item used as equipment type. Active
TRANSACTION_ID NUMBER 18 This identifies the shipping service transaction. Active
CARRIER_NAME VARCHAR2 360 This is the party name of the carrier. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SOURCE_SYSTEM_NAME VARCHAR2 80 Source System that sends the ship confirmation message
WEIGHT_UOM_NAME VARCHAR2 25 Name of the unit of measure for weight.
VOLUME_UOM_NAME VARCHAR2 25 Name of the unit of measure for volume.
ACTUAL_SHIP_DATE DATE This date is when the shipment was actually shipped.
VEHICLE_NUMBER VARCHAR2 35 This is the equipment type number (like license plate).
ORGANIZATION_NAME VARCHAR2 240 Name of the inventory organization.
CARRIER_NUMBER VARCHAR2 30 This is the party number of the carrier.
SHIP_TO_COUNTRY VARCHAR2 2 Code of the ship-to country for the shipment. Obsolete
SHIP_TO_ADDRESS1 VARCHAR2 240 Ship-to address line 1 for the shipment. Obsolete
SHIP_TO_ADDRESS2 VARCHAR2 240 Ship-to address line 2 for the shipment. Obsolete
SHIP_TO_ADDRESS3 VARCHAR2 240 Ship-to address line 3 for the shipment. Obsolete
SHIP_TO_ADDRESS4 VARCHAR2 240 Ship-to address line 4 for the shipment. Obsolete
SHIP_TO_CITY VARCHAR2 60 The city the shipment will be shipped to. Obsolete
SHIP_TO_POSTAL_CODE VARCHAR2 60 Postal code the shipment will be shipped to. Obsolete
SHIP_TO_STATE VARCHAR2 60 State the shipment will be shipped to. Obsolete
SHIP_TO_PROVINCE VARCHAR2 60 Code of the ship-to province for the shipment. Obsolete
SHIP_TO_COUNTY VARCHAR2 60 County the shipment will be shipped to. Obsolete
SHIP_TO_FAX VARCHAR2 240 Fax number for where the shipment will be shipped to. Obsolete
SHIP_TO_PHONE VARCHAR2 240 Phone number for where the shipment will be shipped to. Obsolete
SHIP_TO_URL VARCHAR2 2000 URL for where the shipment will be shipped to.
SHIP_TO_CONTACT_NAME VARCHAR2 360 Name of the ship-to contact for the shipment.
SHIP_TO_CONTACT_PHONE VARCHAR2 240 This is the phone number of the ship-to contact. Obsolete
SHIP_FROM_COUNTRY VARCHAR2 2 Country code of the address where the shipment is shipped from.
SHIP_FROM_ADDRESS1 VARCHAR2 240 Line 1 of the address where the shipment is shipped from.
SHIP_FROM_ADDRESS2 VARCHAR2 240 Line 2 of the address where the shipment is shipped from.
SHIP_FROM_ADDRESS3 VARCHAR2 240 Line 3 of the address where the shipment is shipped from.
SHIP_FROM_ADDRESS4 VARCHAR2 240 Line 4 of the address where the shipment is shipped from.
SHIP_FROM_CITY VARCHAR2 60 City where the shipment is shipped from. Obsolete
SHIP_FROM_POSTAL_CODE VARCHAR2 60 Postal code where the shipment is shipped from.
SHIP_FROM_STATE VARCHAR2 60 State where the shipment is shipped from.
SHIP_FROM_PROVINCE VARCHAR2 60 Province where the shipment is shipped from.
SHIP_FROM_COUNTY VARCHAR2 60 County where the shipment is shipped from.
SHIP_FROM_FAX VARCHAR2 240 Fax number for where the shipment is shipped from.
SHIP_FROM_PHONE VARCHAR2 240 Phone number for where the shipment is shipped from.
SHIP_FROM_URL VARCHAR2 2000 URL for where the shipment is shipped from.
SHIP_FROM_CONTACT_NAME VARCHAR2 360 This is name of the ship from contact.
SHIP_FROM_CONTACT_PHONE VARCHAR2 240 This is phone number of the ship from contact. Obsolete
LOADING_SEQUENCE_RULE VARCHAR2 80 Represents the rule to be applied on shipment lines for loading into the truck.
FOB_ADDRESS1 VARCHAR2 240 Line 1 of the address for freight on board location.
FOB_ADDRESS2 VARCHAR2 240 Line 2 of the address for freight on board location.
FOB_ADDRESS3 VARCHAR2 240 Line 3 of the address for freight on board location.
FOB_ADDRESS4 VARCHAR2 240 Line 4 of the address for freight on board location.
FOB_CITY VARCHAR2 60 City for freight on board location.
FOB_COUNTRY VARCHAR2 2 Country for freight on board location.
FOB_COUNTY VARCHAR2 60 County for freight on board location.
FOB_POSTAL_CODE VARCHAR2 60 Postal Code for freight on board location.
FOB_REGION VARCHAR2 120 Region for freight on board location.
FOB_STATE VARCHAR2 60 State for freight on board location.
SEAL_CODE VARCHAR2 30 This is the seal code for this shipment.
TRANSACTION_TYPE VARCHAR2 50 Determines type of transaction.
TRANSACTION_STATUS VARCHAR2 2 Status of the transaction. Example : SC/ER
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.
E_RECORD_ID NUMBER 18 This column stores electronic record ID when signatures are captured.
SHIP_TO_PARTY_SITE_NUMBER VARCHAR2 30 This is the ship-to party site number.
FREIGHT_TERMS_NAME VARCHAR2 80 This is the name of the freight terms.
FOB_PARTY_SITE_NUMBER VARCHAR2 30 This is the freight on board party site number.
AUTO_AP_EXCLUDE_FLAG VARCHAR2 1 Y - exclude this record from Automated Autopack.
AUTO_SC_EXCLUDE_FLAG VARCHAR2 1 Y - exclude this record from Automated Ship Confirm.
PRORATE_WEIGHT_FLAG VARCHAR2 1 Flag indicates if the weights are to be prorated.
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.

Indexes

Index Uniqueness Tablespace Columns
WSH_NEW_DEL_INTERFACE_N1 Non Unique Default EXTERNAL_SYS_TXN_REFERENCE
WSH_NEW_DEL_INTERFACE_N2 Non Unique Default DELIVERY_NAME
WSH_NEW_DEL_INTERFACE_N3 Non Unique Default REQUEST_ID
WSH_NEW_DEL_INTERFACE_N4 Non Unique Default TRANSACTION_ID
WSH_NEW_DEL_INTERFACE_U1 Unique FUSION_TS_INTERFACE DELIVERY_INTERFACE_ID