DBA Data[Home] [Help] [Dependency Information]

TABLE: JE.JE_ES_MODELO_349_ALL

Object Details
Object Name: JE_ES_MODELO_349_ALL
Object Type: TABLE
Owner: JE
FND Design Data: TableJE.JE_ES_MODELO_349_ALL
Subobject Name:
Status: VALID


JE_ES_MODELO_349_ALL is a temporary table cleared and populated in each data extraction run. This table contains data used for the creation of Spanish Payables and Spanish Receivables Inter-EU Operations Summary Magnetic Formats (Modelo 349) that provide electronic reports for submission to the Spanish government.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books ID
CLAVE_OPERACION VARCHAR2 (1) Yes Operation type
ORG_ID NUMBER (15)
Organization
NIF_COMUNITARIO VARCHAR2 (14)
VAT registration number
NOMBRE VARCHAR2 (40)
Name of the declared
BASE_IMPONIBLE NUMBER

Amount of the operations
OPERACION_TRIANGULAR VARCHAR2 (1)
Triangulation
EJERCICIO VARCHAR2 (2)
Year corrected
PERIODO VARCHAR2 (2)
Period corrected
FIN_IND VARCHAR2 (1) Yes 'Y' means created by the system
RUNNING_TOTAL NUMBER

Running total for the report
FORMERLY_DECLARED_AMOUNT NUMBER

Formerly declared amount of the Spanish Inter-EU operations
PRINT_PERIOD VARCHAR2 (2)
The period that report is printed for
PRINT_YEAR VARCHAR2 (4)
The year that the report is printed for
PRINT_MODE VARCHAR2 (1)
Printing mode
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_OF_BOOKS_ID
,      CLAVE_OPERACION
,      ORG_ID
,      NIF_COMUNITARIO
,      NOMBRE
,      BASE_IMPONIBLE
,      OPERACION_TRIANGULAR
,      EJERCICIO
,      PERIODO
,      FIN_IND
,      RUNNING_TOTAL
,      FORMERLY_DECLARED_AMOUNT
,      PRINT_PERIOD
,      PRINT_YEAR
,      PRINT_MODE
FROM JE.JE_ES_MODELO_349_ALL;

Dependencies

[top of page]

JE.JE_ES_MODELO_349_ALL does not reference any database object

JE.JE_ES_MODELO_349_ALL is referenced by following:

SchemaAPPS
SynonymJE_ES_MODELO_349_ALL