VIEW: AP.JE_FR_DAS2_ETB_HEADERS_T#

Source

View Text - Preformatted

select LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ESTABLISHMENT_ID ESTABLISHMENT_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SIREN_ETAB SIREN_ETAB, NIC_ETAB NIC_ETAB, SECTION_DAS SECTION_DAS, VALIDITE VALIDITE, TYPE_DAS TYPE_DAS, TYPE_ENREG TYPE_ENREG, Z01_94_1 Z01_94_1, CODE_APE CODE_APE, Z01_94_2 Z01_94_2, SIRET_01_JAN SIRET_01_JAN, NIC_01_JAN NIC_01_JAN, Z02 Z02, RAISON_SOCIALE RAISON_SOCIALE, ADR_COMPL ADR_COMPL, Z1 Z1, ADR_CONCAT ADR_CONCAT, ADR_INSEE ADR_INSEE, Z3 Z3, ADR_COMMUNE ADR_COMMUNE, ADR_CPOSTAL ADR_CPOSTAL, Z4 Z4, ADR_BUR_DIST ADR_BUR_DIST, PROFESSION PROFESSION, Z5 Z5, CODE_TAXE_SAL CODE_TAXE_SAL, Z6 Z6, NUM_ENR NUM_ENR, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "AP"."JE_FR_DAS2_ETB_HEADERS_T"

View Text - HTML Formatted

SELECT LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ESTABLISHMENT_ID ESTABLISHMENT_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SIREN_ETAB SIREN_ETAB
, NIC_ETAB NIC_ETAB
, SECTION_DAS SECTION_DAS
, VALIDITE VALIDITE
, TYPE_DAS TYPE_DAS
, TYPE_ENREG TYPE_ENREG
, Z01_94_1 Z01_94_1
, CODE_APE CODE_APE
, Z01_94_2 Z01_94_2
, SIRET_01_JAN SIRET_01_JAN
, NIC_01_JAN NIC_01_JAN
, Z02 Z02
, RAISON_SOCIALE RAISON_SOCIALE
, ADR_COMPL ADR_COMPL
, Z1 Z1
, ADR_CONCAT ADR_CONCAT
, ADR_INSEE ADR_INSEE
, Z3 Z3
, ADR_COMMUNE ADR_COMMUNE
, ADR_CPOSTAL ADR_CPOSTAL
, Z4 Z4
, ADR_BUR_DIST ADR_BUR_DIST
, PROFESSION PROFESSION
, Z5 Z5
, CODE_TAXE_SAL CODE_TAXE_SAL
, Z6 Z6
, NUM_ENR NUM_ENR
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "AP"."JE_FR_DAS2_ETB_HEADERS_T"