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: JA.JAI_CMN_RG_PERIOD_BALS#

Source

View Text - Preformatted


select PERIOD_BALANCE_ID PERIOD_BALANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, REGISTER_TYPE REGISTER_TYPE, START_DATE START_DATE, END_DATE END_DATE, FIN_YEAR FIN_YEAR, OPENING_BALANCE OPENING_BALANCE, CLOSING_BALANCE CLOSING_BALANCE, MISC_ADJUSTMENT MISC_ADJUSTMENT, CUMULATIVE_MISC_ADJUSTMENT CUMULATIVE_MISC_ADJUSTMENT, ROUNDING_ADJUSTMENT ROUNDING_ADJUSTMENT, CUMULATIVE_ROUNDING_ADJUSTMENT CUMULATIVE_ROUNDING_ADJUSTMENT, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CVD_EDU_CESS_ADJ CVD_EDU_CESS_ADJ, CVD_EDU_CESS_ADJ_OP_BAL CVD_EDU_CESS_ADJ_OP_BAL, CVD_EDU_CESS_CL_BAL CVD_EDU_CESS_CL_BAL, EXC_EDU_CESS_ADJ EXC_EDU_CESS_ADJ, EXC_EDU_CESS_ADJ_OP_BAL EXC_EDU_CESS_ADJ_OP_BAL, EXC_EDU_CESS_CL_BAL EXC_EDU_CESS_CL_BAL, SH_CVD_EDU_CESS_ADJ SH_CVD_EDU_CESS_ADJ, SH_CVD_EDU_CESS_ADJ_OP_BAL SH_CVD_EDU_CESS_ADJ_OP_BAL, SH_CVD_EDU_CESS_CL_BAL SH_CVD_EDU_CESS_CL_BAL, SH_EXC_EDU_CESS_ADJ SH_EXC_EDU_CESS_ADJ, SH_EXC_EDU_CESS_ADJ_OP_BAL SH_EXC_EDU_CESS_ADJ_OP_BAL, SH_EXC_EDU_CESS_CL_BAL SH_EXC_EDU_CESS_CL_BAL from "JA"."JAI_CMN_RG_PERIOD_BALS"

View Text - HTML Formatted

SELECT PERIOD_BALANCE_ID PERIOD_BALANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, REGISTER_TYPE REGISTER_TYPE
, START_DATE START_DATE
, END_DATE END_DATE
, FIN_YEAR FIN_YEAR
, OPENING_BALANCE OPENING_BALANCE
, CLOSING_BALANCE CLOSING_BALANCE
, MISC_ADJUSTMENT MISC_ADJUSTMENT
, CUMULATIVE_MISC_ADJUSTMENT CUMULATIVE_MISC_ADJUSTMENT
, ROUNDING_ADJUSTMENT ROUNDING_ADJUSTMENT
, CUMULATIVE_ROUNDING_ADJUSTMENT CUMULATIVE_ROUNDING_ADJUSTMENT
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CVD_EDU_CESS_ADJ CVD_EDU_CESS_ADJ
, CVD_EDU_CESS_ADJ_OP_BAL CVD_EDU_CESS_ADJ_OP_BAL
, CVD_EDU_CESS_CL_BAL CVD_EDU_CESS_CL_BAL
, EXC_EDU_CESS_ADJ EXC_EDU_CESS_ADJ
, EXC_EDU_CESS_ADJ_OP_BAL EXC_EDU_CESS_ADJ_OP_BAL
, EXC_EDU_CESS_CL_BAL EXC_EDU_CESS_CL_BAL
, SH_CVD_EDU_CESS_ADJ SH_CVD_EDU_CESS_ADJ
, SH_CVD_EDU_CESS_ADJ_OP_BAL SH_CVD_EDU_CESS_ADJ_OP_BAL
, SH_CVD_EDU_CESS_CL_BAL SH_CVD_EDU_CESS_CL_BAL
, SH_EXC_EDU_CESS_ADJ SH_EXC_EDU_CESS_ADJ
, SH_EXC_EDU_CESS_ADJ_OP_BAL SH_EXC_EDU_CESS_ADJ_OP_BAL
, SH_EXC_EDU_CESS_CL_BAL SH_EXC_EDU_CESS_CL_BAL
FROM "JA"."JAI_CMN_RG_PERIOD_BALS"