I_PH_TaxBalanceGroupByIndustry

Philippines Industries Covered by VAT | view: IPHINDUSTRYGRP | Extraction: Not supported | Component: Financials Philippines
Tables used: IDTY_CODE_PH
Column Name Description
Country FK Country/Region Key
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
CompanyCode FK Company Code
BusinessPlace FK Business Place
TaxCode FK Tax on sales/purchases code
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
ATC for Philippine VAT
  • Client
  • ATC for Philippine VAT
  • Country/Region Key
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.MANDT == FIPH_ATC_CODE.CLIENT
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.ALPHANUMERICTAXCODE == FIPH_ATC_CODE.FIPH_ATC
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.COUNTRY == FIPH_ATC_CODE.COUNTRY
Business Place
  • ?
  • Client
  • Company Code
  • Business Place
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.MANDT == J_1BBRANCH.MANDT
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.COMPANYCODE == J_1BBRANCH.BUKRS
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.BUSINESSPLACE == J_1BBRANCH.BRANCH
Company Code
  • Client
  • Company Code
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.MANDT == T001.MANDT
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.MANDT == T005.MANDT
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.COUNTRY == T005.LAND1
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.[column in domain "KALSM_D"] == T007A.KALSM
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.MANDT == T007A.MANDT
  • I_PH_TAXBALANCEGROUPBYINDUSTRY.TAXCODE == T007A.MWSKZ