I_BR_NFITEM

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 Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BR_NFITEM (
    BR_NOTAFISCAL,
    BR_NOTAFISCALITEM,
    _BR_ICMSBASEDETN,
    _BR_ICMSEXEMPTIONREASON,
    _BR_ICMSSTBASEDETN,
    _BR_ICMSTAXSITUATION,
    BASEUNIT,
    BATCH,
    BR_BUSINESSPLACECNAE,
    BR_COFINSSTINNFTOTAL,
    BR_COFINSSTTAXAMOUNT,
    BR_COFINSSTTXINCLUDEDTAXAMOUNT,
    BR_COFINSTAXLAW,
    BR_COFINSTAXSITUATION,
    BR_CSTISSCODE,
    BR_EFDREINFSERVICECODE,
    BR_EFFCTVCALCBASISAMOUNT,
    BR_EFFECTIVEICMSAMOUNT,
    BR_EFFECTIVEICMSRATE,
    BR_EXCLICMSAMTFROMPISANDCOFINS,
    BR_EXEMPTEDICMSAMOUNT,
    BR_EXEMPTEDICMSSTAMOUNT,
    BR_FCINUMBER,
    BR_FCPONICMSDEFERMENTAMOUNT,
    BR_FCPONICMSDEFERMENTPERCENT,
    BR_FCPONICMSDEFERRALTAXRATE,
    BR_FCPONICMSSTWITHHELDAMOUNT,
    BR_FCPONICMSSTWITHHELDBASEAMT,
    BR_FCPONICMSSTWITHHELDRATE,
    BR_ICMSBASEDETN,
    BR_ICMSDEFERMENTAMOUNT,
    BR_ICMSDEFERMENTPERCENT,
    BR_ICMSDEFERRALTAXRATE,
    BR_ICMSEXEMPTIONREASON,
    BR_ICMSSTATISTICALEXEMPTIONAMT,
    BR_ICMSSTBASEDETERMINATION,
    BR_ICMSSTDESTTAXAMOUNT,
    BR_ICMSSTDESTTAXBASEAMOUNT,
    BR_ICMSSTEXEMPTIONREASON,
    BR_ICMSSTMARGINADDEDPERCENT,
    BR_ICMSSTRATEINCLUDINGFCP,
    BR_ICMSTAXLAW,
    BR_ICMSTAXSITUATION,
    BR_INTERNALBARCODE,
    BR_INTERNALTRIBUTARYBARCODE,
    BR_IOFTAXAMOUNT,
    BR_IPICONTROLSEALCODE,
    BR_IPICONTROLSEALQUANTITYVALUE,
    BR_IPITAXLAW,
    BR_IPITAXSITUATION,
    BR_ISSBENEFITCODE,
    BR_ISSSUSPENSIONPROCESS,
    BR_ISSTAXLAW,
    BR_ISSTAXSITUATION,
    BR_LC116SERVICECODE,
    BR_MANUFACTURERCNPJ,
    BR_MATERIALORIGIN,
    BR_MATERIALUSAGE,
    BR_NBSCODE,
    BR_NFADREMICMSDEFERRALPERCENT,
    BR_NFADREMICMSREDUCTIONRATE,
    BR_NFADREMICMSREDUCTIONREASON,
    BR_NFADREMICMSRETAINEDTAXRATE,
    BR_NFAPPROXIMATETOTALTAXAMOUNT,
    BR_NFDISCOUNTAMOUNTWITHTAXES,
    BR_NFESTATISTICALAMOUNT,
    BR_NFEXEMPTEDICMSWITHTAXES,
    BR_NFEXPENSESAMOUNTWITHTAXES,
    BR_NFEXTERNALITEMNUMBER,
    BR_NFFREIGHTAMOUNTWITHTAXES,
    BR_NFFREIGHTNATURE,
    BR_NFINSURANCEAMOUNTWITHTAXES,
    BR_NFISPHYSICALMVTOFMATERIAL,
    BR_NFISSERVICEITEM,
    BR_NFITEMHASTAXINCENTIVE,
    BR_NFITEMISSTATISTICAL,
    BR_NFITEMTYPE,
    BR_NFMONOICMSDEFERREDAMOUNT,
    BR_NFMONOICMSOPERATIONAMOUNT,
    BR_NFMONOICMSRETAINEDAMOUNT,
    BR_NFMONORETAINEDTAXEDQUANTITY,
    BR_NFNETDISCOUNTAMOUNT,
    BR_NFNETFREIGHTAMOUNT,
    BR_NFNETINSURANCEAMOUNT,
    BR_NFNETOTHEREXPENSESAMOUNT,
    BR_NFPARTNERCNAE,
    BR_NFPERCENTRETURNED,
    BR_NFPRICEAMOUNTWITHTAXES,
    BR_NFSOURCEDOCUMENTITEM,
    BR_NFSOURCEDOCUMENTNUMBER,
    BR_NFTOTALAMOUNT,
    BR_NFTOTALAMOUNTWITHTAXES,
    BR_NFTRIBUTARYQUANTITY,
    BR_NFTRIBUTARYUNIT,
    BR_NFVALUEAMOUNTWITHTAXES,
    BR_PISSTINNFTOTAL,
    BR_PISSTTAXAMOUNT,
    BR_PISSTTAXINCLUDEDTAXAMOUNT,
    BR_PISTAXLAW,
    BR_PISTAXSITUATION,
    BR_RECOPINUMBER,
    BR_REDUCNPCTEFFCTVCALCBASIS,
    BR_REFERENCENFITEM,
    BR_REFERENCENFNUMBER,
    BR_SUBSTITUTEICMSAMOUNT,
    BR_TOBACCOBEVERAGEIPICLASSFCTN,
    BR_WITHHOLDINGICMSSTAMOUNT,
    BR_WITHHOLDINGICMSSTBASEAMOUNT,
    COSTCENTER,
    COSTOBJECT,
    CUSTOMSCHARGESAMOUNT,
    GLACCOUNT,
    INTERNALORDER,
    INTERNATIONALARTICLENUMBER,
    ISPRODUCEDINHOUSE,
    MATERIAL,
    MATERIALGROUP,
    MATERIALNAME,
    NCMCODE,
    NETPRICEAMOUNT,
    NETVALUEAMOUNT,
    PLANT,
    PRODUCTIONISINRELEVANTSCALE,
    PROFITCENTER,
    PROJECTNETWORK,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    QUANTITYINBASEUNIT,
    SALESDOCUMENTCURRENCY,
    SEGMENT,
    TAXINCENTIVECODE,
    VALUATIONTYPE,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (BR_NOTAFISCAL, BR_NOTAFISCALITEM)
);