eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JE.JE_ES_MODELO_415_ALL

Object Details

Object Name:	JE_ES_MODELO_415_ALL
Object Type:	TABLE
Owner:	JE
FND Design Data:	JE.JE_ES_MODELO_415_ALL
Subobject Name:
Status:	VALID

This table contains invoice information used by the Spanish Canary Islands Annual Operations Magnetic Format. It is populated temporarily during each run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
ORG_ID	NUMBER	(15)		Operating unit identifier
CLAVE_OPERACION	VARCHAR2	(1)	Yes	Operation key
NIF	VARCHAR2	(9)		Declared's taxpayer identifiler
NOMBRE	VARCHAR2	(40)		Declared's name
IMPORTE	NUMBER			Turnover amount
DIRECCION	VARCHAR2	(32)		Declared's address
CODIGO_POSTAL	VARCHAR2	(5)		Postal code of the declared's address
MUNICIPIO	VARCHAR2	(24)		Town or city of the declared's address
FIN_IND	VARCHAR2	(1)	Yes	'Y' if inserted by the program

Query Text

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


SELECT SET_OF_BOOKS_ID
,      ORG_ID
,      CLAVE_OPERACION
,      NIF
,      NOMBRE
,      IMPORTE
,      DIRECCION
,      CODIGO_POSTAL
,      MUNICIPIO
,      FIN_IND
FROM JE.JE_ES_MODELO_415_ALL;

Dependencies

[top of page]

JE.JE_ES_MODELO_415_ALL does not reference any database object

JE.JE_ES_MODELO_415_ALL is referenced by following:

JE: JE_ES_MODELO_415_ALL#