eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: EC.ECE_MVSTO_HEADERS#

Source

View Text - Preformatted


select COMMUNICATION_METHOD COMMUNICATION_METHOD, TP_TEST_FLAG TP_TEST_FLAG, TP_DOCUMENT_ID TP_DOCUMENT_ID, DOCUMENT_TYPE DOCUMENT_TYPE, TP_DOC_PURPOSE_CODE TP_DOC_PURPOSE_CODE, TP_DOCUMENT_CODE TP_DOCUMENT_CODE, TRANSLATOR_CODE TRANSLATOR_CODE, TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT, TP_DESCRIPTION TP_DESCRIPTION, TP_REFERENCE_EXT1 TP_REFERENCE_EXT1, TP_REFERENCE_EXT2 TP_REFERENCE_EXT2, TRANSACTION_DATE TRANSACTION_DATE, RUN_ID RUN_ID, TRANSACTION_CONTROL1 TRANSACTION_CONTROL1, TRANSACTION_CONTROL2 TRANSACTION_CONTROL2, TRANSACTION_CONTROL3 TRANSACTION_CONTROL3, DOCUMENT_STANDARD DOCUMENT_STANDARD, TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY, TPH_ATTRIBUTE1 TPH_ATTRIBUTE1, TPH_ATTRIBUTE2 TPH_ATTRIBUTE2, TPH_ATTRIBUTE3 TPH_ATTRIBUTE3, TPH_ATTRIBUTE4 TPH_ATTRIBUTE4, TPH_ATTRIBUTE5 TPH_ATTRIBUTE5, TPH_ATTRIBUTE6 TPH_ATTRIBUTE6, TPH_ATTRIBUTE7 TPH_ATTRIBUTE7, TPH_ATTRIBUTE8 TPH_ATTRIBUTE8, TPH_ATTRIBUTE9 TPH_ATTRIBUTE9, TPH_ATTRIBUTE10 TPH_ATTRIBUTE10, TPH_ATTRIBUTE11 TPH_ATTRIBUTE11, TPH_ATTRIBUTE12 TPH_ATTRIBUTE12, TPH_ATTRIBUTE13 TPH_ATTRIBUTE13, TPH_ATTRIBUTE14 TPH_ATTRIBUTE14, TPH_ATTRIBUTE15 TPH_ATTRIBUTE15, TPD_ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY, TPD_ATTRIBUTE1 TPD_ATTRIBUTE1, TPD_ATTRIBUTE2 TPD_ATTRIBUTE2, TPD_ATTRIBUTE3 TPD_ATTRIBUTE3, TPD_ATTRIBUTE4 TPD_ATTRIBUTE4, TPD_ATTRIBUTE5 TPD_ATTRIBUTE5, HEADER_DATA_EXIST_FLAG HEADER_DATA_EXIST_FLAG, PERIOD_NAME PERIOD_NAME, EDI_TRANSACTION_REFERENCE EDI_TRANSACTION_REFERENCE, EDI_TRANSACTION_DATE EDI_TRANSACTION_DATE, MOVEMENT_TYPE MOVEMENT_TYPE, MOVEMENT_TYPE_EXT1 MOVEMENT_TYPE_EXT1, MOVEMENT_TYPE_EXT2 MOVEMENT_TYPE_EXT2, MOVEMENT_TYPE_EXT3 MOVEMENT_TYPE_EXT3, MOVEMENT_TYPE_EXT4 MOVEMENT_TYPE_EXT4, MOVEMENT_TYPE_EXT5 MOVEMENT_TYPE_EXT5, REPORT_REFERENCE REPORT_REFERENCE, REPORT_DATE REPORT_DATE, STAT_TYPE STAT_TYPE, STAT_TYPE_EXT1 STAT_TYPE_EXT1, STAT_TYPE_EXT2 STAT_TYPE_EXT2, STAT_TYPE_EXT3 STAT_TYPE_EXT3, STAT_TYPE_EXT4 STAT_TYPE_EXT4, STAT_TYPE_EXT5 STAT_TYPE_EXT5, USAGE_TYPE USAGE_TYPE, USAGE_TYPE_EXT1 USAGE_TYPE_EXT1, USAGE_TYPE_EXT2 USAGE_TYPE_EXT2, USAGE_TYPE_EXT3 USAGE_TYPE_EXT3, USAGE_TYPE_EXT4 USAGE_TYPE_EXT4, USAGE_TYPE_EXT5 USAGE_TYPE_EXT5, MOVEMENT_STATUS MOVEMENT_STATUS, MOVEMENT_STATUS_EXT1 MOVEMENT_STATUS_EXT1, MOVEMENT_STATUS_EXT2 MOVEMENT_STATUS_EXT2, MOVEMENT_STATUS_EXT3 MOVEMENT_STATUS_EXT3, MOVEMENT_STATUS_EXT4 MOVEMENT_STATUS_EXT4, MOVEMENT_STATUS_EXT5 MOVEMENT_STATUS_EXT5, ZONE_CODE ZONE_CODE, ECONOMIC_ZONE_EXT1 ECONOMIC_ZONE_EXT1, ECONOMIC_ZONE_EXT2 ECONOMIC_ZONE_EXT2, ECONOMIC_ZONE_EXT3 ECONOMIC_ZONE_EXT3, ECONOMIC_ZONE_EXT4 ECONOMIC_ZONE_EXT4, ECONOMIC_ZONE_EXT5 ECONOMIC_ZONE_EXT5, LEGAL_ENTITY LEGAL_ENTITY, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, LEGAL_ENTITY_VAT_CODE LEGAL_ENTITY_VAT_CODE, LEGAL_ENTITY_TAX_NAME LEGAL_ENTITY_TAX_NAME, ORGANIZATION_ID ORGANIZATION_ID, LEGAL_ENTITY_CODE_INT LEGAL_ENTITY_CODE_INT, ECE_TP_LOC_CODE ECE_TP_LOC_CODE, LEGAL_ENTITY_CUSTOMER_NAME LEGAL_ENTITY_CUSTOMER_NAME, LEGAL_ENTITY_ADDRESS1 LEGAL_ENTITY_ADDRESS1, LEGAL_ENTITY_ADDRESS2 LEGAL_ENTITY_ADDRESS2, LEGAL_ENTITY_ADDRESS3 LEGAL_ENTITY_ADDRESS3, LEGAL_ENTITY_CITY LEGAL_ENTITY_CITY, LEGAL_ENTITY_POSTAL_CODE LEGAL_ENTITY_POSTAL_CODE, LEGAL_ENTITY_COUNTRY_INT LEGAL_ENTITY_COUNTRY_INT, LEGAL_ENTITY_COUNTRY_EXT1 LEGAL_ENTITY_COUNTRY_EXT1, LEGAL_ENTITY_REGION1_INT LEGAL_ENTITY_REGION1_INT, LEGAL_ENTITY_REGION1_EXT1 LEGAL_ENTITY_REGION1_EXT1, LEGAL_ENTITY_REGION2_INT LEGAL_ENTITY_REGION2_INT, LEGAL_ENTITY_REGION2_EXT1 LEGAL_ENTITY_REGION2_EXT1, LEGAL_ENTITY_REGION3_INT LEGAL_ENTITY_REGION3_INT, LEGAL_ENTITY_REGION3_EXT1 LEGAL_ENTITY_REGION3_EXT1, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ENTITY_ORG_ID ENTITY_ORG_ID, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, TOTAL_INVOICE_EXT_VALUE TOTAL_INVOICE_EXT_VALUE, TOTAL_SUPPLEMENTARY_UNITS TOTAL_SUPPLEMENTARY_UNITS, TOTAL_STATISTICAL_VALUE TOTAL_STATISTICAL_VALUE, TOTAL_TOTAL_WEIGHT TOTAL_TOTAL_WEIGHT, TOTAL_RECORDS TOTAL_RECORDS, MAP_ID MAP_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "EC"."ECE_MVSTO_HEADERS"

View Text - HTML Formatted

SELECT COMMUNICATION_METHOD COMMUNICATION_METHOD
, TP_TEST_FLAG TP_TEST_FLAG
, TP_DOCUMENT_ID TP_DOCUMENT_ID
, DOCUMENT_TYPE DOCUMENT_TYPE
, TP_DOC_PURPOSE_CODE TP_DOC_PURPOSE_CODE
, TP_DOCUMENT_CODE TP_DOCUMENT_CODE
, TRANSLATOR_CODE TRANSLATOR_CODE
, TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, TP_DESCRIPTION TP_DESCRIPTION
, TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, TRANSACTION_DATE TRANSACTION_DATE
, RUN_ID RUN_ID
, TRANSACTION_CONTROL1 TRANSACTION_CONTROL1
, TRANSACTION_CONTROL2 TRANSACTION_CONTROL2
, TRANSACTION_CONTROL3 TRANSACTION_CONTROL3
, DOCUMENT_STANDARD DOCUMENT_STANDARD
, TPH_ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1 TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2 TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3 TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4 TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5 TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6 TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7 TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8 TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9 TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10 TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11 TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12 TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13 TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14 TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15 TPH_ATTRIBUTE15
, TPD_ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY
, TPD_ATTRIBUTE1 TPD_ATTRIBUTE1
, TPD_ATTRIBUTE2 TPD_ATTRIBUTE2
, TPD_ATTRIBUTE3 TPD_ATTRIBUTE3
, TPD_ATTRIBUTE4 TPD_ATTRIBUTE4
, TPD_ATTRIBUTE5 TPD_ATTRIBUTE5
, HEADER_DATA_EXIST_FLAG HEADER_DATA_EXIST_FLAG
, PERIOD_NAME PERIOD_NAME
, EDI_TRANSACTION_REFERENCE EDI_TRANSACTION_REFERENCE
, EDI_TRANSACTION_DATE EDI_TRANSACTION_DATE
, MOVEMENT_TYPE MOVEMENT_TYPE
, MOVEMENT_TYPE_EXT1 MOVEMENT_TYPE_EXT1
, MOVEMENT_TYPE_EXT2 MOVEMENT_TYPE_EXT2
, MOVEMENT_TYPE_EXT3 MOVEMENT_TYPE_EXT3
, MOVEMENT_TYPE_EXT4 MOVEMENT_TYPE_EXT4
, MOVEMENT_TYPE_EXT5 MOVEMENT_TYPE_EXT5
, REPORT_REFERENCE REPORT_REFERENCE
, REPORT_DATE REPORT_DATE
, STAT_TYPE STAT_TYPE
, STAT_TYPE_EXT1 STAT_TYPE_EXT1
, STAT_TYPE_EXT2 STAT_TYPE_EXT2
, STAT_TYPE_EXT3 STAT_TYPE_EXT3
, STAT_TYPE_EXT4 STAT_TYPE_EXT4
, STAT_TYPE_EXT5 STAT_TYPE_EXT5
, USAGE_TYPE USAGE_TYPE
, USAGE_TYPE_EXT1 USAGE_TYPE_EXT1
, USAGE_TYPE_EXT2 USAGE_TYPE_EXT2
, USAGE_TYPE_EXT3 USAGE_TYPE_EXT3
, USAGE_TYPE_EXT4 USAGE_TYPE_EXT4
, USAGE_TYPE_EXT5 USAGE_TYPE_EXT5
, MOVEMENT_STATUS MOVEMENT_STATUS
, MOVEMENT_STATUS_EXT1 MOVEMENT_STATUS_EXT1
, MOVEMENT_STATUS_EXT2 MOVEMENT_STATUS_EXT2
, MOVEMENT_STATUS_EXT3 MOVEMENT_STATUS_EXT3
, MOVEMENT_STATUS_EXT4 MOVEMENT_STATUS_EXT4
, MOVEMENT_STATUS_EXT5 MOVEMENT_STATUS_EXT5
, ZONE_CODE ZONE_CODE
, ECONOMIC_ZONE_EXT1 ECONOMIC_ZONE_EXT1
, ECONOMIC_ZONE_EXT2 ECONOMIC_ZONE_EXT2
, ECONOMIC_ZONE_EXT3 ECONOMIC_ZONE_EXT3
, ECONOMIC_ZONE_EXT4 ECONOMIC_ZONE_EXT4
, ECONOMIC_ZONE_EXT5 ECONOMIC_ZONE_EXT5
, LEGAL_ENTITY LEGAL_ENTITY
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, LEGAL_ENTITY_VAT_CODE LEGAL_ENTITY_VAT_CODE
, LEGAL_ENTITY_TAX_NAME LEGAL_ENTITY_TAX_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, LEGAL_ENTITY_CODE_INT LEGAL_ENTITY_CODE_INT
, ECE_TP_LOC_CODE ECE_TP_LOC_CODE
, LEGAL_ENTITY_CUSTOMER_NAME LEGAL_ENTITY_CUSTOMER_NAME
, LEGAL_ENTITY_ADDRESS1 LEGAL_ENTITY_ADDRESS1
, LEGAL_ENTITY_ADDRESS2 LEGAL_ENTITY_ADDRESS2
, LEGAL_ENTITY_ADDRESS3 LEGAL_ENTITY_ADDRESS3
, LEGAL_ENTITY_CITY LEGAL_ENTITY_CITY
, LEGAL_ENTITY_POSTAL_CODE LEGAL_ENTITY_POSTAL_CODE
, LEGAL_ENTITY_COUNTRY_INT LEGAL_ENTITY_COUNTRY_INT
, LEGAL_ENTITY_COUNTRY_EXT1 LEGAL_ENTITY_COUNTRY_EXT1
, LEGAL_ENTITY_REGION1_INT LEGAL_ENTITY_REGION1_INT
, LEGAL_ENTITY_REGION1_EXT1 LEGAL_ENTITY_REGION1_EXT1
, LEGAL_ENTITY_REGION2_INT LEGAL_ENTITY_REGION2_INT
, LEGAL_ENTITY_REGION2_EXT1 LEGAL_ENTITY_REGION2_EXT1
, LEGAL_ENTITY_REGION3_INT LEGAL_ENTITY_REGION3_INT
, LEGAL_ENTITY_REGION3_EXT1 LEGAL_ENTITY_REGION3_EXT1
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ENTITY_ORG_ID ENTITY_ORG_ID
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, TOTAL_INVOICE_EXT_VALUE TOTAL_INVOICE_EXT_VALUE
, TOTAL_SUPPLEMENTARY_UNITS TOTAL_SUPPLEMENTARY_UNITS
, TOTAL_STATISTICAL_VALUE TOTAL_STATISTICAL_VALUE
, TOTAL_TOTAL_WEIGHT TOTAL_TOTAL_WEIGHT
, TOTAL_RECORDS TOTAL_RECORDS
, MAP_ID MAP_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "EC"."ECE_MVSTO_HEADERS"