[Home] [Help] [Dependency Information]
Object Name: | JL_BR_SPED_EXTR_PARAM# |
---|---|
Object Type: | VIEW |
Owner: | JL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | |
LEDGER_ID | NUMBER | (15) | Yes | |
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
ESTABLISHMENT_ID | NUMBER | (15) | ||
PERIOD_TYPE | VARCHAR2 | (30) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
ADJUSTMENT_PERIOD | VARCHAR2 | (15) | ||
SPEC_SITU_INDIC | VARCHAR2 | (1) | ||
SPEC_SITU_START_DATE | DATE | |||
SPEC_SITU_END_DATE | DATE | |||
BOOKKEEPING_TYPE | VARCHAR2 | (3) | Yes | |
ESTB_ACCT_TYPE | VARCHAR2 | (15) | ||
ESTABLISHMET_NAME | VARCHAR2 | (80) | ||
PARTICIPANT_TYPE | VARCHAR2 | (50) | Yes | |
PARTIC_ACCT_SEGMENT | VARCHAR2 | (80) | ||
CONSOL_MAP_ID | NUMBER | (15) | ||
BALSHEET_REP_REQUEST_ID | NUMBER | (15) | ||
INCMSTMT_REP_REQUEST_ID | NUMBER | (15) | ||
AGC_SOURCE | VARCHAR2 | (30) | ||
RTF_FILE_SOURCE | NUMBER | (15) | ||
HAS_CODE | VARCHAR2 | (40) | ||
ACCT_STMT_INDF | VARCHAR2 | (1) | ||
ACCT_STMT_HEADER | VARCHAR2 | (30) | ||
DATA_EXIST | VARCHAR2 | (1) | ||
REPORT_MODE | VARCHAR2 | (1) | Yes | |
REGISTRATION_SOURCE | VARCHAR2 | (20) | Yes | |
XLE_STATE_INS_REG_CODE | VARCHAR2 | (20) | ||
XLE_CITY_INS_REG_CODE | VARCHAR2 | (20) | ||
ZX_STATE_INS_TAX_ID | VARCHAR2 | (20) | ||
ZX_CITY_INS_TAX_ID | VARCHAR2 | (20) | ||
ZX_STATE_INS_REG_CODE | VARCHAR2 | (20) | ||
ZX_CITY_INS_REG_CODE | VARCHAR2 | (20) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, LEDGER_ID
, LEGAL_ENTITY_ID
, ESTABLISHMENT_ID
, PERIOD_TYPE
, PERIOD_NAME
, ADJUSTMENT_PERIOD
, SPEC_SITU_INDIC
, SPEC_SITU_START_DATE
, SPEC_SITU_END_DATE
, BOOKKEEPING_TYPE
, ESTB_ACCT_TYPE
, ESTABLISHMET_NAME
, PARTICIPANT_TYPE
, PARTIC_ACCT_SEGMENT
, CONSOL_MAP_ID
, BALSHEET_REP_REQUEST_ID
, INCMSTMT_REP_REQUEST_ID
, AGC_SOURCE
, RTF_FILE_SOURCE
, HAS_CODE
, ACCT_STMT_INDF
, ACCT_STMT_HEADER
, DATA_EXIST
, REPORT_MODE
, REGISTRATION_SOURCE
, XLE_STATE_INS_REG_CODE
, XLE_CITY_INS_REG_CODE
, ZX_STATE_INS_TAX_ID
, ZX_CITY_INS_TAX_ID
, ZX_STATE_INS_REG_CODE
, ZX_CITY_INS_REG_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM JL.JL_BR_SPED_EXTR_PARAM#;
|
|
|