P_CO_DIANStRpJournalEntryItemC

G/L Formats - BP Logic for Journal Entry | view: PSRCODOCJRNLC | Extraction: Not supported | Component: Financials Colombia
Tables used: ACDOCA, BKPF, BSEG, FICODIANC_CNCPT, PROJ, PRPS, T001, T014, FICODIANC_GLA, FINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
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
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 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
GLAccountType Type of a General Ledger Account Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
OffsettingAccountType Offsetting Account Type 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
OffsettingAccount Offsetting Account GKONT
AccountingDocumentItem Journal Entry Posting View Item BUZEI
TransactionTypeDetermination Transaction Key CHAR3
FiscalPeriod Fiscal Period POPER
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • P_CO_DIANSTRPJOURNALENTRYITEMC.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == SKA1.MANDT
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.CHARTOFACCOUNTS == T004.KTOPL
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.COMPANYCODE == T001.BUKRS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "DATBI"] == CSKS.DATBI
  • P_CO_DIANSTRPJOURNALENTRYITEMC.COSTCENTER == CSKS.KOSTL
  • P_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == CSKS.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T004.MANDT
Amount Classification
  • Amount Classification
  • Client
  • DIAN Report Format
  • P_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FICODIANI_CLFN.MANDT
  • P_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT
DIAN Report Format
  • Client
  • DIAN Report Format
Report Format Item Type
  • ?
  • Client
  • DIAN Report Format
  • Report Format Item Type
  • P_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FICODIANC_CNCPT.MANDT
  • P_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT
  • P_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.COMPANYCODE == SKB1.BUKRS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.GLACCOUNT == SKB1.SAKNR
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.GLOBALCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FINSC_LEDGER.MANDT
  • P_CO_DIANSTRPJOURNALENTRYITEMC.LEDGER == FINSC_LEDGER.RLDNR
  • P_CO_DIANSTRPJOURNALENTRYITEMC.SOURCELEDGER == FINSC_LEDGER.RLDNR
Profit Center
  • ?
  • Profit Center
  • ?
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "DATBI"] == CEPC.DATBI
  • P_CO_DIANSTRPJOURNALENTRYITEMC.PROFITCENTER == CEPC.PRCTR
  • P_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == CEPC.MANDT
Reference Document Type P_CO_DIANSTRPJOURNALENTRYITEMC.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.LEDGER == FINSC_LEDGER.RLDNR
  • P_CO_DIANSTRPJOURNALENTRYITEMC.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FINSC_LEDGER.MANDT
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_CO_DIANSTRPJOURNALENTRYITEMC.SPECIALGLCODE == T074U.UMSKZ
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T074U.MANDT
Tax on Sales/Purchases Code
  • ?
  • Tax on Sales/Purchases Code
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "KALSM_D"] == T007A.KALSM
  • P_CO_DIANSTRPJOURNALENTRYITEMC.TAXCODE == T007A.MWSKZ
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T007A.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_CO_DIANSTRPJOURNALENTRYITEMC.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT