[Home] [Help]
View: GLFV_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
, '_KF:SQLGL:GL#:GL_BIS_IEA_TRAN_LINES_V'
, ENTERED_DR
, ENTERED_CR
, '_DF:SQLGL:GL_IEA_TRANSACTION_LINES:GL_BIS_IEA_TRAN_LINES_V'
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
, '_KF:SQLGL:GL#:GL_BIS_IEA_TRAN_LINES_V'
, ENTERED_DR
, ENTERED_CR
, '_DF:SQLGL:GL_IEA_TRANSACTION_LINES:GL_BIS_IEA_TRAN_LINES_V'
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 |
"_KF:INTERCO_CLEARING_ACCT" |
ENTERED_DR |
ENTERED_CR |
"_DF" |