P_CO_DIANStRpWhldgTaxItem

Withholding Tax Item for Colombia DIAN | view: PSRCOWHLDGTXITMC | Extraction: Not supported | Component: Withholding Tax Reporting
Tables used: BKPF, BSEC, WITH_ITEM, BKPF, BSEG, ADCP, ADRC, ADR6, BUT000, T001, TKA02, FICODIANC_CNCPT, KNA1, CVI_CUST_LINK, T059Z, LFA1, CVI_VEND_LINK, T001, T014, T059P, FICODIANC_WHLDG
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Tax Line Item
CO_DIANReportFormat FK DIAN Report Format
CO_DIANReportItemType Report Format Item Type
WithholdingTaxType FK Indicator for Withholding Tax Type
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
WhldgTaxBaseAmtInCoCodeCrcy Withholding Tax Base Amount in Company Code Currency
WhldgTaxAmtInCoCodeCrcy Withholding Tax Amount in Company Code Currency
WhldgTaxBaseAmtInTransacCrcy Withholding Tax Base Amount
WhldgTaxAmtInTransacCrcy Withholding Tax Amount
WhldgTaxExmptAmtInCoCodeCrcy Amount Exempt from Withholding Tax in Local Currency
WhldgTaxExmptAmtInTransacCrcy Amount Exempt from Withholding Tax in Document Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Posting Date
Column Name Description
FinancialAccountType Account type Show values
Column Name Description Domain name
TaxNumberType Tax Number Type TEXT2
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
TaxNumber4 Tax Number 4 CHAR18
TaxNumber5 Tax Number 5 CHAR60
VATRegistration VAT Registration Number STCEG
BusinessPartnerCountry Country/Region Key LAND1
Region Region (State, Province, County) REGIO
CityName City TEXT40
StreetName Street TEXT60
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == T003.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == T001.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == T005.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM.COUNTRY == T005.LAND1
Amount Classification
  • Client
  • DIAN Report Format
  • Amount Classification
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == FICODIANI_CLFN.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT
  • P_CO_DIANSTRPWHLDGTAXITEM.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE
DIAN Report Format
  • Client
  • DIAN Report Format
Customer Number
  • Customer Number
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM.CUSTOMER == KNA1.KUNNR
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == KNA1.MANDT
General Ledger Account
  • Client
  • General Ledger Account
  • ?
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == SKA1.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM.GLACCOUNT == SKA1.SAKNR
  • P_CO_DIANSTRPWHLDGTAXITEM.[column in domain "KTOPL"] == SKA1.KTOPL
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM.SUPPLIER == LFA1.LIFNR
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Withholding Tax Code
  • Client
  • Indicator for Withholding Tax Type
  • Withholding Tax Code
  • Country/Region Key
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == T059Z.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • P_CO_DIANSTRPWHLDGTAXITEM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • P_CO_DIANSTRPWHLDGTAXITEM.COUNTRY == T059Z.LAND1
Indicator for Withholding Tax Type
  • Client
  • Indicator for Withholding Tax Type
  • Country/Region Key
  • P_CO_DIANSTRPWHLDGTAXITEM.MANDT == T059P.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM.WITHHOLDINGTAXTYPE == T059P.WITHT
  • P_CO_DIANSTRPWHLDGTAXITEM.COUNTRY == T059P.LAND1