[Home] [Help]
| Product: | GL - General Ledger |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT INTERCO_S.TRANSACTION_ID
, INTERCO_S.TRANSACTION_TYPE
, INTERCO_S.TRANSACTION_CURRENCY
, INTERCO_S.TRANSACTION_NUMBER
, INTERCO_S.SENDING_SUBSIDIARY_ID
, INTERCO_S.SENDING_SUBSIDIARY_NAME
, INTERCO_R.RECEIVING_SUBSIDIARY_ID
, INTERCO_R.RECEIVING_SUBSIDIARY_NAME
, '_LA:INTERCO_S.STATUS:GL_LOOKUPS:IEA_TRANSACTION_STATUS:MEANING'
, INTERCO_S.SENDER_CLEARING_ACCT_ID
, '_KF:SQLGL:GL#:INTERCO_S'
, INTERCO_R.RECEIVER_CLEARING_ACCT_ID
, '_KF:SQLGL:GL#:INTERCO_R'
, INTERCO_S.GL_DATE
, INTERCO_S.ENTERED_DATE
, '_LA:INTERCO_S.SENDER_TRANSFER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:INTERCO_R.RECEIVER_TRANSFER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, INTERCO_S.SENDER_PERIOD
, INTERCO_R.RECEIVER_PERIOD
, INTERCO_S.SENDER_TOTAL_DR
, INTERCO_S.SENDER_TOTAL_CR
, INTERCO_R.RECEIVER_TOTAL_DR
, INTERCO_R.RECEIVER_TOTAL_CR
, INTERCO_S.CONTROL_TOTAL
, INTERCO_S.APPROVED_DATE
, INTERCO_S.DESCRIPTION
, INTERCO_S.NOTE
, '_DF:SQLGL:GL_IEA_TRANSACTIONS:INTERCO_S'
FROM GL_BIS_IEA_TRANS_SENDER_V INTERCO_S
, GL_BIS_IEA_TRANS_RECEIVER_V INTERCO_R
WHERE INTERCO_S.TRANSACTION_ID= INTERCO_R.TRANSACTION_ID WITH READ ONLY