CDS Views for Financials Philippines (FI-LOC-FI-PH)

CDS View NameDescriptionSQL View Name
C_PH_AMORTIZEDTAXITEMQUERYConsumption view for Exceeding 1PM Tax Item for PH VATCSRPHAMTXITEMQ
C_PH_CASCASHITEMQUERYCAS Cash Item QueryCPHCASHITMQ
C_PH_INVENTORYQUERYPh Inventory Query PhilippinesCPHINVENTORYQRY
C_PH_JOURNALENTRYQUERYPH CAS General Journal/Ledger QueryCPHGENJRNLQRY
C_PH_NOTAMORTIZEDTAXITEMQUERYConsumption View of Tax Item Not Exceding 1PM for PH VATCSRPHNAMTAXITEMQ
C_PH_PURCHASESSUMMARYITEMQUERYPhilippines Purchases Summary QueryCPHSLPQ
C_PH_SALESSUMMARYITEMQUERYPhilippines Sales Summary QueryCPHSLSQ
C_PH_STOCKQUERYPh Stock Query PhilippinesCPHSTOCKQRY
C_PH_STRPTAXITEMQTax Item Statutory Reporting for PHCSRPHTAXITEMQ
C_PH_STRPTXITMGRPBYINDSTRYQRYTax Item Statutory Reporting for PhilipplineCSRPHSTAXITEMQRY
C_PH_SUPLRCUSTJOURNALQUERYPH CAS Journal QueryCPHCSJRNLQRY
I_PH_ALPHANUMERICTAXCODEPhilippines Alphanumeric Tax CodeIPHATCC
I_PH_ALPHANUMERICTAXCODETEXTPhilippines Alphanumeric Tax Code - TextIPHATCCTEXT
I_PH_AMORTIZEDTAXITEMCUBECube View of Tax Item Exceeding 1PM for PH VATIPHAMTTXITMCUBE
I_PH_CASCASHITEMCUBECAS Cash Item CubeIPHCASHITMCUBE
I_PH_JOURNALENTRYCUBEPH CAS General Journal CubeIPHGENJRNLCUBE
I_PH_NOTAMORTIZEDTAXITEMCUBECube View of Not Amortized Tax Item for PH VATIPHNAMTAXITM
I_PH_PURCHASESSUMMARYITEMCUBEPhilippines Purchases SummaryIPHSLPCUBE
I_PH_SALESSUMMARYITEMCUBEPhilippines Sales Summary CubeIPHSLSCUBE
I_PH_STRPTAXITEMCUBETax Item Statutory Reporting for PHISRPHTAXITEM
I_PH_STRPTXITMGRPBYINDSTRYCUBETax Item for PhilipplineIPHSPTAXITEM
I_PH_SUPLRCUSTJOURNALCUBEPH CAS Supplier Customer Journal CubeIPHSCJRNLCUBE
I_PH_TAXBALANCEGROUPBYINDUSTRYPhilippines Industries Covered by VATIPHINDUSTRYGRP
P_COMPANYPLANTDETAILSCompany and Plant DetailsPCOMPLTABRDETLS
P_PH_ASSETDOCITEMCollecting Asset Item for Phillipine VATPPHASSETITM
P_PH_ATCITEMFor PH 2550M ATC ItemsPPHATCITEM
P_PH_ATCSUMITEMfor getting atc summary itemPPHATCSUM
P_PH_CAPITALGOODSITEMCollecting Capital Goods Item For PhillipinePPHGOODSITEM
P_PH_CASCASHITEMCAS Cash ItemPPHCASCASHITM
P_PH_COMPANYCODEADDRESSGet Company Code AddressPPHSLCOMADDRE
P_PH_DISCOUNTTAXITEMSCalculation of Discount Tax ItemsPPHDISCTAXITEMS
P_PH_EXCD1PMTAXITEMAsset Tax Item Exceeding 1PM for PH VATPPHEX1PMTAXITM
P_PH_EXCD1PMTAXITEM1Calculate passed month for PH VAT AssetPPHEX1PMTAXITM1
P_PH_EXCD1PMTAXITEM2Calculation life for PH Tax Item exceeding 1PMPPHEX1PMTAXITM2
P_PH_EXCD1PMTAXITEM3Calculation life for PH Tax Item exceeding 1PMPPHEX1PMTAXITM3
P_PH_EXCD1PMTAXITEM4Calculation Amount for PH Tax Item exceeding 1PMPPHEX1PMTAXITM4
P_PH_GENERALLEDGERACCOUNTPH CAS General Ledger AccountPPHGLACCOUNT
P_PH_INPUTTAXALLOCATIONCalculate Input Tax AllocationPPHALLOCINPTTAX
P_PH_JOURNALENTRYBALWPERIODPH CAS Journal Entry Balance With PeriodPPHJRNLENTRYBALP
P_PH_JOURNALENTRYSUMPH CAS Journal Entry Balance SumPPHCASJRNLENTRY
P_PH_JOURNALENTRYSUM2PH CAS Journal Entry Balance Sum 2PPHCASJRNLENTRY2
P_PH_MONTHEXCEEDING1PMDetermine the period which exceeding 1PM for PH VATPPHMONEX1PM
P_PH_MONTHNOTEXCEEDING1PMDetermine the period which not exceeding 1PM for PH VATPPHMONTHNEX1PM
P_PH_NOTEXCD1PMTAXITEMSchedule 2 for PH VATPPHNEXCD1PMITM
P_PH_PAYTCLRDRECEIVABLEPYBLITMPayment Cleared Receivable Payable ItemPPHPAYTCLRPITM
P_PH_PAYTCLRDRECVPYBLHEADERPayment Cleared Receivable Payable HeaderPPHPAYTCLRPHDR
P_PH_PAYTOPNRECEIVABLEPYBLITMPayment Open Receivable Payable ItemPPHPATYOPRPITM
P_PH_PAYTRECEIVABLEPYBLITMPayment Receivable Payable ItemPPHPAYTRPITM
P_PH_SALESPURCHASESSUMMARYITEMPH Sales Purchase SummaryPPHSLSP
P_PH_STRPNOTRPTDTAXITEMNon Reported document for Statutory Reporting of PhilippinesPSRPHNTRPTDTXITM
P_PH_STRPTAXITEMQTax Item Statutory Reporting for PHPSRPHTAXITEMQ
P_PH_STRPTAXITEMStax Items with discountsPPHSTRPTAITEMS
P_PH_SUPLRCUSTJOURNALAMOUNTPH CAS Supplier Customer Journal AmountPPHSCJRNLAMT
P_PH_SUPLRCUSTJRNLTAXAMOUNTPH CAS Supplier Customer Tax AmountPPHCSTAXAMT
P_PLANTABROADDETAILSPlant Aborad DetailsPPLTABRDETLS
SHSM_CUSTOMERCOCOD_VHCDS View VH for customer company codeSHSMPHCUSCOCODE
SHSM_SUPPLIERCOCOD_VHCDS View VH for supplier company codeSHSMPHSUPCOCODE
SRF_HELPER_PH_ENVELOPCalculate values for PH VAT FormsSRFPHVATENV

Other CDS Views