P_CO_DIANStRpBPTaxItem4

Format 1005 & 1006 - BP Tax Item | view: PCOSRBPTXITM4 | 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, FICODIANC_VAT, FICODIANC_DOCTYP, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
Column Name Description
CompanyCode 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 FK Report Format Item Type
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
TaxAmountInCountryCrcy null
💲 Reporting Currency (ReportingCurrency):
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
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
Column Name Description
CO_DIANTaxNumberType DIAN Type of Document Show values
TaxType Tax Type Show values
BusinessPartnerCategory Business Partner Category Show values
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
Column Name Description Domain name
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
ReportedTaxNumber Reporting Tax Number FICODIAN_TAX_NUMBER
TaxNumberType Tax Number Type TEXT2
AccountingDocumentItem null
TaxCode Tax on sales/purchases code MWSKZ
TaxCodeName Tax Code Name TEXT50
TaxJurisdiction Tax Jurisdiction TXJCD
TransactionTypeDetermination Transaction Key CHAR3
GLAccount General Ledger Account SAKNR
GLAccountName G/L Account Short Text TEXT20
Customer null
Supplier null
BusinessPartner Business Partner Number BU_PARTNER
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
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
BusinessPartnerCountry Country/Region Key LAND1
Region Region (State, Province, County) REGIO
StreetName Street TEXT60
CityCode City code for city/street file CITY_CODE
CityName City TEXT40
ReferenceDocument null
OriginalReferenceDocument Object key AWKEY
BusinessPartnerUUID Business Partner GUID SYSUUID
ReferenceDocumentContext null
CompanyCodeCountry Country/Region Key LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
ReportingCountry Reporting Country/Region LAND1
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CO_DIANSTRPBPTAXITEM4.MANDT == T003.MANDT
  • P_CO_DIANSTRPBPTAXITEM4.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Amount Classification
  • Amount Classification
  • Client
  • DIAN Report Format
DIAN Report Format
  • Client
  • DIAN Report Format
Report Format Item Type
  • ?
  • Report Format Item Type
  • Client
  • DIAN Report Format
Reporting Entity
  • Reporting Entity
  • Client
  • P_CO_DIANSTRPBPTAXITEM4.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • P_CO_DIANSTRPBPTAXITEM4.MANDT == SRF_RPG_ENT.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_CO_DIANSTRPBPTAXITEM4.[column in domain "KVEWE"] == T683.KVEWE
  • P_CO_DIANSTRPBPTAXITEM4.[column in domain "KAPPL"] == T683.KAPPL
  • P_CO_DIANSTRPBPTAXITEM4.MANDT == T683.MANDT
  • P_CO_DIANSTRPBPTAXITEM4.TAXCALCULATIONPROCEDURE == T683.KALSM