WSH_DELIVERY_DETAILS
WSH_DELIVERY_DETAILS has delivery lines.
Details
-
Schema: FUSION
-
Object owner: WSH
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
WSH_DELIVERY_DETAILS_PK |
DELIVERY_DETAIL_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
---|---|---|---|---|---|---|---|
DELIVERY_DETAIL_ID | NUMBER | 18 | Yes | Primary Key to identify delivery line | Active | ||
ENFORCE_SINGLE_SHIPMENT | VARCHAR2 | 1 | Indicates whether the order should be fulfilled using a single shipment. | ||||
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. | ||||
PROJECT_EXPENSE_FLAG | VARCHAR2 | 1 | 'Y' - Project details available with source system | ||||
BASE_ITEM_ID | NUMBER | 18 | Foreign key to EGP_SYSTEM_ITEMS | ||||
SOURCE_HEADER_ID | NUMBER | 18 | For example, it can be sale order header ID | Active | |||
SOURCE_LINE_ID | NUMBER | 18 | Yes | OE, WIP, or PO line identifier. For example, it can be sales order line ID | Active | ||
SOURCE_HEADER_NUMBER | VARCHAR2 | 150 | The user visible identifier for the header, Ex. Order number | Active | |||
CUST_PO_NUMBER | VARCHAR2 | 50 | OE: PO Number the line belongs to | Active | |||
SOLD_TO_CONTACT_ID | NUMBER | 18 | Identifier for sold to contact for the shipment line. | Active | |||
INVENTORY_ITEM_ID | NUMBER | 18 | Foreign key to EGP_SYSTEM_ITEMS | Active | |||
ITEM_DESCRIPTION | VARCHAR2 | 250 | Description of the item on the shipment line. | Active | |||
SHIP_FROM_LOCATION_ID | NUMBER | 18 | Yes | Location identifier of shipping from warehouse | Active | ||
ORGANIZATION_ID | NUMBER | 18 | This identifies the inventory organization. | 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 | |||
ROOT_SOURCE_SHIPMENT_ID | NUMBER | 18 | Identifies the initial shipment from the source system. | ||||
SHIP_TOLERANCE_ABOVE | NUMBER | Over shipment tolerance percentage | Active | ||||
SHIP_TOLERANCE_BELOW | NUMBER | Under shipment tolerance percentage | Active | ||||
WMS_SHIP_TOLERANCE_ABOVE | NUMBER | Over shipment tolerance percentage for third party system. | |||||
WMS_SHIP_TOLERANCE_BELOW | NUMBER | Under shipment tolerance percentage for third party system | |||||
SRC_REQUESTED_QUANTITY | NUMBER | Quantity ordered by customer from the source system. | Active | ||||
SRC_REQUESTED_QUANTITY_UOM | VARCHAR2 | 3 | Ordered quantity unit of measure from the source system | Active | |||
CANCELLED_QUANTITY | NUMBER | Quantity that was canceled by the source system. | Active | ||||
REQUESTED_QUANTITY | NUMBER | Yes | As shipping quantity for customer. | Active | |||
REQUESTED_QUANTITY_UOM | VARCHAR2 | 3 | Yes | Unit of measure for requested quantity | 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 | ||||
CYCLE_COUNT_QUANTITY | NUMBER | Cycle count in requested quantity unit of measure | Active | ||||
MOVE_ORDER_LINE_ID | NUMBER | 18 | Move order line identifier for this shipment line | 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 in the shipment line. | Active | |||
RELEASED_STATUS | VARCHAR2 | 1 | Status that determines where the shipment line is in its lifecycle (ready to release, released, staged, shipped, or backordered). | Active | |||
SERIAL_NUMBER | VARCHAR2 | 80 | Serial number of item for the shipment line. | Active | |||
LOCATOR_ID | NUMBER | 18 | Locator identifier 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 | Master container item identifier | Active | |||
DETAIL_CONTAINER_ITEM_ID | NUMBER | 18 | Detail container item identifier | 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 | |||
NET_WEIGHT | NUMBER | Container Net and Loose Item weight | Active | ||||
WEIGHT_UOM_CODE | VARCHAR2 | 3 | Unit of measure code for weight | Active | |||
VOLUME | NUMBER | Volume of the item in this shipment line. | Active | ||||
VOLUME_UOM_CODE | VARCHAR2 | 3 | Unit of measure code for volume | Active | |||
SHIPPING_INSTRUCTIONS | VARCHAR2 | 2000 | Instructions for shipping the shipment line. | Active | |||
PACKING_INSTRUCTIONS | VARCHAR2 | 2000 | Instructions for packing the shipment line. | Active | |||
PARENT_LPN_ID | NUMBER | 18 | Parent LPN / Container ID to which Detail Line is Packed. | Active | |||
ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | Active | |||
MVT_STAT_STATUS | VARCHAR2 | 30 | This is the MVT statistics status. | Active | |||
TRACKING_NUMBER | VARCHAR2 | 30 | Tracking number of the shipment line. | Active | |||
TRANSACTION_TEMP_ID | NUMBER | 18 | Foreign key to inventory transaction temp tables | Active | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | Active | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | 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 | |||
MOVEMENT_ID | NUMBER | 18 | Movement statistics identifier for this shipment line | Active | |||
SPLIT_FROM_DELIVERY_DETAIL_ID | NUMBER | 18 | Delivery detail identifier that the line is split from | Active | |||
INV_INTERFACED_FLAG | VARCHAR2 | 1 | Indicates if line is interfaced to inventory | Active | |||
SOURCE_LINE_NUMBER | VARCHAR2 | 150 | User visible line number in source system | Active | |||
SEAL_CODE | VARCHAR2 | 30 | Seal code for the shipment line. | Active | |||
GROSS_WEIGHT | NUMBER | Gross weight of the shipment line | Active | ||||
PREFERRED_GRADE | VARCHAR2 | 150 | Preferred grade for 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 | As shipping secondary quantity for customer. | Active | ||||
SHIPPED_QUANTITY2 | NUMBER | Shipped secondary quantity in secondary requested quantity unit of measure. | Active | ||||
DELIVERED_QUANTITY2 | NUMBER | Secondary quantity that was delivered. | Active | ||||
CANCELLED_QUANTITY2 | NUMBER | Secondary canceled quantity in secondary requested quantity unit | Active | ||||
CYCLE_COUNT_QUANTITY2 | NUMBER | Secondary quantity to be backordered or cycle counted. | Active | ||||
REQUESTED_QUANTITY_UOM2 | VARCHAR2 | 3 | Secondary ordered quantity unit of measure for the shipment line. | Active | |||
UNIT_PRICE | NUMBER | Unit price for the shipment line. | Active | ||||
CURRENCY_CODE | VARCHAR2 | 15 | Currency code for the unit price. | Active | |||
LPN_CONTENT_ID | NUMBER | 18 | Packing unit content identifier | Active | |||
INSPECTION_FLAG | VARCHAR2 | 1 | Flag that determines whether inspection is required. | Active | |||
SHIP_TO_SITE_USE_ID | NUMBER | 18 | Site identifier for ship to destination NOT USED | Active | |||
ORIGINAL_SUBINVENTORY | VARCHAR2 | 10 | This is the original subinventory requested by the order system | Active | |||
PICKABLE_FLAG | VARCHAR2 | 1 | Flag indicating whether the shipment line can be picked | Active | |||
PICKED_QUANTITY | NUMBER | Quantity that is picked for the shipment line. | Active | ||||
PICKED_QUANTITY2 | NUMBER | Secondary quantity that is picked for the shipment line. | Active | ||||
BATCH_ID | NUMBER | 18 | Foreign key to WSH_PICKING_BATCHES | Active | |||
TRANSACTION_ID | NUMBER | 18 | This identifies a shipping service transaction associated with this shipment line. | Active | |||
SERVICE_LEVEL | VARCHAR2 | 30 | Service level for the shipping method. | Active | |||
MODE_OF_TRANSPORT | VARCHAR2 | 30 | Mode of transport for 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 | |||
SOURCE_DOCUMENT_TYPE_ID | NUMBER | 18 | To be collected from source order header | Active | |||
UNIT_WEIGHT | NUMBER | Unit Weight of the item on this delivery detail | Active | ||||
UNIT_VOLUME | NUMBER | Unit Volume of the item on this delivery detail | Active | ||||
WV_FROZEN_FLAG | VARCHAR2 | 1 | Y' if the W/V is entered manually. 'N' if the W/V is automatically computed by system | ||||
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 who sent the order line | Active | |||
BILL_TO_PARTY_ID | NUMBER | 18 | Bill To Party for the Order Line | Active | |||
BILL_TO_LOCATION_ID | NUMBER | 18 | Bill To Location for the Order Line | Active | |||
BILL_TO_CONTACT_ID | NUMBER | 18 | Bill To Contact for the Order Line | Active | |||
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 | |||
SOURCE_LINE_UPDATE_DATE | DATE | The date when the source line was last updated. | Active | ||||
SELLING_PRICE | NUMBER | Saves the actual selling price as opposed to UNIT_PRICE | Active | ||||
SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | This identifies the ship-to party site. | Active | |||
BILL_TO_PARTY_SITE_ID | NUMBER | 18 | This identifies the bill-to party site. | Active | |||
REQUISITION_HEADER_ID | NUMBER | 18 | Requisition header identifier for the shipment line. | Active | |||
REQUISITION_LINE_ID | NUMBER | 18 | Requisition line identifier for the shipment line. | Active | |||
CONVERTED_QUANTITY | NUMBER | Shipped or backordered quantity converted into ordered quantity unit | Active | ||||
SOURCE_SHIPMENT_ID | NUMBER | 18 | Identifies the shipment from the source system. | Active | |||
SOURCE_SHIPMENT_NUMBER | VARCHAR2 | 150 | Shipment number from source system | Active | |||
SOURCE_SYSTEM_ID | NUMBER | 18 | Source system identifier in TCA | Active | |||
SALES_ORDER_LINE_NUMBER | VARCHAR2 | 150 | Sales Order line number from order capture system | Active | |||
SALES_ORDER_NUMBER | VARCHAR2 | 150 | Sales Order number from order capture system | Active | |||
SALES_ORDER_SHIPMENT_NUMBER | VARCHAR2 | 150 | Sales Order shipment number from order capture system | Active | |||
CONVERSION_TYPE | VARCHAR2 | 80 | Currency conversion type to be used if order is in different currency than the currency of 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 | |||
SP_PICKED_QUANTITY | NUMBER | Stores picked quantity for standard pack. | Active | ||||
SPQ_UOM | VARCHAR2 | 3 | Unit of measure for standard packed quantity | Active | |||
PARENT_INVENTORY_ITEM_ID | NUMBER | 18 | Added for Globalization, Intrastat support for kits | Active | |||
PARENT_SOURCE_SHIPMENT_ID | NUMBER | 18 | Added for Globalization, Intrastat support for kits | 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. | Shipment Line (WSH_DELIVERY_DETAILS) | |||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | |||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | |||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | |||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||||
CONVERTED_QUANTITY2 | NUMBER | Secondary shipped or backordered quantity converted into secondary ordered quantity unit | |||||
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. | |||||
CALC_WND_WDD_DATE | DATE | If the line is assigned to a delivery, this stores the initial pick up date. If the line is unassigned, this is the same as the scheduled ship date. | |||||
SOURCE_LINE_TYPE | VARCHAR2 | 30 | 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 | |||||
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 Tax 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. | ||||
SHIP_TO_LOCATION_TYPE | VARCHAR2 | 1 | Defines the ship to location type. | ||||
CATEGORY_ID | NUMBER | 18 | Tax Determinant : Category ID, used to store the internal ID for Product Fiscal Classification | ||||
WMS_INTERFACED_FLAG | VARCHAR2 | 30 | 3PL/WMS : Indicates whether the delivery detail has been interfaced to WMS or not. | ||||
PICKED_FROM_SUBINVENTORY | VARCHAR2 | 10 | Subinventory from where the item was picked for this shipment line. | ||||
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_RECEIVED_DATE | DATE | Date when the transportation planning of the shipment line is received. | |||||
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. | ||||
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. | ||||
TRADE_COMPLIANCE_STATUS | VARCHAR2 | 30 | Status of the trade compliance screening of the shipment line. | ||||
TRADE_COMPLIANCE_DATE | DATE | Date when the trade compliance status is updated. | |||||
TRADE_COMPLIANCE_REASON | VARCHAR2 | 2000 | Reason for the trade compliance screening status. | ||||
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. | ||||
TRADE_COMPLIANCE_METHOD | VARCHAR2 | 30 | Method determining when the line to be screened for trade compliance. | ||||
RCV_SHIPMENT_LINE_ID | NUMBER | 18 | This column stores the receiving shipment receipt line unique identifier. This is used to join to the RCV_SHIPMENT_LINES table. | ||||
QUICK_SHIP_STATUS | VARCHAR2 | 30 | Status of using the quick ship process for the shipment line. | ||||
PJC_PROJECT_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | Active | |||
PJC_TASK_ID | NUMBER | 18 | DFF Column used by Standardized Project Cost Collection Widget | Active | |||
PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | Active | |||
TASK_ID | NUMBER | 18 | Identifier 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 | |||
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 | ||||
CONVERTED_REQUESTED_QUANTITY | NUMBER | Requested quantity of the shipment line in order UOM | |||||
ALLOW_ITEM_SUBSTITUTION_FLAG | VARCHAR2 | 1 | Indicates whether shipping substitute items is allowed. | ||||
ORIGINAL_ITEM_ID | NUMBER | 18 | Ordered item from the source system. | ||||
ORIGINAL_DELIVERY_DETAIL_ID | NUMBER | 18 | Delivery detail identifier of the line that was originally created for the order line. | ||||
ORIGINAL_ITEM_UOM | VARCHAR2 | 3 | Primary UOM of the original item requested by the source system. | ||||
ORIGINAL_ITEM_UOM2 | VARCHAR2 | 3 | Secondary UOM of the original item requested by the source system. | ||||
ORIGINAL_ITEM_CONVERTED_QTY | NUMBER | Shipped or backordered quantity converted into original item in ordered UOM. | |||||
NEW_SOURCE_SHIPMENT_ID | NUMBER | 18 | New Shipment ID from the source system. | ||||
NEW_SOURCE_SHIPMENT_NUMBER | VARCHAR2 | 150 | New Shipment Number from the Source System | ||||
CANCELLED_SOURCE | VARCHAR2 | 70 | The source by which this line is cancelled. Ex: Ship confirm, Pick release, Pick confirm. | ||||
CANCELLED_BY_ENTITY_ID | NUMBER | 18 | The source entity ID by which this line is cancelled. Ex: DELIVERY_ID, BATCH_ID. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
WSH_DELIVERY_DETAILS | wsh_delivery_details | SPLIT_FROM_DELIVERY_DETAIL_ID |
WSH_DELIVERY_DETAILS | hz_parties | SHIP_TO_PARTY_ID |
WSH_DELIVERY_DETAILS | inv_license_plate_numbers | PARENT_LPN_ID |
WSH_DELIVERY_DETAILS | hz_parties | SOLD_TO_PARTY_ID |
wsh_delivery_details | wsh_delivery_details | SPLIT_FROM_DELIVERY_DETAIL_ID |
wsh_exceptions_purge_bkp | wsh_delivery_details | DELIVERY_DETAIL_ID |
wsh_serial_numbers | wsh_delivery_details | DELIVERY_DETAIL_ID |
wsh_delivery_assignments | wsh_delivery_details | DELIVERY_DETAIL_ID |
wsh_delivery_assignments | wsh_delivery_details | PARENT_DELIVERY_DETAIL_ID |
wsh_picking_batches | wsh_delivery_details | DELIVERY_DETAIL_ID |
wsh_freight_costs | wsh_delivery_details | DELIVERY_DETAIL_ID |
wsh_prorated_freight_costs | wsh_delivery_details | DELIVERY_DETAIL_ID |
wsh_exceptions | wsh_delivery_details | DELIVERY_DETAIL_ID |
wsh_del_details_interface | wsh_delivery_details | DELIVERY_DETAIL_INTERFACE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
WSH_DELIVERY_DETAILS_N1 | Non Unique | FUSION_TS_TX_IDX | DATE_SCHEDULED |
WSH_DELIVERY_DETAILS_N14 | Non Unique | FUSION_TS_TX_IDX | INV_INTERFACED_FLAG |
WSH_DELIVERY_DETAILS_N18 | Non Unique | FUSION_TS_TX_IDX | BATCH_ID, SALES_ORDER_NUMBER |
WSH_DELIVERY_DETAILS_N2 | Non Unique | FUSION_TS_TX_IDX | SOURCE_HEADER_ID |
WSH_DELIVERY_DETAILS_N20 | Non Unique | FUSION_TS_TX_IDX | SHIP_TO_PARTY_ID |
WSH_DELIVERY_DETAILS_N21 | Non Unique | FUSION_TS_TX_IDX | PARENT_LPN_ID |
WSH_DELIVERY_DETAILS_N22 | Non Unique | FUSION_TS_TX_IDX | SOLD_TO_PARTY_ID |
WSH_DELIVERY_DETAILS_N23 | Non Unique | FUSION_TS_TX_IDX | OUTSOURCER_PARTY_ID |
WSH_DELIVERY_DETAILS_N25 | Non Unique | FUSION_TS_TX_IDX | BILL_TO_PARTY_ID |
WSH_DELIVERY_DETAILS_N26 | Non Unique | FUSION_TS_TX_IDX | SHIP_TO_PARTY_SITE_ID |
WSH_DELIVERY_DETAILS_N27 | Non Unique | FUSION_TS_TX_IDX | BILL_TO_PARTY_SITE_ID |
WSH_DELIVERY_DETAILS_N29 | Non Unique | FUSION_TS_TX_IDX | BILL_TO_CONTACT_ID |
WSH_DELIVERY_DETAILS_N3 | Non Unique | FUSION_TS_TX_IDX | SOURCE_LINE_ID, PICKABLE_FLAG, RELEASED_STATUS |
WSH_DELIVERY_DETAILS_N30 | Non Unique | FUSION_TS_TX_IDX | SOLD_TO_CONTACT_ID |
WSH_DELIVERY_DETAILS_N31 | Non Unique | FUSION_TS_TX_IDX | SHIP_TO_CONTACT_ID |
WSH_DELIVERY_DETAILS_N34 | Non Unique | FUSION_TS_TX_IDX | CARRIER_ID |
WSH_DELIVERY_DETAILS_N35 | Non Unique | FUSION_TS_TX_DATA | SOURCE_HEADER_NUMBER, SOURCE_SHIPMENT_ID |
WSH_DELIVERY_DETAILS_N36 | Non Unique | FUSION_TS_TX_IDX | SALES_ORDER_NUMBER |
WSH_DELIVERY_DETAILS_N37 | Non Unique | FUSION_TS_TX_IDX | TO_CHAR("ORGANIZATION_ID") |
WSH_DELIVERY_DETAILS_N38 | Non Unique | FUSION_TS_TX_IDX | UPPER("SALES_ORDER_NUMBER") |
WSH_DELIVERY_DETAILS_N39 | Non Unique | Default | SOURCE_DOCUMENT_TYPE_ID |
WSH_DELIVERY_DETAILS_N40 | Non Unique | Default | RELEASED_STATUS, ORGANIZATION_ID, CALC_WND_WDD_DATE |
WSH_DELIVERY_DETAILS_N41 | Non Unique | Default | RELEASED_STATUS, INVENTORY_ITEM_ID, ORGANIZATION_ID |
WSH_DELIVERY_DETAILS_N42 | Non Unique | Default | TP_SHIPMENT_NUMBER |
WSH_DELIVERY_DETAILS_N43 | Non Unique | FUSION_TS_TX_IDX | ORGANIZATION_ID, UPPER("TRACKING_NUMBER") |
WSH_DELIVERY_DETAILS_N44 | Non Unique | FUSION_TS_TX_IDX | SRC_REQUESTED_QUANTITY_UOM, REQUESTED_QUANTITY_UOM, REQUESTED_QUANTITY_UOM2, ORGANIZATION_ID, INV_INTERFACED_FLAG, RELEASED_STATUS |
WSH_DELIVERY_DETAILS_N5 | Non Unique | FUSION_TS_TX_IDX | SHIP_FROM_LOCATION_ID, RELEASED_STATUS |
WSH_DELIVERY_DETAILS_N6 | Non Unique | FUSION_TS_TX_IDX | SHIP_TO_LOCATION_ID |
WSH_DELIVERY_DETAILS_N7 | Non Unique | FUSION_TS_TX_IDX | MOVE_ORDER_LINE_ID |
WSH_DELIVERY_DETAILS_N8 | Non Unique | FUSION_TS_TX_IDX | RELEASED_STATUS, ORGANIZATION_ID, DATE_SCHEDULED |
WSH_DELIVERY_DETAILS_N9 | Non Unique | FUSION_TS_TX_IDX | INVENTORY_ITEM_ID, ORGANIZATION_ID, SRC_REQUESTED_QUANTITY_UOM, REQUESTED_QUANTITY_UOM, SRC_REQUESTED_QUANTITY_UOM2, INV_INTERFACED_FLAG, RELEASED_STATUS |
WSH_DELIVERY_DETAILS_U1 | Unique | FUSION_TS_TX_IDX | DELIVERY_DETAIL_ID |