C_CO_DIAN1001TotByBPWthMinAmtC

DIAN 1001 Total with Min. Amount Cube | view: CCO1001BPMINAMTC | TRAN | Extraction: Not supported | Component: Financials Colombia
Tables used: BKPF, FICODIAND_HCM, MATDOC, BSEC, EKKO, EKBE, EKPO, EKBEH, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, WITH_ITEM, ACDOCA, BKPF, BSEG, EKKO, ADCP, ADRC, ADR6, BUT000, T001, TKA02, MBEW, T005, FICODIANC_CNCPT, FICODIAND_EMPSRI, KNA1, KNB1, KNB5, CVI_CUST_LINK, T059Z, SKAT, PROJ, LFA1, LFB1, CVI_VEND_LINK, T030, PRPS, T001, T014, ADRCITY, ADRCITYT, T001K, T007B, T059P, FICODIANC_CNTRY, FICODIANC_EXDCTY, FICODIANC_GLA, FICODIANC_EXMAMT, FICODIANC_MINAMT, FICODIANC_VAT, FICODIANC_DOCTYP, FICODIANC_WHLDG, FINSC_LEDGER_REP
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
CO_DIANReportFormat DIAN Report Format
CO_DIANReportItemType Report Format Item Type
CO_DIANReportedTaxNumber Reporting Tax Number
Column Name Description
💲 Reporting Currency (ReportingCurrency):
DcblGLAcctPaytsAmtInRptgCrcy Payments or Credits in deductible General Ledger Account
NonDcblGLAcctPaytAmtInRptgCrcy Payments or Credits in Non Deductible General Ledger Account
DcblVATIncrdCostInRptgCrcy Deductible VAT as increased amount of cost or expense
NonDcblVATIncrdCostInRptgCrcy Non Deductible VAT as increased amount of cost or expense
WhldgTxIncAmtInRptgCurrency Practiced Withholding on Income
TakenWhldgTaxIncAmtInRptgCrcy Withholding on Income Paid on Behalf Creditor
WhldgTaxCommonVATAmtInRptgCrcy Practiced Withholding on Common VAT
TknWhldgSimpfdVATAmtInRptgCrcy Paid Withholding on Simplified VAT on Behalf of Creditor
WhldgTxForeignVATAmtInRptgCrcy Practiced Withholding on VAT for Foreigns
CO_WhldgCREEAmtInRptgCurrency Paid Withholding for CREE on behalf of Creditor
CO_TknWhldgCREEAmtInRptgCrcy Practiced Withholding for CREE
Column Name Description
Column Name Description
Column Name Description
CO_DIANTaxNumberType DIAN Type of Document Show values
IsBelowMinimumAmountThreshold Below Minimum Amount Show values
BusinessPartnerCategory Business Partner Category Show values
IsNaturalPerson Natural Person Show values
CO_DIANCountry DIAN Country/Region Code Show values
Column Name Description Domain name
TaxNumberType Tax Number Type TEXT2
Customer null
Supplier null
BusinessPlace Business Place J_1BBRANCH
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
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
BusinessPartnerCountry Country/Region Key LAND1
CO_DIANConcatenatedKey Concatenated string representing one item in the final XML
Region Region (State, Province, County) REGIO
CO_DIANCityCode City Code for DIAN Magnetic Media CHAR3
CityName City TEXT40
StreetName Street TEXT60
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
GLAccount G/L Account Number SAKNR
GLAccountName G/L Account Long Text TEXT50