C_PH_AmortizedTaxRetItmQuery

Exceeding 1PM Tax Item for PH VAT | view: CSRPHAMTXITEMQT | Extraction: Not supported | Component: Financials Philippines
Column Name Description
CompanyCode Company Code
AccountingDocumentType Document Type
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
TaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
TaxGroup Tax Group
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
TaxCode Tax on sales/purchases code
Column Name Description
💲 Document Currency (DocumentCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
PrevPerdsBalTaxAmtInCoCodeCrcy Balance of Input Tax From Pervious Period
PerdcTaxAmtInCompanyCodeCrcy Allowable Tax Amount in Reporting Period
BalCarryFwdTaxAmtInCoCodeCrcy Balance Carried Forward in Local Currency
TaxBaseAmountInTransCrcy Tax Base Amount in Document Currency
TaxAmount Tax Amount in Document Currency
Column Name Description
Column Name Description
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
PostingDate Posting Date
ReportingDate Reporting Date
DocumentDate Journal Entry Date
TaxBoxStrucValidityEndDate Valid To Date for Tax Box Structure
TaxReportingDate Tax Reporting Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
AssetValueDate Asset Value Date
Column Name Description
TaxType Tax Type Show values
PlannedUsefulLifeInPeriods Est. Life for Philippine VAT Show values
RemainingUsefulLifeInPeriods Recognized Life for Philippine VAT Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
TaxJurisdiction Tax Jurisdiction TXJCD
GLAccount General Ledger Account SAKNR
TaxRate Tax Rate DEC3_2
TaxItemGroup Group Indicator for Tax Line Items NUM03
MasterFixedAsset Fixed Asset ANLN1
FixedAsset Asset Subnumber ANLN2
AssetClassName Short Text for Asset Class Name TEXT20
ReportingCountry Tax Country/Region or Company Code Country/Region LAND1
BusinessPlace Business Place J_1BBRANCH
Master Data Relations Join Conditions
Reporting Entity
  • Client
  • Reporting Entity
  • C_PH_AMORTIZEDTAXRETITMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_PH_AMORTIZEDTAXRETITMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY