VIEW: JA.JA_CN_ERROR_ACCOUNTS#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, ACCOUNT_SEGMENT ACCOUNT_SEGMENT, CURRENCY_CODE CURRENCY_CODE, FUNC_BEGIN_BALANCE FUNC_BEGIN_BALANCE, ORIG_BEGIN_BALANCE ORIG_BEGIN_BALANCE, FUNC_PERIOD_NET_DR FUNC_PERIOD_NET_DR, FUNC_PERIOD_NET_CR FUNC_PERIOD_NET_CR, ORIG_PERIOD_NET_DR ORIG_PERIOD_NET_DR, ORIG_PERIOD_NET_CR ORIG_PERIOD_NET_CR, FUNC_END_BALANCE FUNC_END_BALANCE, ORIG_END_BALANCE ORIG_END_BALANCE, PERIOD_MON PERIOD_MON, COST_CENTER COST_CENTER, THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER, PERSONNEL_NUMBER PERSONNEL_NUMBER, PROJECT_NUMBER PROJECT_NUMBER, HAS_THIRD_PARTY HAS_THIRD_PARTY, HAS_COST_CENTER HAS_COST_CENTER, HAS_PERSONNEL HAS_PERSONNEL, HAS_PROJECT HAS_PROJECT, ACCOUNT_TYPE ACCOUNT_TYPE, IS_FOREIGN IS_FOREIGN, BALANCE_SIDE BALANCE_SIDE, ACCOUNT_LEVEL ACCOUNT_LEVEL, PERIOD_NAME PERIOD_NAME, START_DATE START_DATE from "JA"."JA_CN_ERROR_ACCOUNTS"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, ACCOUNT_SEGMENT ACCOUNT_SEGMENT
, CURRENCY_CODE CURRENCY_CODE
, FUNC_BEGIN_BALANCE FUNC_BEGIN_BALANCE
, ORIG_BEGIN_BALANCE ORIG_BEGIN_BALANCE
, FUNC_PERIOD_NET_DR FUNC_PERIOD_NET_DR
, FUNC_PERIOD_NET_CR FUNC_PERIOD_NET_CR
, ORIG_PERIOD_NET_DR ORIG_PERIOD_NET_DR
, ORIG_PERIOD_NET_CR ORIG_PERIOD_NET_CR
, FUNC_END_BALANCE FUNC_END_BALANCE
, ORIG_END_BALANCE ORIG_END_BALANCE
, PERIOD_MON PERIOD_MON
, COST_CENTER COST_CENTER
, THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER
, PERSONNEL_NUMBER PERSONNEL_NUMBER
, PROJECT_NUMBER PROJECT_NUMBER
, HAS_THIRD_PARTY HAS_THIRD_PARTY
, HAS_COST_CENTER HAS_COST_CENTER
, HAS_PERSONNEL HAS_PERSONNEL
, HAS_PROJECT HAS_PROJECT
, ACCOUNT_TYPE ACCOUNT_TYPE
, IS_FOREIGN IS_FOREIGN
, BALANCE_SIDE BALANCE_SIDE
, ACCOUNT_LEVEL ACCOUNT_LEVEL
, PERIOD_NAME PERIOD_NAME
, START_DATE START_DATE
FROM "JA"."JA_CN_ERROR_ACCOUNTS"