[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_MVSTO_HEADERS |
|---|---|
| Object Type: | TABLE |
| Owner: | EC |
| FND Design Data: |  EC.ECE_MVSTO_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
ECE_MVSTO_HEADERS contains movement statistics header
data to support the outbound Movement Statistics transaction.
ECE_MVSTO_HEADERS is based primarily on data stored in
MTL_MOVEMENT_STATISTICS from Oracle Inventory. It contains
statistical data related to material movements and gives the
ability to track movement of goods regardless of countries
involved.
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_HEADERS table to its corresponding extension
table ECE_MVSTO_HEADERS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ECE_MVSTO_HEADERS_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 TRANSACTION_RECORD_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COMMUNICATION_METHOD | VARCHAR2 | (30) | Communication Method | |
| TP_TEST_FLAG | VARCHAR2 | (1) | Test Indicator | |
| TP_DOCUMENT_ID | VARCHAR2 | (6) | Document ID | |
| DOCUMENT_TYPE | VARCHAR2 | (25) | Document Type | |
| TP_DOC_PURPOSE_CODE | VARCHAR2 | (2) | Document Purpose Code | |
| TP_DOCUMENT_CODE | VARCHAR2 | (20) | Document Code | |
| TRANSLATOR_CODE | VARCHAR2 | (30) | Trading Partner Translator Code | |
| TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | Trading Partner Location Code | |
| TP_DESCRIPTION | VARCHAR2 | (240) | Trading Partner Description | |
| TP_REFERENCE_EXT1 | VARCHAR2 | (240) | Trading Partner Reference 1 | |
| TP_REFERENCE_EXT2 | VARCHAR2 | (240) | Trading Partner Reference 2 | |
| TRANSACTION_DATE | DATE | Transaction Date/Time | ||
| RUN_ID | NUMBER | Transaction Run ID | ||
| TRANSACTION_CONTROL1 | VARCHAR2 | (10) | Transaction Control 1 | |
| TRANSACTION_CONTROL2 | VARCHAR2 | (10) | Transaction Control 2 | |
| TRANSACTION_CONTROL3 | VARCHAR2 | (10) | Transaction Control 3 | |
| DOCUMENT_STANDARD | VARCHAR2 | (10) | Document Standard | |
| TPH_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Trading Partner Header Flexfield Context | |
| TPH_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Header Flexfield 1 | |
| TPH_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Header Flexfield 2 | |
| TPH_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Header Flexfield 3 | |
| TPH_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Header Flexfield 4 | |
| TPH_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Header Flexfield 5 | |
| TPH_ATTRIBUTE6 | VARCHAR2 | (150) | Trading Partner Header Flexfield 6 | |
| TPH_ATTRIBUTE7 | VARCHAR2 | (150) | Trading Partner Header Flexfield 7 | |
| TPH_ATTRIBUTE8 | VARCHAR2 | (150) | Trading Partner Header Flexfield 8 | |
| TPH_ATTRIBUTE9 | VARCHAR2 | (150) | Trading Partner Header Flexfield 9 | |
| TPH_ATTRIBUTE10 | VARCHAR2 | (150) | Trading Partner Header Flexfield 10 | |
| TPH_ATTRIBUTE11 | VARCHAR2 | (150) | Trading Partner Header Flexfield 11 | |
| TPH_ATTRIBUTE12 | VARCHAR2 | (150) | Trading Partner Header Flexfield 12 | |
| TPH_ATTRIBUTE13 | VARCHAR2 | (150) | Trading Partner Header Flexfield 13 | |
| TPH_ATTRIBUTE14 | VARCHAR2 | (150) | Trading Partner Header Flexfield 14 | |
| TPH_ATTRIBUTE15 | VARCHAR2 | (150) | Trading Partner Header Flexfield 15 | |
| TPD_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Trading Partner Detail Flexfield Context | |
| TPD_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 1 | |
| TPD_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 2 | |
| TPD_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 3 | |
| TPD_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 4 | |
| TPD_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Detail Flexfield 5 | |
| HEADER_DATA_EXIST_FLAG | VARCHAR2 | (1) | Header Data Exist Flag | |
| PERIOD_NAME | VARCHAR2 | (15) | Period Name | |
| EDI_TRANSACTION_REFERENCE | VARCHAR2 | (35) | EDI Transaction Reference | |
| EDI_TRANSACTION_DATE | DATE | EDI Transaction Date | ||
| MOVEMENT_TYPE | VARCHAR2 | (30) | Movement Type (Internal) | |
| 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) | |
| REPORT_REFERENCE | VARCHAR2 | (35) | Report Reference | |
| REPORT_DATE | DATE | Report Date | ||
| 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) | |
| USAGE_TYPE | VARCHAR2 | (30) | Usage Type (Internal) | |
| USAGE_TYPE_EXT1 | VARCHAR2 | (30) | Usage Type 1 (Ext) | |
| USAGE_TYPE_EXT2 | VARCHAR2 | (30) | Usage Type 2 (Ext) | |
| USAGE_TYPE_EXT3 | VARCHAR2 | (30) | Usage Type 3 (Ext) | |
| USAGE_TYPE_EXT4 | VARCHAR2 | (30) | Usage Type 4 (Ext) | |
| USAGE_TYPE_EXT5 | VARCHAR2 | (30) | Usage Type 5 (Ext) | |
| MOVEMENT_STATUS | VARCHAR2 | (30) | Movement Status (Internal) | |
| MOVEMENT_STATUS_EXT1 | VARCHAR2 | (30) | Movement Status 1 (Ext) | |
| MOVEMENT_STATUS_EXT2 | VARCHAR2 | (30) | Movement Status 2 (Ext) | |
| MOVEMENT_STATUS_EXT3 | VARCHAR2 | (30) | Movement Status 3 (Ext) | |
| MOVEMENT_STATUS_EXT4 | VARCHAR2 | (30) | Movement Status 4 (Ext) | |
| MOVEMENT_STATUS_EXT5 | VARCHAR2 | (30) | Movement Status 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) | |
| LEGAL_ENTITY | NUMBER | Legal Entity | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | (60) | Legal Entity Name | |
| LEGAL_ENTITY_VAT_CODE | VARCHAR2 | (150) | Legal Entity VAT Code | |
| LEGAL_ENTITY_TAX_NAME | VARCHAR2 | (15) | Legal Entity Tax Name | |
| ORGANIZATION_ID | NUMBER | Organization ID | ||
| LEGAL_ENTITY_CODE_INT | NUMBER | Legal Entity Code (Internal) | ||
| ECE_TP_LOC_CODE | VARCHAR2 | (35) | Legal Entity Code (Ext) | |
| LEGAL_ENTITY_CUSTOMER_NAME | VARCHAR2 | (50) | Legal Entity Customer Name | |
| LEGAL_ENTITY_ADDRESS1 | VARCHAR2 | (60) | Legal Entity Address 1 | |
| LEGAL_ENTITY_ADDRESS2 | VARCHAR2 | (60) | Legal Entity Address 2 | |
| LEGAL_ENTITY_ADDRESS3 | VARCHAR2 | (60) | Legal Entity Address 3 | |
| LEGAL_ENTITY_CITY | VARCHAR2 | (30) | Legal Entity City | |
| LEGAL_ENTITY_POSTAL_CODE | VARCHAR2 | (30) | Legal Entity Postal Code | |
| LEGAL_ENTITY_COUNTRY_INT | VARCHAR2 | (20) | Legal Entity Country (Internal) | |
| LEGAL_ENTITY_COUNTRY_EXT1 | VARCHAR2 | (80) | Legal Entity Country (Ext) | |
| LEGAL_ENTITY_REGION1_INT | VARCHAR2 | (60) | Legal Entity Region 1 (Internal) | |
| LEGAL_ENTITY_REGION1_EXT1 | VARCHAR2 | (80) | Legal Entity Region 1 (Ext) | |
| LEGAL_ENTITY_REGION2_INT | VARCHAR2 | (60) | Legal Entity Region 2 (Internal) | |
| LEGAL_ENTITY_REGION2_EXT1 | VARCHAR2 | (80) | Legal Entity Region 2 (Ext) | |
| LEGAL_ENTITY_REGION3_INT | VARCHAR2 | (60) | Legal Entity Region 3 (Internal) | |
| LEGAL_ENTITY_REGION3_EXT1 | VARCHAR2 | (80) | Legal Entity Region 3 (Ext) | |
| LEGAL_ENTITY_ID | NUMBER | Legal Entity ID | ||
| ENTITY_ORG_ID | NUMBER | Entity Organization ID | ||
| TRANSACTION_RECORD_ID | NUMBER | Yes | Transaction Record ID | |
| TOTAL_INVOICE_EXT_VALUE | NUMBER | Total Invoice External Value | ||
| TOTAL_SUPPLEMENTARY_UNITS | NUMBER | Total Supplementary Units | ||
| TOTAL_STATISTICAL_VALUE | NUMBER | Total Statistical Value | ||
| TOTAL_TOTAL_WEIGHT | NUMBER | Total Weight | ||
| TOTAL_RECORDS | NUMBER | Total Records | ||
| MAP_ID | NUMBER | Map ID | ||
| SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT COMMUNICATION_METHOD
, TP_TEST_FLAG
, TP_DOCUMENT_ID
, DOCUMENT_TYPE
, TP_DOC_PURPOSE_CODE
, TP_DOCUMENT_CODE
, TRANSLATOR_CODE
, TP_LOCATION_CODE_EXT
, TP_DESCRIPTION
, TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2
, TRANSACTION_DATE
, RUN_ID
, TRANSACTION_CONTROL1
, TRANSACTION_CONTROL2
, TRANSACTION_CONTROL3
, DOCUMENT_STANDARD
, TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15
, TPD_ATTRIBUTE_CATEGORY
, TPD_ATTRIBUTE1
, TPD_ATTRIBUTE2
, TPD_ATTRIBUTE3
, TPD_ATTRIBUTE4
, TPD_ATTRIBUTE5
, HEADER_DATA_EXIST_FLAG
, PERIOD_NAME
, EDI_TRANSACTION_REFERENCE
, EDI_TRANSACTION_DATE
, MOVEMENT_TYPE
, MOVEMENT_TYPE_EXT1
, MOVEMENT_TYPE_EXT2
, MOVEMENT_TYPE_EXT3
, MOVEMENT_TYPE_EXT4
, MOVEMENT_TYPE_EXT5
, REPORT_REFERENCE
, REPORT_DATE
, STAT_TYPE
, STAT_TYPE_EXT1
, STAT_TYPE_EXT2
, STAT_TYPE_EXT3
, STAT_TYPE_EXT4
, STAT_TYPE_EXT5
, USAGE_TYPE
, USAGE_TYPE_EXT1
, USAGE_TYPE_EXT2
, USAGE_TYPE_EXT3
, USAGE_TYPE_EXT4
, USAGE_TYPE_EXT5
, MOVEMENT_STATUS
, MOVEMENT_STATUS_EXT1
, MOVEMENT_STATUS_EXT2
, MOVEMENT_STATUS_EXT3
, MOVEMENT_STATUS_EXT4
, MOVEMENT_STATUS_EXT5
, ZONE_CODE
, ECONOMIC_ZONE_EXT1
, ECONOMIC_ZONE_EXT2
, ECONOMIC_ZONE_EXT3
, ECONOMIC_ZONE_EXT4
, ECONOMIC_ZONE_EXT5
, LEGAL_ENTITY
, LEGAL_ENTITY_NAME
, LEGAL_ENTITY_VAT_CODE
, LEGAL_ENTITY_TAX_NAME
, ORGANIZATION_ID
, LEGAL_ENTITY_CODE_INT
, ECE_TP_LOC_CODE
, LEGAL_ENTITY_CUSTOMER_NAME
, LEGAL_ENTITY_ADDRESS1
, LEGAL_ENTITY_ADDRESS2
, LEGAL_ENTITY_ADDRESS3
, LEGAL_ENTITY_CITY
, LEGAL_ENTITY_POSTAL_CODE
, LEGAL_ENTITY_COUNTRY_INT
, LEGAL_ENTITY_COUNTRY_EXT1
, LEGAL_ENTITY_REGION1_INT
, LEGAL_ENTITY_REGION1_EXT1
, LEGAL_ENTITY_REGION2_INT
, LEGAL_ENTITY_REGION2_EXT1
, LEGAL_ENTITY_REGION3_INT
, LEGAL_ENTITY_REGION3_EXT1
, LEGAL_ENTITY_ID
, ENTITY_ORG_ID
, TRANSACTION_RECORD_ID
, TOTAL_INVOICE_EXT_VALUE
, TOTAL_SUPPLEMENTARY_UNITS
, TOTAL_STATISTICAL_VALUE
, TOTAL_TOTAL_WEIGHT
, TOTAL_RECORDS
, MAP_ID
, SECURITY_GROUP_ID
FROM EC.ECE_MVSTO_HEADERS;
EC.ECE_MVSTO_HEADERS does not reference any database object
EC.ECE_MVSTO_HEADERS is referenced by following:
APPS
ECE_MVSTO_HEADERS
|
|
|
|