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 | 3 | 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 |
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 |