P_PH_JournalEntrySum2

PH CAS Journal Entry Balance Sum 2 | view: PPHCASJRNLENTRY2 | 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
DebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy null
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency null
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
AccountingDocumentTypeName Document Type Name TEXT20
DocumentItemText Item Text TEXT50
DocumentReferenceID Document Reference ID XBLNR1
OriginalReferenceDocument null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_PH_JOURNALENTRYSUM2.MANDT == T003.MANDT
  • P_PH_JOURNALENTRYSUM2.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_PH_JOURNALENTRYSUM2.MANDT == T004.MANDT
  • P_PH_JOURNALENTRYSUM2.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_PH_JOURNALENTRYSUM2.MANDT == T001.MANDT
  • P_PH_JOURNALENTRYSUM2.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_PH_JOURNALENTRYSUM2.MANDT == TCURC.MANDT
  • P_PH_JOURNALENTRYSUM2.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_PH_JOURNALENTRYSUM2.MANDT == SKB1.MANDT
  • P_PH_JOURNALENTRYSUM2.GLACCOUNT == SKB1.SAKNR
  • P_PH_JOURNALENTRYSUM2.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
  • P_PH_JOURNALENTRYSUM2.MANDT == T007A.MANDT
  • P_PH_JOURNALENTRYSUM2.[column in domain "KALSM_D"] == T007A.KALSM
  • P_PH_JOURNALENTRYSUM2.TAXCODE == T007A.MWSKZ