[Home] [Help] [Dependency Information]
Object Name: | GL_SUBR_STA# |
---|---|
Object Type: | VIEW |
Owner: | GMF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLOSED_PER_IND | NUMBER | (2) | Yes | |
GL_DATE | DATE | |||
GL_FISCAL_YEAR | NUMBER | (5) | ||
REFERENCE_NO | NUMBER | (10) | Yes | |
GL_PERIOD | NUMBER | (5) | ||
CO_CODE | VARCHAR2 | (4) | ||
CURRENT_STATE | NUMBER | (5) | Yes | |
START_TIME | DATE | |||
END_TIME | DATE | |||
COMPLETION_IND | NUMBER | (5) | Yes | |
STARTED_BY | NUMBER | (15) | Yes | |
STOP_IND | NUMBER | (5) | Yes | |
FISCAL_YEAR | NUMBER | (5) | Yes | |
PERIOD | NUMBER | (5) | Yes | |
PERIOD_START_DATE | DATE | Yes | ||
PERIOD_END_DATE | DATE | Yes | ||
TEST_POSTING | NUMBER | (5) | Yes | |
POST_IC | NUMBER | (5) | ||
POST_OP | NUMBER | (5) | ||
POST_PM | NUMBER | (5) | ||
POST_PO | NUMBER | (5) | ||
POST_CM | NUMBER | (5) | ||
SCHEDULED_ON | VARCHAR2 | (32) | Yes | |
ABORTED_BY | NUMBER | (15) | ||
UPDATE_STAGE | NUMBER | (5) | ||
ERRORS_FOUND | NUMBER | (10) | ||
ERRORS_POSTED | NUMBER | (10) | ||
ERRORS_LIMIT | NUMBER | (10) | ||
ROWS_POSTED | NUMBER | (10) | ||
ABORT_REASON | VARCHAR2 | (70) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
DELETE_MARK | NUMBER | (5) | Yes | |
IN_USE | NUMBER | (5) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) | ||
POST_OM | NUMBER | (5) | ||
INCL_NO_COST | NUMBER | (5) | ||
POST_PUR | NUMBER | (5) | ||
DEFAULT_LANGUAGE | VARCHAR2 | (4) | ||
CREV_CURR_CALENDAR | VARCHAR2 | (10) | ||
CREV_CURR_MTHD | VARCHAR2 | (10) | ||
CREV_CURR_PERIOD | VARCHAR2 | (10) | ||
CREV_GL_TRANS_DATE | DATE | |||
CREV_INV_PREV_CAL | VARCHAR2 | (10) | ||
CREV_INV_PREV_PER | NUMBER | (15) | ||
CREV_PREV_CALENDAR | VARCHAR2 | (10) | ||
CREV_PREV_MTHD | VARCHAR2 | (10) | ||
CREV_PREV_PERIOD | VARCHAR2 | (10) | ||
BASE_CURRENCY | VARCHAR2 | (15) | ||
COST_BASIS | NUMBER | |||
COST_MTHD_CODE | VARCHAR2 | (10) | ||
COST_TYPE | NUMBER | |||
COST_TYPE_ID | NUMBER | |||
CREV_CURR_COST_TYPE_ID | NUMBER | |||
CREV_CURR_PERIOD_ID | NUMBER | |||
CREV_PREV_COST_TYPE_ID | NUMBER | |||
CREV_PREV_PERIOD_ID | NUMBER | |||
DEFAULT_COST_MTHD_CODE | VARCHAR2 | (10) | ||
DEFAULT_COST_TYPE_ID | NUMBER | |||
EXTRACT_HDR_ROWS_POSTED | NUMBER | |||
EXTRACT_LINE_ROWS_POSTED | NUMBER | |||
LEDGER_ID | NUMBER | |||
LEGAL_ENTITY_ID | NUMBER | |||
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | ||
PERIOD_ID | NUMBER | (15) | ||
PROCESS_CATEGORY | VARCHAR2 | (100) | ||
POST_CM_CADJ | NUMBER | (5) | ||
POST_CM_RVAL | NUMBER | (5) | ||
POST_GL_ALOC | NUMBER | (5) | ||
BATCH_ID_FROM | NUMBER | |||
BATCH_ID_TO | NUMBER | |||
NUM_OF_PROCESS | NUMBER | (5) | ||
POST_TXN_CMPT_COST | NUMBER | (5) |
Cut, paste (and edit) the following text to query this object:
SELECT CLOSED_PER_IND
, GL_DATE
, GL_FISCAL_YEAR
, REFERENCE_NO
, GL_PERIOD
, CO_CODE
, CURRENT_STATE
, START_TIME
, END_TIME
, COMPLETION_IND
, STARTED_BY
, STOP_IND
, FISCAL_YEAR
, PERIOD
, PERIOD_START_DATE
, PERIOD_END_DATE
, TEST_POSTING
, POST_IC
, POST_OP
, POST_PM
, POST_PO
, POST_CM
, SCHEDULED_ON
, ABORTED_BY
, UPDATE_STAGE
, ERRORS_FOUND
, ERRORS_POSTED
, ERRORS_LIMIT
, ROWS_POSTED
, ABORT_REASON
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELETE_MARK
, IN_USE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, POST_OM
, INCL_NO_COST
, POST_PUR
, DEFAULT_LANGUAGE
, CREV_CURR_CALENDAR
, CREV_CURR_MTHD
, CREV_CURR_PERIOD
, CREV_GL_TRANS_DATE
, CREV_INV_PREV_CAL
, CREV_INV_PREV_PER
, CREV_PREV_CALENDAR
, CREV_PREV_MTHD
, CREV_PREV_PERIOD
, BASE_CURRENCY
, COST_BASIS
, COST_MTHD_CODE
, COST_TYPE
, COST_TYPE_ID
, CREV_CURR_COST_TYPE_ID
, CREV_CURR_PERIOD_ID
, CREV_PREV_COST_TYPE_ID
, CREV_PREV_PERIOD_ID
, DEFAULT_COST_MTHD_CODE
, DEFAULT_COST_TYPE_ID
, EXTRACT_HDR_ROWS_POSTED
, EXTRACT_LINE_ROWS_POSTED
, LEDGER_ID
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, PERIOD_ID
, PROCESS_CATEGORY
, POST_CM_CADJ
, POST_CM_RVAL
, POST_GL_ALOC
, BATCH_ID_FROM
, BATCH_ID_TO
, NUM_OF_PROCESS
, POST_TXN_CMPT_COST
FROM GMF.GL_SUBR_STA#;
|
|
|