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