[Home] [Help]
View: 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
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 |
Name |