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 |