DBA Data[Home] [Help] [Dependency Information]

TABLE: JL.JL_BR_SPED_EXTR_PARAM

Object Details
Object Name: JL_BR_SPED_EXTR_PARAM
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_BR_SPED_EXTR_PARAM
Subobject Name:
Status: VALID


This tables stores the parameters of every Accounting SPED Data extract program submitted


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_BR_SPED_EXTR_PARAM_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Accounting SPED Data extract program request id
LEDGER_ID NUMBER (15) Yes Ledger Id
LEGAL_ENTITY_ID NUMBER (15) Yes Legal Entity Id
ESTABLISHMENT_ID NUMBER (15)
Establishment Id
PERIOD_TYPE VARCHAR2 (30)
Period Type
PERIOD_NAME VARCHAR2 (15)
Period Name
ADJUSTMENT_PERIOD VARCHAR2 (15)
Adjustment Period
SPEC_SITU_INDIC VARCHAR2 (1)
Special Situation Indicator
SPEC_SITU_START_DATE DATE

Special Situation Start Date
SPEC_SITU_END_DATE DATE

Special Situation End Date
BOOKKEEPING_TYPE VARCHAR2 (3) Yes Bookkeeping Type
ESTB_ACCT_TYPE VARCHAR2 (15)
Establishment Account Type
ESTABLISHMET_NAME VARCHAR2 (80)
Establishment Name
PARTICIPANT_TYPE VARCHAR2 (50) Yes Participant Type
PARTIC_ACCT_SEGMENT VARCHAR2 (80)
Participant Accounting Segment
CONSOL_MAP_ID NUMBER (15)
Consolidation Mapping Id
BALSHEET_REP_REQUEST_ID NUMBER (15)
FSG Balance Sheet Report Request ID
INCMSTMT_REP_REQUEST_ID NUMBER (15)
FSG Income Statement Report Request ID
AGC_SOURCE VARCHAR2 (30)
Agglutination Code Source
RTF_FILE_SOURCE NUMBER (15)
RTF File Source
HAS_CODE VARCHAR2 (40)
Hash Code
ACCT_STMT_INDF VARCHAR2 (1)
Account Statement Identification
ACCT_STMT_HEADER VARCHAR2 (30)
Account Statement Header
DATA_EXIST VARCHAR2 (1)
Data Exist Flag
REPORT_MODE VARCHAR2 (1) Yes Report Mode
REGISTRATION_SOURCE VARCHAR2 (20) Yes Registration Source (XLE or ZX)
XLE_STATE_INS_REG_CODE VARCHAR2 (20)
State Inscription Registration Code for LE
XLE_CITY_INS_REG_CODE VARCHAR2 (20)
City Inscription Registration Code for LE
ZX_STATE_INS_TAX_ID VARCHAR2 (20)
State Inscription tax for EB tax (ZX)
ZX_CITY_INS_TAX_ID VARCHAR2 (20)
City Inscription tax for EB tax (ZX)
ZX_STATE_INS_REG_CODE VARCHAR2 (20)
State Inscription Registration Code for EB tax (ZX)
ZX_CITY_INS_REG_CODE VARCHAR2 (20)
City Inscription Registration Code for EB tax (ZX)
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row
CREATION_DATE DATE
Yes Standard who column - date when this row was created
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row
LAST_UPDATE_DATE DATE
Yes Standard who column - date when this row was updated
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row
Query Text

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;

Dependencies

[top of page]

JL.JL_BR_SPED_EXTR_PARAM does not reference any database object

JL.JL_BR_SPED_EXTR_PARAM is referenced by following:

SchemaJL
ViewJL_BR_SPED_EXTR_PARAM#