1. Tables and Views for Financials
  2. JE_IT_TP_DECLARATION

JE_IT_TP_DECLARATION

This table contains the third-party declaration process information that provides electronic reports for submission to the government of Italy. This table also contains declaration protocol information received from the tax authorities for declarations submitted in final mode.

Details

  • Schema: FUSION

  • Object owner: JE

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

JE_IT_TP_DECLARATION_PK

DECLARATION_ID

Columns

Name Datatype Length Precision Not-null Comments
DECLARATION_ID NUMBER 18 Yes Record identifier that is associated with the third-party declaration.
VAT_REPORTING_ENTITY_ID NUMBER 18 Yes Tax reporting entity for which the extract is run.
DECLARATION_TYPE_CODE VARCHAR2 5 Yes Type of declaration. Possible values are 0 for restricted countries, 1 for San Marino, and 2 for third-party listing.
YEAR_OF_DECLARATION NUMBER 4 Yes Name of the year for which data is extracted.
MONTH_OF_DECLARATION VARCHAR2 15 Name of the period for which data is extracted.
PERIOD_START_DATE DATE Yes Start date of the declaration period.
PERIOD_END_DATE DATE Yes End date of the declaration period.
TRANSMISSION_TYPE VARCHAR2 5 Yes Transmission type of declaration. Possible values are 0 for ordinary, 1 for substitution, and 2 for cancellation.
TRANSMISSION_PROTOCOL_NUM NUMBER 18 External declaration number, such as the transmission protocol number for Italy. Number can be received after the actual declaration is submitted to the tax authority.
DOCUMENT_PROTOCOL_NUM NUMBER 18 External declaration number. For example, the document protocol number for Italy. Number can be received after the actual declaration is submitted to the tax authority.
REPORT_MODE VARCHAR2 1 Yes Extraction mode of the report. Possible values are D for draft and F for final.
LATEST_REC_FLAG VARCHAR2 1 Yes Indicates whether the declaration record is the latest record. Possible values are Y for yes and N for no.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
JE_IT_TP_DECLARATION_N1 Non Unique Default VAT_REPORTING_ENTITY_ID, DECLARATION_TYPE_CODE, YEAR_OF_DECLARATION, MONTH_OF_DECLARATION
JE_IT_TP_DECLARATION_U1 Unique Default DECLARATION_ID