WSH_DELIVERY_DETAILS has delivery lines.
Schema: FUSION
Object owner: WSH
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA
| Name | Columns |
|---|---|
| WSH_DELIVERY_DETAILS_PK | DELIVERY_DETAIL_ID |
| Name | Database | Length | Precision | Not Null | Comments | Flexfield Mapping |
|---|---|---|---|---|---|---|
| DELIVERY_DETAIL_ID | NUMBER | 18 | Yes | Primary Key to identify delivery line | ||
| 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 | |||
| SOURCE_LINE_ID | NUMBER | 18 | Yes | OE, WIP, or PO line identifier. For example, it can be sales order line ID | ||
| SOURCE_HEADER_NUMBER | VARCHAR2 | 150 | The user visible identifier for the header, Ex. Order number | |||
| CUST_PO_NUMBER | VARCHAR2 | 50 | OE: PO Number the line belongs to | |||
| SOLD_TO_CONTACT_ID | NUMBER | 18 | Identifier for sold to contact | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Foreign key to EGP_SYSTEM_ITEMS | |||
| ITEM_DESCRIPTION | VARCHAR2 | 250 | Item description | |||
| SHIP_FROM_LOCATION_ID | NUMBER | 18 | Yes | Location identifier of shipping from warehouse | ||
| ORGANIZATION_ID | NUMBER | 18 | Organization identifier | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Location identifier for ship to destination | |||
| SHIP_TO_CONTACT_ID | NUMBER | 18 | Contact identifier for ship to destination | |||
| SHIP_TOLERANCE_ABOVE | NUMBER | Over shipment tolerance percentage | ||||
| SHIP_TOLERANCE_BELOW | NUMBER | Under shipment tolerance percentage | ||||
| SRC_REQUESTED_QUANTITY | NUMBER | As ordered by customer | ||||
| SRC_REQUESTED_QUANTITY_UOM | VARCHAR2 | 3 | Ordered quantity unit of measure from the source system | |||
| CANCELLED_QUANTITY | NUMBER | Quantity being canceled | ||||
| REQUESTED_QUANTITY | NUMBER | Yes | As shipping quantity for customer | |||
| REQUESTED_QUANTITY_UOM | VARCHAR2 | 3 | Yes | Unit of measure for requested quantity | ||
| SHIPPED_QUANTITY | NUMBER | Shipped quantity in requested quantity unit of measure | ||||
| DELIVERED_QUANTITY | NUMBER | Delivered quantity in requested quantity unit of measure | ||||
| CYCLE_COUNT_QUANTITY | NUMBER | Cycle count in requested quantity unit of measure | ||||
| MOVE_ORDER_LINE_ID | NUMBER | 18 | Move order line identifier | |||
| SUBINVENTORY | VARCHAR2 | 10 | Subinventory of item | |||
| REVISION | VARCHAR2 | 3 | Revision of item | |||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number of item | |||
| RELEASED_STATUS | VARCHAR2 | 1 | Pick Release Status | |||
| SERIAL_NUMBER | VARCHAR2 | 30 | Serial number of item | |||
| LOCATOR_ID | NUMBER | 18 | Locator of item | |||
| DATE_REQUESTED | DATE | Date on which the line is requested | ||||
| DATE_SCHEDULED | DATE | Date on which the line is scheduled | ||||
| MASTER_CONTAINER_ITEM_ID | NUMBER | 18 | Master container item identifier | |||
| DETAIL_CONTAINER_ITEM_ID | NUMBER | 18 | Detail container item identifier | |||
| LOAD_SEQ_NUMBER | NUMBER | Load sequence number | ||||
| SHIP_METHOD_CODE | VARCHAR2 | 30 | Ship method | |||
| CARRIER_ID | NUMBER | 18 | Freight carrier | |||
| FREIGHT_TERMS_CODE | VARCHAR2 | 30 | Freight terms code | |||
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | 30 | Shipment priority | |||
| FOB_CODE | VARCHAR2 | 30 | Freight on board code | |||
| CUSTOMER_ITEM_ID | NUMBER | 18 | Foreign key to EGP_CUSTOMER_ITEMS | |||
| NET_WEIGHT | NUMBER | Container Net and Loose Item weight | ||||
| WEIGHT_UOM_CODE | VARCHAR2 | 3 | Unit of measure code for weight | |||
| VOLUME | NUMBER | Volume | ||||
| VOLUME_UOM_CODE | VARCHAR2 | 3 | Unit of measure code for volume | |||
| SHIPPING_INSTRUCTIONS | VARCHAR2 | 2000 | Instructions for shipping | |||
| PACKING_INSTRUCTIONS | VARCHAR2 | 2000 | Instructions for packing | |||
| PARENT_LPN_ID | NUMBER | 18 | Parent LPN / Container ID to which Detail Line is Packed. | |||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | |||
| MVT_STAT_STATUS | VARCHAR2 | 30 | MVT statistics status | |||
| TRACKING_NUMBER | VARCHAR2 | 30 | Tracking number | |||
| TRANSACTION_TEMP_ID | NUMBER | 18 | Foreign key to inventory transaction temp tables | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Shipment Line (WSH_DELIVERY_DETAILS) | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| MOVEMENT_ID | NUMBER | 18 | Movement statistics identifier | |||
| SPLIT_FROM_DELIVERY_DETAIL_ID | NUMBER | 18 | Delivery detail identifier that the line is split from | |||
| INV_INTERFACED_FLAG | VARCHAR2 | 1 | Indicates if line is interfaced to inventory | |||
| SOURCE_LINE_NUMBER | VARCHAR2 | 150 | User visible line number in source system | |||
| SEAL_CODE | VARCHAR2 | 30 | Seal Code | |||
| GROSS_WEIGHT | NUMBER | Gross weight of the line | ||||
| PREFERRED_GRADE | VARCHAR2 | 150 | Preferred grade | |||
| SRC_REQUESTED_QUANTITY2 | NUMBER | Dual ordered quantity | ||||
| SRC_REQUESTED_QUANTITY_UOM2 | VARCHAR2 | 3 | Secondary ordered quantity unit of measure from the source system | |||
| REQUESTED_QUANTITY2 | NUMBER | Dual requested quantity | ||||
| SHIPPED_QUANTITY2 | NUMBER | Dual shipped quantity | ||||
| DELIVERED_QUANTITY2 | NUMBER | Dual delivered quantity | ||||
| CANCELLED_QUANTITY2 | NUMBER | Secondary canceled quantity in secondary requested quantity unit | ||||
| CYCLE_COUNT_QUANTITY2 | NUMBER | Dual cycle count quantity | ||||
| REQUESTED_QUANTITY_UOM2 | VARCHAR2 | 3 | Dual requested quantity | |||
| UNIT_PRICE | NUMBER | Unit price | ||||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code | |||
| LPN_CONTENT_ID | NUMBER | 18 | Packing unit content identifier | |||
| INSPECTION_FLAG | VARCHAR2 | 1 | Inspection Flag | |||
| SHIP_TO_SITE_USE_ID | NUMBER | 18 | Site identifier for ship to destination NOT USED | |||
| ORIGINAL_SUBINVENTORY | VARCHAR2 | 10 | Original subinventory | |||
| PICKABLE_FLAG | VARCHAR2 | 1 | Flag indicating whether the shipment line can be picked | |||
| PICKED_QUANTITY | NUMBER | Picked Quantity | ||||
| PICKED_QUANTITY2 | NUMBER | Secondary Picked Quantity | ||||
| BATCH_ID | NUMBER | 18 | Foreign key to WSH_PICKING_BATCHES | |||
| TRANSACTION_ID | NUMBER | 18 | Transaction Identifier | |||
| SERVICE_LEVEL | VARCHAR2 | 30 | Service level for ship method | |||
| MODE_OF_TRANSPORT | VARCHAR2 | 30 | Mode of transport for ship method | |||
| EARLIEST_PICKUP_DATE | DATE | Date on which this line is to be first picked up | ||||
| LATEST_PICKUP_DATE | DATE | Latest date on which this line can be picked up | ||||
| EARLIEST_DROPOFF_DATE | DATE | Earliest date on which the line needs to be delivered | ||||
| LATEST_DROPOFF_DATE | DATE | Latest date at which this line is to be delivered to customer | ||||
| REQUEST_DATE_TYPE_CODE | VARCHAR2 | 30 | Request date type code | |||
| SOURCE_DOCUMENT_TYPE_ID | NUMBER | 18 | To be collected from source order header | |||
| UNIT_WEIGHT | NUMBER | Unit Weight of the item on this delivery detail | ||||
| UNIT_VOLUME | NUMBER | Unit Volume of the item on this delivery detail | ||||
| 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. | ||
| SHIP_TO_PARTY_ID | NUMBER | 18 | Ship-to party identifier | |||
| SOLD_TO_PARTY_ID | NUMBER | 18 | Sold-to party identifier | |||
| OUTSOURCER_PARTY_ID | NUMBER | 18 | Party identifier of the outsourcer who sent the order line | |||
| BILL_TO_PARTY_ID | NUMBER | 18 | Bill To Party for the Order Line | |||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Bill To Location for the Order Line | |||
| BILL_TO_CONTACT_ID | NUMBER | 18 | Bill To Contact for the Order Line | |||
| SHIP_SET_NAME | VARCHAR2 | 150 | Ship Set Name to which the Order Line belongs to | |||
| ARRIVAL_SET_NAME | VARCHAR2 | 150 | Arrival Set Name to which the Order Line belongs to | |||
| SOURCE_LINE_UPDATE_DATE | DATE | Source line date last updated | ||||
| SELLING_PRICE | NUMBER | Saves the actual selling price as opposed to UNIT_PRICE | ||||
| SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | Ship To Site Identifier | |||
| BILL_TO_PARTY_SITE_ID | NUMBER | 18 | Bill To Site Identifier | |||
| REQUISITION_HEADER_ID | NUMBER | 18 | Requisition header id | |||
| REQUISITION_LINE_ID | NUMBER | 18 | Requisition Line ID | |||
| CONVERTED_QUANTITY | NUMBER | Shipped or backordered quantity converted into ordered quantity unit | ||||
| SOURCE_SHIPMENT_ID | NUMBER | 18 | Shipment id from source system | |||
| SOURCE_SHIPMENT_NUMBER | VARCHAR2 | 150 | Shipment number from source system | |||
| SOURCE_SYSTEM_ID | NUMBER | 18 | Source system identifier in TCA | |||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | 150 | Sales Order line number from order capture system | |||
| SALES_ORDER_NUMBER | VARCHAR2 | 150 | Sales Order number from order capture system | |||
| SALES_ORDER_SHIPMENT_NUMBER | VARCHAR2 | 150 | Sales Order shipment number from order capture system | |||
| CONVERSION_TYPE | VARCHAR2 | 80 | Currency conversion type to be used if order is in different currency than the currency of shipping costs. | |||
| CONVERSION_DATE | DATE | Date to be used for the currency conversion. | ||||
| CONVERSION_RATE | NUMBER | 15 | Rate to be used for the currency conversion | |||
| SP_PICKED_QUANTITY | NUMBER | Stores picked quantity for standard pack. | ||||
| SPQ_UOM | VARCHAR2 | 3 | Unit of measure for standard packed quantity | |||
| PARENT_INVENTORY_ITEM_ID | NUMBER | 18 | Added for Globalization, Intrastat support for kits | |||
| PARENT_SOURCE_SHIPMENT_ID | NUMBER | 18 | Added for Globalization, Intrastat support for kits | |||
| 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. | |||
| 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 line type. | |||
| 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 | 1 | 3PL/WMS : Indicates whether the delivery detail has been interfaced to WMS or not. |
| 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_PICKING_BATCHES | WSH_DELIVERY_DETAILS | DELIVERY_DETAIL_ID |
| WSH_EXCEPTIONS | WSH_DELIVERY_DETAILS | DELIVERY_DETAIL_ID |
| WSH_SERIAL_NUMBERS | WSH_DELIVERY_DETAILS | DELIVERY_DETAIL_ID |
| WSH_FREIGHT_COSTS | 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_DEL_DETAILS_INTERFACE | WSH_DELIVERY_DETAILS | DELIVERY_DETAIL_INTERFACE_ID |
| WSH_PRORATED_FREIGHT_COSTS | WSH_DELIVERY_DETAILS | DELIVERY_DETAIL_ID |
| Index | Uniqueness | Tablespace | Column |
|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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_N5 | Non Unique | FUSION_TS_TX_IDX | SHIP_FROM_LOCATION_ID |
| 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 |
| WSH_DELIVERY_DETAILS_U1 | Unique | FUSION_TS_TX_IDX | DELIVERY_DETAIL_ID |