I_LU_SAFTJournalEntry

SAFT LU General Ledger Documents | view: ILUSAFTGLENTRY | Extraction: Not supported | Component: SAF-T Luxembourg
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
Ledger FK Ledger in General Ledger Accounting
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
AccountingDocumentCreationDate Accounting Document Entry Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
IsReversal Indicator: Item is Reversing Another Item Show values
Column Name Description Domain name
DocumentTransaction null
FiscalPeriod Fiscal Period POPER
AccountingDocCreatedByUser User that created the journal entry
ExchangeRate Absolute Exchange Rate FIS_UKURS
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
LedgerFiscalYear Ledger Fiscal Year GJAHR
DocumentItemText Item Text TEXT50
AccountingDocumentItemType Identification of the Line Item CHAR1
VATRegistration null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_LU_SAFTJOURNALENTRY.MANDT == T003.MANDT
  • I_LU_SAFTJOURNALENTRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_LU_SAFTJOURNALENTRY.CHARTOFACCOUNTS == T004.KTOPL
  • I_LU_SAFTJOURNALENTRY.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_LU_SAFTJOURNALENTRY.COMPANYCODE == T001.BUKRS
  • I_LU_SAFTJOURNALENTRY.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_LU_SAFTJOURNALENTRY.COMPANYCODECURRENCY == TCURC.WAERS
  • I_LU_SAFTJOURNALENTRY.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • I_LU_SAFTJOURNALENTRY.CUSTOMER == KNA1.KUNNR
  • I_LU_SAFTJOURNALENTRY.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_LU_SAFTJOURNALENTRY.GLACCOUNT == SKB1.SAKNR
  • I_LU_SAFTJOURNALENTRY.COMPANYCODE == SKB1.BUKRS
  • I_LU_SAFTJOURNALENTRY.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Special G/L Indicator
  • Client
  • Account Type
  • Special G/L Indicator
  • I_LU_SAFTJOURNALENTRY.MANDT == T074U.MANDT
  • I_LU_SAFTJOURNALENTRY.FINANCIALACCOUNTTYPE == T074U.KOART
  • I_LU_SAFTJOURNALENTRY.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Supplier
  • Client
  • I_LU_SAFTJOURNALENTRY.SUPPLIER == LFA1.LIFNR
  • I_LU_SAFTJOURNALENTRY.MANDT == LFA1.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • I_LU_SAFTJOURNALENTRY.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_LU_SAFTJOURNALENTRY.MANDT == T683.MANDT
  • I_LU_SAFTJOURNALENTRY.[column in domain "KVEWE"] == T683.KVEWE
  • I_LU_SAFTJOURNALENTRY.[column in domain "KAPPL"] == T683.KAPPL
Tax on Sales/Purchases Code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax on Sales/Purchases Code
  • Client
  • I_LU_SAFTJOURNALENTRY.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • I_LU_SAFTJOURNALENTRY.TAXCODE == T007A.MWSKZ
  • I_LU_SAFTJOURNALENTRY.MANDT == T007A.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • I_LU_SAFTJOURNALENTRY.MANDT == TCURC.MANDT
  • I_LU_SAFTJOURNALENTRY.TRANSACTIONCURRENCY == TCURC.WAERS