C_PH_AmortizedTaxItemQuery

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.
ValidFrom "Valid From" Date for Version
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
💲 Currency Key (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
ValidFrom "Valid From" Date for Version
PostingDate Posting Date in the Document
ReportingDate Reporting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
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 Reporting Country/Region LAND1
BusinessPlace Business Place J_1BBRANCH
Master Data Relations Join Conditions
Reporting Entity
  • Client
  • Reporting Entity
  • C_PH_AMORTIZEDTAXITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_PH_AMORTIZEDTAXITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY