project QadFinancials > class BCubeQuery > business logic (internal API) query CubeDimForPostingHist (optimised)


query filter (table tFilter)


tcBusinessFieldNametcDataTypetcOperator
iiCompanyIdi
tCompany.CompanyCodec=,>=,>,<>,<=,<,begins,can-do,matches
tCostCentre.CostCentreCodec=,>=,>,<>,<=,<,begins,can-do,matches
tCurrency.CurrencyCodec=,>=,>,<>,<=,<,begins,can-do,matches
tDivision.DivisionCodec=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode01c=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode02c=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode03c=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode04c=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode05c=,>=,>,<>,<=,<,begins,can-do,matches
tGL.GLCodec=,>=,>,<>,<=,<,begins,can-do,matches
tJournal.JournalCodec=,>=,>,<>,<=,<,begins,can-do,matches
tLayer.LayerCodec=,>=,>,<>,<=,<,begins,can-do,matches
tPostingHist.PostingHistBalanceCreditCCd=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceCreditLCd=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceCreditPCd=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceCreditTCd=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceDebitCCd=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceDebitLCd=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceDebitPCd=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceDebitTCd=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceQTYd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntCreditCCd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntCreditLCd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntCreditPCd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntCreditTCd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntDebitCCd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntDebitLCd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntDebitPCd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntDebitTCd=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntQTYd=,>=,>,<>,<=,<
tPostingHist.PostingHistYearPeriodFromi=,>=,>,<>,<=,<
tPostingHist.PostingHistYearPeriodTilli=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDCreditCCd=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDCreditLCd=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDCreditPCd=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDCreditTCd=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDDebitCCd=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDDebitLCd=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDDebitPCd=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDDebitTCd=,>=,>,<>,<=,<
tProject.ProjectCodec=,>=,>,<>,<=,<,begins,can-do,matches


Parameters (internal)


iiCompanyIdintegerCompany id


query condition


  each FRWCubeDim where
FRWCubeDim.Company_Id = iiCompanyId AND

      each FRWCubeMeas (inner-join) where
FRWCubeMeas.FRWCubeDim_ID = FRWCubeDim.FRWCubeDim_ID AND

          each FRWCubeHistLink (inner-join) where
FRWCubeHistLink.FRWCubeMeas_ID = FRWCubeMeas.FRWCubeMeas_ID AND

              first PostingHist (inner-join) where
PostingHist.Company_Id = iiCompanyId AND
PostingHist.PostingHist_ID = FRWCubeHistLink.PostingHist_ID AND

                  first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = PostingHist.Company_ID AND

                  first CostCentre (conditional-join) where
CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = PostingHist.CostCentre_ID AND

                  first Currency (conditional-join) where
Currency.Currency_ID = PostingHist.Currency_ID AND

                  first Division (conditional-join) where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = PostingHist.Division_ID AND

                  first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = PostingHist.GL_ID AND

                  first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = PostingHist.Journal_ID AND

                  first Layer (conditional-join) where
Layer.Layer_ID = PostingHist.Layer_ID AND

                  first Project (conditional-join) where
Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = PostingHist.Project_ID AND

          first FRWCubePeriod (inner-join) where
FRWCubePeriod.FRWCubePeriod_ID = FRWCubeMeas.FRWCubePeriod_ID AND


query resultset tqCubeDimForPostingHist


field namedata typedb fielddescription
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tcCostCentreCodecharacterCostCentre.CostCentreCodeCost Center: A code that identifies the cost center.
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tcFRWCubeDimSafCode01characterFRWCubeDim.FRWCubeDimSafCode01Saf 1
tcFRWCubeDimSafCode02characterFRWCubeDim.FRWCubeDimSafCode02Saf 2
tcFRWCubeDimSafCode03characterFRWCubeDim.FRWCubeDimSafCode03Saf 3
tcFRWCubeDimSafCode04characterFRWCubeDim.FRWCubeDimSafCode04Saf 4
tcFRWCubeDimSafCode05characterFRWCubeDim.FRWCubeDimSafCode05Saf 5
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcLayerCodecharacterLayer.LayerCodeLayer Code
tdPostingHistBalanceCreditCCdecimalPostingHist.PostingHistBalanceCreditCCSC Credit Balance
tdPostingHistBalanceCreditLCdecimalPostingHist.PostingHistBalanceCreditLCBC Balance Credit
tdPostingHistBalanceCreditPCdecimalPostingHist.PostingHistBalanceCreditPCPC Credit Balance
tdPostingHistBalanceCreditTCdecimalPostingHist.PostingHistBalanceCreditTCTC Credit Balance
tdPostingHistBalanceDebitCCdecimalPostingHist.PostingHistBalanceDebitCCSC Debit Balance
tdPostingHistBalanceDebitLCdecimalPostingHist.PostingHistBalanceDebitLCBC Balance Debit
tdPostingHistBalanceDebitPCdecimalPostingHist.PostingHistBalanceDebitPCPC Debit Balance
tdPostingHistBalanceDebitTCdecimalPostingHist.PostingHistBalanceDebitTCTC Debit Balance
tdPostingHistBalanceQTYdecimalPostingHist.PostingHistBalanceQTYQuantity Balance
tdPostingHistMovemntCreditCCdecimalPostingHist.PostingHistMovemntCreditCCSC Credit Activity
tdPostingHistMovemntCreditLCdecimalPostingHist.PostingHistMovemntCreditLCBC Movement Credit
tdPostingHistMovemntCreditPCdecimalPostingHist.PostingHistMovemntCreditPCPC Credit Activity
tdPostingHistMovemntCreditTCdecimalPostingHist.PostingHistMovemntCreditTCTC Credit Activity
tdPostingHistMovemntDebitCCdecimalPostingHist.PostingHistMovemntDebitCCSC Debit Activity
tdPostingHistMovemntDebitLCdecimalPostingHist.PostingHistMovemntDebitLCBC Movement Debit
tdPostingHistMovemntDebitPCdecimalPostingHist.PostingHistMovemntDebitPCPC Debit Activity
tdPostingHistMovemntDebitTCdecimalPostingHist.PostingHistMovemntDebitTCTC Debit Activity
tdPostingHistMovemntQTYdecimalPostingHist.PostingHistMovemntQTYQty Activity
tiPostingHistYearPeriodFromintegerPostingHist.PostingHistYearPeriodFromFrom Year/GL Period
tiPostingHistYearPeriodTillintegerPostingHist.PostingHistYearPeriodTillTo Year/GL Period
tdPostingHistYTDCreditCCdecimalPostingHist.PostingHistYTDCreditCCSC Credit (YTD)
tdPostingHistYTDCreditLCdecimalPostingHist.PostingHistYTDCreditLCBC YTD Credit
tdPostingHistYTDCreditPCdecimalPostingHist.PostingHistYTDCreditPCPC Credit (YTD)
tdPostingHistYTDCreditTCdecimalPostingHist.PostingHistYTDCreditTCTC Credit (YTD)
tdPostingHistYTDDebitCCdecimalPostingHist.PostingHistYTDDebitCCSC Debit (YTD)
tdPostingHistYTDDebitLCdecimalPostingHist.PostingHistYTDDebitLCBC YTD Debit
tdPostingHistYTDDebitPCdecimalPostingHist.PostingHistYTDDebitPCPC Debit (YTD)
tdPostingHistYTDDebitTCdecimalPostingHist.PostingHistYTDDebitTCTC Debit (YTD)
tcProjectCodecharacterProject.ProjectCodeProject
FRWCubeDimCustomcharactercalculatedcustom fields
PostingHistCustomcharactercalculatedcustom fields
GLCustomcharactercalculatedcustom fields
CostCentreCustomcharactercalculatedcustom fields
DivisionCustomcharactercalculatedcustom fields
JournalCustomcharactercalculatedcustom fields
LayerCustomcharactercalculatedcustom fields
ProjectCustomcharactercalculatedcustom fields
CurrencyCustomcharactercalculatedcustom fields
CompanyCustomcharactercalculatedcustom fields
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(FRWCubeDim),rowid(FRWCubeMeas),rowid(FRWCubeHistLink),rowid(PostingHist),rowid(Company),rowid(CostCentre),rowid(Currency),rowid(Division),rowid(GL),rowid(Journal),rowid(Layer),rowid(Project),rowid(FRWCubePeriod)


Internal usage


QadFinancials
method BCube.ApiCubePostingHistCal
method BFRWTreeView.ApiCubePostingHist
dataset BCube.tqCubeDimForPostingHist