P_BR_RPTGNFDATAAGGREGATION

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- EFD - Nota Fiscal Data - Aggregation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BR_RPTGNFDATAAGGREGATION (
    BR_NOTAFISCAL,
    BR_NOTAFISCALITEM,
    COMPANYCODE,
    BR_CTEACCESSKEY,
    BR_CTEDOCUMENTTYPE,
    BR_CTEJURISDICTIONCODEDEST,
    BR_CTEJURISDICTIONCODEORIGIN,
    BR_FCPONICMSTAXAMOUNT,
    BR_ICMSDESTINATIONTAXAMOUNT,
    BR_ICMSORIGINTAXAMOUNT,
    BR_ICMSTAXAMOUNT,
    BR_ICMSTAXBASEAMOUNT,
    BR_ICMSTAXEXCLUDEDBASEAMOUNT,
    BR_ICMSTAXOTHERBASEAMOUNT,
    BR_NFARRIVALORDEPARTUREDATE,
    BR_NFDIRECTION,
    BR_NFDISCOUNTAMOUNTWITHTAXES,
    BR_NFENUMBER,
    BR_NFISSUEDATE,
    BR_NFISSUEDBY,
    BR_NFMODEL,
    BR_NFPARTNER,
    BR_NFPARTNERREGIONCODE,
    BR_NFPOSTINGDATE,
    BR_NFREFERENCEDOCUMENT,
    BR_NFSERIES,
    BR_NFSITUATIONCODE,
    BR_NFSUBSERIES,
    BR_NFTOTALAMOUNT,
    BUSINESSPLACE,
    FREIGHTPAYER,
    NFHEADERTOTALAMOUNT,
    SALESDOCUMENTCURRENCY,
    PRIMARY KEY (BR_NOTAFISCAL, BR_NOTAFISCALITEM, COMPANYCODE)
);