Skip to content

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

TABLE: JL.JL_BR_SPED_EXTR_DATA_H

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


This table is a history table to store the finally submitted Accounting SPED Text file data


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_BR_SPED_EXTR_DATA_H_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnRECORD_SEQ
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Accounting SPED Data extract program request id
RECORD_SEQ NUMBER
Yes Record Sequence
BLOCK VARCHAR2 (4) Yes SPED Data block. Possible Values are 0,I,J and 9
FIELD1 VARCHAR2 (255)
Field1
SEPARATOR1 VARCHAR2 (1)
Separator 1: Possible values are | or NULL
FIELD2 VARCHAR2 (255)
Field2
SEPARATOR2 VARCHAR2 (1)
Separator 2: Possible values are | or NULL
FIELD3 VARCHAR2 (255)
Field3
SEPARATOR3 VARCHAR2 (1)
Separator 3: Possible values are | or NULL
FIELD4 VARCHAR2 (255)
Field4
SEPARATOR4 VARCHAR2 (1)
Separator 4: Possible values are | or NULL
FIELD5 VARCHAR2 (255)
Field5
SEPARATOR5 VARCHAR2 (1)
Separator 5: Possible values are | or NULL
FIELD6 VARCHAR2 (255)
Field6
SEPARATOR6 VARCHAR2 (1)
Separator 6: Possible values are | or NULL
FIELD7 VARCHAR2 (255)
Field7
SEPARATOR7 VARCHAR2 (1)
Separator 7: Possible values are | or NULL
FIELD8 VARCHAR2 (255)
Field8
SEPARATOR8 VARCHAR2 (1)
Separator 8: Possible values are | or NULL
FIELD9 VARCHAR2 (255)
Field9
SEPARATOR9 VARCHAR2 (1)
Separator 9: Possible values are | or NULL
FIELD10 VARCHAR2 (255)
Field10
SEPARATOR10 VARCHAR2 (1)
Separator 10: Possible values are | or NULL
FIELD11 VARCHAR2 (255)
Field11
SEPARATOR11 VARCHAR2 (1)
Separator 11: Possible values are | or NULL
FIELD12 VARCHAR2 (255)
Field12
SEPARATOR12 VARCHAR2 (1)
Separator 12: Possible values are | or NULL
FIELD13 VARCHAR2 (255)
Field13
SEPARATOR13 VARCHAR2 (1)
Separator 13: Possible values are | or NULL
FIELD14 VARCHAR2 (255)
Field14
SEPARATOR14 VARCHAR2 (1)
Separator 14: Possible values are | or NULL
FIELD15 VARCHAR2 (255)
Field15
SEPARATOR15 VARCHAR2 (1)
Separator 15: Possible values are | or NULL
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_ID
,      RECORD_SEQ
,      BLOCK
,      FIELD1
,      SEPARATOR1
,      FIELD2
,      SEPARATOR2
,      FIELD3
,      SEPARATOR3
,      FIELD4
,      SEPARATOR4
,      FIELD5
,      SEPARATOR5
,      FIELD6
,      SEPARATOR6
,      FIELD7
,      SEPARATOR7
,      FIELD8
,      SEPARATOR8
,      FIELD9
,      SEPARATOR9
,      FIELD10
,      SEPARATOR10
,      FIELD11
,      SEPARATOR11
,      FIELD12
,      SEPARATOR12
,      FIELD13
,      SEPARATOR13
,      FIELD14
,      SEPARATOR14
,      FIELD15
,      SEPARATOR15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JL.JL_BR_SPED_EXTR_DATA_H;

Dependencies

[top of page]

JL.JL_BR_SPED_EXTR_DATA_H does not reference any database object

JL.JL_BR_SPED_EXTR_DATA_H is referenced by following:

SchemaJL
ViewJL_BR_SPED_EXTR_DATA_H#