FARP_MIV_IVINF

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.

-- manage ap/ar invoice head info
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARP_MIV_IVINF (
    MANDT,                           -- Client [MANDT]
    OUTGOINGINVOICEUUID,             -- Upload Invoice UUID [FARP_MIV_UPLOADINVOICEUUID]
    ACCOUNTINGDOCUMENT,              -- Inv. Doc. No. [RE_BELNR]
    FISCALYEAR,                      -- Fiscal Year [FIS_GJAHR]
    COMPANYCODE,                     -- Company Code [BUKRS]
    DOCUMENTREFERENCEID,             -- Reference [XBLNR1]
    ACCOUNTINGDOCUMENTHEADERTEXT,    -- Doc.Header Text [BKTXT]
    TOTALAMOUNTINTRANSACTIONCRCY,    -- Gross Inv. Amnt [FAP_RECURR_DMBTR_CS]
    INVOICINGPARTY,                  -- Invoicing Party [LIFRE]
    CUSTOMER,                        -- Customer [KUNNR]
    TRANSACTIONCURRENCY,             -- Transaction Currency [FIS_RWCUR]
    ASSIGNMENTREFERENCE,             -- Assignment [FARP_MIV_ZUONR]
    SUPPLIERBANKTYPE,                -- Partner Bank Type [FARP_MIV_BVTYP]
    IBAN,                            -- IBAN [IBAN]
    SWIFTCODE,                       -- SWIFT/BIC [SWIFT]
    PAYMENTTERMS,                    -- Pyt Terms [DZTERM]
    PAYMENTMETHOD,                   -- Pymt Meth. [DZLSCH]
    PAYMENTREFERENCE,                -- Payment Ref. [KIDNO]
    CASHDISCOUNT1DAYS,               -- Cash Discount Days 1 [FARP_MIV_DZBD1T]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [FARP_MIV_DZBD1P]
    CASHDISCOUNT2DAYS,               -- Cash Discount Days 2 [FARP_MIV_DZBD2T]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [FARP_MIV_DZBD2P]
    NETPAYMENTDAYS,                  -- Net Pmt Terms Period [FARP_MIV_DZBD3T]
    HOUSEBANK,                       -- House Bank [HBKID]
    HOUSEBANKACCOUNT,                -- Account ID [HKTID]
    MANUALCASHDISCOUNT,              -- Amount in LC [DMBTR]
    PAYMENTMETHODSUPPLEMENT,         -- Pmnt Meth. Sup. [UZAWE]
    SUPLRINVCPAYMENTBLOCKINGREASON,  -- Pmnt block [DZLSPR]
    TAXDETERMINATIONDATE,            -- Tax Date [TXDAT]
    OUTGOINGINVOICESTATUS,           -- Status [FARP_MIV_STATUS]
    POSTINGDATE,                     -- Posting Date [BUDAT]
    INVOICEDATE,                     -- Run On [LAUFD]
    CREATEDBYUSER,                   -- Created By [ERNAM]
    USERNAME,                        -- Created By [FAC_RJET_RECURRENCE_ENTERED]
    CREATIONDATETIME,                -- Created On [FAP_CREATIONDATETIME]
    LASTCHANGEDBYUSER,               -- Last Changed By [FAP_LASTCHGBY]
    LASTCHANGEDATETIME,              -- Last Changed On [FAP_LASTCHANGEDATETIME]
    SUPPLIERINVOICETRANSACTIONTYPE,  -- Transaction [INV_TRAN]
    ACCOUNTINGDOCUMENTTYPE,          -- Document Type [FARP_RECURR_BLART]
    PAYMENTBLOCKINGREASON,           -- Payment Block [DZAHLS]
    DUECALCULATIONBASEDATE,          -- Baseline Date [FARP_MIV_DZFBDT]
    CASHDISCOUNTAMOUNT,              -- Cash Discount Amount [FIS_WSKTO]
    ELIGIBLEAMOUNTFORCSHDISCINTC,    -- Cash Discount Base [FARP_MIV_SKFBT]
    INVOICEREFERENCE,                -- Invoice Reference [FIS_REBZG]
    INVOICEITEMREFERENCE,            -- Invoice Item Reference [FIS_REBZZ]
    DATAEXCHANGEINSTRUCTION1,        -- Instruction 1 [FARP_DTAT16]
    DATAEXCHANGEINSTRUCTION2,        -- Instruction 2 [FARP_DTAT17]
    DATAEXCHANGEINSTRUCTION3,        -- Instruction 3 [FARP_DTAT18]
    DATAEXCHANGEINSTRUCTION4,        -- Instruction 4 [FARP_DTAT19]
    PAYMENTDIFFERENCEREASON,         -- Reason Code [FARP_RSTGR]
    FIXEDCASHDISCOUNT,               -- Fixed [DZBFIX]
    DOCUMENTITEMTEXT,                -- Text [SGTXT]
    BUSINESSAREA,                    -- Business Area [GSBER]
    PARTNERBUSINESSAREA,             -- Partner Bus. Area [FIS_PARGB]
    TREASURYCONTRACT,                -- Contract Number [RANL]
    TREASURYCONTRACTTYPE,            -- Contract Type [RANTYP]
    REFERENCE1IDBYBUSINESSPARTNER,   -- Reference Key 1 [FARP_XREF1]
    REFERENCE2IDBYBUSINESSPARTNER,   -- Reference Key 2 [FARP_XREF2]
    REFERENCE3IDBYBUSINESSPARTNER,   -- Reference Key 3 [FARP_XREF3]
    STATECENTRALBANKPAYMENTREASON,   -- SCB Ind. [LZBKZ]
    SUPPLYINGCOUNTRY,                -- Supply C/R [LANDL]
    RECRRGSUPLRINVCISSRVCINVOICE,    -- Service Ind. [DIEKZ]
    FINTRANSFLOWTYPE,                -- Flow Type [TB_SFHAZBA]
    CREDITCONTROLAREA,               -- Credit Control Area [FARP_KKBER]
    COMPANYCODECOUNTRY,              -- Reporting C/R [EGMLD_BSEZ]
    ISEUTRIANGULARDEAL,              -- EU Triang. Deal [XEGDR]
    PLANNINGLEVEL,                   -- Planning Level [FDLEV]
    PLANNINGDATE,                    -- Planning Date [FARP_MIV_PLAN_DATE]
    ISNEGATIVEPOSTING,               -- Negative Posting [FARP_XNEGP]
    TAXREPORTINGDATE,                -- Tax Reporting Date [VATDATE]
    TAXFULFILLMENTDATE,              -- Tax Fulfill. Date [FOT_FULFILLDATE]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    EXCHANGERATE,                    -- Exchange Rate [FIS_EXCHANGE_RATE]
    RAITEMTRANSLATIONDATE,           -- Translatn Date [WWERT_D]
    BUSINESSPLACE,                   -- Business Place [FARP_BUPLA]
    BUSINESSSECTIONCODE,             -- Section Code [SECCO]
    INVOICEREFERENCEFISCALYEAR,      -- Invoice Reference Fiscal Year [FIS_REBZJ]
    RECONCILIATIONACCOUNT,           -- Recon. Account [FARP_AKONT]
    CREATIONDATE,                    -- Created On [FARP_RECURR_CPDAT]
    FINPLANAPPLICATIONLOGHANDLE,     -- Handle [BALLOGHNDL]
    APPLICATIONLOGHANDLE,            -- Handle [BALLOGHNDL]
    EVENTHANDLERTYPEDESCRIPTION,     -- Formula [FARR_FORMULA]
    SITNTYPEDESCRIPTION,             -- Formula [FARR_FORMULA]
    UPLOADBATCHUUID,                 -- Upload Batch UUID [FARP_MIV_UPLOADBATCHUUID]
    DOCUMENTSEQUENCENO,              -- Doc. Sequence Number [FARP_MIV_DOC_SEQ_NO]
    ONETIMEACCOUNTBPSALUTATIONTEXT,  -- Title [ANRED]
    BUSINESSPARTNERNAME1,            -- Name [AD_NAME1]
    BUSINESSPARTNERNAME2,            -- Name 2 [AD_NAME2]
    BUSINESSPARTNERNAME3,            -- Name 3 [AD_NAME3]
    BUSINESSPARTNERNAME4,            -- Name 4 [AD_NAME4]
    STREETNAME,                      -- Street [STRAS_GP]
    CITYNAME,                        -- City [ORT01_GP]
    POSTALCODE,                      -- Postal Code [PSTLZ]
    POBOX,                           -- PO Box [PFACH]
    POBOXISWITHOUTNUMBER,            -- PO Box w/o No. [AD_POBXNUM]
    POBOXPOSTALCODE,                 -- PO Box Postal Code [FIS_AD_PSTCD2]
    COUNTRY,                         -- Country/Region Key [LAND1_GP]
    REGION,                          -- Region [REGIO]
    EMAILADDRESS,                    -- E-Mail Address [AD_SMTPADR]
    BANKCOUNTRY,                     -- Bank Ctry/Reg. [BANKS]
    BANKINTERNALID,                  -- Bank Key [BANKK]
    BANKACCOUNT,                     -- Bank Account [BANKN]
    BANKREFERENCE,                   -- Bank Reference [REFBK]
    BANKCONTROLKEY,                  -- Control Key [BKONT]
    PAYMENTSYSTEM,                   -- Payment System [PAYMENT_SYSTEM_ID]
    ALIASTYPE,                       -- Alias Type [ALIAS_TYPE_ID]
    BPBANKACCOUNTALIASNAME,          -- Bank Account Alias [BU_BANK_ALIAS]
    ISVATLIABLE,                     -- Liable for VAT [STKZU]
    ACCOUNTTAXTYPE,                  -- Tax Type [J_1AFITP_D]
    TAXNUMBERTYPE,                   -- Tax number type [J_1ATOID]
    TAXID1,                          -- Tax Number 1 [STCD1]
    TAXID2,                          -- Tax Number 2 [STCD2]
    TAXID3,                          -- Tax Number 3 [STCD3]
    TAXID4,                          -- Tax Number 4 [STCD4]
    TAXID5,                          -- Tax Number 5 [STCD5]
    VATREGISTRATION,                 -- VAT Registration No. [FARP_STCEG]
    ISNATURALPERSON,                 -- Natural person [STKZN]
    ONETMEACCTISEQUALIZATIONTXSUBJ,  -- Equalizatn tax [STKZA]
    BUSINESSTYPE,                    -- Type of Business [GESTYP]
    INDUSTRYTYPE,                    -- Type of Industry [INDTYP]
    REPRESENTATIVENAME,              -- Rep's Name [REPRES]
    DATAEXCHANGEINSTRUCTIONKEY,      -- Instruction [FARP_DTAWS]
    DATAMEDIUMEXCHANGEINDICATOR,     -- DME Rec. Code [DTAMS]
    ALTERNATIVEPAYEEISALLOWED,       -- Payee in doc. [XZEMP]
    ISONETIMEACCOUNT,                -- One-time acct [XCPDK]
    ADDRESSANDBANKISSETMANUALLY,     -- Address and Bank is Set Manually [FARP_XCPDD]
    PRIMARY KEY (MANDT, OUTGOINGINVOICEUUID)
);