C_NL_SAFTJournalEntryQry

SAF-T NL Journal Header Query | view: CSAFTJEQRY | Extraction: Not supported | Component: Netherlands
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
Ledger null
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TotalGrossAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
AccountingDocumentHeaderText Document Header Text TEXT25
FiscalPeriod Fiscal Period POPER
DebitCreditCode null
CAReconciliationKey Reconciliation Key for General Ledger FIKEY_KK
ReferenceDocumentType Reference Document Type AWTYP
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_NL_SAFTJOURNALENTRYQRY.COMPANYCODE == T001.BUKRS
  • C_NL_SAFTJOURNALENTRYQRY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_NL_SAFTJOURNALENTRYQRY.MANDT == TCURC.MANDT
  • C_NL_SAFTJOURNALENTRYQRY.COMPANYCODECURRENCY == TCURC.WAERS
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_NL_SAFTJOURNALENTRYQRY.JOURNALENTRYTYPE == T003.BLART
  • C_NL_SAFTJOURNALENTRYQRY.MANDT == T003.MANDT