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.

VIEW: AR.AR_MC_DISTRIBUTIONS_ALL#

Source

View Text - Preformatted


select LINE_ID LINE_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SOURCE_ID SOURCE_ID, SOURCE_TABLE SOURCE_TABLE, SOURCE_TYPE SOURCE_TYPE, CODE_COMBINATION_ID CODE_COMBINATION_ID, AMOUNT_DR AMOUNT_DR, AMOUNT_CR AMOUNT_CR, ACCTD_AMOUNT_DR ACCTD_AMOUNT_DR, ACCTD_AMOUNT_CR ACCTD_AMOUNT_CR, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_ID ORG_ID, SOURCE_TABLE_SECONDARY SOURCE_TABLE_SECONDARY, SOURCE_ID_SECONDARY SOURCE_ID_SECONDARY, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR, TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR, TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR, TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR, TAX_LINK_ID TAX_LINK_ID, THIRD_PARTY_ID THIRD_PARTY_ID, THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID, REVERSED_SOURCE_ID REVERSED_SOURCE_ID, TAX_CODE_ID TAX_CODE_ID, LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID, SOURCE_TYPE_SECONDARY SOURCE_TYPE_SECONDARY, TAX_GROUP_CODE_ID TAX_GROUP_CODE_ID from "AR"."AR_MC_DISTRIBUTIONS_ALL"

View Text - HTML Formatted

SELECT LINE_ID LINE_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, SOURCE_TYPE SOURCE_TYPE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, AMOUNT_DR AMOUNT_DR
, AMOUNT_CR AMOUNT_CR
, ACCTD_AMOUNT_DR ACCTD_AMOUNT_DR
, ACCTD_AMOUNT_CR ACCTD_AMOUNT_CR
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_ID ORG_ID
, SOURCE_TABLE_SECONDARY SOURCE_TABLE_SECONDARY
, SOURCE_ID_SECONDARY SOURCE_ID_SECONDARY
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, TAX_LINK_ID TAX_LINK_ID
, THIRD_PARTY_ID THIRD_PARTY_ID
, THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
, REVERSED_SOURCE_ID REVERSED_SOURCE_ID
, TAX_CODE_ID TAX_CODE_ID
, LOCATION_SEGMENT_ID LOCATION_SEGMENT_ID
, SOURCE_TYPE_SECONDARY SOURCE_TYPE_SECONDARY
, TAX_GROUP_CODE_ID TAX_GROUP_CODE_ID
FROM "AR"."AR_MC_DISTRIBUTIONS_ALL"