1. Tables and Views for Financials
  2. JL_BR_SPED_EXTR_DATA_H

JL_BR_SPED_EXTR_DATA_H

This table contains the financial information that has already been reported to the government. Once the SPED text file is generated in the final mode, data gets purged from the main SPED extract table and gets inserted into this history table.

Details

  • Schema: FUSION

  • Object owner: JL

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JL_BR_SPED_EXTR_DATA_H_PK

SPED_EXTR_DATA_ID

Columns

Name Datatype Length Precision Not-null Comments Status
SPED_EXTR_DATA_ID NUMBER 18 Yes Reporting data identifier for which the SPED text file is generated.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
RECORD_SEQ NUMBER Yes Transaction header record sequence for public system of digital bookkeeping. Active
BLOCK VARCHAR2 4 Yes Block number of the SPED file that is used for reporting accounting transactions. Active
FIELD1 VARCHAR2 255 Register number within a block of the SPED file. Active
SEPARATOR1 VARCHAR2 1 No longer used. Active
FIELD2 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR2 VARCHAR2 1 No longer used. Active
FIELD3 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR3 VARCHAR2 1 No longer used. Active
FIELD4 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR4 VARCHAR2 1 No longer used. Active
FIELD5 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR5 VARCHAR2 1 No longer used. Active
FIELD6 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR6 VARCHAR2 1 No longer used. Active
FIELD7 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR7 VARCHAR2 1 No longer used. Active
FIELD8 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR8 VARCHAR2 1 No longer used. Active
FIELD9 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR9 VARCHAR2 1 No longer used. Active
FIELD10 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR10 VARCHAR2 1 No longer used. Active
FIELD11 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR11 VARCHAR2 1 No longer used. Active
FIELD12 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR12 VARCHAR2 1 No longer used. Active
FIELD13 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR13 VARCHAR2 1 No longer used. Active
FIELD14 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR14 VARCHAR2 1 No longer used. Active
FIELD15 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
SEPARATOR15 VARCHAR2 1 No longer used. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
FIELD16 CLOB An attribute of the SPED file. It is different for each register. Active
FIELD17 CLOB An attribute of the SPED file. It is different for each register. Active
FIELD18 VARCHAR2 255 An attribute of the SPED file. It is different for each register. Active
FIELD19 VARCHAR2 255 An attribute of the SPED file. It is different for each register.
FIELD20 VARCHAR2 255 An attribute of the SPED file. It is different for each register.

Indexes

Index Uniqueness Tablespace Columns Status
JL_BR_SPED_EXTR_DATA_H_U1 Unique Default SPED_EXTR_DATA_ID
JL_BR_SPED_EXTR_DATA_H_U2 Unique FUSION_TS_TX_IDX REQUEST_ID, RECORD_SEQ Active