I_PH_NotAmortizedTaxRetItmCube

Not Amortized Tax Item for PH VAT | view: IPHNAMTAXITMT | TRAN | Extraction: Not supported | Component: Financials Philippines
Tables used: ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, BKPF, BSEG, T007A, ANKA, FAAC_ACLS0, ANKT, FAAC_ACLS0_T, T001, T014, ANLA, FAAT_MD, FAAT_MD_ROOT, T001
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
TaxCode Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
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
Column Name Description
💲 Local Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
💲 Transaction Currency (DocumentCurrency):
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
TaxBoxStrucValidityEndDate Valid To Date for Tax Box Structure
ReportingDate Reporting Date
PostingDate Posting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
AssetValueDate Asset Value Date
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxType Tax Type 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
AccountingDocumentType Document Type BLART
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
Company Code
  • Client
  • Company Code
  • I_PH_NOTAMORTIZEDTAXRETITMCUBE.MANDT == T001.MANDT
  • I_PH_NOTAMORTIZEDTAXRETITMCUBE.COMPANYCODE == T001.BUKRS
Reporting Entity
  • Reporting Entity
  • Client
  • I_PH_NOTAMORTIZEDTAXRETITMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • I_PH_NOTAMORTIZEDTAXRETITMCUBE.MANDT == SRF_RPG_ENT.MANDT