P_CO_DIANStRpSupplierOpenItem

Supplier Balances for Colombia DIAN | view: PSRCOSUPOITM | 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, T001, TKA02, FICODIANC_CNCPT, KNA1, CVI_CUST_LINK, PROJ, LFA1, CVI_VEND_LINK, PRPS, T001, T014, FICODIANC_GLA, FINSC_LEDGER_REP
Column Name Description
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
CO_DIANReportFormat FK DIAN Report Format
CO_DIANReportItemType FK Report Format Item Type
Column Name Description
💲 Reporting Currency (ReportingCurrency):
AmountInReportingCurrency Amount in Global Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
OpnItmAmountInCountryCurrency null
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code 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
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
IsNaturalPerson Natural Person Show values
BusinessPartnerCategory Business Partner Category Show values
GLAccountType Type of a General Ledger Account Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
Column Name Description Domain name
Supplier Account Number of Supplier LIFNR
Customer Customer Number KUNNR
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
ReportedTaxNumber Reporting Tax Number FICODIAN_TAX_NUMBER
TaxNumberType Tax Number Type TEXT2
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
CityCode City code for city/street file CITY_CODE
CityName City TEXT40
StreetName Street TEXT60
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
TransactionTypeDetermination Transaction Key CHAR3
FiscalPeriod Fiscal Period POPER
CompanyCodeAddressID Address ADRNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == T003.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative G/L Account Number In Company Code
  • P_CO_DIANSTRPSUPPLIEROPENITEM.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == SKA1.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == T004.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_CO_DIANSTRPSUPPLIEROPENITEM.COMPANYCODE == T001.BUKRS
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == T001.MANDT
Country key
  • Client
  • Country/Region Key
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == T005.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.COMPANYCODECOUNTRY == T005.LAND1
Company Code Currency
  • Client
  • Company Code Currency
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • ?
  • Cost Center
  • Client
  • ?
  • P_CO_DIANSTRPSUPPLIEROPENITEM.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_CO_DIANSTRPSUPPLIEROPENITEM.COSTCENTER == CSKS.KOSTL
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == CSKS.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.[column in domain "DATBI"] == CSKS.DATBI
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_CO_DIANSTRPSUPPLIEROPENITEM.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == T004.MANDT
Amount Classification
  • Amount Classification
  • Client
  • DIAN Report Format
  • P_CO_DIANSTRPSUPPLIEROPENITEM.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == FICODIANI_CLFN.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.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
  • P_CO_DIANSTRPSUPPLIEROPENITEM.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE
  • P_CO_DIANSTRPSUPPLIEROPENITEM.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == FICODIANC_CNCPT.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_CO_DIANSTRPSUPPLIEROPENITEM.COMPANYCODE == SKB1.BUKRS
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == SKB1.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • ?
  • Profit Center
  • Client
  • ?
  • P_CO_DIANSTRPSUPPLIEROPENITEM.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_CO_DIANSTRPSUPPLIEROPENITEM.PROFITCENTER == CEPC.PRCTR
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == CEPC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.[column in domain "DATBI"] == CEPC.DATBI
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • P_CO_DIANSTRPSUPPLIEROPENITEM.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == T074U.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Reporting Entity
  • Client
  • P_CO_DIANSTRPSUPPLIEROPENITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == SRF_RPG_ENT.MANDT
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == T007A.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_CO_DIANSTRPSUPPLIEROPENITEM.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • P_CO_DIANSTRPSUPPLIEROPENITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPSUPPLIEROPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS