JE_IT_INVOICES_E_LISTING
This table contains the electronic listing process information for invoices, that generates XML files for submission to the government of Italy. This table also contains file transmission information received from the revenue agency for declarations submitted in final mode.
Details
-
Schema: FUSION
-
Object owner: JE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
JE_IT_INVOICES_E_LISTING_PK |
E_LISTING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| E_LISTING_ID | NUMBER | 18 | Yes | Record identifier that is associated with the e-invoices declaration. | |
| VAT_REPORTING_ENTITY_ID | NUMBER | 18 | Yes | Tax reporting entity for which the extract is run. | |
| TAX_CALENDAR_NAME | VARCHAR2 | 15 | Yes | Calendar used for tax reporting. | |
| YEAR_OF_ELISTING | NUMBER | 4 | Yes | Name of the year 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. | ||
| SOURCE_NAME | VARCHAR2 | 30 | Yes | Source of the transaction. For example, sales or purchase transaction. | |
| TRANSMISSION_TYPE_CODE | VARCHAR2 | 5 | Yes | Transmission type of declaration. Valid values are 0 for original, and 1 for cancellation. | |
| PROGRESSIVE_TRANSMISSION_NUM | NUMBER | 18 | Internal progressive transmission number used by the transmitter to identify the file transmitted in final mode. This is submitted to the tax authority. | ||
| FILE_TRANSMISSION_NUM | VARCHAR2 | 30 | External declaration number. This number is received from the tax authority as part of acknowledgement of the electronic file transmitted to them. | ||
| REPORT_MODE_CODE | VARCHAR2 | 1 | Yes | Extraction mode of the report. Valid values are D for draft and F for final. | |
| LATEST_RECORD_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the declaration record is the latest one. Valid values are Y and N. | |
| 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_INVOICES_E_LISTING_N1 | Non Unique | Default | VAT_REPORTING_ENTITY_ID, YEAR_OF_ELISTING, PERIOD_START_DATE, PERIOD_END_DATE, SOURCE_NAME |
| JE_IT_INVOICES_E_LISTING_U1 | Unique | Default | E_LISTING_ID |