[Home] [Help]
View: XTR_TRIAL_BALANCE_V
Product: | XTR - Treasury |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CODE_COMBINATION_ID
, COMPANY_CODE
, GL_TRANSFER_DATE
, BALANCE_CFWD_HCE_DR_CR
, CURRENCY
, SUM(BALANCE_CFWD) BALANCE_CFWD
, SUM(HCE_BALANCE_CFWD) HCE_BALANCE_CFWD FROM XTR_GENERAL_LEDGER_SUMMARY GROUP BY CODE_COMBINATION_ID
, COMPANY_CODE
, GL_TRANSFER_DATE
, BALANCE_CFWD_HCE_DR_CR
, CURRENCY UNION ALL SELECT CODE_COMBINATION_ID
, COMPANY_CODE
, GL_TRANSFER_DATE
, BALANCE_CFWD_HCE_DR_CR
, NULL CURRENCY
, SUM(BALANCE_CFWD) BALANCE_CFWD
, SUM(HCE_BALANCE_CFWD) HCE_BALANCE_CFWD FROM XTR_GENERAL_LEDGER_SUMMARY GROUP BY CODE_COMBINATION_ID
, COMPANY_CODE
, GL_TRANSFER_DATE
, BALANCE_CFWD_HCE_DR_CR
Columns
Name |
CODE_COMBINATION_ID |
COMPANY_CODE |
GL_TRANSFER_DATE |
BALANCE_CFWD_HCE_DR_CR |
CURRENCY |
BALANCE_CFWD |
HCE_BALANCE_CFWD |