Skip to content

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

VIEW: EC.ECE_MVSTO_HEADERS#

Object Details
Object Name: ECE_MVSTO_HEADERS#
Object Type: VIEW
Owner: EC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMMUNICATION_METHOD VARCHAR2 (30)
TP_TEST_FLAG VARCHAR2 (1)
TP_DOCUMENT_ID VARCHAR2 (6)
DOCUMENT_TYPE VARCHAR2 (25)
TP_DOC_PURPOSE_CODE VARCHAR2 (2)
TP_DOCUMENT_CODE VARCHAR2 (20)
TRANSLATOR_CODE VARCHAR2 (30)
TP_LOCATION_CODE_EXT VARCHAR2 (35)
TP_DESCRIPTION VARCHAR2 (240)
TP_REFERENCE_EXT1 VARCHAR2 (240)
TP_REFERENCE_EXT2 VARCHAR2 (240)
TRANSACTION_DATE DATE

RUN_ID NUMBER

TRANSACTION_CONTROL1 VARCHAR2 (10)
TRANSACTION_CONTROL2 VARCHAR2 (10)
TRANSACTION_CONTROL3 VARCHAR2 (10)
DOCUMENT_STANDARD VARCHAR2 (10)
TPH_ATTRIBUTE_CATEGORY VARCHAR2 (150)
TPH_ATTRIBUTE1 VARCHAR2 (150)
TPH_ATTRIBUTE2 VARCHAR2 (150)
TPH_ATTRIBUTE3 VARCHAR2 (150)
TPH_ATTRIBUTE4 VARCHAR2 (150)
TPH_ATTRIBUTE5 VARCHAR2 (150)
TPH_ATTRIBUTE6 VARCHAR2 (150)
TPH_ATTRIBUTE7 VARCHAR2 (150)
TPH_ATTRIBUTE8 VARCHAR2 (150)
TPH_ATTRIBUTE9 VARCHAR2 (150)
TPH_ATTRIBUTE10 VARCHAR2 (150)
TPH_ATTRIBUTE11 VARCHAR2 (150)
TPH_ATTRIBUTE12 VARCHAR2 (150)
TPH_ATTRIBUTE13 VARCHAR2 (150)
TPH_ATTRIBUTE14 VARCHAR2 (150)
TPH_ATTRIBUTE15 VARCHAR2 (150)
TPD_ATTRIBUTE_CATEGORY VARCHAR2 (150)
TPD_ATTRIBUTE1 VARCHAR2 (150)
TPD_ATTRIBUTE2 VARCHAR2 (150)
TPD_ATTRIBUTE3 VARCHAR2 (150)
TPD_ATTRIBUTE4 VARCHAR2 (150)
TPD_ATTRIBUTE5 VARCHAR2 (150)
HEADER_DATA_EXIST_FLAG VARCHAR2 (1)
PERIOD_NAME VARCHAR2 (15)
EDI_TRANSACTION_REFERENCE VARCHAR2 (35)
EDI_TRANSACTION_DATE DATE

MOVEMENT_TYPE VARCHAR2 (30)
MOVEMENT_TYPE_EXT1 VARCHAR2 (30)
MOVEMENT_TYPE_EXT2 VARCHAR2 (30)
MOVEMENT_TYPE_EXT3 VARCHAR2 (30)
MOVEMENT_TYPE_EXT4 VARCHAR2 (30)
MOVEMENT_TYPE_EXT5 VARCHAR2 (30)
REPORT_REFERENCE VARCHAR2 (35)
REPORT_DATE DATE

STAT_TYPE VARCHAR2 (30)
STAT_TYPE_EXT1 VARCHAR2 (30)
STAT_TYPE_EXT2 VARCHAR2 (30)
STAT_TYPE_EXT3 VARCHAR2 (30)
STAT_TYPE_EXT4 VARCHAR2 (30)
STAT_TYPE_EXT5 VARCHAR2 (30)
USAGE_TYPE VARCHAR2 (30)
USAGE_TYPE_EXT1 VARCHAR2 (30)
USAGE_TYPE_EXT2 VARCHAR2 (30)
USAGE_TYPE_EXT3 VARCHAR2 (30)
USAGE_TYPE_EXT4 VARCHAR2 (30)
USAGE_TYPE_EXT5 VARCHAR2 (30)
MOVEMENT_STATUS VARCHAR2 (30)
MOVEMENT_STATUS_EXT1 VARCHAR2 (30)
MOVEMENT_STATUS_EXT2 VARCHAR2 (30)
MOVEMENT_STATUS_EXT3 VARCHAR2 (30)
MOVEMENT_STATUS_EXT4 VARCHAR2 (30)
MOVEMENT_STATUS_EXT5 VARCHAR2 (30)
ZONE_CODE VARCHAR2 (10)
ECONOMIC_ZONE_EXT1 VARCHAR2 (10)
ECONOMIC_ZONE_EXT2 VARCHAR2 (30)
ECONOMIC_ZONE_EXT3 VARCHAR2 (30)
ECONOMIC_ZONE_EXT4 VARCHAR2 (30)
ECONOMIC_ZONE_EXT5 VARCHAR2 (30)
ORGANIZATION_ID NUMBER

ECE_TP_LOC_CODE VARCHAR2 (35)
ENTITY_ORG_ID NUMBER

TRANSACTION_RECORD_ID NUMBER
Yes
TOTAL_INVOICE_EXT_VALUE NUMBER

TOTAL_SUPPLEMENTARY_UNITS NUMBER

TOTAL_STATISTICAL_VALUE NUMBER

TOTAL_TOTAL_WEIGHT NUMBER

TOTAL_RECORDS NUMBER

MAP_ID NUMBER

SECURITY_GROUP_ID NUMBER

Query Text

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#;

Dependencies

[top of page]

EC.ECE_MVSTO_HEADERS# references the following:

SchemaEC
TableECE_MVSTO_HEADERS
EC.ECE_MVSTO_HEADERS# is referenced by following:

SchemaAPPS
SynonymECE_MVSTO_HEADERS