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

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, LINE_NUMBER LINE_NUMBER, HEADER_DETAIL_INDICATOR HEADER_DETAIL_INDICATOR, ALLOWANCE_CHARGE_INDICATOR ALLOWANCE_CHARGE_INDICATOR, ALLOWANCE_CHARGE_AMOUNT ALLOWANCE_CHARGE_AMOUNT, SPECIAL_SERVICES_CODE SPECIAL_SERVICES_CODE, SPECIAL_SERVICES_CODE_EXT1 SPECIAL_SERVICES_CODE_EXT1, SPECIAL_SERVICES_CODE_EXT2 SPECIAL_SERVICES_CODE_EXT2, SPECIAL_SERVICES_CODE_EXT3 SPECIAL_SERVICES_CODE_EXT3, SPECIAL_SERVICES_CODE_EXT4 SPECIAL_SERVICES_CODE_EXT4, SPECIAL_SERVICES_CODE_EXT5 SPECIAL_SERVICES_CODE_EXT5, SPECIAL_CHARGES_CODE SPECIAL_CHARGES_CODE, SPECIAL_CHARGES_CODE_EXT1 SPECIAL_CHARGES_CODE_EXT1, SPECIAL_CHARGES_CODE_EXT2 SPECIAL_CHARGES_CODE_EXT2, SPECIAL_CHARGES_CODE_EXT3 SPECIAL_CHARGES_CODE_EXT3, SPECIAL_CHARGES_CODE_EXT4 SPECIAL_CHARGES_CODE_EXT4, SPECIAL_CHARGES_CODE_EXT5 SPECIAL_CHARGES_CODE_EXT5, METHOD_HANDLING_CODE METHOD_HANDLING_CODE, METHOD_HANDLING_CODE_EXT1 METHOD_HANDLING_CODE_EXT1, METHOD_HANDLING_CODE_EXT2 METHOD_HANDLING_CODE_EXT2, METHOD_HANDLING_CODE_EXT3 METHOD_HANDLING_CODE_EXT3, METHOD_HANDLING_CODE_EXT4 METHOD_HANDLING_CODE_EXT4, METHOD_HANDLING_CODE_EXT5 METHOD_HANDLING_CODE_EXT5, ALLOWANCE_CHARGE_DESC ALLOWANCE_CHARGE_DESC, AGENCY_QUALIFIER_CODE AGENCY_QUALIFIER_CODE, ALLOWANCE_CHARGE_RATE ALLOWANCE_CHARGE_RATE, ALLOWANCE_CHARGE_PCT_QUALIFIER ALLOWANCE_CHARGE_PCT_QUALIFIER, ALLOWANCE_CHARGE_PCT ALLOWANCE_CHARGE_PCT, ALLOWANCE_CHARGE_UOM_CODE ALLOWANCE_CHARGE_UOM_CODE, ALLOWANCE_CHARGE_QUANTITY ALLOWANCE_CHARGE_QUANTITY, AC_ATTRIBUTE_CATEGORY AC_ATTRIBUTE_CATEGORY, AC_ATTRIBUTE1 AC_ATTRIBUTE1, AC_ATTRIBUTE2 AC_ATTRIBUTE2, AC_ATTRIBUTE3 AC_ATTRIBUTE3, AC_ATTRIBUTE4 AC_ATTRIBUTE4, AC_ATTRIBUTE5 AC_ATTRIBUTE5, AC_ATTRIBUTE6 AC_ATTRIBUTE6, AC_ATTRIBUTE7 AC_ATTRIBUTE7, AC_ATTRIBUTE8 AC_ATTRIBUTE8, AC_ATTRIBUTE9 AC_ATTRIBUTE9, AC_ATTRIBUTE10 AC_ATTRIBUTE10, AC_ATTRIBUTE11 AC_ATTRIBUTE11, AC_ATTRIBUTE12 AC_ATTRIBUTE12, AC_ATTRIBUTE13 AC_ATTRIBUTE13, AC_ATTRIBUTE14 AC_ATTRIBUTE14, AC_ATTRIBUTE15 AC_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 from "EC"."ECE_AR_TRX_ALLOWANCE_CHARGES"

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
, LINE_NUMBER LINE_NUMBER
, HEADER_DETAIL_INDICATOR HEADER_DETAIL_INDICATOR
, ALLOWANCE_CHARGE_INDICATOR ALLOWANCE_CHARGE_INDICATOR
, ALLOWANCE_CHARGE_AMOUNT ALLOWANCE_CHARGE_AMOUNT
, SPECIAL_SERVICES_CODE SPECIAL_SERVICES_CODE
, SPECIAL_SERVICES_CODE_EXT1 SPECIAL_SERVICES_CODE_EXT1
, SPECIAL_SERVICES_CODE_EXT2 SPECIAL_SERVICES_CODE_EXT2
, SPECIAL_SERVICES_CODE_EXT3 SPECIAL_SERVICES_CODE_EXT3
, SPECIAL_SERVICES_CODE_EXT4 SPECIAL_SERVICES_CODE_EXT4
, SPECIAL_SERVICES_CODE_EXT5 SPECIAL_SERVICES_CODE_EXT5
, SPECIAL_CHARGES_CODE SPECIAL_CHARGES_CODE
, SPECIAL_CHARGES_CODE_EXT1 SPECIAL_CHARGES_CODE_EXT1
, SPECIAL_CHARGES_CODE_EXT2 SPECIAL_CHARGES_CODE_EXT2
, SPECIAL_CHARGES_CODE_EXT3 SPECIAL_CHARGES_CODE_EXT3
, SPECIAL_CHARGES_CODE_EXT4 SPECIAL_CHARGES_CODE_EXT4
, SPECIAL_CHARGES_CODE_EXT5 SPECIAL_CHARGES_CODE_EXT5
, METHOD_HANDLING_CODE METHOD_HANDLING_CODE
, METHOD_HANDLING_CODE_EXT1 METHOD_HANDLING_CODE_EXT1
, METHOD_HANDLING_CODE_EXT2 METHOD_HANDLING_CODE_EXT2
, METHOD_HANDLING_CODE_EXT3 METHOD_HANDLING_CODE_EXT3
, METHOD_HANDLING_CODE_EXT4 METHOD_HANDLING_CODE_EXT4
, METHOD_HANDLING_CODE_EXT5 METHOD_HANDLING_CODE_EXT5
, ALLOWANCE_CHARGE_DESC ALLOWANCE_CHARGE_DESC
, AGENCY_QUALIFIER_CODE AGENCY_QUALIFIER_CODE
, ALLOWANCE_CHARGE_RATE ALLOWANCE_CHARGE_RATE
, ALLOWANCE_CHARGE_PCT_QUALIFIER ALLOWANCE_CHARGE_PCT_QUALIFIER
, ALLOWANCE_CHARGE_PCT ALLOWANCE_CHARGE_PCT
, ALLOWANCE_CHARGE_UOM_CODE ALLOWANCE_CHARGE_UOM_CODE
, ALLOWANCE_CHARGE_QUANTITY ALLOWANCE_CHARGE_QUANTITY
, AC_ATTRIBUTE_CATEGORY AC_ATTRIBUTE_CATEGORY
, AC_ATTRIBUTE1 AC_ATTRIBUTE1
, AC_ATTRIBUTE2 AC_ATTRIBUTE2
, AC_ATTRIBUTE3 AC_ATTRIBUTE3
, AC_ATTRIBUTE4 AC_ATTRIBUTE4
, AC_ATTRIBUTE5 AC_ATTRIBUTE5
, AC_ATTRIBUTE6 AC_ATTRIBUTE6
, AC_ATTRIBUTE7 AC_ATTRIBUTE7
, AC_ATTRIBUTE8 AC_ATTRIBUTE8
, AC_ATTRIBUTE9 AC_ATTRIBUTE9
, AC_ATTRIBUTE10 AC_ATTRIBUTE10
, AC_ATTRIBUTE11 AC_ATTRIBUTE11
, AC_ATTRIBUTE12 AC_ATTRIBUTE12
, AC_ATTRIBUTE13 AC_ATTRIBUTE13
, AC_ATTRIBUTE14 AC_ATTRIBUTE14
, AC_ATTRIBUTE15 AC_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
FROM "EC"."ECE_AR_TRX_ALLOWANCE_CHARGES"