CREATE TABLE je_fr_das2_ven_summary_t (
    LEGAL_ENTITY_ID           NUMBER(18, 0)    NOT NULL,
    LOCATION_PROFILE_ID       NUMBER(18, 0),
    VEN_SUMMARY_ID            NUMBER(18, 0),
    PROGRAM_NAME              VARCHAR2(120),
    REQUEST_ID                NUMBER(18, 0),
    PROGRAM_APP_NAME          VARCHAR2(200),
    ESTABLISHMENT_ID          NUMBER(18, 0)    NOT NULL,
    SIREN_ETAB                NUMBER(9, 0) ,
    NIC_ETAB                  NUMBER(5, 0) ,
    SECTION_DAS               VARCHAR2(8)  ,
    VALIDITE                  NUMBER(4, 0) ,
    TYPE_DAS                  VARCHAR2(4)  ,
    TYPE_ENREG                VARCHAR2(12) ,
    SIRET_BENEF               VARCHAR2(56) ,
    NOM                       VARCHAR2(120),
    PRENOM                    VARCHAR2(80) ,
    RAISON_SOCIALE            VARCHAR2(200),
    PROFESSION                VARCHAR2(120),
    ADR_COMPL                 VARCHAR2(128),
    Z1                        VARCHAR2(4)  ,
    ADR_NUM                   VARCHAR2(16) ,
    ADR_TYPE                  VARCHAR2(4)  ,
    Z2                        VARCHAR2(4)  ,
    ADR_VOIE                  VARCHAR2(104),
    ADR_INSEE                 VARCHAR2(20) ,
    Z3                        VARCHAR2(4)  ,
    ADR_COMMUNE               VARCHAR2(104),
    ADR_CPOSTAL               VARCHAR2(20) ,
    Z4                        VARCHAR2(4)  ,
    ADR_BUR_DIST              VARCHAR2(104),
    DHON_H                    NUMBER(10, 0),
    DCOM_C                    NUMBER(10, 0),
    DCO_CO                    NUMBER(10, 0),
    DRIS_R                    NUMBER(10, 0),
    DJE_JP                    NUMBER(10, 0),
    DDA_DA                    NUMBER(10, 0),
    DDI_I                     NUMBER(10, 0),
    DAU_AR                    NUMBER(10, 0),
    INDE                      NUMBER(10, 0),
    AVAN                      NUMBER(10, 0),
    RETE                      NUMBER(10, 0),
    NAT_AVAN_NOUR             VARCHAR2(4)  ,
    NAT_AVAN_LOGE             VARCHAR2(4)  ,
    NAT_AVAN_VOIT             VARCHAR2(4)  ,
    NAT_AVAN_AUTR             VARCHAR2(4)  ,
    Z5                        VARCHAR2(4)  ,
    NAT_RETE_ALLO             VARCHAR2(4)  ,
    NAT_RETE_REMB             VARCHAR2(4)  ,
    NAT_RETE_PRIS             VARCHAR2(4)  ,
    NAT_TVA_REDUI             VARCHAR2(4)  ,
    NAT_TVA_DISPE             VARCHAR2(4)  ,
    TVA_NETTE                 NUMBER(10, 0),
    Z6                        VARCHAR2(960),
    SEGMENT1                  VARCHAR2(120),
    AGE_11                    NUMBER(11, 0),
    SET_OF_BOOKS_ID           NUMBER(18, 0)    NOT NULL,
    VENDOR_SITE_ID            NUMBER(18, 0)    NOT NULL,
    CHECK_NUMBER              NUMBER(18, 0)    NOT NULL,
    INVOICE_NUM               VARCHAR2(200)    NOT NULL,
    VENDOR_SITE_CODE          VARCHAR2(960)    NOT NULL,
    TAX_IDENTIFICATION_NUM    VARCHAR2(80)     NOT NULL,
    VENDOR_NAME               VARCHAR2(320)    NOT NULL,
    TYPE_1099                 VARCHAR2(40) ,
    INVOICE_DATE              DATE         ,
    INVOICE_AMOUNT            NUMBER       ,
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    LEGAL_ENTITY_ID           NUMBER(18, 0)    NOT NULL,
    LOCATION_PROFILE_ID       NUMBER(18, 0),
    VEN_SUMMARY_ID            NUMBER(18, 0),
    PROGRAM_NAME              VARCHAR2(120),
    REQUEST_ID                NUMBER(18, 0),
    PROGRAM_APP_NAME          VARCHAR2(200),
    ESTABLISHMENT_ID          NUMBER(18, 0)    NOT NULL,
    SIREN_ETAB                NUMBER(9, 0) ,
    NIC_ETAB                  NUMBER(5, 0) ,
    SECTION_DAS               VARCHAR2(8)  ,
    VALIDITE                  NUMBER(4, 0) ,
    TYPE_DAS                  VARCHAR2(4)  ,
    TYPE_ENREG                VARCHAR2(12) ,
    SIRET_BENEF               VARCHAR2(56) ,
    NOM                       VARCHAR2(120),
    PRENOM                    VARCHAR2(80) ,
    RAISON_SOCIALE            VARCHAR2(200),
    PROFESSION                VARCHAR2(120),
    ADR_COMPL                 VARCHAR2(128),
    Z1                        VARCHAR2(4)  ,
    ADR_NUM                   VARCHAR2(16) ,
    ADR_TYPE                  VARCHAR2(4)  ,
    Z2                        VARCHAR2(4)  ,
    ADR_VOIE                  VARCHAR2(104),
    ADR_INSEE                 VARCHAR2(20) ,
    Z3                        VARCHAR2(4)  ,
    ADR_COMMUNE               VARCHAR2(104),
    ADR_CPOSTAL               VARCHAR2(20) ,
    Z4                        VARCHAR2(4)  ,
    ADR_BUR_DIST              VARCHAR2(104),
    DHON_H                    NUMBER(10, 0),
    DCOM_C                    NUMBER(10, 0),
    DCO_CO                    NUMBER(10, 0),
    DRIS_R                    NUMBER(10, 0),
    DJE_JP                    NUMBER(10, 0),
    DDA_DA                    NUMBER(10, 0),
    DDI_I                     NUMBER(10, 0),
    DAU_AR                    NUMBER(10, 0),
    INDE                      NUMBER(10, 0),
    AVAN                      NUMBER(10, 0),
    RETE                      NUMBER(10, 0),
    NAT_AVAN_NOUR             VARCHAR2(4)  ,
    NAT_AVAN_LOGE             VARCHAR2(4)  ,
    NAT_AVAN_VOIT             VARCHAR2(4)  ,
    NAT_AVAN_AUTR             VARCHAR2(4)  ,
    Z5                        VARCHAR2(4)  ,
    NAT_RETE_ALLO             VARCHAR2(4)  ,
    NAT_RETE_REMB             VARCHAR2(4)  ,
    NAT_RETE_PRIS             VARCHAR2(4)  ,
    NAT_TVA_REDUI             VARCHAR2(4)  ,
    NAT_TVA_DISPE             VARCHAR2(4)  ,
    TVA_NETTE                 NUMBER(10, 0),
    Z6                        VARCHAR2(960),
    SEGMENT1                  VARCHAR2(120),
    AGE_11                    NUMBER(11, 0),
    SET_OF_BOOKS_ID           NUMBER(18, 0)    NOT NULL,
    VENDOR_SITE_ID            NUMBER(18, 0)    NOT NULL,
    CHECK_NUMBER              NUMBER(18, 0)    NOT NULL,
    INVOICE_NUM               VARCHAR2(200)    NOT NULL,
    VENDOR_SITE_CODE          VARCHAR2(960)    NOT NULL,
    TAX_IDENTIFICATION_NUM    VARCHAR2(80)     NOT NULL,
    VENDOR_NAME               VARCHAR2(320)    NOT NULL,
    TYPE_1099                 VARCHAR2(40) ,
    INVOICE_DATE              DATE         ,
    INVOICE_AMOUNT            NUMBER       ,
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    CONSTRAINT pk_je_fr_das2_ven_summary_t PRIMARY KEY (VEN_SUMMARY_ID, VEN_SUMMARY_ID)
);
