FND Design Data [Home] [Help]

View: XTR_A_JOURNALS_V

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

SELECT COMPANY_CODE
, JOURNAL_DATE
, DEAL_NUMBER
, TRANSACTION_NUMBER
, DEAL_TYPE
, DEAL_SUBTYPE
, AMOUNT_TYPE
, DEBIT_AMOUNT
, CREDIT_AMOUNT
, CODE_COMBINATION_ID
, COMMENTS
, GL_TRANSFER_DATE
, JNL_REVERSAL_IND
, CANCELLED_IN_GL
, CREATED_BY
, CREATED_ON
, UPDATED_BY
, UPDATED_ON
, PRODUCT_TYPE
, PORTFOLIO_CODE
, CURRENCY
, TRANSFER_TO_EXTERNAL_GL
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
, SET_OF_BOOKS_ID
, SUSPENSE_GL
, ACCOUNTED_DR
, ACCOUNTED_CR
, GL_SL_LINK_ID
, SETTLEMENT_NUMBER
FROM XTR_A_JOURNALS

Columns

Name
COMPANY_CODE
JOURNAL_DATE
DEAL_NUMBER
TRANSACTION_NUMBER
DEAL_TYPE
DEAL_SUBTYPE
AMOUNT_TYPE
DEBIT_AMOUNT
CREDIT_AMOUNT
CODE_COMBINATION_ID
COMMENTS
GL_TRANSFER_DATE
JNL_REVERSAL_IND
CANCELLED_IN_GL
CREATED_BY
CREATED_ON
UPDATED_BY
UPDATED_ON
PRODUCT_TYPE
PORTFOLIO_CODE
CURRENCY
TRANSFER_TO_EXTERNAL_GL
AUDIT_INDICATOR
AUDIT_DATE_STORED
SET_OF_BOOKS_ID
SUSPENSE_GL
ACCOUNTED_DR
ACCOUNTED_CR
GL_SL_LINK_ID
SETTLEMENT_NUMBER