FND Design Data [Home] [Help]

View: XTR_JOURNALS_V

Product: XTR - Treasury
Description:
Implementation/DBA Data: ViewAPPS.XTR_JOURNALS_V
View Text

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

Columns

Name
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