C_NO_SAFTJournalItemQuery

SAF-T Norway Journal Item Query | view: CNOSAFTJITMQ | Extraction: Not supported | Component: Financials Norway
Tables used: BSECACDOCABSEGT003TKNA1LFA1T001T014FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInTransCrcy Amount in Transaction Currency
CreditAmountInTransCrcy null
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Amount in Company Code Currency
CreditAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
CashDiscount1DueDate Due Calculation Base Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
Customer null
Supplier null
PersonnelNumber Personnel Number PERNR
DocumentItemText Item Text TEXT50
TotalAmountCurrency null
CreditAmountCurrency null
LastChangeDateTime null
TransactionTypeDetermination Transaction Key CHAR3
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_NO_SAFTJOURNALITEMQUERY.MANDT == T001.MANDT
  • C_NO_SAFTJOURNALITEMQUERY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_NO_SAFTJOURNALITEMQUERY.MANDT == TCURC.MANDT
  • C_NO_SAFTJOURNALITEMQUERY.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • C_NO_SAFTJOURNALITEMQUERY.CONTROLLINGAREA == TKA01.KOKRS
  • C_NO_SAFTJOURNALITEMQUERY.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • Cost Center
  • ?
  • C_NO_SAFTJOURNALITEMQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_NO_SAFTJOURNALITEMQUERY.MANDT == CSKS.MANDT
  • C_NO_SAFTJOURNALITEMQUERY.COSTCENTER == CSKS.KOSTL
  • C_NO_SAFTJOURNALITEMQUERY.[column in domain "DATBI"] == CSKS.DATBI
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_NO_SAFTJOURNALITEMQUERY.MANDT == SKB1.MANDT
  • C_NO_SAFTJOURNALITEMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_NO_SAFTJOURNALITEMQUERY.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Order ID
  • Order ID
  • Client
  • C_NO_SAFTJOURNALITEMQUERY.ORDERID == AUFK.AUFNR
  • C_NO_SAFTJOURNALITEMQUERY.MANDT == AUFK.MANDT
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • Client
  • ?
  • C_NO_SAFTJOURNALITEMQUERY.TAXCODE == T007A.MWSKZ
  • C_NO_SAFTJOURNALITEMQUERY.MANDT == T007A.MANDT
  • C_NO_SAFTJOURNALITEMQUERY.[column in domain "KALSM_D"] == T007A.KALSM
Transaction Currency
  • Client
  • Transaction Currency
  • C_NO_SAFTJOURNALITEMQUERY.MANDT == TCURC.MANDT
  • C_NO_SAFTJOURNALITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS