C_CO_DIANStRpCustomerOpenItemQ

Cust. Balances Query for Colombia DIAN | view: CSRCOCUSTOPITEMQ | Extraction: Not supported | Component: Financials Colombia
Tables used: BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, BKPF, BSEG, ADCP, ADRC, BUT000, T004, T001, TKA02, FICODIANC_CNCPT, KNA1, CVI_CUST_LINK, SKA1, PROJ, LFA1, CVI_VEND_LINK, PRPS, T001, T014, ADRCITY, ADRCITYT, SKAT, T004, FICODIANC_CNTRY, FICODIANC_GLA, FICODIANC_EXMAMT, FICODIANC_MINAMT, FICODIANC_DOCTYP, 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
CO_DIANReportItemType FK Report Format Item Type
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
ReportedTaxNumber Reporting Tax Number
TaxNumberVerificationDigit Verification Digit for DIAN Magnetic Media
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Reporting Currency (ReportingCurrency):
OpnItmAmountInCountryCurrency Open Items Value
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
Column Name Description
PostingDate Posting Date
ClearingDate Clearing Date
Column Name Description
CO_DIANTaxNumberType DIAN Type of Document Show values
IsNaturalPerson Natural Person Show values
IsBelowMinimumAmountThreshold Below Minimum Amount Show values
BusinessPartnerCategory Business Partner Category Show values
CO_DIANCountry DIAN Country/Region Code Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
ReferenceDocument Reference document number AWREF
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
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
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
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
GLAccount G/L Account SAKNR
GLAccountName G/L Account Name CHAR30
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
FiscalPeriod Fiscal Period POPER
SpecialGLCode Special G/L Indicator UMSKZ
Master Data Relations Join Conditions
Amount Classification
  • Amount Classification
  • Client
  • DIAN Report Format
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.MANDT == FICODIANI_CLFN.MANDT
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT
DIAN Report Format
  • Client
  • DIAN Report Format
Report Format Item Type
  • Report Format Item Type
  • Client
  • ?
  • DIAN Report Format
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.MANDT == FICODIANC_CNCPT.MANDT
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT
Reporting Entity
  • Client
  • Reporting Entity
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.MANDT == SRF_RPG_ENT.MANDT
  • C_CO_DIANSTRPCUSTOMEROPENITEMQ.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY