C_CO_DIANStRpFormat1001Query

Format 1001 - Journal Entry Item Query | view: CSRCOFRMT1001Q | 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_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_DIANConcatenatedKey Concatenated string representing one item in the final XML
CO_DIANReportFormat DIAN Report Format
CO_DIANReportItemType Report Format Item Type
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
ReportedTaxNumber 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
PostingDate Posting Date
Column Name Description
CO_DIANTaxNumberType DIAN Type of Document Show values
BusinessPartnerCategory Business Partner Category Show values
IsNaturalPerson Natural Person Show values
IsBelowMinimumAmountThreshold Below Minimum Amount Show values
CO_DIANCountry DIAN Country/Region Code 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
TaxNumberType Tax Number Type TEXT2
Customer null
Supplier null
PurchasingDocument Purchasing Document EBELN
BusinessPlace Business Place J_1BBRANCH
AccountingDocumentType Journal Entry Type BLART
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
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerCountry Country/Region Key LAND1
Region Region (State, Province, County) REGIO
CityCode City Code for DIAN Magnetic Media CHAR3
CityName City TEXT40
StreetName Street TEXT60
CreationUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GLAccount G/L Account SAKNR
GLAccountName G/L Account Short Text TEXT20
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20