C_CO_DIANStRpTaxItemQuery

Format 1005 & 1006 - Tax Item Query | view: CSRCOTAXITEMQ | Extraction: Not supported | Component: Financials Colombia
Tables used: BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, BKPF, BSEG, BSET, ADCP, ADRC, BUT000, T001, TKA02, T005, KNA1, KNB1, KNB5, CVI_CUST_LINK, SKAT, FINSC_LEDGER, LFA1, LFB1, CVI_VEND_LINK, T007A, T007S, T001, T014, ADRCITY, ADRCITYT, FICODIANC_CNTRY, FICODIANC_VAT, FICODIANC_DOCTYP, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
CO_DIANConcatenatedKey Concatenated string representing one item in the final XML
CO_DIANReportFormat FK DIAN Report Format
AccountingDocument Journal Entry
TaxItem Number of Tax Line Item
TaxType Tax Type Show values
ReportedTaxNumber Reporting Tax Number
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInCountryCrcy null
TaxAmountInCountryCrcy null
TaxBaseAmountInRptgCrcy Base Amount for Tax Calculation
TaxAmountInRptgCrcy DIAN BP Tax Amount
InptTxDebitAmtInCntryCurrency VAT Input: Debit Value
OutpTxDebitAmtInCntryCurrency VAT Output: Debit Value
OutpTxCrdtAmtInCntryCurrency VAT Output: Credit Value
InptTxCrdtAmtInCntryCurrency VAT Input: Credit Value
CnsmpnTxAmtInCountryCurrency DIAN BP Consumption Tax Amount
Column Name Description
Column Name Description
ReportingDate Reporting Date
PostingDate Posting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
Column Name Description
TaxType Tax Type Show values
CO_DIANTaxNumberType DIAN Type of Document Show values
BusinessPartnerCategory Business Partner Category Show values
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
CO_DIANCountry DIAN Country/Region Code Show values
Column Name Description Domain name
TaxCode Tax on sales/purchases code MWSKZ
TaxCodeName Tax Code Name TEXT50
GLAccount General Ledger Account SAKNR
GLAccountName G/L Account Short Text TEXT20
AccountingDocumentType Journal Entry Type BLART
BusinessPlace Business Place J_1BBRANCH
TransactionTypeDetermination Transaction Key CHAR3
TaxReturnCountry Country/Region for Tax Report LAND1
CompanyCodeCountry Country/Region Key LAND1
TaxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
TaxJurisdiction Tax Jurisdiction TXJCD
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
FirstName First name of business partner (person) BU_NAME
MiddleName Middle name or second forename of a person BU_NAME
LastName Last name of business partner (person) BU_NAME
AdditionalLastName Other Last Name of a Person BU_NAME
BusinessPartnerOrgLongName Business Partner Organization Long Name
OrganizationBPName1 Name 1 of organization BU_NAME
OrganizationBPName2 Name 2 of organization BU_NAME
OrganizationBPName3 Name 3 of organization BU_NAME
OrganizationBPName4 Name 4 of organization BU_NAME
BusinessPartner Business Partner Number BU_PARTNER
Customer null
Supplier null
BusinessPartnerCountry Country/Region Key LAND1
Master Data Relations Join Conditions
DIAN Report Format
  • Client
  • DIAN Report Format
Reporting Entity
  • Client
  • Reporting Entity
  • C_CO_DIANSTRPTAXITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_CO_DIANSTRPTAXITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY