VIEW: AP.JE_FR_DAS_210#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CHECK_NUMBER CHECK_NUMBER, INVOICE_NUM INVOICE_NUM, VENDOR_SITE_CODE VENDOR_SITE_CODE, TAX_IDENTIFICATION_NUM TAX_IDENTIFICATION_NUM, VENDOR_NAME VENDOR_NAME, SIREN_ETAB SIREN_ETAB, NIC_ETAB NIC_ETAB, SECTION SECTION, VALIDITE VALIDITE, TYPE_DAS TYPE_DAS, TYPE_ENREG TYPE_ENREG, SIRET_BENEF SIRET_BENEF, NOM NOM, PRENOM PRENOM, RAISON_SOCIALE RAISON_SOCIALE, PROFESSION PROFESSION, ADR_COMPL ADR_COMPL, Z1 Z1, ADR_NUM ADR_NUM, ADR_TYPE ADR_TYPE, Z2 Z2, ADR_VOIE ADR_VOIE, ADR_INSEE ADR_INSEE, Z3 Z3, ADR_COMMUNE ADR_COMMUNE, ADR_CPOSTAL ADR_CPOSTAL, Z4 Z4, ADR_BUR_DIST ADR_BUR_DIST, 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, NAT_AVAN_NOUR NAT_AVAN_NOUR, NAT_AVAN_LOGE NAT_AVAN_LOGE, NAT_AVAN_VOIT NAT_AVAN_VOIT, NAT_AVAN_AUTR NAT_AVAN_AUTR, Z5 Z5, NAT_RETE_ALLO NAT_RETE_ALLO, NAT_RETE_REMB NAT_RETE_REMB, NAT_RETE_PRIS NAT_RETE_PRIS, NAT_TVA_REDUI NAT_TVA_REDUI, NAT_TVA_DISPE NAT_TVA_DISPE, TVA_NETTE TVA_NETTE, Z6 Z6, SEGMENT1 SEGMENT1, AGE_11 AGE_11, TYPE_1099 TYPE_1099, INVOICE_DATE INVOICE_DATE, INVOICE_AMOUNT INVOICE_AMOUNT from "AP"."JE_FR_DAS_210"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CHECK_NUMBER CHECK_NUMBER
, INVOICE_NUM INVOICE_NUM
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, TAX_IDENTIFICATION_NUM TAX_IDENTIFICATION_NUM
, VENDOR_NAME VENDOR_NAME
, SIREN_ETAB SIREN_ETAB
, NIC_ETAB NIC_ETAB
, SECTION SECTION
, VALIDITE VALIDITE
, TYPE_DAS TYPE_DAS
, TYPE_ENREG TYPE_ENREG
, SIRET_BENEF SIRET_BENEF
, NOM NOM
, PRENOM PRENOM
, RAISON_SOCIALE RAISON_SOCIALE
, PROFESSION PROFESSION
, ADR_COMPL ADR_COMPL
, Z1 Z1
, ADR_NUM ADR_NUM
, ADR_TYPE ADR_TYPE
, Z2 Z2
, ADR_VOIE ADR_VOIE
, ADR_INSEE ADR_INSEE
, Z3 Z3
, ADR_COMMUNE ADR_COMMUNE
, ADR_CPOSTAL ADR_CPOSTAL
, Z4 Z4
, ADR_BUR_DIST ADR_BUR_DIST
, 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
, NAT_AVAN_NOUR NAT_AVAN_NOUR
, NAT_AVAN_LOGE NAT_AVAN_LOGE
, NAT_AVAN_VOIT NAT_AVAN_VOIT
, NAT_AVAN_AUTR NAT_AVAN_AUTR
, Z5 Z5
, NAT_RETE_ALLO NAT_RETE_ALLO
, NAT_RETE_REMB NAT_RETE_REMB
, NAT_RETE_PRIS NAT_RETE_PRIS
, NAT_TVA_REDUI NAT_TVA_REDUI
, NAT_TVA_DISPE NAT_TVA_DISPE
, TVA_NETTE TVA_NETTE
, Z6 Z6
, SEGMENT1 SEGMENT1
, AGE_11 AGE_11
, TYPE_1099 TYPE_1099
, INVOICE_DATE INVOICE_DATE
, INVOICE_AMOUNT INVOICE_AMOUNT
FROM "AP"."JE_FR_DAS_210"