VIEW: AP.JE_FR_DAS_300#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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