I_PH_SuplrCustJournalCube

PH CAS Supplier Customer Journal Cube | view: IPHSCJRNLCUBE | TRAN | Extraction: Full only | Component: Financials Philippines
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
Supplier FK Supplier
Customer FK Customer
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency null
CashDiscountAmtInCoCodeCrcy null
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
TaxAmountInCountryCrcy null
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
BusinessPartnerName null
BusinessPartnerCountry Business Partner Country/Region LAND1
CustomerSupplierAddress Business Partner Address
AddressID Address Text
VATRegistration null
AccountingDocumentHeaderText null
DocumentReferenceID Reference Document Number XBLNR1
OriginalReferenceDocument null
TaxRate Tax Rate
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_PH_SUPLRCUSTJOURNALCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_PH_SUPLRCUSTJOURNALCUBE.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • I_PH_SUPLRCUSTJOURNALCUBE.COMPANYCODE == T001.BUKRS
  • I_PH_SUPLRCUSTJOURNALCUBE.MANDT == T001.MANDT
Customer
  • Customer
  • Client
  • I_PH_SUPLRCUSTJOURNALCUBE.CUSTOMER == KNA1.KUNNR
  • I_PH_SUPLRCUSTJOURNALCUBE.MANDT == KNA1.MANDT
Supplier
  • Supplier
  • Client
  • I_PH_SUPLRCUSTJOURNALCUBE.SUPPLIER == LFA1.LIFNR
  • I_PH_SUPLRCUSTJOURNALCUBE.MANDT == LFA1.MANDT
Sales/Purchases Tax Code
  • Sales/Purchases Tax Code
  • Client
  • ?
  • I_PH_SUPLRCUSTJOURNALCUBE.TAXCODE == T007A.MWSKZ
  • I_PH_SUPLRCUSTJOURNALCUBE.MANDT == T007A.MANDT
  • I_PH_SUPLRCUSTJOURNALCUBE.[column in domain "KALSM_D"] == T007A.KALSM