P_CO_DIANFrmt1001WhldgTaxItem

Format 1001 - Whitholding Tax Item | view: PSRCO1001WHLDGTX | 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 Report Format Item Type
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
AccountingDocumentItem Number of Line Item Within Accounting Document
Column Name Description
💲 Reporting Currency (ReportingCurrency):
AmountInReportingCurrency Amount in Global Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
FinancialAccountType Account type Show values
Column Name Description Domain name
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CO_DIANFRMT1001WHLDGTAXITEM.MANDT == T003.MANDT
  • P_CO_DIANFRMT1001WHLDGTAXITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • P_CO_DIANFRMT1001WHLDGTAXITEM.MANDT == T001.MANDT
  • P_CO_DIANFRMT1001WHLDGTAXITEM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • P_CO_DIANFRMT1001WHLDGTAXITEM.COMPANYCODECOUNTRY == T005.LAND1
  • P_CO_DIANFRMT1001WHLDGTAXITEM.MANDT == T005.MANDT
Amount Classification
  • Client
  • DIAN Report Format
  • Amount Classification
  • P_CO_DIANFRMT1001WHLDGTAXITEM.MANDT == FICODIANI_CLFN.MANDT
  • P_CO_DIANFRMT1001WHLDGTAXITEM.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT
  • P_CO_DIANFRMT1001WHLDGTAXITEM.CO_DIANAMOUNTCLASSFCTNWHLDG == FICODIANI_CLFN.CLF_CODE
DIAN Report Format
  • Client
  • DIAN Report Format
Customer Number
  • Client
  • Customer Number
  • P_CO_DIANFRMT1001WHLDGTAXITEM.MANDT == KNA1.MANDT
  • P_CO_DIANFRMT1001WHLDGTAXITEM.CUSTOMER == KNA1.KUNNR
General Ledger Account
  • General Ledger Account
  • Client
  • ?
  • P_CO_DIANFRMT1001WHLDGTAXITEM.GLACCOUNT == SKA1.SAKNR
  • P_CO_DIANFRMT1001WHLDGTAXITEM.MANDT == SKA1.MANDT
  • P_CO_DIANFRMT1001WHLDGTAXITEM.[column in domain "KTOPL"] == SKA1.KTOPL
Reporting Entity
  • Client
  • Reporting Entity
  • P_CO_DIANFRMT1001WHLDGTAXITEM.MANDT == SRF_RPG_ENT.MANDT
  • P_CO_DIANFRMT1001WHLDGTAXITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • P_CO_DIANFRMT1001WHLDGTAXITEM.MANDT == LFA1.MANDT
  • P_CO_DIANFRMT1001WHLDGTAXITEM.SUPPLIER == LFA1.LIFNR