C_NO_SAFTJournalItemCube

SAF-T Norway Journal Item Cube | view: CNOSAFTJITMC | TRAN | Extraction: Not supported | Component: Financials Norway
Tables used: BSECACDOCABSEGT003TKNA1LFA1T001T014FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Amount in Transaction Currency
CreditAmountInTransCrcy null
ExchRateDiffAmtInAddlCrcy1 Exchange Rate Difference Realized for Second Local Currency
ExchRateDiffAmtInAddlCrcy2 Exchange Rate Difference Realized for Second Local Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Amount in Company Code Currency
CreditAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
ValueDate Value date
CashDiscount1DueDate Due Calculation Base Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
Column Name Description Domain name
Customer null
Supplier null
JournalEntryType null
DocumentTransaction null
TaxCountry Tax Reporting Country/Region LAND1
PersonnelNumber Personnel Number PERNR
WBSElement WBS Element FIS_WBS
DocumentItemText Item Text TEXT50
PaymentReference Payment Reference CHAR30
AccountingDocumentItemType Identification of the Line Item CHAR1
TotalAmountCurrency null
CreditAmountCurrency null
LastChangeDateTime null
TransactionTypeDetermination Transaction Key CHAR3
NO_SAFTSourceDocument SAF-T NO : Source Document ID
ReferenceDocument null
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
SalesDocumentItem Sales Document Item POSNR
ReversalReferenceDocument Reversal Reference Document AWREF
ExchangeRate Exchange Rate UKURS
AccountingDocumentTypeName null
DocumentReferenceID null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == T003.MANDT
  • C_NO_SAFTJOURNALITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • C_NO_SAFTJOURNALITEMCUBE.COMPANYCODE == T001.BUKRS
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_NO_SAFTJOURNALITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_NO_SAFTJOURNALITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • C_NO_SAFTJOURNALITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • C_NO_SAFTJOURNALITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == CSKS.MANDT
  • C_NO_SAFTJOURNALITEMCUBE.COSTCENTER == CSKS.KOSTL
G/L Account
  • Company Code
  • Client
  • G/L Account
  • C_NO_SAFTJOURNALITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == SKB1.MANDT
  • C_NO_SAFTJOURNALITEMCUBE.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Order ID
  • Order ID
  • Client
  • C_NO_SAFTJOURNALITEMCUBE.ORDERID == AUFK.AUFNR
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == AUFK.MANDT
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • Client
  • ?
  • C_NO_SAFTJOURNALITEMCUBE.TAXCODE == T007A.MWSKZ
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == T007A.MANDT
  • C_NO_SAFTJOURNALITEMCUBE.[column in domain "KALSM_D"] == T007A.KALSM
Transaction Currency
  • Transaction Currency
  • Client
  • C_NO_SAFTJOURNALITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_NO_SAFTJOURNALITEMCUBE.MANDT == TCURC.MANDT