[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 |