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

VIEW: AP.JE_FR_DAS_310#

Object Details
Object Name: JE_FR_DAS_310#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes
SIREN_ENT NUMBER (9)
Z0 VARCHAR2 (12)
TYPE_ENREG VARCHAR2 (3)
NBRE_ETAB NUMBER (5)
NBRE_200 NUMBER (6)
NBRE_210 NUMBER (6)
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_ENT NUMBER (6)
Z4 VARCHAR2 (313)
Query Text

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


SELECT SET_OF_BOOKS_ID
,      SIREN_ENT
,      Z0
,      TYPE_ENREG
,      NBRE_ETAB
,      NBRE_200
,      NBRE_210
,      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_ENT
,      Z4
FROM AP.JE_FR_DAS_310#;

Dependencies

[top of page]

AP.JE_FR_DAS_310# references the following:

SchemaAP
TableJE_FR_DAS_310
AP.JE_FR_DAS_310# is referenced by following:

SchemaAPPS
SynonymJE_FR_DAS_310