P_PH_JournalEntrySum

PH CAS Journal Entry Balance Sum | view: PPHCASJRNLENTRY | Extraction: Not supported | Component: Financials Philippines
Column Name Description
CompanyCode FK Company Code
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
AccountingDocument Journal Entry
GLAccount FK G/L Account
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy null
AmountInCompanyCodeCurrency null
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
DocumentReferenceID Document Reference ID XBLNR1
OriginalReferenceDocument null
AccountingDocumentTypeName Document Type Name TEXT20
DocumentItemText Item Text TEXT50
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_PH_JOURNALENTRYSUM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_PH_JOURNALENTRYSUM.MANDT == T003.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PH_JOURNALENTRYSUM.CHARTOFACCOUNTS == T004.KTOPL
  • P_PH_JOURNALENTRYSUM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_PH_JOURNALENTRYSUM.COMPANYCODE == T001.BUKRS
  • P_PH_JOURNALENTRYSUM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_PH_JOURNALENTRYSUM.MANDT == TCURC.MANDT
  • P_PH_JOURNALENTRYSUM.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_PH_JOURNALENTRYSUM.COMPANYCODE == SKB1.BUKRS
  • P_PH_JOURNALENTRYSUM.GLACCOUNT == SKB1.SAKNR
  • P_PH_JOURNALENTRYSUM.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Tax on Sales/Purchases Code
  • ?
  • Tax on Sales/Purchases Code
  • Client
  • P_PH_JOURNALENTRYSUM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_PH_JOURNALENTRYSUM.TAXCODE == T007A.MWSKZ
  • P_PH_JOURNALENTRYSUM.MANDT == T007A.MANDT