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: AP.JE_FR_DAS_300

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
TAX_IDENTIFICATION_NUM	VARCHAR2	(20)	Yes
SIREN_ETAB	NUMBER	(9)
NIC_ETAB	NUMBER	(5)
SECTION	VARCHAR2	(2)
VALIDITE	NUMBER	(4)
TYPE_DAS	VARCHAR2	(1)
TYPE_ENREG	VARCHAR2	(3)
Z1	VARCHAR2	(36)
BASE_BRUTE_FISC	NUMBER	(12)
REMUNERATIONS_NET	NUMBER	(12)
AVANTAGES_NAT	NUMBER	(12)
FRAIS_PROF	NUMBER	(12)
CHEQUE_VAC	NUMBER	(12)
TOTAL_IMPOS	NUMBER	(12)
TOTAL_BASE_IMPOS1	NUMBER	(12)
TOTAL_BASE_IMPOS2	NUMBER	(12)
TOTAL_RET	NUMBER	(12)
DHON_H	NUMBER	(12)
DCOM_C	NUMBER	(12)
DCO_CO	NUMBER	(12)
DRIS_R	NUMBER	(12)
DJE_JP	NUMBER	(12)
DDA_DA	NUMBER	(12)
DDI_I	NUMBER	(12)
DAU_AR	NUMBER	(12)
INDE	NUMBER	(12)
AVAN	NUMBER	(12)
RETE	NUMBER	(12)
Z2	VARCHAR2	(12)
TAXE_SAL	NUMBER	(12)
Z3	VARCHAR2	(12)
EFFECTIF_ETAB	NUMBER	(6)
Z4	VARCHAR2	(134)
NOM_RESP	VARCHAR2	(30)
PRENOM_RESP	VARCHAR2	(20)
TPH_FONC_RESP	VARCHAR2	(40)
CONTACTE_NOM	VARCHAR2	(30)
CONTACTE_PRENOM	VARCHAR2	(20)
CONTACTE_TPH	VARCHAR2	(40)
Z5	VARCHAR2	(107)

Query Text

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


SELECT SET_OF_BOOKS_ID
,      TAX_IDENTIFICATION_NUM
,      SIREN_ETAB
,      NIC_ETAB
,      SECTION
,      VALIDITE
,      TYPE_DAS
,      TYPE_ENREG
,      Z1
,      BASE_BRUTE_FISC
,      REMUNERATIONS_NET
,      AVANTAGES_NAT
,      FRAIS_PROF
,      CHEQUE_VAC
,      TOTAL_IMPOS
,      TOTAL_BASE_IMPOS1
,      TOTAL_BASE_IMPOS2
,      TOTAL_RET
,      DHON_H
,      DCOM_C
,      DCO_CO
,      DRIS_R
,      DJE_JP
,      DDA_DA
,      DDI_I
,      DAU_AR
,      INDE
,      AVAN
,      RETE
,      Z2
,      TAXE_SAL
,      Z3
,      EFFECTIF_ETAB
,      Z4
,      NOM_RESP
,      PRENOM_RESP
,      TPH_FONC_RESP
,      CONTACTE_NOM
,      CONTACTE_PRENOM
,      CONTACTE_TPH
,      Z5
FROM AP.JE_FR_DAS_300;

Dependencies

[top of page]

AP.JE_FR_DAS_300 does not reference any database object

AP.JE_FR_DAS_300 is referenced by following:

APPS: JE_FR_DAS_300