P_CODIANStRpTaxCodesAndItems

DEPRECATED - DO NOT USE! | view: PSRCOTXCODESITMS | Extraction: Not supported | Component: Financials Colombia
Column Name Description
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
CO_DIANReportFormat FK DIAN Report Format
CO_DIANReportItemType FK Report Format Item Type
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
TaxRate TaxRate (Percentage)
TaxExchangeRate null
Master Data Relations Join Conditions
Amount Classification
  • DIAN Report Format
  • Amount Classification
  • Client
  • P_CODIANSTRPTAXCODESANDITEMS.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT
  • P_CODIANSTRPTAXCODESANDITEMS.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE
  • P_CODIANSTRPTAXCODESANDITEMS.MANDT == FICODIANI_CLFN.MANDT
DIAN Report Format
  • DIAN Report Format
  • Client
Report Format Item Type
  • Report Format Item Type
  • DIAN Report Format
  • ?
  • Client
  • P_CODIANSTRPTAXCODESANDITEMS.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE
  • P_CODIANSTRPTAXCODESANDITEMS.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT
  • P_CODIANSTRPTAXCODESANDITEMS.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM
  • P_CODIANSTRPTAXCODESANDITEMS.MANDT == FICODIANC_CNCPT.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • P_CODIANSTRPTAXCODESANDITEMS.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • P_CODIANSTRPTAXCODESANDITEMS.MANDT == SRF_RPG_ENT.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_CODIANSTRPTAXCODESANDITEMS.[column in domain "MWSKZ"] == T007A.MWSKZ
  • P_CODIANSTRPTAXCODESANDITEMS.MANDT == T007A.MANDT
  • P_CODIANSTRPTAXCODESANDITEMS.TAXCALCULATIONPROCEDURE == T007A.KALSM
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_CODIANSTRPTAXCODESANDITEMS.TAXCODE == T007A.MWSKZ
  • P_CODIANSTRPTAXCODESANDITEMS.MANDT == T007A.MANDT
  • P_CODIANSTRPTAXCODESANDITEMS.TAXCALCULATIONPROCEDURE == T007A.KALSM
Account Key
  • ?
  • Account Key
  • Client
  • P_CODIANSTRPTAXCODESANDITEMS.[column in domain "KAPPL"] == T687.KAPPL
  • P_CODIANSTRPTAXCODESANDITEMS.TRANSACTIONTYPEDETERMINATION == T687.KVSL1
  • P_CODIANSTRPTAXCODESANDITEMS.MANDT == T687.MANDT