[Home] [Help] [Dependency Information]
Object Name: | IGI_MHC_LEDGER# |
---|---|
Object Type: | VIEW |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ENTRY_ID | NUMBER | (15) | Yes | |
CURRENT_PERIOD_COUNTER | NUMBER | (15) | Yes | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | |
ASSET_ID | NUMBER | (15) | Yes | |
DISTRIBUTION_ID | NUMBER | Yes | ||
TRANSACTION_TYPE | VARCHAR2 | (25) | Yes | |
TRANSACTION_SUB_TYPE | VARCHAR2 | (25) | Yes | |
TRANSACTION_HEADER_ID | NUMBER | Yes | ||
TRANSFER_STATUS | VARCHAR2 | (5) | Yes | |
TRANSFER_PERIOD_COUNTER | NUMBER | (15) | ||
PROCESS_ID | NUMBER | (15) | ||
PROCESS_MODE | VARCHAR2 | (1) | ||
JOURNAL_DESCRIPTION | VARCHAR2 | (200) | ||
JOURNAL_SOURCE | VARCHAR2 | (30) | Yes | |
JOURNAL_DATE | DATE | |||
ENTERED_DEBIT | NUMBER | |||
ENTERED_CREDIT | NUMBER | |||
AMOUNT | NUMBER | |||
DR_CR_FLAG | VARCHAR2 | (2) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
REVERSAL_LEDGER_ENTRY_ID | NUMBER | (25) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REFERENCE1 | VARCHAR2 | (100) | ||
REFERENCE2 | VARCHAR2 | (240) | ||
REFERENCE3 | VARCHAR2 | (240) | ||
REFERENCE4 | VARCHAR2 | (240) | ||
REFERENCE5 | VARCHAR2 | (240) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (1000) | ||
ACCOUNT_TYPE | VARCHAR2 | (25) | Yes | |
FA_ADJUSTMENTS_ROWID | ROWID | (10) | ||
GL_JE_LINES_ROWID | ROWID | (10) | ||
CURRENT_MHC_PERIOD_COUNTER | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ENTRY_ID
, CURRENT_PERIOD_COUNTER
, BOOK_TYPE_CODE
, ASSET_ID
, DISTRIBUTION_ID
, TRANSACTION_TYPE
, TRANSACTION_SUB_TYPE
, TRANSACTION_HEADER_ID
, TRANSFER_STATUS
, TRANSFER_PERIOD_COUNTER
, PROCESS_ID
, PROCESS_MODE
, JOURNAL_DESCRIPTION
, JOURNAL_SOURCE
, JOURNAL_DATE
, ENTERED_DEBIT
, ENTERED_CREDIT
, AMOUNT
, DR_CR_FLAG
, CODE_COMBINATION_ID
, REVERSAL_LEDGER_ENTRY_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, CONCATENATED_SEGMENTS
, ACCOUNT_TYPE
, FA_ADJUSTMENTS_ROWID
, GL_JE_LINES_ROWID
, CURRENT_MHC_PERIOD_COUNTER
FROM IGI.IGI_MHC_LEDGER#;
|
|
|