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: AR.JG_ZZ_AR_TMP_BAL#

Source

View Text - Preformatted


select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, CURRENCY_CODE CURRENCY_CODE, PERIOD_NAME PERIOD_NAME, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, BEGIN_BAL_ENTERED_DR BEGIN_BAL_ENTERED_DR, BEGIN_BAL_ENTERED_CR BEGIN_BAL_ENTERED_CR, BEGIN_BAL_ACCOUNTED_DR BEGIN_BAL_ACCOUNTED_DR, BEGIN_BAL_ACCOUNTED_CR BEGIN_BAL_ACCOUNTED_CR, PERIOD_NET_ENTERED_DR PERIOD_NET_ENTERED_DR, PERIOD_NET_ENTERED_CR PERIOD_NET_ENTERED_CR, PERIOD_NET_ACCOUNTED_DR PERIOD_NET_ACCOUNTED_DR, PERIOD_NET_ACCOUNTED_CR PERIOD_NET_ACCOUNTED_CR, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, POSTED_TO_GL_FLAG POSTED_TO_GL_FLAG from "AR"."JG_ZZ_AR_TMP_BAL"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, CURRENCY_CODE CURRENCY_CODE
, PERIOD_NAME PERIOD_NAME
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, BEGIN_BAL_ENTERED_DR BEGIN_BAL_ENTERED_DR
, BEGIN_BAL_ENTERED_CR BEGIN_BAL_ENTERED_CR
, BEGIN_BAL_ACCOUNTED_DR BEGIN_BAL_ACCOUNTED_DR
, BEGIN_BAL_ACCOUNTED_CR BEGIN_BAL_ACCOUNTED_CR
, PERIOD_NET_ENTERED_DR PERIOD_NET_ENTERED_DR
, PERIOD_NET_ENTERED_CR PERIOD_NET_ENTERED_CR
, PERIOD_NET_ACCOUNTED_DR PERIOD_NET_ACCOUNTED_DR
, PERIOD_NET_ACCOUNTED_CR PERIOD_NET_ACCOUNTED_CR
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, POSTED_TO_GL_FLAG POSTED_TO_GL_FLAG
FROM "AR"."JG_ZZ_AR_TMP_BAL"