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

Source

View Text - Preformatted


select COMMUNICATION_METHOD COMMUNICATION_METHOD, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, RUN_ID RUN_ID, EQUIPMENT_PREFIX EQUIPMENT_PREFIX, EQUIPMENT_NUMBER EQUIPMENT_NUMBER, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS, PACKING_SLIP_NUMBER PACKING_SLIP_NUMBER, INTERFACE_ATTRIBUTE_CATEGORY INTERFACE_ATTRIBUTE_CATEGORY, INTERFACE_ATTRIBUTE1 INTERFACE_ATTRIBUTE1, INTERFACE_ATTRIBUTE2 INTERFACE_ATTRIBUTE2, INTERFACE_ATTRIBUTE3 INTERFACE_ATTRIBUTE3, INTERFACE_ATTRIBUTE4 INTERFACE_ATTRIBUTE4, INTERFACE_ATTRIBUTE5 INTERFACE_ATTRIBUTE5, INTERFACE_ATTRIBUTE6 INTERFACE_ATTRIBUTE6, INTERFACE_ATTRIBUTE7 INTERFACE_ATTRIBUTE7, INTERFACE_ATTRIBUTE8 INTERFACE_ATTRIBUTE8, INTERFACE_ATTRIBUTE9 INTERFACE_ATTRIBUTE9, INTERFACE_ATTRIBUTE10 INTERFACE_ATTRIBUTE10, INTERFACE_ATTRIBUTE11 INTERFACE_ATTRIBUTE11, INTERFACE_ATTRIBUTE12 INTERFACE_ATTRIBUTE12, INTERFACE_ATTRIBUTE13 INTERFACE_ATTRIBUTE13, INTERFACE_ATTRIBUTE14 INTERFACE_ATTRIBUTE14, INTERFACE_ATTRIBUTE15 INTERFACE_ATTRIBUTE15, TRANSACTION_ATTRIBUTE_CATEGORY TRANSACTION_ATTRIBUTE_CATEGORY, TRANSACTION_ATTRIBUTE1 TRANSACTION_ATTRIBUTE1, TRANSACTION_ATTRIBUTE2 TRANSACTION_ATTRIBUTE2, TRANSACTION_ATTRIBUTE3 TRANSACTION_ATTRIBUTE3, TRANSACTION_ATTRIBUTE4 TRANSACTION_ATTRIBUTE4, TRANSACTION_ATTRIBUTE5 TRANSACTION_ATTRIBUTE5, TRANSACTION_ATTRIBUTE6 TRANSACTION_ATTRIBUTE6, TRANSACTION_ATTRIBUTE7 TRANSACTION_ATTRIBUTE7, TRANSACTION_ATTRIBUTE8 TRANSACTION_ATTRIBUTE8, TRANSACTION_ATTRIBUTE9 TRANSACTION_ATTRIBUTE9, TRANSACTION_ATTRIBUTE10 TRANSACTION_ATTRIBUTE10, TRANSACTION_ATTRIBUTE11 TRANSACTION_ATTRIBUTE11, TRANSACTION_ATTRIBUTE12 TRANSACTION_ATTRIBUTE12, TRANSACTION_ATTRIBUTE13 TRANSACTION_ATTRIBUTE13, TRANSACTION_ATTRIBUTE14 TRANSACTION_ATTRIBUTE14, TRANSACTION_ATTRIBUTE15 TRANSACTION_ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SHIP_FROM_CODE_INT SHIP_FROM_CODE_INT, SHIP_FROM_CODE_EXT SHIP_FROM_CODE_EXT, DELIVERY_ID DELIVERY_ID, SHIP_FROM_CODE_EXT1 SHIP_FROM_CODE_EXT1, SHIP_FROM_CODE_EXT2 SHIP_FROM_CODE_EXT2, SHIP_FROM_CODE_EXT3 SHIP_FROM_CODE_EXT3, SHIP_FROM_CODE_EXT4 SHIP_FROM_CODE_EXT4, SHIP_FROM_CODE_EXT5 SHIP_FROM_CODE_EXT5, SHIP_FROM_CODE_INT_1 SHIP_FROM_CODE_INT_1 from "EC"."ECE_AR_TRX_HEADER_1"

View Text - HTML Formatted

SELECT COMMUNICATION_METHOD COMMUNICATION_METHOD
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, RUN_ID RUN_ID
, EQUIPMENT_PREFIX EQUIPMENT_PREFIX
, EQUIPMENT_NUMBER EQUIPMENT_NUMBER
, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS
, PACKING_SLIP_NUMBER PACKING_SLIP_NUMBER
, INTERFACE_ATTRIBUTE_CATEGORY INTERFACE_ATTRIBUTE_CATEGORY
, INTERFACE_ATTRIBUTE1 INTERFACE_ATTRIBUTE1
, INTERFACE_ATTRIBUTE2 INTERFACE_ATTRIBUTE2
, INTERFACE_ATTRIBUTE3 INTERFACE_ATTRIBUTE3
, INTERFACE_ATTRIBUTE4 INTERFACE_ATTRIBUTE4
, INTERFACE_ATTRIBUTE5 INTERFACE_ATTRIBUTE5
, INTERFACE_ATTRIBUTE6 INTERFACE_ATTRIBUTE6
, INTERFACE_ATTRIBUTE7 INTERFACE_ATTRIBUTE7
, INTERFACE_ATTRIBUTE8 INTERFACE_ATTRIBUTE8
, INTERFACE_ATTRIBUTE9 INTERFACE_ATTRIBUTE9
, INTERFACE_ATTRIBUTE10 INTERFACE_ATTRIBUTE10
, INTERFACE_ATTRIBUTE11 INTERFACE_ATTRIBUTE11
, INTERFACE_ATTRIBUTE12 INTERFACE_ATTRIBUTE12
, INTERFACE_ATTRIBUTE13 INTERFACE_ATTRIBUTE13
, INTERFACE_ATTRIBUTE14 INTERFACE_ATTRIBUTE14
, INTERFACE_ATTRIBUTE15 INTERFACE_ATTRIBUTE15
, TRANSACTION_ATTRIBUTE_CATEGORY TRANSACTION_ATTRIBUTE_CATEGORY
, TRANSACTION_ATTRIBUTE1 TRANSACTION_ATTRIBUTE1
, TRANSACTION_ATTRIBUTE2 TRANSACTION_ATTRIBUTE2
, TRANSACTION_ATTRIBUTE3 TRANSACTION_ATTRIBUTE3
, TRANSACTION_ATTRIBUTE4 TRANSACTION_ATTRIBUTE4
, TRANSACTION_ATTRIBUTE5 TRANSACTION_ATTRIBUTE5
, TRANSACTION_ATTRIBUTE6 TRANSACTION_ATTRIBUTE6
, TRANSACTION_ATTRIBUTE7 TRANSACTION_ATTRIBUTE7
, TRANSACTION_ATTRIBUTE8 TRANSACTION_ATTRIBUTE8
, TRANSACTION_ATTRIBUTE9 TRANSACTION_ATTRIBUTE9
, TRANSACTION_ATTRIBUTE10 TRANSACTION_ATTRIBUTE10
, TRANSACTION_ATTRIBUTE11 TRANSACTION_ATTRIBUTE11
, TRANSACTION_ATTRIBUTE12 TRANSACTION_ATTRIBUTE12
, TRANSACTION_ATTRIBUTE13 TRANSACTION_ATTRIBUTE13
, TRANSACTION_ATTRIBUTE14 TRANSACTION_ATTRIBUTE14
, TRANSACTION_ATTRIBUTE15 TRANSACTION_ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SHIP_FROM_CODE_INT SHIP_FROM_CODE_INT
, SHIP_FROM_CODE_EXT SHIP_FROM_CODE_EXT
, DELIVERY_ID DELIVERY_ID
, SHIP_FROM_CODE_EXT1 SHIP_FROM_CODE_EXT1
, SHIP_FROM_CODE_EXT2 SHIP_FROM_CODE_EXT2
, SHIP_FROM_CODE_EXT3 SHIP_FROM_CODE_EXT3
, SHIP_FROM_CODE_EXT4 SHIP_FROM_CODE_EXT4
, SHIP_FROM_CODE_EXT5 SHIP_FROM_CODE_EXT5
, SHIP_FROM_CODE_INT_1 SHIP_FROM_CODE_INT_1
FROM "EC"."ECE_AR_TRX_HEADER_1"