[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_MVSTO_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | EC |
| FND Design Data: |  EC.ECE_MVSTO_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
ECE_MVSTO_DETAILS contains movement statistics
detail level information to support the outbound Movement
Statistics transaction.
ECE_MVSTO_DETAILS is based primarily on data stored in
the table MTL_MOVEMENT_STATISTICS from Oracle
Inventory.
ECE_MVSTO_DETAILS contains information on the
movement identifer, movement type, nature of transport,
statistical types, statistical values, territory, country, port,
and currency related to the movement.
All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.
TRANSACTION_RECORD_ID is the unique key that links the
ECE_MVSTO_DETAILS table to its corresponding extension table
ECE_MVSTO_DETAILS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ECE_MVSTO_DETAILS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 MOVEMENT_ID
|
| ECE_MVSTO_DETAILS_U2 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_RECORD_ID
TRANSACTION_HEADER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EDI_SENT_FLAG | VARCHAR2 | (1) | EDI Sent Flag | |
| PERIOD_NAME | VARCHAR2 | (15) | Period Name | |
| EDI_TRANSACTION_REFERENCE | VARCHAR2 | (35) | EDI Transaction Reference | |
| EDI_TRANSACTION_DATE | DATE | EDI Transaction Date | ||
| TRANSACTION_DATE | DATE | Transaction Date | ||
| SET_OF_BOOKS_PERIOD | VARCHAR2 | (15) | Set of Books Period | |
| CREATION_METHOD | VARCHAR2 | (30) | Creation Method (Internal) | |
| CREATION_METHOD_EXT1 | VARCHAR2 | (30) | Creation Method 1 (Ext) | |
| CREATION_METHOD_EXT2 | VARCHAR2 | (30) | Creation Method 2 (Ext) | |
| CREATION_METHOD_EXT3 | VARCHAR2 | (30) | Creation Method 3 (Ext) | |
| CREATION_METHOD_EXT4 | VARCHAR2 | (30) | Creation Method 4 (Ext) | |
| CREATION_METHOD_EXT5 | VARCHAR2 | (30) | Creation Method 5 (Ext) | |
| FLOW_INDICATOR_CODE | VARCHAR2 | (30) | Flow Indicator Code (Internal) | |
| FLOW_INDICATOR_CODE_EXT1 | VARCHAR2 | (50) | Flow Indicator Code 1 (Ext) | |
| FLOW_INDICATOR_CODE_EXT2 | VARCHAR2 | (30) | Flow Indicator Code 2 (Ext) | |
| FLOW_INDICATOR_CODE_EXT3 | VARCHAR2 | (30) | Flow Indicator Code 3 (Ext) | |
| FLOW_INDICATOR_CODE_EXT4 | VARCHAR2 | (30) | Flow Indicator Code 4 (Ext) | |
| FLOW_INDICATOR_CODE_EXT5 | VARCHAR2 | (30) | Flow Indicator Code 5 (Ext) | |
| STAT_METHOD | VARCHAR2 | (30) | Statistical Method (Internal) | |
| STAT_METHOD_EXT1 | VARCHAR2 | (30) | Statistical Method 1 (Ext) | |
| STAT_METHOD_EXT2 | VARCHAR2 | (30) | Statistical Method 2 (Ext) | |
| STAT_METHOD_EXT3 | VARCHAR2 | (30) | Statistical Method 3 (Ext) | |
| STAT_METHOD_EXT4 | VARCHAR2 | (30) | Statistical Method 4 (Ext) | |
| STAT_METHOD_EXT5 | VARCHAR2 | (30) | Statistical Method 5 (Ext) | |
| STAT_TYPE | VARCHAR2 | (30) | Statistical Type (Internal) | |
| STAT_TYPE_EXT1 | VARCHAR2 | (30) | Statistical Type 1 (Ext) | |
| STAT_TYPE_EXT2 | VARCHAR2 | (30) | Statistical Type 2 (Ext) | |
| STAT_TYPE_EXT3 | VARCHAR2 | (30) | Statistical Type 3 (Ext) | |
| STAT_TYPE_EXT4 | VARCHAR2 | (30) | Statistical Type 4 (Ext) | |
| STAT_TYPE_EXT5 | VARCHAR2 | (30) | Statistical Type 5 (Ext) | |
| TRANSPORT_MODE | VARCHAR2 | (30) | Nature of Transport (Internal) | |
| TRANSPORT_MODE_EXT1 | VARCHAR2 | (30) | Transport Mode 1 (Ext) | |
| TRANSPORT_MODE_EXT2 | VARCHAR2 | (30) | Transport Mode 2 (Ext) | |
| TRANSPORT_MODE_EXT3 | VARCHAR2 | (30) | Transport Mode 3 (Ext) | |
| TRANSPORT_MODE_EXT4 | VARCHAR2 | (30) | Transport Mode 4 (Ext) | |
| TRANSPORT_MODE_EXT5 | VARCHAR2 | (30) | Transport Mode 5 (Ext) | |
| TRANSACTION_NATURE | VARCHAR2 | (30) | Transaction Nature (Internal) | |
| TRANSACTION_NATURE_EXT1 | VARCHAR2 | (30) | Transaction Nature 1 (Ext) | |
| TRANSACTION_NATURE_EXT2 | VARCHAR2 | (30) | Transaction Nature 2 (Ext) | |
| TRANSACTION_NATURE_EXT3 | VARCHAR2 | (30) | Transaction Nature 3 (Ext) | |
| TRANSACTION_NATURE_EXT4 | VARCHAR2 | (30) | Transaction Nature 4 (Ext) | |
| TRANSACTION_NATURE_EXT5 | VARCHAR2 | (30) | Transaction Nature 5 (Ext) | |
| MOVEMENT_NATURE_CODE | VARCHAR2 | (30) | Movement Nature Code (Internal) | |
| MOVEMENT_NATURE_CODE_EXT1 | VARCHAR2 | (30) | Movement Nature Code 1 (Ext) | |
| MOVEMENT_NATURE_CODE_EXT2 | VARCHAR2 | (30) | Movement Nature Code 2 (Ext) | |
| MOVEMENT_NATURE_CODE_EXT3 | VARCHAR2 | (30) | Movement Nature Code 3 (Ext) | |
| MOVEMENT_NATURE_CODE_EXT4 | VARCHAR2 | (30) | Movement Nature Code 4 (Ext) | |
| MOVEMENT_NATURE_CODE_EXT5 | VARCHAR2 | (30) | Movement Nature Code 5 (Ext) | |
| ORIGIN_TERRITORY_EU_CODE | VARCHAR2 | (3) | Origin Territory Code | |
| ORIGIN_TERRITORY_CODE | VARCHAR2 | (2) | Origin Territory Code (Internal) | |
| ORIGIN_TERRITORY_CODE_EXT1 | VARCHAR2 | (2) | Origin Territory Code 1 (Ext) | |
| ORIGIN_TERRITORY_CODE_EXT2 | VARCHAR2 | (30) | Origin Territory Code 2 (Ext) | |
| ORIGIN_TERRITORY_CODE_EXT3 | VARCHAR2 | (30) | Origin Territory Code 3 (Ext) | |
| ORIGIN_TERRITORY_CODE_EXT4 | VARCHAR2 | (30) | Origin Territory Code 4 (Ext) | |
| ORIGIN_TERRITORY_CODE_EXT5 | VARCHAR2 | (30) | Origin Territory Code 5 (Ext) | |
| DESTINATION_TERRITORY_EU_CODE | VARCHAR2 | (3) | Destination Territory Code | |
| DESTINATION_TERRITORY_CODE | VARCHAR2 | (2) | Destination Territory Code (Internal) | |
| DEST_TERRITORY_CODE_EXT1 | VARCHAR2 | (2) | Destination Territory Code 1 (Ext) | |
| DEST_TERRITORY_CODE_EXT2 | VARCHAR2 | (30) | Destination Territory Code 2 (Ext) | |
| DEST_TERRITORY_CODE_EXT3 | VARCHAR2 | (30) | Destination Territory Code 3 (Ext) | |
| DEST_TERRITORY_CODE_EXT4 | VARCHAR2 | (30) | Destination Territory Code 4 (Ext) | |
| DEST_TERRITORY_CODE_EXT5 | VARCHAR2 | (30) | Destination Territory Code 5 (Ext) | |
| DISPATCH_TERRITORY_EU_CODE | VARCHAR2 | (3) | Dispatch Territory Code | |
| DISPATCH_TERRITORY_CODE | VARCHAR2 | (2) | Dispatch Territory Code (Internal) | |
| DISPATCH_TERRITORY_CODE_EXT1 | VARCHAR2 | (2) | Dispatch Territory Code 1 (Ext) | |
| DISPATCH_TERRITORY_CODE_EXT2 | VARCHAR2 | (30) | Dispatch Territory Code 2 (Ext) | |
| DISPATCH_TERRITORY_CODE_EXT3 | VARCHAR2 | (30) | Dispatch Territory Code 3 (Ext) | |
| DISPATCH_TERRITORY_CODE_EXT4 | VARCHAR2 | (30) | Dispatch Territory Code 4 (Ext) | |
| DISPATCH_TERRITORY_CODE_EXT5 | VARCHAR2 | (30) | Dispatch Territory Code 5 (Ext) | |
| TRIANGULATION_COUNTRY_EU_CODE | VARCHAR2 | (30) | Triangulation Country Code | |
| TRIANGULATION_COUNTRY_CODE | VARCHAR2 | (30) | Triangulation Country Code (Internal) | |
| TRIANG_COUNTRY_CODE_EXT1 | VARCHAR2 | (30) | Triangulation Country Code 1 (Ext) | |
| TRIANG_COUNTRY_CODE_EXT2 | VARCHAR2 | (30) | Triangulation Country Code 2 (Ext) | |
| TRIANG_COUNTRY_CODE_EXT3 | VARCHAR2 | (30) | Triangulation Country Code 3 (Ext) | |
| TRIANG_COUNTRY_CODE_EXT4 | VARCHAR2 | (30) | Triangulation Country Code 4 (Ext) | |
| TRIANG_COUNTRY_CODE_EXT5 | VARCHAR2 | (30) | Triangulation Country Code 5 (Ext) | |
| PORT | VARCHAR2 | (30) | Port (Internal) | |
| PORT_EXT1 | VARCHAR2 | (30) | Port 1 (Ext) | |
| PORT_EXT2 | VARCHAR2 | (30) | Port 2 (Ext) | |
| PORT_EXT3 | VARCHAR2 | (30) | Port 3 (Ext) | |
| PORT_EXT4 | VARCHAR2 | (30) | Port 4 (Ext) | |
| PORT_EXT5 | VARCHAR2 | (30) | Port 5 (Ext) | |
| AREA | VARCHAR2 | (30) | Area (Internal) | |
| AREA_EXT1 | VARCHAR2 | (30) | Area 1 (Ext) | |
| AREA_EXT2 | VARCHAR2 | (30) | Area 2 (Ext) | |
| AREA_EXT3 | VARCHAR2 | (30) | Area 3 (Ext) | |
| AREA_EXT4 | VARCHAR2 | (30) | Area 4 (Ext) | |
| AREA_EXT5 | VARCHAR2 | (30) | Area 5 (Ext) | |
| MOVEMENT_ID | NUMBER | Yes | Movement ID | |
| MOVEMENT_TYPE | VARCHAR2 | (30) | Movement Type | |
| MOVEMENT_TYPE_EXT1 | VARCHAR2 | (30) | Movement Type 1 (Ext) | |
| MOVEMENT_TYPE_EXT2 | VARCHAR2 | (30) | Movement Type 2 (Ext) | |
| MOVEMENT_TYPE_EXT3 | VARCHAR2 | (30) | Movement Type 3 (Ext) | |
| MOVEMENT_TYPE_EXT4 | VARCHAR2 | (30) | Movement Type 4 (Ext) | |
| MOVEMENT_TYPE_EXT5 | VARCHAR2 | (30) | Movement Type 5 (Ext) | |
| ZONE_CODE | VARCHAR2 | (10) | Economic Zone Code (Internal) | |
| ECONOMIC_ZONE_EXT1 | VARCHAR2 | (10) | Economic Zone Code 1 (Ext) | |
| ECONOMIC_ZONE_EXT2 | VARCHAR2 | (30) | Economic Zone Code 2 (Ext) | |
| ECONOMIC_ZONE_EXT3 | VARCHAR2 | (30) | Economic Zone Code 3 (Ext) | |
| ECONOMIC_ZONE_EXT4 | VARCHAR2 | (30) | Economic Zone Code 4 (Ext) | |
| ECONOMIC_ZONE_EXT5 | VARCHAR2 | (30) | Economic Zone Code 5 (Ext) | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code (Internal) | |
| CURRENCY_CODE_EXT1 | VARCHAR2 | (30) | Currency Code 1 (Ext) | |
| CURRENCY_CODE_EXT2 | VARCHAR2 | (30) | Currency Code 2 (Ext) | |
| CURRENCY_CODE_EXT3 | VARCHAR2 | (30) | Currency Code 3 (Ext) | |
| CURRENCY_CODE_EXT4 | VARCHAR2 | (30) | Currency Code 4 (Ext) | |
| CURRENCY_CODE_EXT5 | VARCHAR2 | (30) | Currency Code 5 (Ext) | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type (Internal) | |
| CURRENCY_CONVERSION_TYPE_EXT1 | VARCHAR2 | (30) | Currency Conversion Type 1 (Ext) | |
| CURRENCY_CONVERSION_TYPE_EXT2 | VARCHAR2 | (30) | Currency Conversion Type 2 (Ext) | |
| CURRENCY_CONVERSION_TYPE_EXT3 | VARCHAR2 | (30) | Currency Conversion Type 3 (Ext) | |
| CURRENCY_CONVERSION_TYPE_EXT4 | VARCHAR2 | (30) | Currency Conversion Type 4 (Ext) | |
| CURRENCY_CONVERSION_TYPE_EXT5 | VARCHAR2 | (30) | Currency Conversion Type 5 (Ext) | |
| CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
| MOVEMENT_AMOUNT | NUMBER | Movement Amount | ||
| ITEM_COST | NUMBER | Item Cost | ||
| DOCUMENT_UNIT_PRICE | NUMBER | Document Unit Price | ||
| DOCUMENT_LINE_EXT_VALUE | NUMBER | Document Line Extend Value | ||
| OUTSIDE_CODE | VARCHAR2 | (30) | Outside Code (Internal) | |
| OUTSIDE_CODE_EXT1 | VARCHAR2 | (30) | Outside Code 1 (Ext) | |
| OUTSIDE_CODE_EXT2 | VARCHAR2 | (30) | Outside Code 2 (Ext) | |
| OUTSIDE_CODE_EXT3 | VARCHAR2 | (30) | Outside Code 3 (Ext) | |
| OUTSIDE_CODE_EXT4 | VARCHAR2 | (30) | Outside Code 4 (Ext) | |
| OUTSIDE_CODE_EXT5 | VARCHAR2 | (30) | Outside Code 5 (Ext) | |
| OUTSIDE_EXT_VALUE | NUMBER | Outside External Value | ||
| OUTSIDE_UNIT_PRICE | NUMBER | Outside Unit Price | ||
| STAT_ADJ_AMOUNT | NUMBER | Statistical Adjustment Amount | ||
| STAT_ADJ_PERCENT | NUMBER | Statistical Adjustment Percent | ||
| STAT_EXT_VALUE | NUMBER | Statistical External Value | ||
| DELIVERY_TERMS | VARCHAR2 | (30) | Delivery Terms (Internal) | |
| DELIVERY_TERMS_EXT1 | VARCHAR2 | (30) | Delivery Terms 1 (Ext) | |
| DELIVERY_TERMS_EXT2 | VARCHAR2 | (30) | Delivery Terms 2 (Ext) | |
| DELIVERY_TERMS_EXT3 | VARCHAR2 | (30) | Delivery Terms 3 (Ext) | |
| DELIVERY_TERMS_EXT4 | VARCHAR2 | (30) | Delivery Terms 4 (Ext) | |
| DELIVERY_TERMS_EXT5 | VARCHAR2 | (30) | Delivery Terms 5 (Ext) | |
| PRIMARY_QUANTITY | NUMBER | Primary Quantity | ||
| TRANSACTION_QUANTITY | NUMBER | Transaction Quantity | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | (3) | Transaction Unit of Measure Code (Internal) | |
| TRANSACTION_UOM_CODE_EXT1 | VARCHAR2 | (3) | Transaction Unit of Measure Code 1 (Ext) | |
| TRANSACTION_UOM_CODE_EXT2 | VARCHAR2 | (30) | Transaction Unit of Measure Code 2 (Ext) | |
| TRANSACTION_UOM_CODE_EXT3 | VARCHAR2 | (30) | Transaction Unit of Measure Code 3 (Ext) | |
| TRANSACTION_UOM_CODE_EXT4 | VARCHAR2 | (30) | Transaction Unit of Measure Code 4 (Ext) | |
| TRANSACTION_UOM_CODE_EXT5 | VARCHAR2 | (30) | Transaction Unit of Measure Code 5 (Ext) | |
| WEIGHT_METHOD | VARCHAR2 | (30) | Weight Method (Internal) | |
| WEIGHT_METHOD_EXT1 | VARCHAR2 | (30) | Weight Method 1 (Ext) | |
| WEIGHT_METHOD_EXT2 | VARCHAR2 | (30) | Weight Method 2 (Ext) | |
| WEIGHT_METHOD_EXT3 | VARCHAR2 | (30) | Weight Method 3 (Ext) | |
| WEIGHT_METHOD_EXT4 | VARCHAR2 | (30) | Weight Method 4 (Ext) | |
| WEIGHT_METHOD_EXT5 | VARCHAR2 | (30) | Weight Method 5 (Ext) | |
| UNIT_WEIGHT | NUMBER | Unit Weight | ||
| TOTAL_WEIGHT | NUMBER | Total Weight | ||
| TOTAL_WEIGHT_UOM_CODE | VARCHAR2 | (3) | Total Weight Unit of Measure Code (Internal) | |
| TOTAL_WEIGHT_UOM_CODE_EXT1 | VARCHAR2 | (30) | Total Weight Unit of Measure Code 1 (Ext) | |
| TOTAL_WEIGHT_UOM_CODE_EXT2 | VARCHAR2 | (30) | Total Weight Unit of Measure Code 2 (Ext) | |
| TOTAL_WEIGHT_UOM_CODE_EXT3 | VARCHAR2 | (30) | Total Weight Unit of Measure Code 3 (Ext) | |
| TOTAL_WEIGHT_UOM_CODE_EXT4 | VARCHAR2 | (30) | Total Weight Unit of Measure Code 4 (Ext) | |
| TOTAL_WEIGHT_UOM_CODE_EXT5 | VARCHAR2 | (30) | Total Weight Unit of Measure Code 5 (Ext) | |
| ALTERNATE_QUANTITY | NUMBER | Alternate Quantity | ||
| ALTERNATE_UOM_CODE | VARCHAR2 | (3) | Alternate Unit of Measure Code (Internal) | |
| ALTERNATE_UOM_CODE_EXT1 | VARCHAR2 | (3) | Alternate Unit of Measure Code 1 (Ext) | |
| ALTERNATE_UOM_CODE_EXT2 | VARCHAR2 | (30) | Alternate Unit of Measure Code 2 (Ext) | |
| ALTERNATE_UOM_CODE_EXT3 | VARCHAR2 | (30) | Alternate Unit of Measure Code 3 (Ext) | |
| ALTERNATE_UOM_CODE_EXT4 | VARCHAR2 | (30) | Alternate Unit of Measure Code 4 (Ext) | |
| ALTERNATE_UOM_CODE_EXT5 | VARCHAR2 | (30) | Alternate Unit of Measure Code 5 (Ext) | |
| COMMODITY_CODE | VARCHAR2 | (240) | Commodity Code (Internal) | |
| COMMODITY_DESCRIPTION | VARCHAR2 | (240) | Commodity Description | |
| COMMENTS | VARCHAR2 | (240) | Comments | |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
| DOCUMENT_SOURCE_TYPE | VARCHAR2 | (30) | Document Source Type (Internal) | |
| DOCUMENT_REFERENCE | VARCHAR2 | (50) | Document Reference | |
| DOCUMENT_LINE_REFERENCE | VARCHAR2 | (30) | Document Line Reference | |
| TRANSACTING_FROM_ORG | VARCHAR2 | (50) | Transacting From Organization | |
| TRANSACTING_TO_ORG | VARCHAR2 | (50) | Transacting To Organization | |
| DISTRIBUTION_LINE_NUMBER | NUMBER | Distribution Line Number | ||
| AFFILIATION_REFERENCE_CODE | VARCHAR2 | (30) | Affiliation Reference Code (Internal) | |
| AFFILIATION_REF_CODE_EXT1 | VARCHAR2 | (30) | Affiliation Reference Code 1 (Ext) | |
| AFFILIATION_REF_CODE_EXT2 | VARCHAR2 | (30) | Affiliation Reference Code 2 (Ext) | |
| AFFILIATION_REF_CODE_EXT3 | VARCHAR2 | (30) | Affiliation Reference Code 3 (Ext) | |
| AFFILIATION_REF_CODE_EXT4 | VARCHAR2 | (30) | Affiliation Reference Code 4 (Ext) | |
| AFFILIATION_REF_CODE_EXT5 | VARCHAR2 | (30) | Affiliation Reference Code 5 (Ext) | |
| CONTAINER_TYPE_CODE | VARCHAR2 | (30) | Container Type Code (Internal) | |
| CONTAINER_TYPE_CODE_EXT1 | VARCHAR2 | (30) | Container Type Code 1 (Ext) | |
| CONTAINER_TYPE_CODE_EXT2 | VARCHAR2 | (30) | Container Type Code 2 (Ext) | |
| CONTAINER_TYPE_CODE_EXT3 | VARCHAR2 | (30) | Container Type Code 3 (Ext) | |
| CONTAINER_TYPE_CODE_EXT4 | VARCHAR2 | (30) | Container Type Code 4 (Ext) | |
| CONTAINER_TYPE_CODE_EXT5 | VARCHAR2 | (30) | Container Type Code 5 (Ext) | |
| CSA_CODE | VARCHAR2 | (30) | CSA Code (Internal) | |
| CSA_CODE_EXT1 | VARCHAR2 | (30) | CSA Code 1 (Ext) | |
| CSA_CODE_EXT2 | VARCHAR2 | (30) | CSA Code 2 (Ext) | |
| CSA_CODE_EXT3 | VARCHAR2 | (30) | CSA Code 3 (Ext) | |
| CSA_CODE_EXT4 | VARCHAR2 | (30) | CSA Code 4 (Ext) | |
| CSA_CODE_EXT5 | VARCHAR2 | (30) | CSA Code 5 (Ext) | |
| OIL_REFERENCE_CODE | VARCHAR2 | (30) | Oil Reference Code (Internal) | |
| OIL_REFERENCE_CODE_EXT1 | VARCHAR2 | (50) | Oil Reference Code 1 (Ext) | |
| OIL_REFERENCE_CODE_EXT2 | VARCHAR2 | (50) | Oil Reference Code 2 (Ext) | |
| OIL_REFERENCE_CODE_EXT3 | VARCHAR2 | (50) | Oil Reference Code 3 (Ext) | |
| OIL_REFERENCE_CODE_EXT4 | VARCHAR2 | (50) | Oil Reference Code 4 (Ext) | |
| OIL_REFERENCE_CODE_EXT5 | VARCHAR2 | (50) | Oil Reference Code 5 (Ext) | |
| PICK_SLIP_REFERENCE | VARCHAR2 | (50) | Pick Slip Reference | |
| PREFERENCE_CODE | VARCHAR2 | (30) | Preference Code (Internal) | |
| PREFERENCE_CODE_EXT1 | VARCHAR2 | (50) | Preference Code 1 (Ext) | |
| PREFERENCE_CODE_EXT2 | VARCHAR2 | (50) | Preference Code 2 (Ext) | |
| PREFERENCE_CODE_EXT3 | VARCHAR2 | (50) | Preference Code 3 (Ext) | |
| PREFERENCE_CODE_EXT4 | VARCHAR2 | (50) | Preference Code 4 (Ext) | |
| PREFERENCE_CODE_EXT5 | VARCHAR2 | (50) | Preference Code 5 (Ext) | |
| RECEIPT_REFERENCE | VARCHAR2 | (50) | Receipt Reference (Internal) | |
| RECEIPT_REFERENCE_EXT1 | VARCHAR2 | (50) | Receipt Reference 1 (Ext) | |
| RECEIPT_REFERENCE_EXT2 | VARCHAR2 | (50) | Receipt Reference 2 (Ext) | |
| RECEIPT_REFERENCE_EXT3 | VARCHAR2 | (50) | Receipt Reference 3 (Ext) | |
| RECEIPT_REFERENCE_EXT4 | VARCHAR2 | (50) | Receipt Reference 4 (Ext) | |
| RECEIPT_REFERENCE_EXT5 | VARCHAR2 | (50) | Receipt Reference 5 (Ext) | |
| SHIPMENT_LINE_REFERENCE | VARCHAR2 | (30) | Shipment Line Reference (Internal) | |
| SHIPMENT_LINE_REFERENCE_EXT1 | VARCHAR2 | (30) | Shipment Line Reference 1 (Ext) | |
| SHIPMENT_LINE_REFERENCE_EXT2 | VARCHAR2 | (30) | Shipment Line Reference 2 (Ext) | |
| SHIPMENT_LINE_REFERENCE_EXT3 | VARCHAR2 | (30) | Shipment Line Reference 3 (Ext) | |
| SHIPMENT_LINE_REFERENCE_EXT4 | VARCHAR2 | (30) | Shipment Line Reference 4 (Ext) | |
| SHIPMENT_LINE_REFERENCE_EXT5 | VARCHAR2 | (30) | Shipment Line Reference 5 (Ext) | |
| SHIPMENT_REFERENCE | VARCHAR2 | (50) | Shipment Reference (Internal) | |
| SHIPMENT_REFERENCE_EXT1 | VARCHAR2 | (50) | Shipment Reference 1 (Ext) | |
| SHIPMENT_REFERENCE_EXT2 | VARCHAR2 | (50) | Shipment Reference 2 (Ext) | |
| SHIPMENT_REFERENCE_EXT3 | VARCHAR2 | (50) | Shipment Reference 3 (Ext) | |
| SHIPMENT_REFERENCE_EXT4 | VARCHAR2 | (50) | Shipment Reference 4 (Ext) | |
| SHIPMENT_REFERENCE_EXT5 | VARCHAR2 | (50) | Shipment Reference 5 (Ext) | |
| TARIC_CODE | VARCHAR2 | (30) | Taric Code (Internal) | |
| TARIC_CODE_EXT1 | VARCHAR2 | (30) | Taric Code 1 (Ext) | |
| TARIC_CODE_EXT2 | VARCHAR2 | (30) | Taric Code 2 (Ext) | |
| TARIC_CODE_EXT3 | VARCHAR2 | (30) | Taric Code 3 (Ext) | |
| TARIC_CODE_EXT4 | VARCHAR2 | (30) | Taric Code 4 (Ext) | |
| TARIC_CODE_EXT5 | VARCHAR2 | (30) | Taric Code 5 (Ext) | |
| INVOICE_BATCH_REFERENCE | VARCHAR2 | (50) | Invoice Batch Reference | |
| INVOICE_DATE_REFERENCE | DATE | Invoice Date Reference | ||
| INVOICE_LINE_EXT_VALUE | NUMBER | Invoice Line External Value | ||
| INVOICE_LINE_REFERENCE | VARCHAR2 | (30) | Invoice Line Reference | |
| INVOICE_QUANTITY | NUMBER | Invoice Quantity | ||
| INVOICE_REFERENCE | VARCHAR2 | (50) | Invoice Reference | |
| INVOICE_UNIT_PRICE | NUMBER | Invoice Unit Price | ||
| INVOICE_BATCH_ID | NUMBER | Invoice Batch ID | ||
| INVOICE_ID | NUMBER | Invoice ID | ||
| CUSTOMER_LOCATION | VARCHAR2 | (50) | Customer Location | |
| CUSTOMER_NAME | VARCHAR2 | (240) | Customer Name | |
| CUSTOMER_NUMBER | VARCHAR2 | (50) | Customer Number | |
| BILL_TO_NAME | VARCHAR2 | (240) | Bill To Name | |
| BILL_TO_NUMBER | VARCHAR2 | (50) | Bill To Number | |
| BILL_TO_SITE | VARCHAR2 | (50) | Bill To Site | |
| SHIP_TO_NAME | VARCHAR2 | (240) | Ship To Name | |
| SHIP_TO_NUMBER | VARCHAR2 | (50) | Ship To Number | |
| SHIP_TO_SITE | VARCHAR2 | (50) | Ship To Site | |
| BILL_TO_CUSTOMER_ID | NUMBER | Bill To Customer ID | ||
| BILL_TO_SITE_USE_ID | NUMBER | Bill To Site Use ID | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | Ship To Customer ID | ||
| SHIP_TO_SITE_USE_ID | NUMBER | Ship To Site Use ID | ||
| VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
| VENDOR_NUMBER | VARCHAR2 | (50) | Vendor Number | |
| VENDOR_SITE | VARCHAR2 | (50) | Vendor Site | |
| VENDOR_ID | NUMBER | Vendor ID | ||
| VENDOR_SITE_ID | NUMBER | Vendor Site ID | ||
| CATEGORY_ID | NUMBER | Category ID | ||
| CUSTOMER_TRX_LINE_ID | NUMBER | Customer Transaction Line ID | ||
| FROM_ORGANIZATION_ID | NUMBER | From Organization ID | ||
| TO_ORGANIZATION_ID | NUMBER | To Organization ID | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory Item ID | ||
| MTL_TRANSACTION_ID | NUMBER | Material Transaction ID | ||
| RCV_TRANSACTION_ID | NUMBER | Receiving Transaction ID | ||
| ORDER_HEADER_ID | NUMBER | Order Header ID | ||
| ORDER_LINE_ID | NUMBER | Order Line ID | ||
| ORGANIZATION_ID | NUMBER | Organization ID | ||
| PARENT_MOVEMENT_ID | NUMBER | Parent Movement ID | ||
| PICKING_LINE_DETAIL_ID | NUMBER | Picking Line Detail ID | ||
| PICKING_LINE_ID | NUMBER | Picking Line ID | ||
| PO_HEADER_ID | NUMBER | PO Header ID | ||
| PO_LINE_ID | NUMBER | PO Line ID | ||
| PO_LINE_LOCATION_ID | NUMBER | PO Line Location ID | ||
| REQUISITION_HEADER_ID | NUMBER | Requisition Header ID | ||
| REQUISITION_LINE_ID | NUMBER | Requisition Line ID | ||
| SHIPMENT_HEADER_ID | NUMBER | Shipment Header ID | ||
| SHIPMENT_LINE_ID | NUMBER | Shipment Line ID | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| ENTITY_ORG_ID | NUMBER | Entity Organization ID | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Detail Flexfiled Context | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Detail Flexfield 1 | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Detail Flexfield 2 | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Detail Flexfield 3 | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Detail Flexfield 4 | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Detail Flexfield 5 | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Detail Flexfield 6 | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Detail Flexfield 7 | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Detail Flexfield 8 | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Detail Flexfield 9 | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Detail Flexfield 10 | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Detail Flexfield 11 | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Detail Flexfield 12 | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Detail Flexfield 13 | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Detail Flexfield 14 | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Detail Flexfield 15 | |
| TRANSACTION_RECORD_ID | NUMBER | Yes | Transaction Record ID | |
| TRANSACTION_HEADER_ID | NUMBER | Yes | Transction Header ID | |
| RUN_ID | NUMBER | Transaction Run ID | ||
| SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT EDI_SENT_FLAG
, PERIOD_NAME
, EDI_TRANSACTION_REFERENCE
, EDI_TRANSACTION_DATE
, TRANSACTION_DATE
, SET_OF_BOOKS_PERIOD
, CREATION_METHOD
, CREATION_METHOD_EXT1
, CREATION_METHOD_EXT2
, CREATION_METHOD_EXT3
, CREATION_METHOD_EXT4
, CREATION_METHOD_EXT5
, FLOW_INDICATOR_CODE
, FLOW_INDICATOR_CODE_EXT1
, FLOW_INDICATOR_CODE_EXT2
, FLOW_INDICATOR_CODE_EXT3
, FLOW_INDICATOR_CODE_EXT4
, FLOW_INDICATOR_CODE_EXT5
, STAT_METHOD
, STAT_METHOD_EXT1
, STAT_METHOD_EXT2
, STAT_METHOD_EXT3
, STAT_METHOD_EXT4
, STAT_METHOD_EXT5
, STAT_TYPE
, STAT_TYPE_EXT1
, STAT_TYPE_EXT2
, STAT_TYPE_EXT3
, STAT_TYPE_EXT4
, STAT_TYPE_EXT5
, TRANSPORT_MODE
, TRANSPORT_MODE_EXT1
, TRANSPORT_MODE_EXT2
, TRANSPORT_MODE_EXT3
, TRANSPORT_MODE_EXT4
, TRANSPORT_MODE_EXT5
, TRANSACTION_NATURE
, TRANSACTION_NATURE_EXT1
, TRANSACTION_NATURE_EXT2
, TRANSACTION_NATURE_EXT3
, TRANSACTION_NATURE_EXT4
, TRANSACTION_NATURE_EXT5
, MOVEMENT_NATURE_CODE
, MOVEMENT_NATURE_CODE_EXT1
, MOVEMENT_NATURE_CODE_EXT2
, MOVEMENT_NATURE_CODE_EXT3
, MOVEMENT_NATURE_CODE_EXT4
, MOVEMENT_NATURE_CODE_EXT5
, ORIGIN_TERRITORY_EU_CODE
, ORIGIN_TERRITORY_CODE
, ORIGIN_TERRITORY_CODE_EXT1
, ORIGIN_TERRITORY_CODE_EXT2
, ORIGIN_TERRITORY_CODE_EXT3
, ORIGIN_TERRITORY_CODE_EXT4
, ORIGIN_TERRITORY_CODE_EXT5
, DESTINATION_TERRITORY_EU_CODE
, DESTINATION_TERRITORY_CODE
, DEST_TERRITORY_CODE_EXT1
, DEST_TERRITORY_CODE_EXT2
, DEST_TERRITORY_CODE_EXT3
, DEST_TERRITORY_CODE_EXT4
, DEST_TERRITORY_CODE_EXT5
, DISPATCH_TERRITORY_EU_CODE
, DISPATCH_TERRITORY_CODE
, DISPATCH_TERRITORY_CODE_EXT1
, DISPATCH_TERRITORY_CODE_EXT2
, DISPATCH_TERRITORY_CODE_EXT3
, DISPATCH_TERRITORY_CODE_EXT4
, DISPATCH_TERRITORY_CODE_EXT5
, TRIANGULATION_COUNTRY_EU_CODE
, TRIANGULATION_COUNTRY_CODE
, TRIANG_COUNTRY_CODE_EXT1
, TRIANG_COUNTRY_CODE_EXT2
, TRIANG_COUNTRY_CODE_EXT3
, TRIANG_COUNTRY_CODE_EXT4
, TRIANG_COUNTRY_CODE_EXT5
, PORT
, PORT_EXT1
, PORT_EXT2
, PORT_EXT3
, PORT_EXT4
, PORT_EXT5
, AREA
, AREA_EXT1
, AREA_EXT2
, AREA_EXT3
, AREA_EXT4
, AREA_EXT5
, MOVEMENT_ID
, MOVEMENT_TYPE
, MOVEMENT_TYPE_EXT1
, MOVEMENT_TYPE_EXT2
, MOVEMENT_TYPE_EXT3
, MOVEMENT_TYPE_EXT4
, MOVEMENT_TYPE_EXT5
, ZONE_CODE
, ECONOMIC_ZONE_EXT1
, ECONOMIC_ZONE_EXT2
, ECONOMIC_ZONE_EXT3
, ECONOMIC_ZONE_EXT4
, ECONOMIC_ZONE_EXT5
, CURRENCY_CODE
, CURRENCY_CODE_EXT1
, CURRENCY_CODE_EXT2
, CURRENCY_CODE_EXT3
, CURRENCY_CODE_EXT4
, CURRENCY_CODE_EXT5
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_TYPE_EXT1
, CURRENCY_CONVERSION_TYPE_EXT2
, CURRENCY_CONVERSION_TYPE_EXT3
, CURRENCY_CONVERSION_TYPE_EXT4
, CURRENCY_CONVERSION_TYPE_EXT5
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, MOVEMENT_AMOUNT
, ITEM_COST
, DOCUMENT_UNIT_PRICE
, DOCUMENT_LINE_EXT_VALUE
, OUTSIDE_CODE
, OUTSIDE_CODE_EXT1
, OUTSIDE_CODE_EXT2
, OUTSIDE_CODE_EXT3
, OUTSIDE_CODE_EXT4
, OUTSIDE_CODE_EXT5
, OUTSIDE_EXT_VALUE
, OUTSIDE_UNIT_PRICE
, STAT_ADJ_AMOUNT
, STAT_ADJ_PERCENT
, STAT_EXT_VALUE
, DELIVERY_TERMS
, DELIVERY_TERMS_EXT1
, DELIVERY_TERMS_EXT2
, DELIVERY_TERMS_EXT3
, DELIVERY_TERMS_EXT4
, DELIVERY_TERMS_EXT5
, PRIMARY_QUANTITY
, TRANSACTION_QUANTITY
, TRANSACTION_UOM_CODE
, TRANSACTION_UOM_CODE_EXT1
, TRANSACTION_UOM_CODE_EXT2
, TRANSACTION_UOM_CODE_EXT3
, TRANSACTION_UOM_CODE_EXT4
, TRANSACTION_UOM_CODE_EXT5
, WEIGHT_METHOD
, WEIGHT_METHOD_EXT1
, WEIGHT_METHOD_EXT2
, WEIGHT_METHOD_EXT3
, WEIGHT_METHOD_EXT4
, WEIGHT_METHOD_EXT5
, UNIT_WEIGHT
, TOTAL_WEIGHT
, TOTAL_WEIGHT_UOM_CODE
, TOTAL_WEIGHT_UOM_CODE_EXT1
, TOTAL_WEIGHT_UOM_CODE_EXT2
, TOTAL_WEIGHT_UOM_CODE_EXT3
, TOTAL_WEIGHT_UOM_CODE_EXT4
, TOTAL_WEIGHT_UOM_CODE_EXT5
, ALTERNATE_QUANTITY
, ALTERNATE_UOM_CODE
, ALTERNATE_UOM_CODE_EXT1
, ALTERNATE_UOM_CODE_EXT2
, ALTERNATE_UOM_CODE_EXT3
, ALTERNATE_UOM_CODE_EXT4
, ALTERNATE_UOM_CODE_EXT5
, COMMODITY_CODE
, COMMODITY_DESCRIPTION
, COMMENTS
, ITEM_DESCRIPTION
, DOCUMENT_SOURCE_TYPE
, DOCUMENT_REFERENCE
, DOCUMENT_LINE_REFERENCE
, TRANSACTING_FROM_ORG
, TRANSACTING_TO_ORG
, DISTRIBUTION_LINE_NUMBER
, AFFILIATION_REFERENCE_CODE
, AFFILIATION_REF_CODE_EXT1
, AFFILIATION_REF_CODE_EXT2
, AFFILIATION_REF_CODE_EXT3
, AFFILIATION_REF_CODE_EXT4
, AFFILIATION_REF_CODE_EXT5
, CONTAINER_TYPE_CODE
, CONTAINER_TYPE_CODE_EXT1
, CONTAINER_TYPE_CODE_EXT2
, CONTAINER_TYPE_CODE_EXT3
, CONTAINER_TYPE_CODE_EXT4
, CONTAINER_TYPE_CODE_EXT5
, CSA_CODE
, CSA_CODE_EXT1
, CSA_CODE_EXT2
, CSA_CODE_EXT3
, CSA_CODE_EXT4
, CSA_CODE_EXT5
, OIL_REFERENCE_CODE
, OIL_REFERENCE_CODE_EXT1
, OIL_REFERENCE_CODE_EXT2
, OIL_REFERENCE_CODE_EXT3
, OIL_REFERENCE_CODE_EXT4
, OIL_REFERENCE_CODE_EXT5
, PICK_SLIP_REFERENCE
, PREFERENCE_CODE
, PREFERENCE_CODE_EXT1
, PREFERENCE_CODE_EXT2
, PREFERENCE_CODE_EXT3
, PREFERENCE_CODE_EXT4
, PREFERENCE_CODE_EXT5
, RECEIPT_REFERENCE
, RECEIPT_REFERENCE_EXT1
, RECEIPT_REFERENCE_EXT2
, RECEIPT_REFERENCE_EXT3
, RECEIPT_REFERENCE_EXT4
, RECEIPT_REFERENCE_EXT5
, SHIPMENT_LINE_REFERENCE
, SHIPMENT_LINE_REFERENCE_EXT1
, SHIPMENT_LINE_REFERENCE_EXT2
, SHIPMENT_LINE_REFERENCE_EXT3
, SHIPMENT_LINE_REFERENCE_EXT4
, SHIPMENT_LINE_REFERENCE_EXT5
, SHIPMENT_REFERENCE
, SHIPMENT_REFERENCE_EXT1
, SHIPMENT_REFERENCE_EXT2
, SHIPMENT_REFERENCE_EXT3
, SHIPMENT_REFERENCE_EXT4
, SHIPMENT_REFERENCE_EXT5
, TARIC_CODE
, TARIC_CODE_EXT1
, TARIC_CODE_EXT2
, TARIC_CODE_EXT3
, TARIC_CODE_EXT4
, TARIC_CODE_EXT5
, INVOICE_BATCH_REFERENCE
, INVOICE_DATE_REFERENCE
, INVOICE_LINE_EXT_VALUE
, INVOICE_LINE_REFERENCE
, INVOICE_QUANTITY
, INVOICE_REFERENCE
, INVOICE_UNIT_PRICE
, INVOICE_BATCH_ID
, INVOICE_ID
, CUSTOMER_LOCATION
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, BILL_TO_NAME
, BILL_TO_NUMBER
, BILL_TO_SITE
, SHIP_TO_NAME
, SHIP_TO_NUMBER
, SHIP_TO_SITE
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID
, VENDOR_NAME
, VENDOR_NUMBER
, VENDOR_SITE
, VENDOR_ID
, VENDOR_SITE_ID
, CATEGORY_ID
, CUSTOMER_TRX_LINE_ID
, FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID
, INVENTORY_ITEM_ID
, MTL_TRANSACTION_ID
, RCV_TRANSACTION_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, ORGANIZATION_ID
, PARENT_MOVEMENT_ID
, PICKING_LINE_DETAIL_ID
, PICKING_LINE_ID
, PO_HEADER_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, ENTITY_ORG_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TRANSACTION_RECORD_ID
, TRANSACTION_HEADER_ID
, RUN_ID
, SECURITY_GROUP_ID
FROM EC.ECE_MVSTO_DETAILS;
EC.ECE_MVSTO_DETAILS does not reference any database object
EC.ECE_MVSTO_DETAILS is referenced by following:
APPS
ECE_MVSTO_DETAILS
|
|
|
|