[Home] [Help] [Dependency Information]
Object Name: | JE_FR_DAS2_ETB_HEADERS_T# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
ESTABLISHMENT_ID | NUMBER | (15) | Yes | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
SIREN_ETAB | NUMBER | (9) | ||
NIC_ETAB | NUMBER | (5) | ||
SECTION_DAS | VARCHAR2 | (2) | ||
VALIDITE | NUMBER | (4) | ||
TYPE_DAS | VARCHAR2 | (1) | ||
TYPE_ENREG | VARCHAR2 | (3) | ||
Z01_94_1 | VARCHAR2 | (14) | ||
CODE_APE | VARCHAR2 | (5) | ||
Z01_94_2 | VARCHAR2 | (1) | ||
SIRET_01_JAN | NUMBER | (9) | ||
NIC_01_JAN | NUMBER | (5) | ||
Z02 | VARCHAR2 | (41) | ||
RAISON_SOCIALE | VARCHAR2 | (50) | ||
ADR_COMPL | VARCHAR2 | (32) | ||
Z1 | VARCHAR2 | (1) | ||
ADR_CONCAT | VARCHAR2 | (64) | ||
ADR_INSEE | VARCHAR2 | (5) | ||
Z3 | VARCHAR2 | (1) | ||
ADR_COMMUNE | VARCHAR2 | (26) | ||
ADR_CPOSTAL | VARCHAR2 | (5) | ||
Z4 | VARCHAR2 | (1) | ||
ADR_BUR_DIST | VARCHAR2 | (26) | ||
PROFESSION | VARCHAR2 | (40) | ||
Z5 | VARCHAR2 | (53) | ||
CODE_TAXE_SAL | VARCHAR2 | (1) | ||
Z6 | VARCHAR2 | (301) | ||
NUM_ENR | 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
, SET_OF_BOOKS_ID
, SIREN_ETAB
, NIC_ETAB
, SECTION_DAS
, VALIDITE
, TYPE_DAS
, TYPE_ENREG
, Z01_94_1
, CODE_APE
, Z01_94_2
, SIRET_01_JAN
, NIC_01_JAN
, Z02
, RAISON_SOCIALE
, ADR_COMPL
, Z1
, ADR_CONCAT
, ADR_INSEE
, Z3
, ADR_COMMUNE
, ADR_CPOSTAL
, Z4
, ADR_BUR_DIST
, PROFESSION
, Z5
, CODE_TAXE_SAL
, Z6
, NUM_ENR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM AP.JE_FR_DAS2_ETB_HEADERS_T#;
|
|
|