CREATE OR REPLACE VIEW ASPORT2.V_YOSOU
    (CHK_YEAR,CHK_MONTH,TANCD,YOSOUAMT,ARAYOSOUAMT)
AS
SELECT
    TR_YOSOU.CHK_YEAR ,
    TR_YOSOU.CHK_MONTH,
    TR_YOSOU.TANCD,
    SUM(TR_YOSOU.YOSOUAMT) YOSOUAMT,
    SUM(TR_YOSOU.ARAYOSOUAMT) ARAYOSOUAMT
FROM
    BR_CUSTOMER LEFT OUTER JOIN TR_YOSOU ON BR_CUSTOMER.TOKCD = TR_YOSOU.TOKCD AND BR_CUSTOMER.TANCD = TR_YOSOU.TANCD
GROUP BY
    TR_YOSOU.CHK_YEAR,
    TR_YOSOU.CHK_MONTH,
    TR_YOSOU.TANCD
;

CREATE OR REPLACE VIEW ASPORT2.V_JISSEKIYY
    (年度,BUKA,TANTO,得意先コード,SUMKBN,GYOKBN,URI1,URI2,URI3,URI4,URI5,
    URI6,URI7,URI8,URI9,URI10,URI11,URI12,ARA1,ARA2,ARA3,ARA4,ARA5,ARA6,
    ARA7,ARA8,ARA9,ARA10,ARA11,ARA12,MOK1,MOK2,MOK3,MOK4,MOK5,MOK6,MOK7,
    MOK8,MOK9,MOK10,MOK11,MOK12,BUKASEQ,TANTOSEQ,MOKYY,ELSEFLG,ARAMOK1,
    ARAMOK2,ARAMOK3,ARAMOK4,ARAMOK5,ARAMOK6,ARAMOK7,ARAMOK8,ARAMOK9,ARAMOK10,
    ARAMOK11,ARAMOK12,ARAMOKYY)
AS
SELECT
    年度,
    BUKA,
    TANTO,
    得意先コード,
    SUMKBN,
    GYOKBN,
    URI1,
    URI2,
    URI3,
    URI4,
    URI5,
    URI6,
    URI7,
    URI8,
    URI9,
    URI10,
    URI11,
    URI12,
    ARA1,
    ARA2,
    ARA3,
    ARA4,
    ARA5,
    ARA6,
    ARA7,
    ARA8,
    ARA9,
    ARA10,
    ARA11,
    ARA12,
    MOK1,
    MOK2,
    MOK3,
    MOK4,
    MOK5,
    MOK6,
    MOK7,
    MOK8,
    MOK9,
    MOK10,
    MOK11,
    MOK12,
    BUKASEQ,
    TANTOSEQ,
    MOKYY,
    NVL2(TR_JISSEKI_TOKU.TANCD, 0, 1) ELSEFLG,
    ARAMOK1,
    ARAMOK2,
    ARAMOK3,
    ARAMOK4,
    ARAMOK5,
    ARAMOK6,
    ARAMOK7,
    ARAMOK8,
    ARAMOK9,
    ARAMOK10,
    ARAMOK11,
    ARAMOK12,
    ARAMOKYY
FROM
    TR_JISSEKIYY LEFT OUTER JOIN TR_JISSEKI_TOKU ON TR_JISSEKIYY.TANTO = TR_JISSEKI_TOKU.TANCD AND TR_JISSEKIYY.得意先コード = TR_JISSEKI_TOKU.TOKCD
;