[Home] [Help] [Dependency Information]
Object Name: | JE_FR_DAS2_LE_ETB_SUMM_T |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | JE.JE_FR_DAS2_LE_ETB_SUMM_T |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JE_FR_DAS2_LE_ETB_SUMM_T_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LEGAL_ENTITY_ID
ESTABLISHMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
ESTABLISHMENT_ID | NUMBER | (15) | Yes | |
SIREN_ETAB | NUMBER | (9) | ||
SIREN_ENT | NUMBER | (9) | ||
NIC_ETAB | NUMBER | (5) | ||
Z0 | VARCHAR2 | (12) | ||
SECTION_DAS | VARCHAR2 | (2) | ||
VALIDITE | NUMBER | (4) | ||
TYPE_DAS | VARCHAR2 | (1) | ||
TYPE_ENREG | VARCHAR2 | (3) | ||
SIRET_BENEF | VARCHAR2 | (14) | ||
NOM | VARCHAR2 | (30) | ||
PRENOM | VARCHAR2 | (20) | ||
RAISON_SOCIALE | VARCHAR2 | (50) | ||
PROFESSION | VARCHAR2 | (30) | ||
ADR_COMPL | VARCHAR2 | (32) | ||
Z1 | VARCHAR2 | (1) | ||
ADR_NUM | VARCHAR2 | (4) | ||
ADR_TYPE | VARCHAR2 | (1) | ||
Z2 | VARCHAR2 | (1) | ||
ADR_VOIE | VARCHAR2 | (26) | ||
ADR_INSEE | VARCHAR2 | (5) | ||
Z3 | VARCHAR2 | (1) | ||
ADR_COMMUNE | VARCHAR2 | (26) | ||
ADR_CPOSTAL | VARCHAR2 | (5) | ||
Z4 | VARCHAR2 | (1) | ||
ADR_BUR_DIST | VARCHAR2 | (26) | ||
DHON_H | NUMBER | (10) | ||
DCOM_C | NUMBER | (10) | ||
DCO_CO | NUMBER | (10) | ||
DRIS_R | NUMBER | (10) | ||
DJE_JP | NUMBER | (10) | ||
DDA_DA | NUMBER | (10) | ||
DDI_I | NUMBER | (10) | ||
DAU_AR | NUMBER | (10) | ||
INDE | NUMBER | (10) | ||
AVAN | NUMBER | (10) | ||
RETE | NUMBER | (10) | ||
NAT_AVAN_NOUR | VARCHAR2 | (1) | ||
NAT_AVAN_LOGE | VARCHAR2 | (1) | ||
NAT_AVAN_VOIT | VARCHAR2 | (1) | ||
NAT_AVAN_AUTR | VARCHAR2 | (1) | ||
Z5 | VARCHAR2 | (1) | ||
NAT_RETE_ALLO | VARCHAR2 | (1) | ||
NAT_RETE_REMB | VARCHAR2 | (1) | ||
NAT_RETE_PRIS | VARCHAR2 | (1) | ||
NAT_TVA_REDUI | VARCHAR2 | (1) | ||
NAT_TVA_DISPE | VARCHAR2 | (1) | ||
TVA_NETTE | NUMBER | (10) | ||
Z6 | VARCHAR2 | (240) | ||
SEGMENT1 | VARCHAR2 | (30) | ||
AGE_11 | NUMBER | (11) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
VENDOR_SITE_ID | NUMBER | Yes | ||
CHECK_NUMBER | NUMBER | (15) | Yes | |
INVOICE_NUM | VARCHAR2 | (50) | Yes | |
VENDOR_SITE_CODE | VARCHAR2 | (15) | Yes | |
TAX_IDENTIFICATION_NUM | VARCHAR2 | (20) | Yes | |
VENDOR_NAME | VARCHAR2 | (80) | Yes | |
TYPE_1099 | VARCHAR2 | (10) | ||
INVOICE_DATE | DATE | |||
INVOICE_AMOUNT | NUMBER | |||
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) | ||
TAXE_SAL | NUMBER | (12) | ||
EFFECTIF_ENT | NUMBER | (6) | ||
EFFECTIF_ETAB | NUMBER | (6) | ||
NOM_RESP | VARCHAR2 | (30) | ||
PRENOM_RESP | VARCHAR2 | (30) | ||
TPH_FONC_RESP | VARCHAR2 | (30) | ||
CONTACTE_NOM | VARCHAR2 | (30) | ||
CONTACTE_PRENOM | VARCHAR2 | (30) | ||
CONTACTE_TPH | VARCHAR2 | (30) | ||
NBRE_ETAB | NUMBER | (5) | ||
NBRE_200 | NUMBER | (6) | ||
NBRE_210 | NUMBER | (6) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT LEGAL_ENTITY_ID
, ESTABLISHMENT_ID
, SIREN_ETAB
, SIREN_ENT
, NIC_ETAB
, Z0
, SECTION_DAS
, VALIDITE
, TYPE_DAS
, TYPE_ENREG
, SIRET_BENEF
, NOM
, PRENOM
, RAISON_SOCIALE
, PROFESSION
, ADR_COMPL
, Z1
, ADR_NUM
, ADR_TYPE
, Z2
, ADR_VOIE
, ADR_INSEE
, Z3
, ADR_COMMUNE
, ADR_CPOSTAL
, Z4
, ADR_BUR_DIST
, DHON_H
, DCOM_C
, DCO_CO
, DRIS_R
, DJE_JP
, DDA_DA
, DDI_I
, DAU_AR
, INDE
, AVAN
, RETE
, NAT_AVAN_NOUR
, NAT_AVAN_LOGE
, NAT_AVAN_VOIT
, NAT_AVAN_AUTR
, Z5
, NAT_RETE_ALLO
, NAT_RETE_REMB
, NAT_RETE_PRIS
, NAT_TVA_REDUI
, NAT_TVA_DISPE
, TVA_NETTE
, Z6
, SEGMENT1
, AGE_11
, SET_OF_BOOKS_ID
, VENDOR_SITE_ID
, CHECK_NUMBER
, INVOICE_NUM
, VENDOR_SITE_CODE
, TAX_IDENTIFICATION_NUM
, VENDOR_NAME
, TYPE_1099
, INVOICE_DATE
, INVOICE_AMOUNT
, BASE_BRUTE_FISC
, REMUNERATIONS_NET
, AVANTAGES_NAT
, FRAIS_PROF
, CHEQUE_VAC
, TOTAL_IMPOS
, TOTAL_BASE_IMPOS1
, TOTAL_BASE_IMPOS2
, TOTAL_RET
, TAXE_SAL
, EFFECTIF_ENT
, EFFECTIF_ETAB
, NOM_RESP
, PRENOM_RESP
, TPH_FONC_RESP
, CONTACTE_NOM
, CONTACTE_PRENOM
, CONTACTE_TPH
, NBRE_ETAB
, NBRE_200
, NBRE_210
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM AP.JE_FR_DAS2_LE_ETB_SUMM_T;
AP.JE_FR_DAS2_LE_ETB_SUMM_T does not reference any database object
AP.JE_FR_DAS2_LE_ETB_SUMM_T is referenced by following:
|
|
|