I_BR_NFDOCUMENT

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.

-- Brazil Nota Fiscal Document Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BR_NFDOCUMENT (
    BR_NOTAFISCAL,
    _BR_CTESERVICETYPE,
    _BR_NFDIRECTION,
    _BR_NFISCREATEDMANUALLY,
    _BR_NFMODEL,
    ACCOUNTINGDOCUMENT,
    BR_CTEFISCALDOCUMENTPARTNER,
    BR_CTEJURISDICTIONCODEDEST,
    BR_CTETOTALGOODSAMOUNT,
    BR_ISNFE,
    BR_NFARRIVALORDEPARTUREDATE,
    BR_NFARRIVALORDEPARTURETIME,
    BR_NFAUTHENTICATIONDATE,
    BR_NFAUTHENTICATIONTIME,
    BR_NFAUTHZNPROTOCOLNUMBER,
    BR_NFAUTHZNPROTOCOLNUMBER16,
    BR_NFCOMMITMENTNOTE,
    BR_NFDIRECTION,
    BR_NFDISCOUNTAMOUNT,
    BR_NFDOCUMENTTYPE,
    BR_NFEDOCUMENTSTATUS,
    BR_NFEINTERMEDIATORCNPJ,
    BR_NFEINTERMEDIATORREGISTRY,
    BR_NFEINTERMEDIATORTRANSACTION,
    BR_NFENUMBER,
    BR_NFEXMLVERSION,
    BR_NFEXPORTDISPATCHLOCATION,
    BR_NFEXPORTSHIPMENTPLACE,
    BR_NFEXPORTSHIPMENTREGION,
    BR_NFFISCALCOUPONDOCMODEL,
    BR_NFFISCALYEAR,
    BR_NFHASFOLLOWONDOCUMENT,
    BR_NFHASSERVICEITEM,
    BR_NFISCALCULATEDBYTAXSERVICE,
    BR_NFISCANCELED,
    BR_NFISCHARGINGINVOICE,
    BR_NFISCONTINGENCY,
    BR_NFISCREATEDMANUALLY,
    BR_NFISMUNICIPAL,
    BR_NFISPRINTED,
    BR_NFISSUEDATE,
    BR_NFISSUEDBY,
    BR_NFMODEL,
    BR_NFNETAMOUNT,
    BR_NFNUMBER,
    BR_NFNUMBEROFPACKAGES,
    BR_NFORIGINALAMOUNT,
    BR_NFPARTNER,
    BR_NFPARTNERAUTHORIZATIONGROUP,
    BR_NFPARTNERFUNCTION,
    BR_NFPARTNERNAME1,
    BR_NFPOSTINGDATE,
    BR_NFREFERENCEDOCUMENT,
    BR_NFSERIES,
    BR_NFSHIPPINGUNIT,
    BR_NFSHIPPINGUNITBRAND,
    BR_NFSHIPPINGUNITNUMBER,
    BR_NFSITUATIONCODE,
    BR_NFSUBSERIES,
    BR_NFSVERIFICATIONCODE,
    BR_NFTYPE,
    BR_NFWITHHOLDINGAMOUNT,
    BR_PAYMENTFORM,
    BR_SUFRAMACODE,
    BR_UTILSNFNUMBER,
    BR_WHLDGICMSFORTRANSPCITY,
    BUSINESSPLACE,
    CHANGEAMOUNT,
    COMPANYCODE,
    COMPANYCODENAME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    FERRYBOATID,
    FREIGHTPAYER,
    HEADERGROSSWEIGHT,
    HEADERNETWEIGHT,
    HEADERWEIGHTUNIT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    ISBUSINESSPURPOSECOMPLETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LICENSEPLATE,
    LOGICALSYSTEM,
    MEANSOFTRANSPORT,
    MEANSOFTRANSPORTTYPE,
    PAYMENTTERMS,
    SALESDOCUMENTCURRENCY,
    SHIPPINGPOINT,
    SUGARCANECURMNTHQTYUNIT,
    SUGARCANECURRENTMONTHQTY,
    SUGARCANEHARVEST,
    SUGARCANELASTMNTHQTYUNIT,
    SUGARCANELASTMNTHQUANTITY,
    SUGARCANEREFMONTHYEAR,
    SUGARCANESUMBOTHMNTHSQTYUNIT,
    SUGARCANESUMBOTHMONTHSQTY,
    SUGARCANESUPPLIESNETAMT,
    SUGARCANETOTALDEDUCTIONAMOUNT,
    SUPPLIERINVOICE,
    WAGONID,
    PRIMARY KEY (BR_NOTAFISCAL)
);