[Home] [Help]
| Product: | XTR - Treasury |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.XTR_JOURNALS_V
|
SELECT ROWID AS ROW_ID
, BATCH_ID
, COMPANY_CODE
, JOURNAL_DATE
, DEAL_NUMBER
, TRANSACTION_NUMBER
, DEAL_TYPE
, DEAL_SUBTYPE
, AMOUNT_TYPE
, DEBIT_AMOUNT
, CREDIT_AMOUNT
, CODE_COMBINATION_ID
, COMMENTS
, JNL_REVERSAL_IND
, CANCELLED_IN_GL
, CREATED_BY
, CREATED_ON
, UPDATED_BY
, UPDATED_ON
, PRODUCT_TYPE
, PORTFOLIO_CODE
, AUDIT_INDICATOR
, CURRENCY
, TRANSFER_TO_EXTERNAL_GL
, SET_OF_BOOKS_ID
, SUSPENSE_GL
, ACCOUNTED_DR
, ACCOUNTED_CR
, GL_SL_LINK_ID
, SETTLEMENT_NUMBER
, ORIG_JOURNAL_DATE
, ALT_JOURNAL_DATE
, DATE_TYPE
, ACTION_CODE
FROM XTR_JOURNALS