I_PH_JournalEntryCube

PH CAS General Journal Cube | view: IPHGENJRNLCUBE | TRAN | Extraction: Full only | Component: Financials Philippines
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 (Currency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
GLAccountLongName G/L Account Long Text TEXT50
AccountingDocumentTypeName Document Type Name TEXT20
ClearingAccountingDocument Clearing Journal Entry BELNR
DocumentReferenceID Document Reference ID XBLNR1
OriginalReferenceDocument null
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_PH_JOURNALENTRYCUBE.MANDT == T003.MANDT
  • I_PH_JOURNALENTRYCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Business Area
  • Client
  • I_PH_JOURNALENTRYCUBE.BUSINESSAREA == TGSB.GSBER
  • I_PH_JOURNALENTRYCUBE.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • I_PH_JOURNALENTRYCUBE.MANDT == T001.MANDT
  • I_PH_JOURNALENTRYCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_PH_JOURNALENTRYCUBE.MANDT == TCURC.MANDT
  • I_PH_JOURNALENTRYCUBE.CURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • I_PH_JOURNALENTRYCUBE.MANDT == SKB1.MANDT
  • I_PH_JOURNALENTRYCUBE.GLACCOUNT == SKB1.SAKNR
  • I_PH_JOURNALENTRYCUBE.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Tax on Sales/Purchases Code
  • Client
  • Tax on Sales/Purchases Code
  • ?
  • I_PH_JOURNALENTRYCUBE.MANDT == T007A.MANDT
  • I_PH_JOURNALENTRYCUBE.TAXCODE == T007A.MWSKZ
  • I_PH_JOURNALENTRYCUBE.[column in domain "KALSM_D"] == T007A.KALSM