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: XTR_GENERAL_LEDGER_SUMMARY_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT COMPANY_CODE
, ACCOUNTING_PERIOD
, GL_TRANSFER_DATE
, CODE_COMBINATION_ID
, CURRENCY
, BALANCE_BFWD
, DEBIT_CREDIT
, TRANSFER_AMOUNT
, HCE_TRANSFER_AMOUNT
, BALANCE_CFWD
, LATEST_BALANCE
, TRANSFER_TO_EXTERNAL_GL
, DR_CR_BFWD
, DR_CR_CFWD
, OPEN_REVAL_RATE
, CLOSE_REVAL_RATE
, NET_REVALUATION
, HCE_TSFR_DR_CR
, HCE_TSFR_PLUS_REVAL
, BALANCE_CFWD_HCE_DR_CR
, HCE_BALANCE_CFWD
, COMMENTS
FROM XTR_GENERAL_LEDGER_SUMMARY

Columns

Name
COMPANY_CODE
ACCOUNTING_PERIOD
GL_TRANSFER_DATE
CODE_COMBINATION_ID
CURRENCY
BALANCE_BFWD
DEBIT_CREDIT
TRANSFER_AMOUNT
HCE_TRANSFER_AMOUNT
BALANCE_CFWD
LATEST_BALANCE
TRANSFER_TO_EXTERNAL_GL
DR_CR_BFWD
DR_CR_CFWD
OPEN_REVAL_RATE
CLOSE_REVAL_RATE
NET_REVALUATION
HCE_TSFR_DR_CR
HCE_TSFR_PLUS_REVAL
BALANCE_CFWD_HCE_DR_CR
HCE_BALANCE_CFWD
COMMENTS