C_FR_OverdueInvoiceItemQuery

French Overdue Invoices - Query | view: CFROVRDINVCITEMQ | Extraction: Not supported | Component: Financials France
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
FR_OvrdInvcRptdAmtInCCCrcy Reported Amount in Company Code Currency of Overdue Invoices
AmountInCompanyCodeCurrency Amount in Company Code Currency
ByKDtEvaldInvcAmtInCoCodeCrcy Invoice Amount Evaluated on Key Date (Company Code Currency)
InvoiceAlreadyPaidAmtInCCCrcy Invoice: Sum of Partial Payment Amounts
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
NetDueArrearsDays Days in Arrears by Net Due Date WRTV3
FR_InvoicePaymentDelaySegment Payment Delay Segment for Invoices CHAR15
FR_OverdueInvoiceItemNumber Number of Overdue Invoices (France) INT4
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_FR_OVERDUEINVOICEITEMQUERY.MANDT == T003.MANDT
  • C_FR_OVERDUEINVOICEITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • C_FR_OVERDUEINVOICEITEMQUERY.MANDT == T001.MANDT
  • C_FR_OVERDUEINVOICEITEMQUERY.COMPANYCODE == T001.BUKRS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_FR_OVERDUEINVOICEITEMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_FR_OVERDUEINVOICEITEMQUERY.MANDT == SKB1.MANDT
  • C_FR_OVERDUEINVOICEITEMQUERY.COMPANYCODE == SKB1.BUKRS
Payment Blocking Reason
  • Payment Blocking Reason
  • Client
  • C_FR_OVERDUEINVOICEITEMQUERY.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • C_FR_OVERDUEINVOICEITEMQUERY.MANDT == T008.MANDT
Special G/L Indicator in French Overdue Invoice
  • ?
  • Client
  • Special G/L Indicator in French Overdue Invoice
  • C_FR_OVERDUEINVOICEITEMQUERY.[column in domain "KOART"] == T074U.KOART
  • C_FR_OVERDUEINVOICEITEMQUERY.MANDT == T074U.MANDT
  • C_FR_OVERDUEINVOICEITEMQUERY.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • C_FR_OVERDUEINVOICEITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_FR_OVERDUEINVOICEITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Transaction Currency
  • Transaction Currency
  • Client
  • C_FR_OVERDUEINVOICEITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_FR_OVERDUEINVOICEITEMQUERY.MANDT == TCURC.MANDT