[Home] [Help]
[Dependency Information]
Object Name: | JL_BR_SPED_EXTR_DATA_H |
---|---|
Object Type: | TABLE |
Owner: | JL |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table is a history table to store the finally submitted Accounting SPED Text file data
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JL_BR_SPED_EXTR_DATA_H_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
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 |
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;
JL.JL_BR_SPED_EXTR_DATA_H does not reference any database object
JL.JL_BR_SPED_EXTR_DATA_H is referenced by following:
|
|
|