P_NO_SAFTJournalItem

SAF-T Journal Item | view: PNOSAFTJI | Extraction: Not supported | Component: Financials Norway
Tables used: ACDOCABSEGT003TT001T014FINSC_LEDGER_REP
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):
DebitAmountInCoCodeCrcy Amount in Company Code Currency
CreditAmountInCoCodeCrcy null
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy Amount in Transaction Currency
CreditAmountInTransCrcy null
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
CreationDate Creation Date
DueCalculationBaseDate Due Calculation Base Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
CreationTime null
JournalEntryType null
PersonnelNumber Personnel Number PERNR
AccountingDocumentTypeName null
TransactionTypeDetermination Transaction Key CHAR3
DocumentItemText Item Text TEXT50
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
VATRegistration null
AccountingDocumentItemType null
BillingDocument null
PaymentReference null
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_NO_SAFTJOURNALITEM.MANDT == T003.MANDT
  • P_NO_SAFTJOURNALITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • P_NO_SAFTJOURNALITEM.MANDT == T001.MANDT
  • P_NO_SAFTJOURNALITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_NO_SAFTJOURNALITEM.MANDT == TCURC.MANDT
  • P_NO_SAFTJOURNALITEM.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • P_NO_SAFTJOURNALITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_NO_SAFTJOURNALITEM.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_NO_SAFTJOURNALITEM.COSTCENTER == CSKS.KOSTL
  • P_NO_SAFTJOURNALITEM.MANDT == CSKS.MANDT
Customer Number
  • Client
  • Customer Number
  • P_NO_SAFTJOURNALITEM.MANDT == KNA1.MANDT
  • P_NO_SAFTJOURNALITEM.CUSTOMER == KNA1.KUNNR
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_NO_SAFTJOURNALITEM.MANDT == SKB1.MANDT
  • P_NO_SAFTJOURNALITEM.GLACCOUNT == SKB1.SAKNR
  • P_NO_SAFTJOURNALITEM.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Logical System P_NO_SAFTJOURNALITEM.LOGICALSYSTEM == TBDLS.LOGSYS
Order ID
  • Order ID
  • Client
  • P_NO_SAFTJOURNALITEM.ORDERID == AUFK.AUFNR
  • P_NO_SAFTJOURNALITEM.MANDT == AUFK.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • Account Type
  • P_NO_SAFTJOURNALITEM.MANDT == T074U.MANDT
  • P_NO_SAFTJOURNALITEM.SPECIALGLCODE == T074U.UMSKZ
  • P_NO_SAFTJOURNALITEM.FINANCIALACCOUNTTYPE == T074U.KOART
Supplier
  • Client
  • Supplier
  • P_NO_SAFTJOURNALITEM.MANDT == LFA1.MANDT
  • P_NO_SAFTJOURNALITEM.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • ?
  • Client
  • Tax on Sales/Purchases Code
  • P_NO_SAFTJOURNALITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_NO_SAFTJOURNALITEM.MANDT == T007A.MANDT
  • P_NO_SAFTJOURNALITEM.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • P_NO_SAFTJOURNALITEM.MANDT == TCURC.MANDT
  • P_NO_SAFTJOURNALITEM.TRANSACTIONCURRENCY == TCURC.WAERS