1. Tables and Views for Financials
  2. JG_ES_MODELO_DECL_LINES

JG_ES_MODELO_DECL_LINES

This table contains data used for the creation of Spanish Payables and Spanish Receivables Modelo 340, 347, 349 and 415 that provide electronic reports for submission to the Spanish government. This table is cleared and

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

JG_ES_MODELO_DECL_LINES_PK

DECL_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
DECL_LINE_ID NUMBER 18 Yes A unique system generated identifier for the detail record that is associated with the turnover declaration.
DECL_HEADER_ID NUMBER 18 Yes A unique system generated identifier for the header record that is associated with the turnover declaration. Foreign key identifier to JG_ZZ_AR_AP_TRNOVR_DECL_HDRS table.
INTERNAL_ORGANIZATION_ID NUMBER 18 Yes Internal organization identifier of the transaction.
LEDGER_ID NUMBER 18 Yes Internal identifier that identifies the ledger associated with the tax transaction.
APPLICATION_ID NUMBER 18 Yes Application identifier of the transaction.
EVENT_CLASS_CODE VARCHAR2 30 Yes Event class short name of the transaction.
ENTITY_CODE VARCHAR2 30 Yes Entity short name of the transaction.
TRX_ID NUMBER 18 Yes A unique identifier that identifies a transaction.
TRX_LINE_ID NUMBER 18 Yes A unique identifier that identifies a transaction line.
TRX_LINE_DIST_ID NUMBER 18 A unique identifies that identifies an item distribution.
TAX_LINE_ID NUMBER 18 Yes A unique identifier that identifies a tax line.
REC_NREC_TAX_DIST_ID NUMBER 18 An internal identifier that identifies a tax distribtion. Foreign key identifier to the ZX_REC_NREC_DIST table.
TAX_DIST_ID NUMBER 18 An internal identifier that identifies the tax distribtion that is created directly in the tax repository. Foreign key identifier to the ZX_TRX_TAX_DISTRIBUTIONS table.
TRX_NUMBER VARCHAR2 150 Transaction number.
TRX_LINE_NUMBER NUMBER 18 Trasnaction line number.
TAX_LINE_NUMBER NUMBER 18 Line number generated for the tax line.
REC_NREC_TAX_DIST_NUMBER NUMBER 18 Line number generated for the tax distribution.
TRX_DATE DATE Date when the transaction occurred.
GL_DATE DATE Default accounting date for transactions.
TRADING_PARTNER_ID NUMBER 18 Party identifier of the trading partner, customer or supplier that is used to bill or pay this transaction
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction business category code of the transaction line that identiifes spanish modelo type.
CORRECTION_YEAR VARCHAR2 30 Reported year of the rectification or correction transaction.
CORRECTION_PERIOD VARCHAR2 30 Reported period of the rectification or correction transaction.
TRIANGULATION VARCHAR2 30 Indicates if the invoice is for a triangulation operation or not.
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
JG_ES_MODELO_DECL_LINES_N1 Non Unique Default APPLICATION_ID, LEDGER_ID, TRX_ID, TRX_LINE_ID
JG_ES_MODELO_DECL_LINES_N2 Non Unique Default TAX_LINE_ID
JG_ES_MODELO_DECL_LINES_U1 Unique Default DECL_LINE_ID