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

Source

View Text - Preformatted


select LINE_ID LINE_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, REF_CUSTOMER_TRX_LINE_ID REF_CUSTOMER_TRX_LINE_ID, REF_CUST_TRX_LINE_GL_DIST_ID REF_CUST_TRX_LINE_GL_DIST_ID, REF_ACCOUNT_CLASS REF_ACCOUNT_CLASS, ACTIVITY_BUCKET ACTIVITY_BUCKET, REF_LINE_ID REF_LINE_ID, FROM_AMOUNT_DR FROM_AMOUNT_DR, FROM_AMOUNT_CR FROM_AMOUNT_CR, FROM_ACCTD_AMOUNT_DR FROM_ACCTD_AMOUNT_DR, FROM_ACCTD_AMOUNT_CR FROM_ACCTD_AMOUNT_CR, REF_MF_DIST_FLAG REF_MF_DIST_FLAG, REF_DIST_CCID REF_DIST_CCID, REF_PREV_CUST_TRX_LINE_ID REF_PREV_CUST_TRX_LINE_ID from "AR"."AR_DISTRIBUTIONS_ALL"

View Text - HTML Formatted

SELECT LINE_ID LINE_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
, REF_CUSTOMER_TRX_LINE_ID REF_CUSTOMER_TRX_LINE_ID
, REF_CUST_TRX_LINE_GL_DIST_ID REF_CUST_TRX_LINE_GL_DIST_ID
, REF_ACCOUNT_CLASS REF_ACCOUNT_CLASS
, ACTIVITY_BUCKET ACTIVITY_BUCKET
, REF_LINE_ID REF_LINE_ID
, FROM_AMOUNT_DR FROM_AMOUNT_DR
, FROM_AMOUNT_CR FROM_AMOUNT_CR
, FROM_ACCTD_AMOUNT_DR FROM_ACCTD_AMOUNT_DR
, FROM_ACCTD_AMOUNT_CR FROM_ACCTD_AMOUNT_CR
, REF_MF_DIST_FLAG REF_MF_DIST_FLAG
, REF_DIST_CCID REF_DIST_CCID
, REF_PREV_CUST_TRX_LINE_ID REF_PREV_CUST_TRX_LINE_ID
FROM "AR"."AR_DISTRIBUTIONS_ALL"