P_CL_TrialBalanceRptgCrcyAmt

Trial Balance Amounts in Reporting Currency | view: PCLBALAMTRC | Extraction: Not supported | Component: Financials Chile
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
SourceLedger FK Source Ledger
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Reporting Currency (ReportingCurrency):
DebitStartingBalAmtInRptgCrcy Debit Starting Balance Amount in Reporting Currency
CreditStartingBalAmtInRptgCrcy Credit Starting Balance Amount in Reporting Currency
StartingBalanceAmtInRptgCrcy Starting Balance Amount in Reporting Currency
DebitAmountInReportingCurrency Debit Amount in Reporting Currency
CreditAmountInReportingCrcy Credit Amount in Reporting Currency
AmountInReportingCurrency Amount in Reporting Currency
DebitEndingBalAmtInRptgCrcy Debit Ending Balance Amount in Reporting Currency
CreditEndingBalAmtInRptgCrcy Credit Ending Balance Amount in Reporting Currency
EndingBalanceAmtInRptgCrcy Ending Balance Amount in Reporting Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
ReconciliationAccountType Account is Reconciliation Account Show values
FinancialAccountType Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
FiscalPeriod Fiscal Period POPER
GLAccountLongName G/L Account Long Text TEXT50
CashJournalItemType null
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_CL_TRIALBALANCERPTGCRCYAMT.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == T003.MANDT
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_CL_TRIALBALANCERPTGCRCYAMT.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == SKA1.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Business Area
  • Business Area
  • Client
  • P_CL_TRIALBALANCERPTGCRCYAMT.BUSINESSAREA == TGSB.GSBER
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == T004.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_CL_TRIALBALANCERPTGCRCYAMT.COMPANYCODE == T001.BUKRS
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == TKA01.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.CONTROLLINGAREA == TKA01.KOKRS
Group Account Number
  • Group Chart of Accts
  • Client
  • Group Account Number
  • P_CL_TRIALBALANCERPTGCRCYAMT.CORPORATEGROUPCHARTOFACCOUNTS == SKA1.KTOPL
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == SKA1.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.CORPORATEGROUPACCOUNT == SKA1.SAKNR
Group Chart of Accts
  • Group Chart of Accts
  • Client
  • P_CL_TRIALBALANCERPTGCRCYAMT.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == T004.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_CL_TRIALBALANCERPTGCRCYAMT.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • P_CL_TRIALBALANCERPTGCRCYAMT.CUSTOMER == KNA1.KUNNR
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == KNA1.MANDT
Functional Area
  • Client
  • Functional Area
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == TFKB.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_CL_TRIALBALANCERPTGCRCYAMT.COMPANYCODE == SKB1.BUKRS
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == SKB1.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Posting Key
  • Client
  • Posting Key
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == TBSL.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.POSTINGKEY == TBSL.BSCHL
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • P_CL_TRIALBALANCERPTGCRCYAMT.PROFITCENTER == CEPC.PRCTR
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == CEPC.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.[column in domain "DATBI"] == CEPC.DATBI
  • P_CL_TRIALBALANCERPTGCRCYAMT.CONTROLLINGAREA == CEPC.KOKRS
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == FAGL_SEGM.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • P_CL_TRIALBALANCERPTGCRCYAMT.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == T074U.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == SRF_RPG_ENT.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • P_CL_TRIALBALANCERPTGCRCYAMT.MANDT == LFA1.MANDT
  • P_CL_TRIALBALANCERPTGCRCYAMT.SUPPLIER == LFA1.LIFNR