DBA Data[Home] [Help] [Dependency Information]


TABLE: EC.ECE_MVSTO_DETAILS

Object Details
Object Name: ECE_MVSTO_DETAILS
Object Type: TABLE
Owner: EC
FND Design Data: TableEC.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.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ECE_MVSTO_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnMOVEMENT_ID
ECE_MVSTO_DETAILS_U2 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRANSACTION_RECORD_ID
ColumnTRANSACTION_HEADER_ID
Columns
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

Query Text

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;

Dependencies

[top of page]

EC.ECE_MVSTO_DETAILS does not reference any database object

EC.ECE_MVSTO_DETAILS is referenced by following:

SchemaAPPS
SynonymECE_MVSTO_DETAILS