[Home] [Help]
View: GLBV_GLOBAL_INTERCO_TRAN_LINES
Product: | GL - General Ledger |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TRANSACTION_ID
, TRANSACTION_NUMBER
, LINE_TYPE
, TRANSACTION_LINE_NUMBER
, INTERCO_CLEARING_ACCT_ID
, ENTERED_DR
, ENTERED_CR
FROM GL_BIS_IEA_TRAN_LINES_V
WHERE SENDER_RECEIVER_CODE = 'S' UNION SELECT TRANSACTION_ID
, TRANSACTION_NUMBER
, LINE_TYPE
, TRANSACTION_LINE_NUMBER
, INTERCO_CLEARING_ACCT_ID
, ENTERED_DR
, ENTERED_CR
FROM GL_BIS_IEA_TRAN_LINES_V
WHERE SENDER_RECEIVER_CODE = 'R' WITH READ ONLY
Columns
Name |
TRANSACTION_ID |
TRANSACTION_NUMBER |
LINE_TYPE |
TRANSACTION_LINE_NUMBER |
INTERCO_CLEARING_ACCT_ID |
ENTERED_DR |
ENTERED_CR |