I_RU_VATREPORTINGITEMLOG

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.

-- VAT Reporting Items Log
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RU_VATREPORTINGITEMLOG (
    ACCOUNTINGDOCUMENT,
    AGENT,
    AGENTISORGANIZATION,
    AGENTORGANIZATIONNAME,
    AGENTPERSONMIDDLENAME,
    AGENTPERSONNAME,
    AGENTPERSONSURNAME,
    BASEAMTWITHOUTTXINCCCRCY,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERISORGANIZATION,
    BUSINESSPARTNERNAME,
    COMMSNTRADEINVCLINKEDVATAMOUNT,
    COMMSNTRADEINVOICELINKEDAMOUNT,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CORRECTIONINVOICE,
    CORRECTIONINVOICEDATE,
    CORRECTIONINVOICEREVISIONDATE,
    CORRECTIONINVOICEREVISIONNMBR,
    CORRECTIONINVOICEYEAR,
    CURRENCY,
    CURRENCYISOCODE,
    DIFFERENCEAMTINTRANSCRCY,
    DIFFERENCETAXAMTINTRANSCRCY,
    EXPORTINVCCONFIRMEDFISCALYEAR,
    EXTERNALCORRECTIONINVOICE,
    EXTERNALINVOICE,
    FIRSTNAME,
    FISCALPERIOD,
    FISCALYEAR,
    INCGINVOICETRANSCRCYISOCODE,
    INCOMINGCORRECTIONINVOICE,
    INCOMINGCORRECTIONINVOICEYEAR,
    INCOMINGEXTERNALINVOICE,
    INCOMINGINVOICETRANSCURRENCY,
    INCOMINGREVISIONNUMBER,
    INVOICE,
    INVOICEDATE,
    INVOICEYEAR,
    ISNATURALPERSON,
    ISREVERSAL,
    ISREVERSED,
    LASTNAME,
    MIDDLENAME,
    ORIGINALAMOUNTINTRANSACCRCY,
    ORIGINALINVOICEREVISIONDATE,
    ORIGINALINVOICEREVISIONNUMBER,
    ORIGINALTAXAMOUNTINTRANSACCRCY,
    REVISIONINVOICE,
    REVISIONINVOICEYEAR,
    REVISIONNUMBER,
    RU_AGENTORGANIZATIONINN,
    RU_AGENTORGANIZATIONKPP,
    RU_AGENTPERSONINN,
    RU_INCOMINGINVOICECOMPANYCODE,
    RU_INCOMINGINVOICEDATE,
    RU_INCOMINGINVOICEFISCALYEAR,
    RU_INCOMINGINVOICENUMBER,
    RU_INCOMINGINVOICETYPE,
    RU_INVOICETYPE,
    RU_PARTNERORGANIZATIONINN,
    RU_PARTNERORGANIZATIONKPP,
    RU_PARTNERPERSONINN,
    RU_TERRITORYCLASSFCTNOKTMO,
    RU_VATOPERATIONTYPE,
    RU_VATRETURNLINE,
    RU_VATRETURNSECTION,
    RU_VATRETURNSECTIONTYPE,
    RU_VATRETURNVERSION,
    RU_VATSCENARIO,
    RU_VATSUBSCENARIO,
    RU_VATSUBSCENARIOVERSION,
    SALESDEALTYPE,
    SIGN,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTFISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINTRANSCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXITEM,
    TAXITEMGROUPINGVERSION,
    TAXREPORTINGDATE,
    TOTALAMOUNTINCOCODECRCY,
    TOTALAMOUNTINTRANSACTIONCRCY,
    TXAMTWITHTXRATE10INCCCRCY,
    TXAMTWITHTXRATE18INCCCRCY,
    TXAMTWITHTXRATE20INCCCRCY,
    TXBASEAMTWITHTXRATE0INCCCRCY,
    TXBASEAMTWITHTXRATE10INCCCRCY,
    TXBASEAMTWITHTXRATE18INCCCRCY,
    TXBASEAMTWITHTXRATE20INCCCRCY,
    VATRETURNOPERATION
);