1. Tables and Views for SCM
  2. WSH_DEL_DETAILS_INTERFACE

WSH_DEL_DETAILS_INTERFACE

WSH_DEL_DETAILS_INTERFACE is an interface table for delivery lines.

Details

  • Schema: FUSION

  • Object owner: WSH

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

WSH_DD_INTERFACE_PK

DELIVERY_DETAIL_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DELIVERY_DETAIL_INTERFACE_ID NUMBER 18 Yes Primary key for the table that uniquely identifies a candidate shipment line. Active
CANCEL_BACKORDERS VARCHAR2 1 Indicates whether the remaining quantity on the shipment line should be automatically canceled during the pick release, pick confirm, and ship confirm process.
ENFORCE_SINGLE_SHIPMENT VARCHAR2 1 Indicates whether the order should be fulfilled using a single shipment.
TP_RECEIVED_DATE DATE Date when the transportation planning of the shipment line is received.
PROJECT_EXPENSE_FLAG VARCHAR2 1 'Y' - Project details available with source system
BASE_ITEM_NUMBER VARCHAR2 300 Base ATO model item number for the confirgured Item of candidate shipment line.
BASE_ITEM_ID NUMBER 18 Foreign key to EGP_SYSTEM_ITEMS
TRANSACTION_NAME VARCHAR2 30 Alternate key for Transaction Id used for SAAS processing
RELEASE_LOCK VARCHAR2 1 This column will be used to release the lock at line level that was applied by Validate And Lock Service.
LOAD_REQUEST_ID NUMBER 18 Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
LINE_ACTION_TYPE VARCHAR2 30 This determines how to process this candidate shipment line: CREATE or UPDATE.
DELIVERY_DETAIL_ID NUMBER 18 Primary Key to identify delivery line Active
SOURCE_HEADER_ID NUMBER 18 For example, it can be sale order header ID Active
SOURCE_LINE_ID NUMBER 18 Source line identifier unique in this system Active
SOLD_TO_CONTACT_ID NUMBER 18 Contact identifier for sold to contact Active
SOLD_TO_CONTACT_NUMBER VARCHAR2 30 Party Number for Sold To Contact
SOLD_TO_CONTACT_NAME VARCHAR2 360 Contact name for sold to contact
INVENTORY_ITEM_ID NUMBER 18 Foreign key to EGP_SYSTEM_ITEMS Active
ITEM_DESCRIPTION VARCHAR2 250 Item Description in case there is no INVENTORY_ITEM_ID value Active
SHIP_FROM_LOCATION_ID NUMBER 18 Location identifier for ship from Active
SHIP_TO_LOCATION_ID NUMBER 18 Location Identifier for ship to destination Active
SHIP_TO_CONTACT_ID NUMBER 18 Contact Identifier for ship to destination Active
SHIP_TO_CONTACT_NUMBER VARCHAR2 30 Party Number for Ship To Contact
SHIP_TO_CONTACT_NAME VARCHAR2 360 Contact name for ship to contact
REQUESTED_QUANTITY NUMBER Requested quantity in requested quantity unit of measure Active
CANCELLED_QUANTITY NUMBER Canceled quantity in requested quantity unit of measure Active
SHIPPED_QUANTITY NUMBER Shipped quantity in requested quantity unit of measure Active
DELIVERED_QUANTITY NUMBER Delivered quantity in requested quantity unit of measure Active
REQUESTED_QUANTITY_UOM VARCHAR2 3 Unit of measure for requested quantity Active
SHIPPING_QUANTITY_UOM VARCHAR2 3 Unit of measure for shipping quantity Active
SUBINVENTORY VARCHAR2 10 Subinventory of item for the shipment line. Active
REVISION VARCHAR2 18 Revision of item for the shipment line. Active
LOT_NUMBER VARCHAR2 80 Lot number of item for the shipment line. Active
SERIAL_NUMBER VARCHAR2 80 Serial number of item for the shipment line. Active
DATE_REQUESTED DATE Date on which the line is requested Active
DATE_SCHEDULED DATE Date on which the line is scheduled Active
MASTER_CONTAINER_ITEM_ID NUMBER 18 Foreign key to EGP_SYSTEM_ITEMS Active
DETAIL_CONTAINER_ITEM_ID NUMBER 18 Foreign key to EGP_SYSTEM_ITEMS Active
LOAD_SEQ_NUMBER NUMBER Sequence number for loading the shipment line. Active
SHIP_METHOD_CODE VARCHAR2 30 Code that identifies the shipping method. Active
CARRIER_ID NUMBER 18 This identifies the freight carrier. Active
FREIGHT_TERMS_CODE VARCHAR2 30 Code that determines the freight terms. Active
SHIPMENT_PRIORITY_CODE VARCHAR2 30 Shipment priority for the shipment line. Active
FOB_CODE VARCHAR2 30 Code that determines freight on board. Active
CUSTOMER_ITEM_ID NUMBER 18 Foreign key to EGP_CUSTOMER_ITEMS Active
GROSS_WEIGHT NUMBER Gross weight of the item in this candidate shipment line. Active
NET_WEIGHT NUMBER Container Net and Loose Item weight Active
WEIGHT_UOM_CODE VARCHAR2 3 Unit of measure for weight of the shipment line. Active
VOLUME NUMBER This is the volume of the candidate shipment line. Active
VOLUME_UOM_CODE VARCHAR2 3 Unit of measure for volume of the shipment line. 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
SOURCE_HEADER_NUMBER VARCHAR2 150 User visible header number in source system. Active
CUST_PO_NUMBER VARCHAR2 50 OE: PO Number the line belongs to Active
ORGANIZATION_ID NUMBER 18 This identifies the inventory organization. Active
SRC_REQUESTED_QUANTITY NUMBER Quantity ordered by customer from the source system. Active
SRC_REQUESTED_QUANTITY_UOM VARCHAR2 3 Unit of measure for ordered quantity Active
CYCLE_COUNT_QUANTITY NUMBER Quantity to be backordered or cycle counted. Active
MOVE_ORDER_LINE_ID NUMBER 18 Foreign key to inventory move order line table Active
LOCATOR_ID NUMBER 18 Locator identifier of item in this candidate shipment line. Active
MVT_STAT_STATUS VARCHAR2 30 This is the MVT statistics status. Active
TRANSACTION_TEMP_ID NUMBER 18 Foreign key to inventory transaction temp tables Active
PREFERRED_GRADE VARCHAR2 150 Preferred grade of the item in the shipment line. Active
SRC_REQUESTED_QUANTITY2 NUMBER Secondary quantity ordered by customer from the source system. Active
SRC_REQUESTED_QUANTITY_UOM2 VARCHAR2 3 Secondary ordered quantity unit of measure from the source system Active
REQUESTED_QUANTITY2 NUMBER This is the secondary requested quantity. Active
SHIPPED_QUANTITY2 NUMBER This is the secondary shipped quantity. Active
DELIVERED_QUANTITY2 NUMBER This is the secondary delivered quantity. Active
CANCELLED_QUANTITY2 NUMBER This is the secondary canceled quantity. Active
CYCLE_COUNT_QUANTITY2 NUMBER Secondary quantity to be backordered or cycle counted. Active
REQUESTED_QUANTITY_UOM2 VARCHAR2 3 Secondary requested quantity unit of measure Active
CONTAINER_FLAG VARCHAR2 1 This flag determines whether this record is a shipment line or a packing unit. Active
CONTAINER_NAME VARCHAR2 50 This is name of the packing unit. Active
CONTAINER_TYPE_CODE VARCHAR2 30 This code determines the packing unit type. Active
CURRENCY_CODE VARCHAR2 15 This is currency code for the unit price. Active
FILL_PERCENT NUMBER How much of the packing unit is filled in percent. Active
INSPECTION_FLAG VARCHAR2 1 Flag that determines whether inspection is required. Active
LPN_CONTENT_ID NUMBER 18 Packing unit content identifier Active
LPN_ID NUMBER 18 Packing unit identifier: foreign key to INV_LICENSE_PLATE_NUMBERS. Active
MASTER_SERIAL_NUMBER VARCHAR2 80 Master serial number for the outermost packing unit. Active
MAXIMUM_LOAD_WEIGHT NUMBER Maximum load weight of the packing unit. Active
MAXIMUM_VOLUME NUMBER Maximum volume of the packing unit. Active
MINIMUM_FILL_PERCENT NUMBER Minimum fill percent for the packing unit. Active
MOVEMENT_ID NUMBER 18 Movement statistics identifier. Active
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row. Active
BUSINESS_UNIT_NAME VARCHAR2 240 Business Unit Name, alternate key for ORG_ID
ORIGINAL_SUBINVENTORY VARCHAR2 10 This is the original subinventory before pick release. Active
PACKING_INSTRUCTIONS VARCHAR2 2000 Instructions for packing the shipment line. Active
PICKED_QUANTITY NUMBER Picked quantity for this candidate shipment line. Active
PICKED_QUANTITY2 NUMBER Secondary picked quantity for this candidate shipment line. Active
SEAL_CODE VARCHAR2 30 Seal code for this candidate shipment line. Active
SHIPPING_INSTRUCTIONS VARCHAR2 2000 Instructions for shipping the shipment line. Active
SOURCE_LINE_NUMBER VARCHAR2 150 User visible line number in source system. Active
SPLIT_FROM_DELIVERY_DETAIL_ID NUMBER 18 Identifier of the original shipment line this line is split from Active
TO_SERIAL_NUMBER VARCHAR2 80 End serial number in the range. Active
TRACKING_NUMBER VARCHAR2 30 Tracking number of the shipment line. Active
UNIT_PRICE NUMBER Unit price of this candidate shipment line. Active
CUSTOMER_ITEM_NUMBER VARCHAR2 240 This is the customer item number. Active
DETAIL_CONTAINER_ITEM_CODE VARCHAR2 240 Packing unit type code to autopack Active
ITEM_NUMBER VARCHAR2 240 Item number for the candidate shipment line. Active
LOCATOR_CODE VARCHAR2 240 This code identifies the locator for the item. Active
MASTER_CONTAINER_ITEM_NUMBER VARCHAR2 240 Second level of packing unit type code to autopack Active
ORGANIZATION_CODE VARCHAR2 240 This code identifies the inventory organization. Active
ORGANIZATION_NAME VARCHAR2 240 This is the name of the inventory organization.
SHIP_FROM_LOCATION_CODE VARCHAR2 240 This code identifies the ship from location. Active
SHIP_TO_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 Date on which this line is to be first picked up. Active
LATEST_PICKUP_DATE DATE Latest date on which this line can be picked up. Active
EARLIEST_DROPOFF_DATE DATE Earliest date on which the line needs to be delivered. Active
LATEST_DROPOFF_DATE DATE Latest date at which this line is to be delivered to customer. Active
REQUEST_DATE_TYPE_CODE VARCHAR2 30 Code that determines the type of date requested. Active
FILLED_VOLUME NUMBER Filled Volume (Applicable only for containers) Active
WV_FROZEN_FLAG VARCHAR2 1 N' if W/V is System calculated. 'Y'(or null) if W/V is manually entered
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 Name of the ship-to party for the shipment line. Active
SOLD_TO_PARTY_NAME VARCHAR2 360 Name of the sold-to party for the shipment line. 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
OUTSOURCER_PARTY_NUMBER VARCHAR2 30 This is the party number of the oursourcer who sent the order line. Active
OUTSOURCER_PARTY_ID NUMBER 18 Party identifier of the outsourcer who sent the order line. Active
BILL_TO_PARTY_NUMBER VARCHAR2 30 This is the bill-to party number. Active
BILL_TO_PARTY_ID NUMBER 18 This identifies the bill-to party. Active
BILL_TO_LOCATION_ID NUMBER 18 This identifies the bill-to location. Active
BILL_TO_CONTACT_ID NUMBER 18 This identifies the bill-to party's contact. Active
BILL_TO_CONTACT_NUMBER VARCHAR2 30 Party Number for Bill To Contact
BILL_TO_CONTACT_NAME VARCHAR2 360 Contact name for bill to contact
SHIP_SET_NAME VARCHAR2 150 Ship Set Name to which the order line belongs to. Active
ARRIVAL_SET_NAME VARCHAR2 150 Arrival Set Name to which the order line belongs to. Active
REQUESTED_QUANTITY_UOM_NAME VARCHAR2 25 Name of requested quantity unit of measure Active
SHIPPING_QUANTITY_UOM_NAME VARCHAR2 25 Name of shipping quantity unit of measure Active
WEIGHT_UOM_NAME VARCHAR2 25 Name of unit of measure for the item weight Active
VOLUME_UOM_NAME VARCHAR2 25 Name of unit of measure for the item volume Active
SRC_REQUESTED_QTY_UOM_NAME VARCHAR2 25 Ordered quantity unit from the source system Active
SRC_REQUESTED_QTY_UOM2_NAME VARCHAR2 25 Secondary ordered quantity unit from the source system Active
REQUESTED_QUANTITY_UOM2_NAME VARCHAR2 25 Name of secondary requested quantity unit of measure Active
DOCUMENT_NUMBER VARCHAR2 150 Document identifier for the transaction Active
SOURCE_LINE_UPDATE_DATE DATE Last update date (including timestamp) of the order line in source system Active
SELLING_PRICE NUMBER Actual selling price as opposed to UNIT_PRICE Active
BILL_TO_PARTY_NAME VARCHAR2 360 This is the bill-to party name. Active
SHIP_TO_PARTY_SITE_ID NUMBER 18 This identifies the ship-to party site. Active
SHIP_TO_PARTY_SITE_NUMBER VARCHAR2 150 This is the ship-to party site number.
BILL_TO_PARTY_SITE_ID NUMBER 18 This identifies the bill-to party site. Active
BILL_TO_PARTY_SITE_NUMBER VARCHAR2 150 This is the bill-to site number.
TRANSACTION_ID NUMBER 18 This identifies the shipping service transaction. Active
SOURCE_SYSTEM_ID NUMBER 18 Source System ID where the Shipment Request is from or where the Shipment Advice is sent to. Active
SOURCE_SHIPMENT_NUMBER VARCHAR2 150 Shipment Number from the Source System Active
SOURCE_SHIPMENT_ID NUMBER 18 Shipment ID from the source system. This doesn't have any internal usage in Shipping. It will be returned back to the source system in the outbound messages (Intermediate status update, Shipment advice) for the source system's performance. Active
NEW_SOURCE_SHIPMENT_NUMBER VARCHAR2 150 New Shipment Number from the Source System
NEW_SOURCE_SHIPMENT_ID NUMBER 18 New Shipment ID from the source system.
SALES_ORDER_NUMBER VARCHAR2 150 Order Header number from the Sales Order system (ex. Order Capture system) Active
SALES_ORDER_LINE_NUMBER VARCHAR2 150 Order Line number from the Sales Order system (ex. Order Capture system) Active
SALES_ORDER_SHIPMENT_NUMBER VARCHAR2 150 Order Line Shipment number from the Sales Order system (ex. Order Capture system) Active
DETAIL_CONTAINER_ITEM_NUMBER VARCHAR2 240 Packing unit type to use for autopacking. Active
CONVERSION_TYPE VARCHAR2 80 Currency conversion type to be used if the Order is in a different currency than the currency of the Shipping costs. Active
CONVERSION_DATE DATE Date to be used for the currency conversion Active
CONVERSION_RATE NUMBER 15 Rate to be used for the currency conversion Active
SOURCE_SYSTEM_NAME VARCHAR2 80 Source System Name where the Shipment Request is from or where the Shipment Advice is sent to. Active
CARRIER_NUMBER VARCHAR2 30 This is party number of the carrier. Active
CARRIER_NAME VARCHAR2 360 Carrier Name (Party Name of the Carrier) Active
OUTSOURCER_PARTY_NAME VARCHAR2 360 This is the party name of the outsourcer who sent the order line. Active
PARENT_INVENTORY_ITEM_ID NUMBER 18 Added for Globalization, Intrastat support for kits Active
PARENT_ITEM_NUMBER VARCHAR2 240 Parent Item Number, alternate key for PARENT_INVENTORY_ITEM_ID
PARENT_SOURCE_SHIPMENT_ID NUMBER 18 Added for Globalization, Intrastat support for kits Active
LICENSE_PLATE_NUMBER VARCHAR2 30 This is the name of packing unit. Active
GROSS_WEIGHT_UOM_CODE VARCHAR2 3 Gross weight unit of measure code Active
CONTENT_VOLUME_UOM_CODE VARCHAR2 3 Content volume unit of measure code Active
CONTENT_VOLUME NUMBER This is the volume of the candidate packing unit's contents. Active
TARE_WEIGHT_UOM_CODE VARCHAR2 3 Tare weight unit of measure for the packing unit type. Active
TARE_WEIGHT NUMBER Tare weight of the packing unit type. Active
CONTAINER_VOLUME_UOM VARCHAR2 3 Unit of measure code for packing unit's volume Active
CONTAINER_VOLUME NUMBER This is the packing unit volume. Active
DELIVERY_INTERFACE_ID NUMBER 18 Foreign Key to identify delivery interface record Active
SHIPMENT_ADVICE_STATUS VARCHAR2 1 Indicates if the shipment advice has been sent to source system for a shipped line. Null or 'N' = Shipment advice not set. 'Y' = Shipment advice sent. 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.
SRC_ATTRIBUTE_CATEGORY VARCHAR2 30 Source System Descriptive Flexfield: structure definition of the user descriptive flexfield.
SRC_ATTRIBUTE1 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE2 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE3 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE4 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE5 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE6 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE7 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE8 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE9 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE10 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE11 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE12 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE13 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE14 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE15 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE16 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE17 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE18 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE19 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE20 VARCHAR2 150 Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER1 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER2 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER3 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER4 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER5 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER6 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER7 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER8 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER9 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_NUMBER10 NUMBER Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_DATE1 DATE Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_DATE2 DATE Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_DATE3 DATE Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_DATE4 DATE Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_DATE5 DATE Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_TIMESTAMP1 TIMESTAMP Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_TIMESTAMP2 TIMESTAMP Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_TIMESTAMP3 TIMESTAMP Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_TIMESTAMP4 TIMESTAMP Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SRC_ATTRIBUTE_TIMESTAMP5 TIMESTAMP Source System Descriptive Flexfield: segment of the user descriptive flexfield.
SOURCE_LINE_TYPE VARCHAR2 30 This identifies the type of source line.
DO_NOT_SHIP_BEFORE_DATE DATE This column indicates the cutoff date before which the line cannot be shipped
DO_NOT_SHIP_AFTER_DATE DATE This column indicates the cutoff date after which the line cannot be shipped
ROOT_SOURCE_SHIPMENT_ID NUMBER 18 Identifies the initial shipment from the source system.
SHIP_TOLERANCE_ABOVE NUMBER Over shipment tolerance percentage
SHIP_TOLERANCE_BELOW NUMBER Under shipment tolerance percentage
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Tax Determinant: Default taxation country code.
FIRST_PTY_REG_ID NUMBER 18 Tax Determinant: First party tax registration ID for the transaction.
THIRD_PTY_REG_ID NUMBER 18 Tax Determinant: Third party registration ID for the transaction.
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 Tax Determinant: The final discharge location identifier.
DOCUMENT_SUB_TYPE VARCHAR2 240 Tax Determinant: Document fiscal classification code.
TRX_BUSINESS_CATEGORY VARCHAR2 240 Tax Determinant: Transaction business category code.
USER_DEFINED_FISC_CLASS VARCHAR2 30 Tax Determinant: User defined fiscal classification code.
TAX_INVOICE_NUMBER VARCHAR2 150 Tax Determinant: The number of the fiscal document.
TAX_INVOICE_DATE DATE Tax Determinant: Date of the fiscal document.
PRODUCT_CATEGORY VARCHAR2 240 Tax Determinant: Product category code of the transaction line.
INTENDED_USE_CLASSIF_ID NUMBER Tax Determinant: Intended Use Classification Identifier
PRODUCT_TYPE VARCHAR2 240 Tax Determinant: Product type code of the inventory item. Possible values are GOODS and SERVICES.
ASSESSABLE_VALUE NUMBER Tax Determinant: This is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes.
TAX_CLASSIFICATION_CODE VARCHAR2 50 Tax Determinant: Tax classification code
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Tax Determinant: Tax exemption certificate number
EXEMPT_REASON_CODE VARCHAR2 30 Tax Determinant: Tax exemption reason code.
INTENDED_USE VARCHAR2 30 Intended Use, alternate key for INTENDED_USE_CLASSIF_ID
FIRST_PTY_NUMBER VARCHAR2 30 First Party Number, alternate key for FIRST_PTY_REG_ID. Needs to include tax_regime_code, tax_jurisdiction_code and tax as well.
THIRD_PTY_NUMBER VARCHAR2 30 Third Party Number, alternate key for THIRD_PTY_REG_ID. (Needs to include tax_regime_code, tax_jurisdiction_code, tax, third_party_code as well)
CATEGORY_ID NUMBER 18 Tax Determinant : Category ID, used to store the internal ID for Product Fiscal Classification
CATEGORY_NAME VARCHAR2 250 Category Name, Alterate key for tax determinant CATEGORY_ID
FINAL_DISCHARGE_LOC_CODE VARCHAR2 60 Final Discharge Location Code : Alternate key for FINAL_DISCHARGE_LOCATION_ID
UNIT_WEIGHT NUMBER 3PL/WMS : Unit Weight of the shipment line.
UNIT_VOLUME NUMBER 3PL/WMS : Unit Volume of the shipment line.
SELLING_PRICE_CURRENCY_CODE VARCHAR2 15 Currency code for the selling price.
LPN_INTERFACE_ID NUMBER 18 Packing Unit Identifer: Foreign key to INV_LPN_INTERFACE
SHIPPING_QUANTITY_UOM2_NAME VARCHAR2 25 Name of secondary shipping quantity unit of measure.
DELIVERY_NAME VARCHAR2 30 This is the name of the shipment.
TRANSACTION_TYPE VARCHAR2 50 Determines type of transaction.
LOCATOR_NAME VARCHAR2 2000 This code identifies the locator
DEFAULT_TAXATION_COUNTRY_NAME VARCHAR2 80 Tax Determinant: Default taxation country name.
CONTAINER_VOLUME_UOM_NAME VARCHAR2 25 Name of unit of measure for container volume for the packing unit.
CONTENT_VOLUME_UOM_NAME VARCHAR2 25 Name of unit of measure for content volume of the packing unit.
GROSS_WEIGHT_UOM_NAME VARCHAR2 25 Name of unit of measure for gross weight of the packing unit.
TARE_WEIGHT_UOM_NAME VARCHAR2 25 Name of unit of measure for tare weight of the packing unit.
END_ASSEMBLY_ITEM_NUMBER VARCHAR2 300 End assembly item that will be built using the item shipped on this shipment line.
TP_STATUS_CODE VARCHAR2 30 Status of the transportation planning of the shipment line.
TP_SHIPMENT_NUMBER VARCHAR2 101 A shipment planned by the transportation management system.
TP_SHIPMENT_LINE VARCHAR2 101 Shipment line planned by the transportation management system.
TRADE_COMPLIANCE_STATUS VARCHAR2 30 Status of the trade compliance screening of the shipment line.
TRADE_COMPLIANCE_REASON VARCHAR2 2000 Reason for the trade compliance screening status.
TRADE_COMPLIANCE_DATE DATE Date when the trade compliance status is updated.
TP_INITIAL_LEG_DEST_LOC_ID NUMBER 18 Destination location of the initial leg of the transportation planned to deliver the shipment to the final destination
FISCAL_DOC_HEADER_ID NUMBER 18 This column stores the unique identifier for the fiscal document header.
FISCAL_DOC_LINE_ID NUMBER 18 This column stores the unique identifier for the fiscal document line.
PJC_PROJECT_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget Active
PJC_PROJECT_NUMBER VARCHAR2 25 DFF Column used by Standardized Project Cost Collection Widget, this column is to save Number passed through Service/FBDI Active
PJC_TASK_ID NUMBER 18 DFF Column used by Standardized Project Cost Collection Widget Active
PJC_TASK_NUMBER VARCHAR2 100 DFF Column used by Standardized Project Cost Collection Widget, this column is to save Number passed through Service/FBDI Active
PROJECT_ID NUMBER 18 Identifier of the project used to stripe Inventory transactions Active
PROJECT_NUMBER VARCHAR2 25 Number of the project used to stripe Inventory transactions Active
TASK_ID NUMBER 18 Identifier of the task used to stripe Inventory transactions Active
TASK_NUMBER VARCHAR2 100 Number of the task used to stripe Inventory transactions Active
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe Inventory transactions Active
COUNTRY_OF_ORIGIN_NAME VARCHAR2 80 Name for the country of manufacture used to stripe Inventory transactions Active
INV_STRIPING_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for Inventory striping attributes
INV_RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future Inventory striping related functionality
INV_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user-definable Inventory striping information
INV_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user-definable Inventory striping information
PJC_PROJECT_NAME VARCHAR2 240 DFF Column used by Standardized Project Cost Collection Widget, this column is to save Name passed through Service/FBDI
PJC_TASK_NAME VARCHAR2 255 DFF Column used by Standardized Project Cost Collection Widget, this column is to save Name passed through Service/FBDI
PROJECT_NAME VARCHAR2 240 Name of the project used to stripe Inventory transactions
TASK_NAME VARCHAR2 255 Name of the task used to stripe Inventory transactions
REQUESTED_QUANTITY_TO_CONSUME NUMBER Requested quantity to consume for this shipment for the shipment line.
QUANTITY_TO_BACKORDER NUMBER Quantity requested to be back ordered for the shipment line.
ALLOW_ITEM_SUBSTITUTION_FLAG VARCHAR2 1 Indicates whether shipping substitute items is allowed.
FILL_KILL_DELIVERY_DETAIL_ID NUMBER 18 Internal column to capture the delivery detail id of the line that will be cancelled as part of Fill Kill Logic
SHIPPING_QUANTITY_UOM2 VARCHAR2 3 Secondary shipping quantity unit of measure.

Foreign Keys

Table Foreign Table Foreign Key Column
WSH_DEL_DETAILS_INTERFACE wsh_delivery_details DELIVERY_DETAIL_INTERFACE_ID
WSH_DEL_DETAILS_INTERFACE hz_parties SHIP_TO_PARTY_ID
WSH_DEL_DETAILS_INTERFACE hz_parties SOLD_TO_PARTY_ID
WSH_DEL_DETAILS_INTERFACE hz_party_sites SHIP_TO_PARTY_SITE_ID
WSH_DEL_DETAILS_INTERFACE hz_party_sites BILL_TO_PARTY_SITE_ID
WSH_DEL_DETAILS_INTERFACE wsh_transactions_history TRANSACTION_ID

Indexes

Index Uniqueness Tablespace Columns
WSH_DD_INTERFACE_N1 Non Unique FUSION_TS_INTERFACE TRANSACTION_ID
WSH_DD_INTERFACE_N2 Non Unique FUSION_TS_TX_DATA SOURCE_SYSTEM_ID, SOURCE_HEADER_NUMBER, SOURCE_LINE_NUMBER, SOURCE_SHIPMENT_NUMBER
WSH_DD_INTERFACE_N3 Non Unique Default CREATION_DATE
WSH_DD_INTERFACE_N4 Non Unique Default DELIVERY_INTERFACE_ID
WSH_DD_INTERFACE_N5 Non Unique Default TP_SHIPMENT_NUMBER
WSH_DD_INTERFACE_N6 Non Unique Default DELIVERY_NAME, LOAD_REQUEST_ID, LICENSE_PLATE_NUMBER, TRANSACTION_TYPE
WSH_DD_INTERFACE_U1 Unique FUSION_TS_INTERFACE DELIVERY_DETAIL_INTERFACE_ID