C_NL_SAFTJournalItemCube

SAF-T NL Journal Item Cube | view: CNLSAFTJITEMC | TRAN | Extraction: Not supported | Component: Netherlands
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
DefaultDebitCreditCode null
InvoiceReference Reversal Reference Document AWREF
Quantity null
TaxCode Tax on Sales/Purchases Code MWSKZ
TaxRate null
BusinessPartner null
OrderDocument null
ShipmentDocument null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_NL_SAFTJOURNALITEMCUBE.COMPANYCODE == T001.BUKRS
  • C_NL_SAFTJOURNALITEMCUBE.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_NL_SAFTJOURNALITEMCUBE.MANDT == TCURC.MANDT
  • C_NL_SAFTJOURNALITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • C_NL_SAFTJOURNALITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • C_NL_SAFTJOURNALITEMCUBE.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • C_NL_SAFTJOURNALITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • C_NL_SAFTJOURNALITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • C_NL_SAFTJOURNALITEMCUBE.MANDT == CSKS.MANDT
  • C_NL_SAFTJOURNALITEMCUBE.COSTCENTER == CSKS.KOSTL
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting