business logic (internal API) query CubeDimForPostingHist (optimised)

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
iiCompanyId	i
tCompany.CompanyCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tCostCentre.CostCentreCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tCurrency.CurrencyCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tDivision.DivisionCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode01	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode02	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode03	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode04	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCubeDim.FRWCubeDimSafCode05	c	=,>=,>,<>,<=,<,begins,can-do,matches
tGL.GLCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tJournal.JournalCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tLayer.LayerCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tPostingHist.PostingHistBalanceCreditCC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceCreditLC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceCreditPC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceCreditTC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceDebitCC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceDebitLC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceDebitPC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceDebitTC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistBalanceQTY	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntCreditCC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntCreditLC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntCreditPC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntCreditTC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntDebitCC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntDebitLC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntDebitPC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntDebitTC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistMovemntQTY	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistYearPeriodFrom	i	=,>=,>,<>,<=,<
tPostingHist.PostingHistYearPeriodTill	i	=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDCreditCC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDCreditLC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDCreditPC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDCreditTC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDDebitCC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDDebitLC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDDebitPC	d	=,>=,>,<>,<=,<
tPostingHist.PostingHistYTDDebitTC	d	=,>=,>,<>,<=,<
tProject.ProjectCode	c	=,>=,>,<>,<=,<,begins,can-do,matches

Parameters (internal)

iiCompanyId

integer

Company 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 name	data type	db field	description
tcCompanyCode	character	Company.CompanyCode	Entity Code
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tcFRWCubeDimSafCode01	character	FRWCubeDim.FRWCubeDimSafCode01	Saf 1
tcFRWCubeDimSafCode02	character	FRWCubeDim.FRWCubeDimSafCode02	Saf 2
tcFRWCubeDimSafCode03	character	FRWCubeDim.FRWCubeDimSafCode03	Saf 3
tcFRWCubeDimSafCode04	character	FRWCubeDim.FRWCubeDimSafCode04	Saf 4
tcFRWCubeDimSafCode05	character	FRWCubeDim.FRWCubeDimSafCode05	Saf 5
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcLayerCode	character	Layer.LayerCode	Layer Code
tdPostingHistBalanceCreditCC	decimal	PostingHist.PostingHistBalanceCreditCC	SC Credit Balance
tdPostingHistBalanceCreditLC	decimal	PostingHist.PostingHistBalanceCreditLC	BC Balance Credit
tdPostingHistBalanceCreditPC	decimal	PostingHist.PostingHistBalanceCreditPC	PC Credit Balance
tdPostingHistBalanceCreditTC	decimal	PostingHist.PostingHistBalanceCreditTC	TC Credit Balance
tdPostingHistBalanceDebitCC	decimal	PostingHist.PostingHistBalanceDebitCC	SC Debit Balance
tdPostingHistBalanceDebitLC	decimal	PostingHist.PostingHistBalanceDebitLC	BC Balance Debit
tdPostingHistBalanceDebitPC	decimal	PostingHist.PostingHistBalanceDebitPC	PC Debit Balance
tdPostingHistBalanceDebitTC	decimal	PostingHist.PostingHistBalanceDebitTC	TC Debit Balance
tdPostingHistBalanceQTY	decimal	PostingHist.PostingHistBalanceQTY	Quantity Balance
tdPostingHistMovemntCreditCC	decimal	PostingHist.PostingHistMovemntCreditCC	SC Credit Activity
tdPostingHistMovemntCreditLC	decimal	PostingHist.PostingHistMovemntCreditLC	BC Movement Credit
tdPostingHistMovemntCreditPC	decimal	PostingHist.PostingHistMovemntCreditPC	PC Credit Activity
tdPostingHistMovemntCreditTC	decimal	PostingHist.PostingHistMovemntCreditTC	TC Credit Activity
tdPostingHistMovemntDebitCC	decimal	PostingHist.PostingHistMovemntDebitCC	SC Debit Activity
tdPostingHistMovemntDebitLC	decimal	PostingHist.PostingHistMovemntDebitLC	BC Movement Debit
tdPostingHistMovemntDebitPC	decimal	PostingHist.PostingHistMovemntDebitPC	PC Debit Activity
tdPostingHistMovemntDebitTC	decimal	PostingHist.PostingHistMovemntDebitTC	TC Debit Activity
tdPostingHistMovemntQTY	decimal	PostingHist.PostingHistMovemntQTY	Qty Activity
tiPostingHistYearPeriodFrom	integer	PostingHist.PostingHistYearPeriodFrom	From Year/GL Period
tiPostingHistYearPeriodTill	integer	PostingHist.PostingHistYearPeriodTill	To Year/GL Period
tdPostingHistYTDCreditCC	decimal	PostingHist.PostingHistYTDCreditCC	SC Credit (YTD)
tdPostingHistYTDCreditLC	decimal	PostingHist.PostingHistYTDCreditLC	BC YTD Credit
tdPostingHistYTDCreditPC	decimal	PostingHist.PostingHistYTDCreditPC	PC Credit (YTD)
tdPostingHistYTDCreditTC	decimal	PostingHist.PostingHistYTDCreditTC	TC Credit (YTD)
tdPostingHistYTDDebitCC	decimal	PostingHist.PostingHistYTDDebitCC	SC Debit (YTD)
tdPostingHistYTDDebitLC	decimal	PostingHist.PostingHistYTDDebitLC	BC YTD Debit
tdPostingHistYTDDebitPC	decimal	PostingHist.PostingHistYTDDebitPC	PC Debit (YTD)
tdPostingHistYTDDebitTC	decimal	PostingHist.PostingHistYTDDebitTC	TC Debit (YTD)
tcProjectCode	character	Project.ProjectCode	Project
FRWCubeDimCustom	character	calculated	custom fields
PostingHistCustom	character	calculated	custom fields
GLCustom	character	calculated	custom fields
CostCentreCustom	character	calculated	custom fields
DivisionCustom	character	calculated	custom fields
JournalCustom	character	calculated	custom fields
LayerCustom	character	calculated	custom fields
ProjectCustom	character	calculated	custom fields
CurrencyCustom	character	calculated	custom fields
CompanyCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= 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