[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JE_FR_DAS_300_NEW |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  JE.JE_FR_DAS_300_NEW
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | (15) | ||
| MONTANTS_CALCULES | VARCHAR2 | (1) | ||
| Z5 | VARCHAR2 | (107) |
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
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, MONTANTS_CALCULES
, Z5
FROM AP.JE_FR_DAS_300_NEW;
AP.JE_FR_DAS_300_NEW does not reference any database object
AP.JE_FR_DAS_300_NEW is referenced by following:
AP
JE_FR_DAS_300_NEW#
|
|
|
|