C_NL_SAFTJournalItemQry

SAF-T NL Journal Item Query | view: CSAFTJIQRY | Extraction: Not supported | Component: Netherlands
Tables used: VBRK, VBRP, CFIN_AV_PO_ITEM, CFIN_AV_PO_RO, CFIN_AV_PO_ROOT, MATDOC, EKKO, EKPO, ACDOCA, BKPF, BSEG, BSET, EKBE, BUT020, BUT021_FS, BUT000, CFIN_AV_CI_ROOT, CFIN_AV_CI_ITEM, T001, TKA02, T005, CVI_CUST_LINK, SKB1, CVI_VEND_LINK, TB008S, TB008U, T014, FINSC_LEDGER_REP, SAFT_NLC_GENERIC
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Credit Amount in Company Code Currency
TaxAmount Amount in document currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
GLAccount Alternative G/L Account Number In Company Code SAKNR
ReferenceDocument Reference document number AWREF
DocumentItemText Item Text TEXT50
DebitCreditCode null
BusinessPartner null
InvoiceReference Reversal Reference Document AWREF
OrderDocument null
ShipmentDocument null
Quantity null
TaxCode Tax on Sales/Purchases Code MWSKZ
TaxRate null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_NL_SAFTJOURNALITEMQRY.COMPANYCODE == T001.BUKRS
  • C_NL_SAFTJOURNALITEMQRY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_NL_SAFTJOURNALITEMQRY.MANDT == TCURC.MANDT
  • C_NL_SAFTJOURNALITEMQRY.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • C_NL_SAFTJOURNALITEMQRY.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_NL_SAFTJOURNALITEMQRY.COSTCENTER == CSKS.KOSTL
  • C_NL_SAFTJOURNALITEMQRY.[column in domain "DATBI"] == CSKS.DATBI
  • C_NL_SAFTJOURNALITEMQRY.MANDT == CSKS.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client