NFBRIEF

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NFBRIEF (
    BR_NOTAFISCAL,
    BR_NOTAFISCALITEM,
    BASEUNIT,
    BATCH,
    BR_BUSINESSPLACECNAE,
    BR_COFINSSTINNFTOTAL,
    BR_COFINSSTTAXAMOUNT,
    BR_COFINSSTTXINCLUDEDTAXAMOUNT,
    BR_EFDREINFSERVICECODE,
    BR_EXCLICMSAMTFROMPISANDCOFINS,
    BR_EXEMPTEDICMSSTAMOUNT,
    BR_FCINUMBER,
    BR_FCPONICMSDEFERMENTAMOUNT,
    BR_FCPONICMSDEFERMENTPERCENT,
    BR_FCPONICMSDEFERRALTAXRATE,
    BR_FSCLBNFTCODETXBASEREDUCTION,
    BR_ICMSDEFERMENTPERCENT,
    BR_ICMSSTEXEMPTIONREASON,
    BR_INTERNALBARCODE,
    BR_INTERNALTRIBUTARYBARCODE,
    BR_ISSSUSPENSIONPROCESS,
    BR_LC116SERVICECODE,
    BR_MANUFACTURERCNPJ,
    BR_MANUFACTURERCNPJ_2,
    BR_MATERIALORIGIN,
    BR_MATERIALUSAGE,
    BR_NBSCODE,
    BR_NFADREMICMSDEFERRALPERCENT,
    BR_NFADREMICMSREDUCTIONRATE,
    BR_NFADREMICMSREDUCTIONREASON,
    BR_NFADREMICMSRETAINEDTAXRATE,
    BR_NFAPPROXIMATETOTALTAXAMOUNT,
    BR_NFESTATISTICALAMOUNT,
    BR_NFEXTERNALITEMNUMBER,
    BR_NFFREIGHTNATURE,
    BR_NFISSERVICEITEM,
    BR_NFITEMISSTATISTICAL,
    BR_NFMONOICMSDEFERREDAMOUNT,
    BR_NFMONOICMSOPERATIONAMOUNT,
    BR_NFMONOICMSRETAINEDAMOUNT,
    BR_NFMONORETAINEDTAXEDQUANTITY,
    BR_NFPARTNERCNAE,
    BR_NFPERCENTRETURNED,
    BR_NFTRIBUTARYQUANTITY,
    BR_NFTRIBUTARYUNIT,
    BR_PISSTINNFTOTAL,
    BR_PISSTTAXAMOUNT,
    BR_PISSTTAXINCLUDEDTAXAMOUNT,
    BR_RECOPINUMBER,
    GLACCOUNT,
    INTERNATIONALARTICLENUMBER,
    ISPRODUCEDINHOUSE,
    MATERIAL,
    MATERIALGROUP,
    MATERIALNAME,
    PLANT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    QUANTITYINBASEUNIT,
    TAXINCENTIVECODE,
    VALUATIONTYPE,
    PRIMARY KEY (BR_NOTAFISCAL, BR_NOTAFISCALITEM)
);